TEC595658: How to fix "unable to execute query" JDBC exceptions when trying to view some CEM web pages which are due to incorrect postgres APM database table ownership.

Document created by Lynn_Williams Employee on May 25, 2016Last modified by SamCreek on May 25, 2016
Version 2Show Document
  • View in full screen mode

Author: Lynn_Williams

 

Document ID:  TEC595658

Last Modified Date:  7/18/2013

  • Products
    • CA Application Performance Management
  • Components
    • WILY CEM
    • CUSTOMER EXPERIENCE MANAGER

style="margin-bottom:10px"

  • To execute the function:

    1. Stop all EMs in the cluster
    2. Backup the cemdb database.
    3. Run the function using this SQL:
      select apm_reset_table_ownership();

      There will be no data output from the function but you can check back on tables that had the ownership problem to verify that admin is now the owner (a refresh/F5 may be required).

    4. Ensure all EMs in the cluster have their file EM_HOME\config\tess-db-cfg.xml set to use the username of admin to connect to cemdb.
    5. Start the cluster

 

 

Search the Entire CA APM Knowledge Base

 

search-kb.jpg

Attachments

    Outcomes