PENDING Deployment stuck "Starting to process content"

[Stephen2]

Hi all, please excuse me, I'm a newbie to SCCM. So far I think I'm gaining an OK understanding, but this has got me stumped.

My first job after configuration is to deploy a custom EXE package - McAfee antivirus client - to all machines.

Creating the deployment package, with 1 Program in there, all made sense and I think is OK.

It's then trying to distribute to the Distribution Point (there's only 1 SCCM server involved in my network) - and the status is stuck at "Starting to process content"

I've searched the logs, for the package ID WEB0000A - but found nothing except in SMSProv.log, which don't seem to indicate errors


I'd love some help to figure this out, thank you very much!

 

[Stephen2]

More info:
* Using SCCM 2016, Server 2016
* On initial creation of the package, I was getting errors at the end (finishing/saving the package).

The errors led me to things like this in the log:

*** insert SMSPackages (PkgID, Name, Version, Language, Manufacturer, PreDownloadRule, Description, ISVString, Hash, NewHash, Source, SourceSite, StoredPkgPath, RefreshSchedule, LastRefresh, StoredPkgVersion, ShareName, PreferredAddress, StorePkgFlag, ShareType, HashVersion,Architecture, ImagePath,Permission, UseForcedDisconnect, ForcedRetryDelay, DisconnectDelay, IgnoreSchedule, Priority, PkgFlags, MIFFilename, MIFPublisher, MIFName, MIFVersion, SourceVersion, SourceDate, SourceSize, SourceCompSize, ImageFlags, PackageType, AlternateContentProviders, SourceLocaleID, TransformReadiness, TransformAnalysisDate, UpdateMask, UpdateMaskEx, Action, DefaultImage) values (N'WEB0000B', N'Install fonts 2017', N'', N'',N'',N'',N'',N'',N'',N'',N'\\websilk.local\dfs\Resources\fonts library\!2017',N'WEB',N'',N'',N'04/10/1970 06:35:00', 0, N'',N'', 2, 1, 1, N'', N'', 15, 0, 2, 5, 0, 2, 16777216, N'',N'',N'',N'', 1, N'10/01/2017 21:59:02', 0, 0, 0, 0, N'', 1033, 0, N'1980/01/01 00:00:00', 0, 0, 2, 0) $$<SMS Provider><10-02-2017 08:59:02.480-660><thread=5784 (0x1698)>
*** [23000][515][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'SEDOComponentID', table 'CM_WEB.dbo.SMSPackages_G'; column does not allow nulls. INSERT fails. : tr_SMSPackages_ins $$<SMS Provider><10-02-2017 08:59:02.481-660><thread=5784 (0x1698)>
~*~*~[23000][515][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'SEDOComponentID', table 'CM_WEB.dbo.SMSPackages_G'; column does not allow nulls. INSERT fails. : tr_SMSPackages_ins ThreadID : 5784 , DbError: 515 , Sev: 16~*~*~ $$<SMS Provider><10-02-2017 08:59:02.481-660><thread=5784 (0x1698)>
~*~*~e:\cm1702_rtm\sms\siteserver\sdk_provider\smsprov\ssppackage.cpp(1116) : CSspPkgProgram: DISTSRC_SQL_ERROR~ SQL Error: [23000][515][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'SEDOComponentID', table 'CM_WEB.dbo.SMSPackages_G'; column does not allow nulls. INSERT fails. : tr_SMSPackages_ins~*~*~ $$<SMS Provider><10-02-2017 08:59:02.482-660><thread=5784 (0x1698)>
~*~*~CSspPkgProgram: DISTSRC_SQL_ERROR [23000][515][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'SEDOComponentID', table 'CM_WEB.dbo.SMSPackages_G'; column does not allow nulls. INSERT fails. : tr_SMSPackages_ins~*~*~ $$<SMS Provider><10-02-2017 08:59:02.483-660><thread=5784 (0x1698)>


Something about not inserting into "SEDOComponentID" column. Rebooting the SCCM server worked to make this work, to the point where I'm stuck at.


Now, trying to create a 2nd package (install fonts), is giving the same error messages on trying to create the package...

 

[Stephen2]

Upgrade from 1702 to 1706 had broken, leaving things in a not so good state.

Am uninstalling/fresh install and upgrade first, before anything else

Wish me luck