DX Application Performance Management

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. 

May 25, 2016 06:09 PM

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

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.