Service Catalog: HTTP 404 error after upgrading to 17.3

Products

• CA Service Management - Service Desk Manager
• CA Service Catalog

Issue/Introduction

After upgrading from 17.1 to 17.3, Service Catalog does not work and shows an HTTP 404 error message.

seeddata.log:

ERROR Exception while communicating with the database:Conversion failed when converting the nvarchar value '__CLEANINSTALL__' to data type int.
com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the nvarchar value '__CLEANINSTALL__' to data type int.
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)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1794)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:315)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at com.ca.usm.datasource.DBJDBC.update(DBJDBC.java:1238)
at com.ca.usm.datasource.DBSource.executeUpdate(DBSource.java:1584)
at com.ca.usm.datasource.DBSource.executeUpdate(DBSource.java:1559)
at com.ca.usm.util.seeddata.SeedDataImporter.executeUpdate(SeedDataImporter.java:220)
at com.ca.usm.util.seeddata.SeedDataImporter.updateRow(SeedDataImporter.java:535)
at com.ca.usm.util.seeddata.SeedDataImporter.updateRow(SeedDataImporter.java:336)
at com.ca.usm.util.seeddata.SeedDataImporter.importSeedData(SeedDataImporter.java:282)
at com.ca.usm.util.seeddata.SeedDataImporter.importSeeddata(SeedDataImporter.java:624)
at com.ca.usm.util.seeddata.SeedDataImporter.main(SeedDataImporter.java:595)
INFO Successfully loaded the seeddata

 

 

Environment

Release : 17.3

Component : CA SERVICE CATALOG

Cause

The upgrade completed successfully but there was an error in the data loaded through seeddata.bat

Resolution

1. Edit USM_HOME\config.properties

Change from: 

__CLEAN_INSTALL__ = __CLEANINSTALL__

to:

__CLEAN_INSTALL__ = 0

2. USM_HOME >  click on usm.cmd > go to scripts folder (cd scripts) and run:

seeddata.bat -n "USM_HOME\config.properties" -o "USM_HOME\config.properties" "USM_HOME\view\scripts\MDB\SQL"

Example:
seeddata.bat -n "D:\Program Files\CA\Service Catalog\config.properties" -o "D:\Program Files\CA\Service Catalog\config.properties" "D:\Program Files\CA\Service Catalog\view\scripts\MDB\SQL"