Upgrade to 20.3 fails at 0% on sqlserver_nis_base_create.sql

Products

• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• NIMSOFT PROBES
• DX Infrastructure Management

Issue/Introduction

Upgrade to 20.3 fails at 0% on sqlserver_nis_base_create.sql

Environment

Release : 20.3.0

Component : UNIFIED INFRASTRUCTURE MGMT

Resolution

Using windows authentication on the data_engine. The password for the data_engine had recently changed for the user that connects, but the data_engine user password was not changed in the configuration. Even with the old password we were able to authenticate to the SQL server in the data_engine dialog. This is the same user that starts the nimsoft robot watcher service, and the password was changed there.

Update the data_engine probe configuration with the correct password again, apply, and reran the installation.

Additional Information

Error in the installation log:

2020-12-23 11:28:12,110 ERROR impl.UIMServerDBSchemaController:run:167 [Thread-36]  - NimException caught
(503) , com.microsoft.sqlserver.jdbc.SQLServerException: The UPDATE permission was denied on the object 'tbnVersion', database 'CA_UIM', schema 'dbo'.: The UPDATE permission was denied on the object 'tbnVersion', database 'CA_UIM', schema 'dbo'.
 at com.nimsoft.nimdbprovider.base.util.NimDBScriptRunner.runDBScript(NimDBScriptRunner.java:78)
 at com.nimsoft.nimdbprovider.base.provider.NimDBProviderBase.runDBScript(NimDBProviderBase.java:260)
 at com.nimsoft.nimdbprovider.base.provider.NimDBProviderBase.runDBScriptFile(NimDBProviderBase.java:193)
 at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.runScriptCommon(UIMServerDBSchemaController.java:388)
 at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.configureNisBaseCreate(UIMServerDBSchemaController.java:296)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:532)
 at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:516)
 at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.doConfigure_dbScript(UIMServerDBSchemaController.java:267)
 at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.doConfigure(UIMServerDBSchemaController.java:178)
 at com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController.run(UIMServerDBSchemaController.java:165)
 at java.lang.Thread.run(Thread.java:748)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The UPDATE permission was denied on the object 'tbnVersion', database 'CA_UIM', schema 'dbo'.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
 at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:256)
 at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:108)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1531)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:845)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:752)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:729)
 at com.nimsoft.nimdbprovider.base.util.NimDBScriptRunner.executeSQLCommand(NimDBScriptRunner.java:105)
 at com.nimsoft.nimdbprovider.base.util.NimDBScriptRunner.runDBScript(NimDBScriptRunner.java:60)
 ... 14 more