RE: SMS_INVENTORY_DATA_LOADER Error

We had the same issue but it's fixed now. Hopefully this help too, see the
link below.

http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sms.inventory&mid=00619611-e6b4-4b4e-a569-2a6cd7ad56f2&sloc=en-us

AC

"Sonnichsen" wrote:

Hi

I keep getting the following error in the SMS_INVENTORY_DATA_LOADER status
message log every minut:
Microsoft SQL Server reported SQL message 547, severity 16:
[23000][547][Microsoft][ODBC SQL Server Driver][SQL Server]DELETE statement
conflicted with TABLE REFERENCE constraint 'DataItemContext_1_FK'. The
conflict occurred in database 'SMS_100', table 'DataItemContext'.

and the corresponding error in the dataldr.log file:
~Done with wait for Hinv action ID. $$<SMS_INVENTORY_DATA_LOADER><Thu Oct
04 15:09:42.010 2007 W. Europe Daylight Time><thread=540 (0x21C)>
Start of cimv2\sms-to-policy conversion $$<SMS_INVENTORY_DATA_LOADER><Thu
Oct 04 15:09:42.010 2007 W. Europe Daylight Time><thread=540 (0x21C)>
Resetting SMS_Report qualifier to FALSE on all classes and properties in
cimv2\sms namespace $$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04 15:09:42.010
2007 W. Europe Daylight Time><thread=540 (0x21C)>
Running MOFCOMP on C:\PROGSYS\SMS\inboxes\clifiles.src\hinv\sms_def.mof
$$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04 15:09:42.182 2007 W. Europe Daylight
Time><thread=540 (0x21C)>
MOF backed up to C:\PROGSYS\SMS\data\hinvarchive\sms_def.mof.bak~
$$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04 15:09:43.463 2007 W. Europe Daylight
Time><thread=540 (0x21C)>
Warning: cannot get SMS_Class_ID of SMS_Win32ProviderEx~
$$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04 15:09:43.510 2007 W. Europe Daylight
Time><thread=540 (0x21C)>
Removing DataItem id {f0bd0c00-2bed-4db6-a5b5-3076f67d6b9e} from DataItem
table (no longer set for hinv reporting) $$<SMS_INVENTORY_DATA_LOADER><Thu
Oct 04 15:09:45.104 2007 W. Europe Daylight Time><thread=540 (0x21C)>
*** DELETE FROM DataItem WHERE DataItemID =
'{f0bd0c00-2bed-4db6-a5b5-3076f67d6b9e}' $$<SMS_INVENTORY_DATA_LOADER><Thu
Oct 04 15:09:45.120 2007 W. Europe Daylight Time><thread=540 (0x21C)>
*** [23000][547][Microsoft][ODBC SQL Server Driver][SQL Server]DELETE
statement conflicted with TABLE REFERENCE constraint 'DataItemContext_1_FK'.
The conflict occurred in database 'SMS_100', table 'DataItemContext'.
$$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04 15:09:45.120 2007 W. Europe Daylight
Time><thread=540 (0x21C)>
*** DELETE FROM DataItem WHERE DataItemID =
'{f0bd0c00-2bed-4db6-a5b5-3076f67d6b9e}' $$<SMS_INVENTORY_DATA_LOADER><Thu
Oct 04 15:09:45.120 2007 W. Europe Daylight Time><thread=540 (0x21C)>
*** [01000][3621][Microsoft][ODBC SQL Server Driver][SQL Server]The
statement has been terminated. $$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04
15:09:45.120 2007 W. Europe Daylight Time><thread=540 (0x21C)>
SQL statement executed - "DELETE FROM DataItem WHERE DataItemID =
'{f0bd0c00-2bed-4db6-a5b5-3076f67d6b9e}'" result = -1
$$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04 15:09:45.120 2007 W. Europe Daylight
Time><thread=540 (0x21C)>
Warning: could not verify/remove hardware inventory data item record
(DataItem id {f0bd0c00-2bed-4db6-a5b5-3076f67d6b9e}) during MOF class
enumeration - 0x80004005 $$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04
15:09:45.120 2007 W. Europe Daylight Time><thread=540 (0x21C)>
Rolling back policy transaction due to error.
$$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04 15:09:45.120 2007 W. Europe Daylight
Time><thread=540 (0x21C)>
End of cimv2\sms-to-policy conversion; returning 0x80004005
$$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04 15:09:45.120 2007 W. Europe Daylight
Time><thread=540 (0x21C)>
Failed to convert MOF class/properties to policy; a retry will be attempted
later... $$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04 15:09:45.120 2007 W.
Europe Daylight Time><thread=540 (0x21C)>
Cleaning aged temp files... $$<SMS_INVENTORY_DATA_LOADER><Thu Oct 04
15:09:49.479 2007 W. Europe Daylight Time><thread=3628 (0xE2C)>


I'm running SMS 2003 SP3 against SQL 2000 SP3.

Any ideas, it's driving me insain.
--
Soren Holst Sonnichsen
Denmark
.

Relevant Pages

  • RE: SMS_INVENTORY_DATA_LOADER Error
    ... Microsoft SQL Server reported SQL message 547, ... statement conflicted with TABLE REFERENCE constraint 'DataItemContext_1_FK'. ... The conflict occurred in database 'SMS_100', ... Rolling back policy transaction due to error. ...
    (microsoft.public.sms.inventory)
  • RE: Using Access with concurrent users
    ... > See way below, at end of this stuff, for getting a user's network login ... > If you are optimizing the performance of an Access database, ... > to start is with the Performance Analyzer. ... > that connects to a Microsoft SQL Server database and is used to create ...
    (microsoft.public.access.setupconfig)
  • RE: Using Access with concurrent users
    ... See way below, at end of this stuff, for getting a user's network login ... If you are optimizing the performance of an Access database, ... The Performance Analyzer can also make some proposed changes for you if you ... Microsoft SQL Server database and is used to create client/server ...
    (microsoft.public.access.setupconfig)
  • Re: 2008 Express Edition missing Data drivers?
    ... I think I found the posts I was looking for: ... 2000 instance but the only drivers available are Microsoft Access DataBase ... file, Microsoft Sql Server Compact 3.5, and Microsoft SQL Server Database ... connections in a manner I am familiar with. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: 2008 Express Edition missing Data drivers?
    ... I think I found the posts I was looking for: ... I only want to connect to a Northwinds db in my local SQL Server ... 2000 instance but the only drivers available are Microsoft Access DataBase ... file, Microsoft Sql Server Compact 3.5, and Microsoft SQL Server Database ...
    (microsoft.public.dotnet.framework.adonet)