Data Logging System Error occurs with database engine error null values not allow.

The cause of this error is one or more of the database table columns has been modified  to not allow null values.  OAS creates the columns in the table to allow null values so when the data quality is bad for a tag value a null value will be inserted into the table.  The only column that should be set to not allow null values is the DateAndTime column.  There are 2 solutions to this error:

  1. Please review the columns in each table with the SQL Server Management Studio.  If they have been changed to not allow null values change them back to allow null values.
  2. Go to each logging group and enable the property Do Not Buffer On Primary Index Failure.  Keep in mind that with this property enabled the records to be logged that contain null values will be discarded and not logged.
View All FAQs >