none
sccm 12 Данные аппаратной инвентаризации не сохраняются в базу SQL RRS feed

  • Вопрос

  • В сообщениях от компонента SMS_INVENTORY_DATA_LOADER постоянно сыпятся предупреждения 2703

    Загрузчик данных инвентаризации не смог обработать разностный MIF-файл "XHM344TCB.MIF" и переместил его в "C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\ErrorCode_4\8li0zv0a.MIF".

    Возможная причина: файл попытался обновить данные инвентаризации в базе данных сайта, которая уже не существует, или файл содержит недопустимый синтаксис.
    Решение: инвентаризация клиента требует повторной синхронизации, которая будет выполнена автоматически. Найдите сообщения об изменении состояния 2714 и 2715, указывающие на начало повторной синхронизации.

    Потом появляется сообщение 2715, что нужна повторная синхронизация и так постоянно.

    И переодически появляется ошибка 620

    Microsoft SQL Server выдал сообщение SQL 8152, важность 16: [22001][8152][Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. : pINSTALLED_SOFTWARE_DATA

    Дальнейшие сведения об устранении неполадки см. в документации по Configuration Manager, SQL или в базе знаний Майкрософт.

    В логе на сервере dataldr.log похожие сведения и такие строчки

    Begin transaction: Machine=D-COMP7-A(GUID:c352fd48-0b68-4be2-8f15-97338fb668f7) SMS_INVENTORY_DATA_LOADER 16.05.2013 12:46:28 5020 (0x139C)
    *** [22001][8152][Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. : pINSTALLED_SOFTWARE_DATA SMS_INVENTORY_DATA_LOADER 16.05.2013 12:46:28 5020 (0x139C)
    ERROR - SQL Error in SMS_INVENTORY_DATA_LOADER 16.05.2013 12:46:28 5020 (0x139C)
    ERROR - is NOT retyrable. SMS_INVENTORY_DATA_LOADER 16.05.2013 12:46:28 5020 (0x139C)
    Rollback transaction: Machine=D-COMP7-A(GUID:c352fd48-0b68-4be2-8f15-97338fb668f7) SMS_INVENTORY_DATA_LOADER 16.05.2013 12:46:29 5020 (0x139C)
    Cannot process MIF XHZERAGC4.MIF, moving it to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\ErrorCode_4\1ftsvgc1.MIF SMS_INVENTORY_DATA_LOADER 16.05.2013 12:46:29 5020 (0x139C)
    STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SVC-SCCM12-01.domain.local SITE=OPT PID=2228 TID=5020 GMTDATE=Чт май 16 08:46:29.058 2013 ISTR0="XHZERAGC4.MIF" ISTR1="C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\ErrorCode_4\1ftsvgc1.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 16.05.2013 12:46:29 5020 (0x139C)
    Done: Machine=D-COMP7-A(GUID:c352fd48-0b68-4be2-8f15-97338fb668f7) code=4 (1676 stored procs in XHZERAGC4.MIF) SMS_INVENTORY_DATA_LOADER 16.05.2013 12:46:29 5020 (0x139C)

    При чем обчно эти mif файлы перемещаются просто в badmifs, и только некоторые в errorcode_4

    Где можно посмотреть, что мешает этим mif файлам нормально обработаться?

    При чем некоторые mif файлы нормально уходят в папку process. Некоторые отчеты работают, то есть данные с клиентов попадают в базу, но как-то выборочно.

     

Ответы

  • Всё, разобрался.

    Частичное решение проблемы здесь http://social.technet.microsoft.com/Forums/ru-RU/sqlru/thread/b4ef06b6-87e2-4063-87a2-d195035aac7b

    Нужно увеличить длину полей в таблицах на сиквел сервере, вот только понять, какие поля нужно увеличить не удалось выяснить, поэтому увеличил все поля.

    А вообще, насколько мне удалось понять. Раньше Сиквел говорил SCCM'у, что вот именоо это поле в этой таблице would be truncated. А SCCM говорил ему "alter".

    И все жили дружно и счастливо. А сейчас что-то прогнило в Датском королевстве. И когда появляются неправильные данные, всё фейлится :( Поправьте, если я не прав.

Все ответы

  • Можно увидеть полный dataldr.log, посмотрите непосредствено логи SQL есть ли там ошибки?


    Maxim Sinel'nikov

    Отвечающий
  • А как сюда выложить полный лог (и действительно нужен полный-полный?) и какие имено логи SQL нужно смотреть?

    Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG - здесь ничего нет.

    eventvwr на sql server тоже без ошибок.

  • Вот я заново включил Hardware inventory
    Found 'ICP' notification files.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:51.226-240><thread=4844 (0x12EC)>
    Looking for inventory schema changes...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:51.235-240><thread=4844 (0x12EC)>
    ...no inventory schema changes found.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:51.369-240><thread=4844 (0x12EC)>
    Checking if safe to update inventory reporting views.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:51.379-240><thread=4844 (0x12EC)>
    Updating inventory reporting views.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:51.389-240><thread=4844 (0x12EC)>
    Reporting views completed  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:51.510-240><thread=4844 (0x12EC)>
    Looking for inventory schema changes...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:52.028-240><thread=4844 (0x12EC)>
    ...no inventory schema changes found.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:52.302-240><thread=4844 (0x12EC)>
    Checking if safe to update inventory reporting views.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:52.310-240><thread=4844 (0x12EC)>
    Updating inventory reporting views.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:52.319-240><thread=4844 (0x12EC)>
    Reporting views completed  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:22:52.430-240><thread=4844 (0x12EC)>
    Checking for configuration changes ...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:18.832-240><thread=4832 (0x12E0)>
    Cleaning aged temp files...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:18.843-240><thread=4832 (0x12E0)>
    Checking inbox for any MIFs to process...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:18.852-240><thread=4832 (0x12E0)>
    >> Add 1 files to process directory ...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:18.861-240><thread=4832 (0x12E0)>
    Moving MIF file C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\HI9TU68M.MIF to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\process\HI9TU68M.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:18.870-240><thread=4832 (0x12E0)>
    ~Started the machine MIF processing thread, thread ID = E2C  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:18.880-240><thread=4832 (0x12E0)>
    Worker thread 3484 starting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:18.889-240><thread=3484 (0xD9C)>
    ~Done with job queueing.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:19.918-240><thread=3628 (0xE2C)>
    Blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:19.929-240><thread=3628 (0xE2C)>
    Thread: 0 is using GUID   $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:19.918-240><thread=3484 (0xD9C)>
    Thread: 3484 will use GUID GUID:5A879056-FF0B-41B9-9615-F8A04264BA56  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:19.959-240><thread=3484 (0xD9C)>
    Processing Inventory for Machine: D-KUPRIYANOV7-K   Version 5.0  Generated: 05/17/2013 11:27:36  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:20.462-240><thread=3484 (0xD9C)>
    CMachineSource::InsertMachine - machine info is resynced data (ie: MIF is a full/resync report).  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:20.481-240><thread=3484 (0xD9C)>
    STATMSG: ID=2715 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SVC-SCCM12-01.optogan.local SITE=OPT PID=2228 TID=3484 GMTDATE=Пт май 17 07:28:20.490 2013 ISTR0="SMS Inventory Agent" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:20.495-240><thread=3484 (0xD9C)>
    SQL MESSAGE: spAddInventoryLog - Inventory Log for machine:D-KUPRIYANOV7-K,Server:4.142,Client:5.0,Message:full/resync report,Detail:  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:23.393-240><thread=3484 (0xD9C)>
    Begin transaction: Machine=D-KUPRIYANOV7-K(GUID:5A879056-FF0B-41B9-9615-F8A04264BA56)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:23.401-240><thread=3484 (0xD9C)>
    Commit transaction: Machine=D-KUPRIYANOV7-K(GUID:5A879056-FF0B-41B9-9615-F8A04264BA56)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:25.159-240><thread=3484 (0xD9C)>
    Done: Machine=D-KUPRIYANOV7-K(GUID:5A879056-FF0B-41B9-9615-F8A04264BA56) code=0 (3327 stored procs in XHI9TU68M.MIF)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:25.171-240><thread=3484 (0xD9C)>
    Done blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:25.994-240><thread=3628 (0xE2C)>
    ~No more machine MIFs to be processed, terminating thread  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:26.004-240><thread=3628 (0xE2C)>
    Shutting down Machine Writer.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:26.012-240><thread=3628 (0xE2C)>
    Worker thread 3484 halting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:26.020-240><thread=3484 (0xD9C)>
    Finished processing 1 MIFs  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:28:31.021-240><thread=3628 (0xE2C)>
    Cleaning aged temp files...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:03.343-240><thread=4832 (0x12E0)>
    Checking inbox for any MIFs to process...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:03.355-240><thread=4832 (0x12E0)>
    >> Add 1 files to process directory ...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:03.362-240><thread=4832 (0x12E0)>
    Moving MIF file C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\H0CIBOFS.MIF to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\process\H0CIBOFS.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:03.368-240><thread=4832 (0x12E0)>
    ~Started the machine MIF processing thread, thread ID = 171C  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:03.375-240><thread=4832 (0x12E0)>
    Worker thread 172 starting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:03.382-240><thread=172 (0xAC)>
    Thread: 0 is using GUID   $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:04.386-240><thread=172 (0xAC)>
    Thread: 172 will use GUID GUID:99E1EB10-514B-4EAD-8082-3DA45B538144  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:04.395-240><thread=172 (0xAC)>
    ~Done with job queueing.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:04.386-240><thread=5916 (0x171C)>
    Blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:04.432-240><thread=5916 (0x171C)>
    Processing Inventory for Machine: D-TEST7   Version 2.0  Generated: 05/17/2013 11:35:52  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:04.667-240><thread=172 (0xAC)>
    CMachineSource::InsertMachine - machine info is resynced data (ie: MIF is a full/resync report).  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:04.685-240><thread=172 (0xAC)>
    STATMSG: ID=2715 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SVC-SCCM12-01.optogan.local SITE=OPT PID=2228 TID=172 GMTDATE=Пт май 17 07:36:04.692 2013 ISTR0="SMS Inventory Agent" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:04.696-240><thread=172 (0xAC)>
    SQL MESSAGE: spAddInventoryLog - Inventory Log for machine:D-TEST7,Server:1.141,Client:2.0,Message:full/resync report,Detail:  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:05.674-240><thread=172 (0xAC)>
    Begin transaction: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:05.683-240><thread=172 (0xAC)>
    *** [22001][8152][Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. : dINSTALLED_SOFTWARE_DATA  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:05.810-240><thread=172 (0xAC)>
    ERROR - SQL Error in   $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:05.820-240><thread=172 (0xAC)>
    ERROR - is NOT retyrable.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:05.826-240><thread=172 (0xAC)>
    Rollback transaction: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:05.831-240><thread=172 (0xAC)>
    ~Cannot process MIF XH0CIBOFS.MIF, moving it to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\ErrorCode_4\gp51mou5.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:05.858-240><thread=172 (0xAC)>
    STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SVC-SCCM12-01.optogan.local SITE=OPT PID=2228 TID=172 GMTDATE=Пт май 17 07:36:05.900 2013 ISTR0="XH0CIBOFS.MIF" ISTR1="C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\ErrorCode_4\gp51mou5.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:05.900-240><thread=172 (0xAC)>
    Done: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144) code=4 (2275 stored procs in XH0CIBOFS.MIF)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:05.908-240><thread=172 (0xAC)>
    Done blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:06.449-240><thread=5916 (0x171C)>
    ~No more machine MIFs to be processed, terminating thread  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:06.456-240><thread=5916 (0x171C)>
    Shutting down Machine Writer.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:06.461-240><thread=5916 (0x171C)>
    Worker thread 172 halting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:06.467-240><thread=172 (0xAC)>
    Finished processing 1 MIFs  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:36:11.468-240><thread=5916 (0x171C)>
    Cleaning aged temp files...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:04.119-240><thread=4832 (0x12E0)>
    Checking inbox for any MIFs to process...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:04.130-240><thread=4832 (0x12E0)>
    >> Add 1 files to process directory ...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:04.140-240><thread=4832 (0x12E0)>
    Moving MIF file C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\HCCHAZJY.MIF to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\process\HCCHAZJY.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:04.151-240><thread=4832 (0x12E0)>
    ~Started the machine MIF processing thread, thread ID = 9B8  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:04.161-240><thread=4832 (0x12E0)>
    Worker thread 4416 starting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:04.170-240><thread=4416 (0x1140)>
    ~Done with job queueing.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:05.176-240><thread=2488 (0x9B8)>
    Blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:05.187-240><thread=2488 (0x9B8)>
    Thread: 0 is using GUID   $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:05.176-240><thread=4416 (0x1140)>
    Thread: 4416 will use GUID GUID:6F3FF799-F113-46C3-919D-BE1D4151D4B6  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:05.217-240><thread=4416 (0x1140)>
    Processing Inventory for Machine: N-TEST732-G   Version 1.7  Generated: 05/14/2013 12:52:50  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:05.243-240><thread=4416 (0x1140)>
    Begin transaction: Machine=N-TEST732-G(GUID:6F3FF799-F113-46C3-919D-BE1D4151D4B6)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:05.284-240><thread=4416 (0x1140)>
    Commit transaction: Machine=N-TEST732-G(GUID:6F3FF799-F113-46C3-919D-BE1D4151D4B6)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:05.386-240><thread=4416 (0x1140)>
    Done: Machine=N-TEST732-G(GUID:6F3FF799-F113-46C3-919D-BE1D4151D4B6) code=0 (107 stored procs in XHCCHAZJY.MIF)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:05.398-240><thread=4416 (0x1140)>
    Done blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:06.229-240><thread=2488 (0x9B8)>
    ~No more machine MIFs to be processed, terminating thread  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:06.239-240><thread=2488 (0x9B8)>
    Shutting down Machine Writer.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:06.246-240><thread=2488 (0x9B8)>
    Worker thread 4416 halting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:06.254-240><thread=4416 (0x1140)>
    Finished processing 1 MIFs  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:54:11.254-240><thread=2488 (0x9B8)>
    Cleaning aged temp files...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:09.432-240><thread=4832 (0x12E0)>
    Checking inbox for any MIFs to process...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:09.445-240><thread=4832 (0x12E0)>
    >> Add 1 files to process directory ...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:09.455-240><thread=4832 (0x12E0)>
    Moving MIF file C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\HT9G5N64.MIF to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\process\HT9G5N64.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:09.464-240><thread=4832 (0x12E0)>
    ~Started the machine MIF processing thread, thread ID = BA8  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:09.474-240><thread=4832 (0x12E0)>
    Worker thread 1716 starting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:09.483-240><thread=1716 (0x6B4)>
    Thread: 0 is using GUID   $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:10.515-240><thread=1716 (0x6B4)>
    Thread: 1716 will use GUID GUID:6F3FF799-F113-46C3-919D-BE1D4151D4B6  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:10.526-240><thread=1716 (0x6B4)>
    Processing Inventory for Machine: N-TEST732-G   Version 1.8  Generated: 05/17/2013 11:27:11  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:10.543-240><thread=1716 (0x6B4)>
    Begin transaction: Machine=N-TEST732-G(GUID:6F3FF799-F113-46C3-919D-BE1D4151D4B6)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:10.566-240><thread=1716 (0x6B4)>
    ~Done with job queueing.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:10.515-240><thread=2984 (0xBA8)>
    Blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:10.598-240><thread=2984 (0xBA8)>
    Commit transaction: Machine=N-TEST732-G(GUID:6F3FF799-F113-46C3-919D-BE1D4151D4B6)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:10.595-240><thread=1716 (0x6B4)>
    Done: Machine=N-TEST732-G(GUID:6F3FF799-F113-46C3-919D-BE1D4151D4B6) code=0 (45 stored procs in XHT9G5N64.MIF)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:10.625-240><thread=1716 (0x6B4)>
    Done blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:11.608-240><thread=2984 (0xBA8)>
    ~No more machine MIFs to be processed, terminating thread  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:11.617-240><thread=2984 (0xBA8)>
    Shutting down Machine Writer.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:11.624-240><thread=2984 (0xBA8)>
    Worker thread 1716 halting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:11.632-240><thread=1716 (0x6B4)>
    Finished processing 1 MIFs  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 11:55:16.633-240><thread=2984 (0xBA8)>
    Cleaning aged temp files...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:31.520-240><thread=4832 (0x12E0)>
    Checking inbox for any MIFs to process...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:31.531-240><thread=4832 (0x12E0)>
    >> Add 1 files to process directory ...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:31.541-240><thread=4832 (0x12E0)>
    Moving MIF file C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\HVFACRLU.MIF to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\process\HVFACRLU.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:31.551-240><thread=4832 (0x12E0)>
    ~Started the machine MIF processing thread, thread ID = 8D8  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:31.560-240><thread=4832 (0x12E0)>
    Worker thread 1720 starting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:31.571-240><thread=1720 (0x6B8)>
    Thread: 0 is using GUID   $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:32.596-240><thread=1720 (0x6B8)>
    ~Done with job queueing.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:32.596-240><thread=2264 (0x8D8)>
    Blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:32.618-240><thread=2264 (0x8D8)>
    Thread: 1720 will use GUID GUID:99E1EB10-514B-4EAD-8082-3DA45B538144  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:32.609-240><thread=1720 (0x6B8)>
    Processing Inventory for Machine: D-TEST7   Version 3.0  Generated: 05/17/2013 12:01:21  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:32.907-240><thread=1720 (0x6B8)>
    CMachineSource::InsertMachine - machine info is resynced data (ie: MIF is a full/resync report).  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:32.928-240><thread=1720 (0x6B8)>
    STATMSG: ID=2715 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SVC-SCCM12-01.optogan.local SITE=OPT PID=2228 TID=1720 GMTDATE=Пт май 17 08:01:32.937 2013 ISTR0="SMS Inventory Agent" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:32.942-240><thread=1720 (0x6B8)>
    SQL MESSAGE: spAddInventoryLog - Inventory Log for machine:D-TEST7,Server:1.141,Client:3.0,Message:full/resync report,Detail:  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:33.788-240><thread=1720 (0x6B8)>
    Begin transaction: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:33.799-240><thread=1720 (0x6B8)>
    *** [22001][8152][Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. : dINSTALLED_SOFTWARE_DATA  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:33.992-240><thread=1720 (0x6B8)>
    ERROR - SQL Error in   $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:34.005-240><thread=1720 (0x6B8)>
    ERROR - is NOT retyrable.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:34.014-240><thread=1720 (0x6B8)>
    Rollback transaction: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:34.023-240><thread=1720 (0x6B8)>
    ~Cannot process MIF XHVFACRLU.MIF, moving it to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\ErrorCode_4\zyjr21w8.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:34.055-240><thread=1720 (0x6B8)>
    STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SVC-SCCM12-01.optogan.local SITE=OPT PID=2228 TID=1720 GMTDATE=Пт май 17 08:01:34.065 2013 ISTR0="XHVFACRLU.MIF" ISTR1="C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\ErrorCode_4\zyjr21w8.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:34.065-240><thread=1720 (0x6B8)>
    Done: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144) code=4 (2275 stored procs in XHVFACRLU.MIF)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:34.075-240><thread=1720 (0x6B8)>
    Done blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:34.642-240><thread=2264 (0x8D8)>
    ~No more machine MIFs to be processed, terminating thread  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:34.649-240><thread=2264 (0x8D8)>
    Shutting down Machine Writer.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:34.655-240><thread=2264 (0x8D8)>
    Worker thread 1720 halting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:34.661-240><thread=1720 (0x6B8)>
    Finished processing 1 MIFs  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:01:39.662-240><thread=2264 (0x8D8)>
    Cleaning aged temp files...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:41.179-240><thread=4832 (0x12E0)>
    Checking inbox for any MIFs to process...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:41.193-240><thread=4832 (0x12E0)>
    >> Add 1 files to process directory ...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:41.204-240><thread=4832 (0x12E0)>
    Moving MIF file C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\HZDSJWAG.MIF to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\process\HZDSJWAG.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:41.214-240><thread=4832 (0x12E0)>
    ~Started the machine MIF processing thread, thread ID = 1464  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:41.227-240><thread=4832 (0x12E0)>
    Worker thread 5600 starting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:41.235-240><thread=5600 (0x15E0)>
    Thread: 0 is using GUID   $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.252-240><thread=5600 (0x15E0)>
    ~Done with job queueing.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.252-240><thread=5220 (0x1464)>
    Blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.272-240><thread=5220 (0x1464)>
    Thread: 5600 will use GUID GUID:99E1EB10-514B-4EAD-8082-3DA45B538144  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.264-240><thread=5600 (0x15E0)>
    Processing Inventory for Machine: D-TEST7   Version 3.1  Generated: 05/17/2013 12:03:37  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.295-240><thread=5600 (0x15E0)>
    Begin transaction: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.316-240><thread=5600 (0x15E0)>
    WARNING - Attempting to resync due to missed delta reports (sp return code = 7)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.331-240><thread=5600 (0x15E0)>
    Rollback transaction: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.338-240><thread=5600 (0x15E0)>
    SQL MESSAGE: spAddInventoryLog - Inventory Log for machine:D-TEST7,Server:1.141,Client:3.1,Message:Missing Delta. Resync,Detail:  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.359-240><thread=5600 (0x15E0)>
    Remote client hardware inventory resync generated for client GUID:99E1EB10-514B-4EAD-8082-3DA45B538144; update/insert result = 2  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.455-240><thread=5600 (0x15E0)>
    ~Send resync command to local site for machine GUID:99E1EB10-514B-4EAD-8082-3DA45B538144.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.463-240><thread=5600 (0x15E0)>
    STATMSG: ID=2722 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SVC-SCCM12-01.optogan.local SITE=OPT PID=2228 TID=5600 GMTDATE=Пт май 17 08:03:42.470 2013 ISTR0="D-TEST7" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.476-240><thread=5600 (0x15E0)>
    ~Cannot process MIF XHZDSJWAG.MIF, moving it to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\DeltaMismatch\j29yhh1z.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.488-240><thread=5600 (0x15E0)>
    STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SVC-SCCM12-01.optogan.local SITE=OPT PID=2228 TID=5600 GMTDATE=Пт май 17 08:03:42.539 2013 ISTR0="XHZDSJWAG.MIF" ISTR1="C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\DeltaMismatch\j29yhh1z.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.539-240><thread=5600 (0x15E0)>
    Done: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144) code=408 (16 stored procs in XHZDSJWAG.MIF)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:42.549-240><thread=5600 (0x15E0)>
    Done blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:43.293-240><thread=5220 (0x1464)>
    ~No more machine MIFs to be processed, terminating thread  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:43.303-240><thread=5220 (0x1464)>
    Shutting down Machine Writer.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:43.311-240><thread=5220 (0x1464)>
    Worker thread 5600 halting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:43.319-240><thread=5600 (0x15E0)>
    Finished processing 1 MIFs  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:03:48.320-240><thread=5220 (0x1464)>
    Cleaning aged temp files...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:49.688-240><thread=4832 (0x12E0)>
    Checking inbox for any MIFs to process...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:49.703-240><thread=4832 (0x12E0)>
    >> Add 1 files to process directory ...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:49.711-240><thread=4832 (0x12E0)>
    Moving MIF file C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\H9VGRL7Z.MIF to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\process\H9VGRL7Z.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:49.719-240><thread=4832 (0x12E0)>
    ~Started the machine MIF processing thread, thread ID = 6B4  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:49.728-240><thread=4832 (0x12E0)>
    Worker thread 5532 starting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:49.736-240><thread=5532 (0x159C)>
    Thread: 0 is using GUID   $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:50.739-240><thread=5532 (0x159C)>
    Thread: 5532 will use GUID GUID:5A879056-FF0B-41B9-9615-F8A04264BA56  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:50.850-240><thread=5532 (0x159C)>
    Processing Inventory for Machine: D-KUPRIYANOV7-K   Version 5.1  Generated: 05/17/2013 12:07:38  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:50.876-240><thread=5532 (0x159C)>
    ~Done with job queueing.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:50.739-240><thread=1716 (0x6B4)>
    Blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:50.915-240><thread=1716 (0x6B4)>
    Begin transaction: Machine=D-KUPRIYANOV7-K(GUID:5A879056-FF0B-41B9-9615-F8A04264BA56)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:50.920-240><thread=5532 (0x159C)>
    Commit transaction: Machine=D-KUPRIYANOV7-K(GUID:5A879056-FF0B-41B9-9615-F8A04264BA56)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:50.986-240><thread=5532 (0x159C)>
    Done: Machine=D-KUPRIYANOV7-K(GUID:5A879056-FF0B-41B9-9615-F8A04264BA56) code=0 (77 stored procs in XH9VGRL7Z.MIF)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:51.000-240><thread=5532 (0x159C)>
    Done blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:51.930-240><thread=1716 (0x6B4)>
    ~No more machine MIFs to be processed, terminating thread  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:51.989-240><thread=1716 (0x6B4)>
    Shutting down Machine Writer.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:51.995-240><thread=1716 (0x6B4)>
    Worker thread 5532 halting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:52.003-240><thread=5532 (0x159C)>
    Finished processing 1 MIFs  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:07:57.004-240><thread=1716 (0x6B4)>
    Cleaning aged temp files...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:07.020-240><thread=4832 (0x12E0)>
    Checking inbox for any MIFs to process...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:07.030-240><thread=4832 (0x12E0)>
    >> Add 1 files to process directory ...  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:07.039-240><thread=4832 (0x12E0)>
    Moving MIF file C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\HV96HRD8.MIF to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\process\HV96HRD8.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:07.048-240><thread=4832 (0x12E0)>
    ~Started the machine MIF processing thread, thread ID = 1150  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:07.056-240><thread=4832 (0x12E0)>
    Worker thread 4320 starting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:07.065-240><thread=4320 (0x10E0)>
    Thread: 0 is using GUID   $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.080-240><thread=4320 (0x10E0)>
    ~Done with job queueing.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.080-240><thread=4432 (0x1150)>
    Blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.099-240><thread=4432 (0x1150)>
    Thread: 4320 will use GUID GUID:99E1EB10-514B-4EAD-8082-3DA45B538144  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.090-240><thread=4320 (0x10E0)>
    Processing Inventory for Machine: D-TEST7   Version 3.2  Generated: 05/17/2013 12:08:16  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.121-240><thread=4320 (0x10E0)>
    Begin transaction: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.139-240><thread=4320 (0x10E0)>
    WARNING - Attempting to resync due to missed delta reports (sp return code = 7)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.152-240><thread=4320 (0x10E0)>
    Rollback transaction: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.161-240><thread=4320 (0x10E0)>
    SQL MESSAGE: spAddInventoryLog - Inventory Log for machine:D-TEST7,Server:1.141,Client:3.2,Message:Missing Delta. Resync,Detail:  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.171-240><thread=4320 (0x10E0)>
    Remote client hardware inventory resync generated for client GUID:99E1EB10-514B-4EAD-8082-3DA45B538144; update/insert result = 1  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.203-240><thread=4320 (0x10E0)>
    ~Send resync command to local site for machine GUID:99E1EB10-514B-4EAD-8082-3DA45B538144.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.211-240><thread=4320 (0x10E0)>
    STATMSG: ID=2722 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SVC-SCCM12-01.optogan.local SITE=OPT PID=2228 TID=4320 GMTDATE=Пт май 17 08:09:08.219 2013 ISTR0="D-TEST7" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.219-240><thread=4320 (0x10E0)>
    ~Cannot process MIF XHV96HRD8.MIF, moving it to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\DeltaMismatch\1unadx41.MIF  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.231-240><thread=4320 (0x10E0)>
    STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SVC-SCCM12-01.optogan.local SITE=OPT PID=2228 TID=4320 GMTDATE=Пт май 17 08:09:08.242 2013 ISTR0="XHV96HRD8.MIF" ISTR1="C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\DeltaMismatch\1unadx41.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.242-240><thread=4320 (0x10E0)>
    Done: Machine=D-TEST7(GUID:99E1EB10-514B-4EAD-8082-3DA45B538144) code=408 (17 stored procs in XHV96HRD8.MIF)  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:08.253-240><thread=4320 (0x10E0)>
    Done blocking until completion.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:09.120-240><thread=4432 (0x1150)>
    ~No more machine MIFs to be processed, terminating thread  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:09.132-240><thread=4432 (0x1150)>
    Shutting down Machine Writer.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:09.140-240><thread=4432 (0x1150)>
    Worker thread 4320 halting execution.  $$<SMS_INVENTORY_DATA_LOADER><05-17-2013 12:09:09.147-240><thread=4320 (0x10E0)>
    

  • То есть при первом цикле выполняется полная инвентаризация, и у одного из трех компьютеров она не проходит, и потом он ругается на ошибку разностной инвентаризации, что и понятно, так как в базе нету никакой информации о компьютере, а ей пытаются подсунуть дельту.

    Я грешу на то, что я влючил дополнительные классы инвентаризации, но я не знаю, какие должны быть по умолчанию включены... а сбросить к заводским настройкам Default Client Policy, как я понял, нельзя.

  • То есть при первом цикле выполняется полная инвентаризация, и у одного из трех компьютеров она не проходит, и потом он ругается на ошибку разностной инвентаризации, что и понятно, так как в базе нету никакой информации о компьютере, а ей пытаются подсунуть дельту.

    Я грешу на то, что я влючил дополнительные классы инвентаризации, но я не знаю, какие должны быть по умолчанию включены... а сбросить к заводским настройкам Default Client Policy, как я понял, нельзя.

    Ну почему же, можно. Найдите исходный файл sms_def.mof.

    Vladimir Zelenov | http://systemcenter4all.wordpress.com

    Отвечающий
  • Вова, какой такой исходный sms_def.mof?

    http://sccm.com.ua/

    Отвечающий
  • Согласен, в 12 сервере убрали sms_def.mof. Я подумываю, развернуть еще один SCCM и из него экспортнуть классы.

    Но, мне кажется, это не спортивно, так как если я опять включу нужные мне классы, то опять появяться эти длинные строчки, и все равно нужно будет найти, что не нравится сиквелу в данных от SCCM.

    Я проверил все логи в SQL Server Agent, но там всё пусто. Может быть можно включить дополнительные логи, или как-то узнать, почему данные не помещаются в базу?

    P.S. Но если есть способ восстановить Default Client Policy, то было бы здорово. А то у меня еще Endpont Protection спрашивает у пользователя можно ли ему обновиться и не обновляется :(

  • Включите расширенное логирование - http://sccm.com.ua/?p=2189

    http://sccm.com.ua/

    Отвечающий
  • но это включает рассширенное логирование на клиенте. А на нем всё хорошо, проблемма на стыке sccm-sql. Может можно такое же логирование включить на sql, ведь ему же нравятся длинные строчки, клиент и сам sccm всем довольны... ну относительно, конечно.

    Может быть надо задать этот вопрос в форуме по сиквелу?

  • Я увеличил длинну всех полей в dbo.Installed_software_data. И ошибка поменялась с

    Microsoft SQL Server выдал сообщение SQL 8152, важность 16: [22001][8152][Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. : dINSTALLED_SOFTWARE_DATA

    на

    Microsoft SQL Server выдал сообщение SQL 8152, важность 16: [22001][8152][Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. : pINSTALLED_SOFTWARE_DATA

  • Всё, разобрался.

    Частичное решение проблемы здесь http://social.technet.microsoft.com/Forums/ru-RU/sqlru/thread/b4ef06b6-87e2-4063-87a2-d195035aac7b

    Нужно увеличить длину полей в таблицах на сиквел сервере, вот только понять, какие поля нужно увеличить не удалось выяснить, поэтому увеличил все поля.

    А вообще, насколько мне удалось понять. Раньше Сиквел говорил SCCM'у, что вот именоо это поле в этой таблице would be truncated. А SCCM говорил ему "alter".

    И все жили дружно и счастливо. А сейчас что-то прогнило в Датском королевстве. И когда появляются неправильные данные, всё фейлится :( Поправьте, если я не прав.

  • Это баг Asset Intelligence. В 2012 SP1 он пофиксен точно не будет, в R2 - на рассмотрении.

    3 марта 2014 г. 6:15