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.