DX Application Performance Management

Hi there,

I have created a Report from workstation. The report is contains of the list of SQL error. The customer is requesting the report also display the exception error from every single SQL query. 

How to make it, need your advise?

Regards

Rio

Made into a discussion and shared with the APM Developer Community

Hello Rio,

I believe that is not possible.

1) Metrics are stored in the Smartstor database. 

2) Errors descriptions and traces are stored in the Traces database, see Query Stored Events - CA Application Performance Management - 10.5 - CA Technologies Documentation 

You could try to use CLW to export the exception, see CLW Command Reference - CA Application Performance Management - 10.5 - CA Technologies Documentation 

Here is an example:

java -Duser=Admin -Dpassword= -Dhost=localhost -Dport=5001 -Xms512m -Xmx512m -jar CLWorkstation.jar get historical events matching \"type:errorsnapshot AND time:[20170828 TO 20170829]\"

If you need a txt version, you can load the file using Query Historical Events window and then save the file as txt.

I hope this helps,

Regards,

Sergio

Hi Sergio,

Thank you for your reply. From your explanation, it looks there is no way to make it happen. Because, either metrics and error exceptions are stored in different database.
I thought with use PSQL (https://docops.ca.com/ca-apm/10-5/en/integrating/ca-apmsql-cookbook) can extract metrics and error-description together in one page reporting.

Regards

Rio

It is not recommended to pass username and password to CLW as it is done in cleartext.

Instead, use "-Dkeyfile=<workstation_home>/config/internal/console/EM.public". The same keyfile can be found on the EM in the same directory or in "<em_home>/config/internal/server".