Question & Answer
Question
When I run an audit process, it fails with this error: [Report name]: Guard Report Genrator Error: Table does not exist.
Cause
The list of innodb tables that is used in generation of Ad Hoc audit query
was created when GROUP_MEMBER table was corrupted.
Answer
From diag, run Application Debug and reproduce the issue. The debug log will show something similar to this:
| ==============Thu Oct 15 14:42:35 EDT 2015=================== Thread: Thread-2910 - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AH_AUDIT_30506_20151015.GROUP_MEMBER' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39) at java.lang.reflect.Constructor.newInstance(Constructor.java:527) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) |
To resolve, issue the command 'restart gui' from cli. This will cause the list of innodb tables to be regenerated.
[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Guardium Database Activity Monitor","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.1;9.5","Edition":"All Editions","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21969044