none
SQL errors in SCCM 2012 Log

    Question

  • Hello,

    Every time that I attempt to create a new application package in SCCM 2012, it fails with the following errors in the logs.  Any ideas?

    *** *** Unknown SQL Error!  $$<SMS Provider><04-10-2012 11:43:40.390+240><thread=2856 (0xB28)>
    ~*~*~*** Unknown SQL Error!     ThreadID : 2856 , DbError: 50000 , Sev: 16~*~*~  $$<SMS Provider><04-10-2012 11:43:40.390+240><thread=2856 (0xB28)>
    *** if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL) select * from #sp_setupci_resultstr; else select N'';  $$<SMS Provider><04-10-2012 11:43:40.390+240><thread=2856 (0xB28)>
    *** [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state  $$<SMS Provider><04-10-2012 11:43:40.390+240><thread=2856 (0xB28)>
    ~*~*~[24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state   *** Unknown SQL Error!  ThreadID : 2856 , DbError: 0 , Sev: 0~*~*~  $$<SMS Provider><04-10-2012 11:43:40.391+240><thread=2856 (0xB28)>
    *** if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL) select * from #sp_setupci_resultstr; else select N'';;~ if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL)  drop table #sp_setupci_resultstr;  $$<SMS Provider><04-10-2012 11:43:40.391+240><thread=2856 (0xB28)>
    *** [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state  $$<SMS Provider><04-10-2012 11:43:40.391+240><thread=2856 (0xB28)>
    ~*~*~[24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state   [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state  ThreadID : 2856 , DbError: 0 , Sev: 0~*~*~  $$<SMS Provider><04-10-2012 11:43:40.392+240><thread=2856 (0xB28)>
    ~*~*~e:\nts_sccm_release\sms\siteserver\sdk_provider\smsprov\ssputility.cpp(2105) : SQL command failed:  if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL)  drop table #sp_setupci_resultstr;~    SQL Error: [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state~*~*~  $$<SMS Provider><04-10-2012 11:43:40.392+240><thread=2856 (0xB28)>
    ~*~*~SQL command failed:  if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL)  drop table #sp_setupci_resultstr; [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state~*~*~  $$<SMS Provider><04-10-2012 11:43:40.392+240><thread=2856 (0xB28)>
    ERROR: SQL command failed:  if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL)  drop table #sp_setupci_resultstr;~  $$<SMS Provider><04-10-2012 11:43:40.393+240><thread=2856 (0xB28)>

    Tuesday, April 10, 2012 6:07 PM

Answers

All replies