Synchronization Error: Column 'TODID'. has null values in it

Versions / Builds Affected

20160419

Status

Open

Problem Summary

Users LanGuard console is generating error Column 'TODID'. has null values in it when attempting LGCMC sync.

TT / JIRAID

GFIL-751

How 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/A

Required Actions

1. Gather debug logs. 2. Reach out to PSG for escalation.