It's all about the answers!

Ask a question

While importing 7.0.2 tar files for RM I receivd a SQLServerException on DNGLOCKS.DB_LOCK. Is there a workaround?


Daniel Barbour (250222) | asked Mar 29 '21, 4:40 p.m.
During the 'Rebuilding Indices....' phase of a repotools-rm.bat -import command on a RM tar file I exported from a server running RM 7.0.2 and was reimporting in to a server running RM 7.0.2 the RM import log file shows the following (only the first issue is shown):


2021-03-28 18:46:24,805 Importing deferred items...
2021-03-28 18:46:25,320 Finished importing deferred items.

2021-03-28 18:46:25,320 Rebuilding indices...
2021-03-28 18:47:48,157 CRJAZ0577E The following SQL query did not execute properly on the server:
create unique index DNGLOCKS_DBLCK_CFG_RSC_UDX ON DNGLOCKS.DB_LOCK (CONFIGURATION, RESOURCE_ITEM_ID)
com.microsoft.sqlserver.jdbc.SQLServerException: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'DNGLOCKS.DB_LOCK' and the index name 'DNGLOCKS_DBLCK_CFG_RSC_UDX'. The duplicate key value is (_Wf8-gDCyEeWjpc1eG1O1eQ, _BBNy5lQ5EeSwU-S4Uejv-Q).
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:426)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:372)
    ...(lots more)...


Does anyone know of a workaround for this issue?  (Note that I successfully exported/imported 7.0.2 tar files for two other servers with different instances of the 7.0.2 apps but both of those did include RM tar files (though both were much much smaller in size).

Thank you in advance!

Be the first one to answer this question!


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.