USM crashing with error

Document ID : KB000004522
Last Modified Date : 13/07/2018
Show Technical Document Details
Issue:

The Portal is not opening and throws error.
Just after login at UMP, the page starts loading the USM portlet and after few seconds it's throws an error to the screen:

"An unknown error has occurred.
Refreshing your browser may resolve the issue.
Details:
com.firehunter.ump.exceptions.DataFactoryException : null
Stack Trace:
java.lang.NullPointerException"
Refreshing the screen as suggested by the message does not make any effect.

Environment:
Any environment
Cause:

The UIM DB user needs to have all privileges on the UIM tables.

Resolution:

1. Needs GRANT ALL PRIVILEGES and/or GRANT SUPER
2. Deactivate discovery_server
3. Run the following query for the NimsoftSLM backend database using the SLM portlet or MS SQL Server Management Studio utility
4. -- this step #4 - should not be done on the 8.51 and later releases --

DELETE FROM CM_COMPUTER_SYSTEM;

5. On the primary hub, Deactivate the udm_manager probe.
6. Run the following query: DROP TABLE DATOMIC_KVS;
7. Activate udm_manager
8. Activate discovery_server

Additional Information:

https://docops.ca.com/ca-unified-infrastructure-management/8-5-1/en/installing-ca-uim/pre-installation-planning/install-and-configure-your-database-software