Troubleshooting
Problem
I can see no data available for a MS Request/Transaction report, while I suspect there are data in the relevant OCTIGATE database table, what should I check?
Cause
Either the report definition is incorrect, or there are no corresponding data in the database.
Resolving The Problem
First of all, make sure that filtering options are correctly defined, in particular that you don't use a wildcard "*" into the Request/Transaction Name field, this is a possible mistake: an empty field is the correct way to specify no filter.
Moreover, you can find out what exact report SQL is by changing report trace log level to DEBUG_MIN.
Follow these steps:
1. Open MSVE log properties file: $MS_HOME/etc/cynlogging.properties
2. Find line: CYN.trc.ve.par.level, and set it as:
CYN.trc.ve.par.level=DEBUG_MIN
3. Restart MSVE WebSphere server
4. Bring up MSVE, run the report again
5. You will find the SQL statement MSVE executed from MSVE trace log (by default, MSVE trace log is under /var/ibm/tivoli/common/CYN/logs).
This way you can use that SQL statement to query database directly to see if there are data returned.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21631489