LarsReifegerste asked a question.
Error message during SLM update from version 9.19 to 9.20.0
Have any of you had this happen before? The table in question is filled with applications that have more than one license metric.
Error Message in SUS:
Update could not be installed. Instructions have been rolled back. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'PreferredMetric', table 'SnowLicenseManager.dbo.tblApplicationSecondaryMetric'; column does not allow nulls. INSERT fails
Ticket at support is already opened but maybe someone else has an idea.
Hi Lars,
I installed 9.20.0 and 9.20.1 10 days ago.
I did not get that error message during installation. Installation was successful.
What I can say with 9.20.0 Snow did a change for Reports, that causes some trouble for me.
It is weird, but when you want to save a report and added columns or grouping, you first need to click Show report before Save report, otherwise you get only weird columns in that report that have nothing to do with the columns you wanted to save.
I have had this problem for the last 2-3 updates. A server reboot usually helps. Third times a charm works as well.
Only a restart solve this issue?
As far as I can see, the update tries an INSERT with a dummy entry that contains a zero in the PreferredMetric column of this table.
I have this error only in a customer environment. On other platforms the update worked fine.
My update also was successful.
These messages often are caused by failed / incomplete updates.
Snow support should be able to provide a SQL statement to correct this, so my recommendation is to wait for the support response in this case.