Versions / Builds Affected
20160419Status
OpenProblem Summary
Users LanGuard console is generating error Column 'TODID'. has null values in it when attempting LGCMC sync.TT / JIRAID
GFIL-751How to Identify
User has error 'Column 'TODID' has null values in it.' in LanGuard console > Configuration > Central Management Server
The debug logs will contain an entry like this:
2016-08-04,03:56:00,835,1,"#00000ee8","#00002238","error ","CentralManagementHost.dll","Service.MainLoop - DataSyncUploader.MergeAndUploadAllFiles. Error System.Data.DataException: Column 'TODID' has null values in it. at System.Data.DataColumn.CheckNotAllowNull() at System.Data.DataColumn.set_AllowDBNull(Boolean value) at System.Data.DataTable.set_PrimaryKey(DataColumn[] value) at DataCentralizationDBAndDisk.FileMerging.MergeXmlReaderList(List`1 fileList)Workaround / Fix Details
N/ARequired Actions
1. Gather debug logs.
2. Reach out to PSG for escalation.