CA Service Catalog Not Loading After 17.3.0.18; Error in seeddata.log
Article ID: 258720
Updated On:
Products
Issue/Introduction
After applying a RU patch to CA Service Catalog 17.3, unable to access the Service Catalog UI.
Following error is seen in the seeddata.log file:
ERROR Exception while communicating with the database: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "XFK02usm_request_status". The conflict occurred in database "mdb", table "dbo.usm_subscription_detail", column 'id'.
com.microsoft.sqlserver.jdbc.SQLServerException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "XFK02usm_request_status". The conflict occurred in database "mdb", table "dbo.usm_subscription_detail", column 'id'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) ~[sqljdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635) ~[sqljdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:426) ~[sqljdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:372) ~[sqljdbc.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276) ~[sqljdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1794) ~[sqljdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184) ~[sqljdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159) ~[sqljdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:315) ~[sqljdbc.jar:?]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp.jar:2.1.1]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp.jar:2.1.1]
at com.ca.usm.datasource.DBJDBC.update(DBJDBC.java:1239) ~[common.core.jar:17.3.0.1.100]
at com.ca.usm.datasource.DBSource.executeUpdate(DBSource.java:1584) ~[common.core.jar:17.3.0.1.100]
at com.ca.usm.datasource.DBSource.executeUpdate(DBSource.java:1560) ~[common.core.jar:17.3.0.1.100]
at com.ca.usm.util.seeddata.SeedDataImporter.enableFkAndTriggers(SeedDataImporter.java:351) ~[common.core.jar:17.3.0.1.100]
at com.ca.usm.util.seeddata.SeedDataImporter.importSeeddata(SeedDataImporter.java:626) [common.core.jar:17.3.0.1.100]
at com.ca.usm.util.seeddata.SeedDataImporter.main(SeedDataImporter.java:595) [common.core.jar:17.3.0.1.100]"
Tried re-running the seeddata utility, but continue to receive an error about this particular table.
Environment
CA Service Catalog 17.3
Cause
JAR file missing from the Service Catalog install
Resolution
Examine the USM_HOME/view/webapps/WEB-INF/lib directory and compare with a working environment for any missing content.
Contact Broadcom Support for further assistance if required
Feedback
