HTTP status 404 -- Not Found error after upgrading to 17.3

Products

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

Issue/Introduction

After upgrade Service Catalog 17.2 to 17.3 the Service Catalog web UI gives 404 error
http status 404--Not Found


Seedata.log:
==========

2023/04/15 14.52.01.584 ERROR Exception while communicating with the database:ORA-00932: tipos de dados inconsistentes: esperava - obteve NCLOB(English translation: inconsistent data types: expected - got NCLOB)

java.sql.SQLSyntaxErrorException: ORA-00932: tipos de dados inconsistentes: esperava - obteve NCLOB ((English translation: inconsistent data types: expected - got NCLOB)

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) ~[ojdbc8.jar:12.2.0.1.0]

 

Environment

Service Catalog 17.3

Resolution

1. Edit Service-Catalog-install-folder\config.properties

Change from: 

__CLEAN_INSTALL__ = __CLEANINSTALL__

to:

__CLEAN_INSTALL__ = 0

2. Service-Catalog-install-folder >  click on usm.cmd > go to scripts folder (cd scripts) and run:

seeddata.bat -n "Service-Catalog-install-folder\config.properties" -o "Service-Catalog-install-folder\config.properties" "Service-Catalog-install-folder\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"

Additional Information

Transalation : 
ORA-00932: tipos de dados inconsistentes: esperava - obteve NCLOB(English translation: inconsistent data types: expected - got NCLOB)

English Translation: 
ORA-00932: inconsistent data types: expected - got NCLOB