Unable to Open USM portlet

Document ID : KB000033583
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

After migrating to 8.x version the USM portlet is not able to open.

The udm_manager probe has been introduced on the 8.1 version. If you migrate from a previous version before 8.1 and now you are not able to open the USM portlet you may see these errors:

message (11) command not found, Received status (11) on response (for sendRcv) for cmd = 'getUdmDatabaseUrl'

udm_manager log message:

Exception establishing Datomic connection: Malformed escape pair at index 129: datomic: and you are able to see the database password error like below:

sql://udm?jdbc:sqlserver://;serverName=RIOSQ1;databaseName=NimsoftSLM;applicationName=udm_manager;user=sa;password=%SA%abcd2011;sendStringParametersAsUnicode=false

In the password field you see something like % ' * '

ugs shows an error as well:

Oct 01 18:59:08:434 [main, ugs] Starting UDMservices Oct 01 18:59:08:771 [main, ugs] Failed to resolve UDM configuration from hub. Attempting to load UDM from UGS configuration Oct 01 18:59:14:025 [main, ugs] Failed to start UGS. Reason: Oct 01 18:59:14:028 [main, ugs] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'datomicSchemaMigrator':

 

Cause:

The root cause for this is the  udm_manager probe does NOT support special characters like % *

 

Resolution:

Deactivate the data_engine then change the password on the DB and start the data_engine.

Make sure you also recycle the wasp probe.

After the password is changed and no longer includes any special characters, the issue will be solved.