Re: not getting any hardware inventory from clients

*** [42000][0][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load the
DLL smsxp.dll, or one of the DLLs it references. Reason: 126(The specified
module could not be found.). :
xp_SMS_notification SMS_INVENTORY_DATA_LOADER 10/24/2005 10:36:54 AM 1828
(0x0724)


I checked your MP SQL errors from another post. It looks like you're having
SQL problems - outside of SMS.
What changed most recently in your SQL environment?
The only time I saw this problem was on a bad SQL beta build - which leads
me to think that your problem can be isolated to your SQL setup.
Have you tried rebooting your SQL server? (or at least stopping and starting
your sql services)
--
Thanks,
Joseph Calabig

This posting is provided "AS IS" with no warranties, and confers no rights.

"Eric Lau" <EricLau@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1AA7859C-4B4C-4987-860C-C03AFA8AD9C1@xxxxxxxxxxxxxxxx
>I made the changes. I am still getting no hardware inventory.
> Here are of the dataldr.log :
> -----------------------------------------------------------------------------------
> Processing Inventory for Machine: ELAU Generated: 10/24/2005
> 10:35:59 SMS_INVENTORY_DATA_LOADER 10/24/2005 10:36:53 AM 1828 (0x0724)
> File successfully parsed. Processing item ELAU (GUID =
> GUID:1B6FED3A-A12D-4F6F-95A1-986D2C01A9C2) SMS_INVENTORY_DATA_LOADER
> 10/24/2005 10:36:53 AM 1828 (0x0724)
> CDiscoverySource::VerifyClientPublicKeys - Public key does not exist for
> client
> GUID:1B6FED3A-A12D-4F6F-95A1-986D2C01A9C2. SMS_INVENTORY_DATA_LOADER
> 10/24/2005 10:36:53 AM 1828 (0x0724)
> Defining group Class:
> MICROSOFT|SMS_ADVANCED_CLIENT_STATE|1.0... SMS_INVENTORY_DATA_LOADER
> 10/24/2005 10:36:53 AM 1828 (0x0724)
> group Name : SMS Advanced Client
> State... SMS_INVENTORY_DATA_LOADER 10/24/2005 10:36:53 AM 1828 (0x0724)
> *** insert into GroupMap (ArchitectureKey, GroupKey, GroupName,
> NextInstanceKey, GroupClass, Flags, SpecificTableName, HistoryTableName)
> values (5, 1599, "SMS Advanced Client State", 1,
> "MICROSOFT|SMS_ADVANCED_CLIENT_STATE|1.0", 10,
> "SMS_Advanced_Client_S_DATA",
> "SMS_Advanced_Client_S_HIST") SMS_INVENTORY_DATA_LOADER 10/24/2005
> 10:36:54
> AM 1828 (0x0724)
> *** [42000][0][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load
> the
> DLL smsxp.dll, or one of the DLLs it references. Reason: 126(The specified
> module could not be found.). :
> xp_SMS_notification SMS_INVENTORY_DATA_LOADER 10/24/2005 10:36:54 AM 1828
> (0x0724)
> CDefinedArchitecture::InsertDefinedGroup - error in SQL command insert
> into
> GroupMap (ArchitectureKey, GroupKey, GroupName, NextInstanceKey,
> GroupClass,
> Flags, SpecificTableName, HistoryTableName) values (5, 1599, "SMS Advanced
> Client State", 1, "MICROSOFT|SMS_ADVANCED_CLIENT_STATE|1.0", 10,
> "SMS_Advanced_Client_S_DATA",
> "SMS_Advanced_Client_S_HIST") SMS_INVENTORY_DATA_LOADER 10/24/2005
> 10:36:54
> AM 1828 (0x0724)
> CGroup::DefineGroup - couldn't define new
> group SMS_INVENTORY_DATA_LOADER 10/24/2005 10:36:54 AM 1828 (0x0724)
> done SMS_INVENTORY_DATA_LOADER 10/24/2005 10:36:54 AM 1828 (0x0724)
> CGroup::DefineGroupAndAttributes - couldn't define group
> MICROSOFT|SMS_ADVANCED_CLIENT_STATE|1.0 SMS_INVENTORY_DATA_LOADER
> 10/24/2005
> 10:36:54 AM 1828 (0x0724)
> CMachineSource::InsertMachine - could not validate
> machine SMS_INVENTORY_DATA_LOADER 10/24/2005 10:36:54 AM 1828 (0x0724)
> Cannot process MIF Xqhyqolo3.MIF, moving it to
> C:\SMS\inboxes\auth\dataldr.box\BADMIFS\h0oh10uw.MIF
> SMS_INVENTORY_DATA_LOADER 10/24/2005 10:36:54 AM 1828 (0x0724)
> STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server"
> COMP="SMS_INVENTORY_DATA_LOADER" SYS=SMS00 SITE=SUV PID=1504 TID=1828
> GMTDATE=Mon Oct 24 17:36:54.040 2005 ISTR0="Xqhyqolo3.MIF"
> ISTR1="C:\SMS\inboxes\auth\dataldr.box\BADMIFS\h0oh10uw.MIF" ISTR2=""
> ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9=""
> NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 10/24/2005 10:36:54 AM 1828 (0x0724)
> Finished processing file Xqhyqolo3.MIF SMS_INVENTORY_DATA_LOADER
> 10/24/2005
> 10:36:54 AM 1828 (0x0724)
>
> -------------------------------------------------------------------------------------------
>
> Thanks for any help.
>


.

Relevant Pages

  • Re: Deploying sql everwhere
    ... that has updates for sql mobile (there is only the sql everwhere ctp which I ... the sqlcerverce dll: ... need to reference the desktop DLLs, and for a device app you need to ...
    (microsoft.public.sqlserver.ce)
  • Re: Deploying sql everwhere
    ... thanks again for your help with the sql everywhere issues. ... that has updates for sql mobile (there is only the sql everwhere ctp ... the sqlcerverce dll: ... installation but the install did not put any new CAB files on ...
    (microsoft.public.sqlserver.ce)
  • Re: Deploying sql everwhere
    ... Microsoft is aware of one of the bugs - I submitted a support request for it ... error that I get 'sql mobile has encountered an error opening the database'. ... this is the dll I referenced in my .NET compact application but perhaps ...
    (microsoft.public.sqlserver.ce)
  • Re: Deploying sql everwhere
    ... that has updates for sql mobile (there is only the sql everwhere ctp which ... this is the dll I referenced in my .NET compact application but perhaps ... installation but the install did not put any new CAB files on my ...
    (microsoft.public.sqlserver.ce)
  • opinion about a view
    ... The code uses a SQL string which selects * ... very simple inner join of two very simple tables, ... the hotfix package has to update the DLL and run a script ...
    (microsoft.public.vb.database)
Loading