Services on Catalog Server are not starting

Document ID : KB000095252
Last Modified Date : 09/05/2018
Show Technical Document Details
Issue:
Catalog Services fail to start and even if start completed, it fails to hold the Running status - returns to stopped status immediately

Error Message: 
2018/05/09 17.22.37.580 FATAL [localhost-startStop-1] [SelfTestModule] ERROR: View component is not found in the database 
2018/05/09 17.22.37.581 FATAL [localhost-startStop-1] [SelfTestModule] Either catalog or accounting component need to be configured to pass this test.
Environment:
CA Service Catalog 14.x
CA Service Catalog 17.x
Cause:
Registration data missig in ca_application_registration database table for ca service catalog application
Resolution:
Disclaimer: Please note this document is useful on specific scenarios where the database table 'ca_application_registration' has empty values or missing values for - CA Service Catalog / Service View / CA Service Accounting. 'ERROR: View component is not found in the database' is noted due to the entry for service view missing in the database.

Pre-steps: Run the command 'select * from ca_application_registration' table to validate of any of the data missing from the query. Note: Those value appear if you have Service Catalog / Service Accounting components are installed in the first place

Steps to correct this behavior
=============================
1) Take a backup of ca_application_registration table if there are any entries present 
2) Add the missing entries for the application registration table and commit to the database

Sample entries look like this
--------------------------------------
Database Name  - MDB
Table name  -  ca_application_registration
Values         -  <as below>

product_code    minor_version    major_version    product_name    product_specific_data    install_count    description

==============================================================================================
2007    12    9    CA Service Catalog    http://<Hostname>:8080/usm/wpf    1    CA Service Delivery Products
2008    12    9    CA Service Accounting    http://<Hostname>:8080/usm/wpf    1    CA Service Delivery Products
2012    12    9    Service View    http://<Hostname>:8080/usm/wpf    1    CA Service Delivery Products

Note: Ensure that the <Hostname> is replaced with the actual hostname of the catalog application server

3) Recycle the services - Successfully restarts without any issue

Open the Catalog URL for verifying if the login page is presented and able to login successfully
Additional Information:
Those value appear if you have Service Catalog / Service Accounting components installed in the first place i.e.

If Service Catalog is selected during installation then a database entry is created in ca_application_registration table as below

product_code    minor_version    major_version    product_name    product_specific_data    install_count    description
==============================================================================================
2007    12    9    CA Service Catalog    http://<Hostname>:8080/usm/wpf    1    CA Service Delivery Products
2012    12    9    Service View    http://<Hostname>:8080/usm/wpf    1    CA Service Delivery Products

If Service Accounting is selected during installation then a database entry is created in ca_application_registration table as below

product_code    minor_version    major_version    product_name    product_specific_data    install_count    description
==============================================================================================
2008    12    9    CA Service Accounting    http://<Hostname>:8080/usm/wpf    1    CA Service Delivery Products