Product Master hangs and the client UI is frozen

If errors occur when accessing your Product Master, it is possible that the connection to the database might have been lost.

Symptoms

  • Your Product Master UI freezes or is in a constant wait state.
  • Errors occur when attempting to access your Product Master.

Resolving the problem

  • Check the status of the listener process in Oracle:
    1. Log on to Oracle database server by using your Oracle ID.
    2. Run the following command to check whether the listener is running: lsnrctl status
      • If the command completed successfully and you get the "Listening Endpoints Summary..." message, then the listener is running.
      • If the command ends in an error, there might be problems with your database server and you should contact your database administrator.
  • Check the status of your DB2® database:
    • Check the database connectivity with the test_db.sh script located in the $TOP/bin directory.
    • Check the JDBC connectivity with the test_db.sh script located in the $TOP/bin directory. The Admin user can check JDBC connectivity only after running create_schema.sh.
  • Check whether all the services of Product Master have been started. You can run rmi_status.sh script to check the service status.