Service Catalog - Login page is not loading after fresh install

Products

• CA Service Catalog
• CA Service Management - Asset Portfolio Management

Issue/Introduction

After installing Service Catalog 17.1 on a standalone server, the login page just keeps spinning.

Following is the error in the ServiceCatalog.log 
=========================================
NFO | jvm 1 | 2018/08/14 09:11:50 | java.util.ServiceConfigurationError: com.sun.tools.attach.spi.AttachProvider: Provider sun.tools.attach.WindowsAttachProvider could not be instantiated 
INFO | jvm 1 | 2018/08/14 09:11:50 | Exception in thread "Thread-DB-Source-Pool-Thread" java.lang.ExceptionInInitializerError 
INFO | jvm 1 | 2018/08/14 09:11:50 | at com.ca.usm.datasource.DBSource.freeIdleConnections(DBSource.java:509) 
INFO | jvm 1 | 2018/08/14 09:11:50 | at com.ca.usm.datasource.DBSourcePoolThread.run(DBSourcePoolThread.java:32) 
INFO | jvm 1 | 2018/08/14 09:11:50 | Caused by: java.lang.NullPointerException 
INFO | jvm 1 | 2018/08/14 09:11:50 | at com.ca.usm.datasource.CaDBCPDataSource.loadDBSource(CaDBCPDataSource.java:47) 
INFO | jvm 1 | 2018/08/14 09:11:50 | at com.ca.usm.datasource.CaDBCPDataSource.<clinit>(CaDBCPDataSource.java:22) 
INFO | jvm 1 | 2018/08/14 09:11:50 | ... 2 more 
INFO | jvm 1 | 2018/08/14 09:11:50 | Exception in thread "Thread-4" java.lang.NoClassDefFoundError: Could not initialize class com.ca.usm.datasource.CommonDB 
INFO | jvm 1 | 2018/08/14 09:11:50 | at com.ca.usm.system.GuiNodeCacheLoader.getDBObjects(GuiNodeCacheLoader.java:123) 
INFO | jvm 1 | 2018/08/14 09:11:50 | at com.ca.usm.system.GuiNodeCacheLoader.run(GuiNodeCacheLoader.java:44) 
INFO | jvm 1 | 2018/08/14 09:11:50 | at java.lang.Thread.run(Unknown Source) 

Environment

Service Catalog 17.1 and above

Resolution

1. Stop the Service Catalog Service 
2. Make a Backup of the config.properties located in USM_HOME 
3.  Add the lines below to the end of the config.properties 

 ###############################################################

 # Database Performance Tuning configuration 

 ##############################################################
DBSource.scannodetimeout = 3
DBSource.initialsize = 10

DBSource.maxtotal = 500
DBSource.maxidle = 50
DBSource.minidle = 10
DBSource.suspecttimeout = 60
DBSource.timebetweenevictionrunsmillis = 30000
DBSource.minevictableidletimemillis = 60000
DBSource.removeabandonedonmaintenance = true
DBSource.removeabandonedtimeout = 1200
DBSource.logabandoned = false
DBSource.connectionProperties = useUnicode=yes;characterEncoding=utf8;
DBSource.abandonwhenpercentagefull = 50

#Properties for connecting to remote database servers(used in report builder) through DBCP

ReportDBSource.initialsize = 10
ReportDBSource.maxtotal=500
ReportDBSource.maxidle =50
ReportDBSource.minidle =10
ReportDBSource.suspecttimeout =60
ReportDBSource.timebetweenevictionrunsmillis =30000
ReportDBSource.minevictableidletimemillis =60000
ReportDBSource.removeabandonedonmaintenance =true
ReportDBSource.removeabandonedtimeout =1200
ReportDBSource.logabandoned =false
ReportDBSource.connectionProperties =useUnicode=yes;characterEncoding=utf8;
ReportDBSource.abandonwhenpercentagefull =50

#End of properties connecting to remote database servers through DBCP ​

 

4. Start Service Catalog service 
5. The login is successful.