AnsweredAssumed Answered

SLM 9.3.1: DUJ brakes with SQL 666

Question asked by markus.metzger Advocate on Jul 31, 2019
Latest reply on Aug 27, 2019 by markus.metzger

Hi all

since a couple of days DUJ brakes down with SQL message 666 in step slm.GetSoftwareSlm

The details DBjoblog entry shows:

07/30/2019 20:55:51,slm.GetSoftwareSlm [SnowLicenseManager:SnowInventory:MainStream],Error,2,HOL-SQLCL2014\MSSQL2014EE,slm.GetSoftwareSlm [SnowLicenseManager:SnowInventory:MainStream],Execute procedure MainStream.slm.GetSoftwareSlm,,Executed as user: LicenseManagerUser. The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID 439606529884160. Dropping and re-creating the index may resolve this; otherwise<c/> use another clustering key. [SQLSTATE 42000] (Error 666).  NOTE: The step was retried the requested number of times (3) without succeeding.  The step failed.,02:35:16,16,666,,,,3

Does anybody see such errors in the past?

We are running DB in MSSQL 2014 on Cluster environment, shared with other DBs.


Support Ticket is already opened. Snow Support Case: CS0052642