Known issue - Inserting nulls into Data Warehouse tables fail with incorrect error message

When you insert NULL values into NOT NULL columns in SQL tables, the SQL query fails as expected. However, the error message returned references the incorrect column.

Status: Open

Product Experience: Data Warehouse

Symptoms

You might see a failure when executing a SQL query to insert into a Data Warehouse table. The error message is similar to: Cannot insert the value NULL into column <columnname>, table <tablename>. When the query fails, the column referenced isn't the column that caused the error.

Solutions and workarounds

No workarounds at this time. This article will be updated when the fix is released.

Next steps