Article - CS385080
"Cannot insert the value NULL into column '<COLUMN_NAME>'" when uploading or modifying configuration in ThingWorx Apps and Digital Performance Management
Modified: 30-Jan-2025
Applies To
- ThingWorx Connected Work Cell 3.1.0 to 9.7
- ThingWorx Real-Time Production Performance Monitoring 9.5 to 9.7
- ThingWorx Asset Monitoring and Utilization 9.5 to 9.7
- Digital Performance Management 1.2 to 9.7
Description
- Unable to upload JSON data into database for ThingWorx Real-Time Production Performance Monitoring (RTPPM)/ ThingWorx Connected Work Cell (CWC)/ ThingWorx Asset Monitoring and Utilization (AMU)
- When the JSON generated using configuration Excel file is inserted into database, below error occurs in <ThingworxStorage>\logs\DatabaseLog.log or <ThingworxStorage>\logs\ScriptLog.log:
Cannot insert the value NULL into column '<COLUMN_NAME>', table '<DATABASE_NAME>.dbo.<TABLE_NAME>'; column does not allow nulls. INSERT fails. - When programmatically altering the configuration for Digital Performance Management (DPM) the above error occurs in <ThingworxStorage>\logs\DatabaseLog.log or <ThingworxStorage>\logs\ScriptLog.log
This is a printer-friendly version of Article 385080 and may be out of date. For the latest version click CS385080