Error when installing SQL 2019 – Developer Edition

By | November 5, 2019

 

Error Message

Cannot insert the value NULL into column ‘CustomContext.ClusterId’, table ‘DWDiagnostics.dbo.pdw_component_health_data_lock’; column does not allow nulls. INSERT fails.

Affected Components

DB Engine , Replication , Polybase , Full Text Search , Java Connectors for HDFS , Data Quality Services

Resolution

Currently Under investigation

 

Notes

Post installation DB engine components are installed but server is in Single user mode

Restarting the SQL Server Service brings server out of Single User mode, Core DB engine features appear to be working

Table mentioned in the error message does not appear in the database

Workaround

Uninstall and reinstall DB engine components without Polybase Java for HDFS file systems. Make sure Workstation Service is running

Last Update

5/11/2019

 

 

Error Message

The flat name of the target computer could not be retrieved (2138).

Affected Components

Python, R , Machine Learning Services and Language Extensions

Resolution

Work Station Service need to be running in order for Machine Learning Services to be installed and Uninstalled

Last Update

6/11/2019

 

 

Error Message

SQL.cab file missing during installation

Affected Components

Analysis Services

Resolution

Work Station Service need to be running in order for Machine Learning Services to be installed and Uninstalled

Last Update

6/11/2019