IBM Support

DB USER NAME shows "?" and SOURCE PROGRAM information appeas blank (missing) on Infosphere Guardium reports for ORACLE databases.

Troubleshooting


Problem

When running InfoSphere Guardium reports for ORACLE databases activity the fields DB USER NAME shows "?" and SOURCE PROGRAM appeas blank (missing). Additionaly the fields CLIENT HOST NAME, OS USER, EVENT TYPE and EVENT VALUE STRING may also be blank.

Resolving The Problem

1.

Verify that db_install_dir and db_exec_file configuration parameters are set correctly on guard_tap.ini file. This can also be checked from the GUI > Administration Console > Local Taps > S-TAP Control > Inspection Engine. Verify the fields DB Install dir and Process Name.

If you made changes to the guard_tap.ini file, you need to restart the guard_tap process. If you made changes on the GUI, the guard_tap process is automatically restarted when saving the changes.

2.

Restart the ORACLE listener.

The above solution is if you are consistently missing these information on the reports.

If you are sporadically missing information, please see link below for further information on Guardium collector DB USER NAME / SOURCE PROGRAM occasionally missing from activity reports.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0;10.0.1;10.1;10.1.2;8.2;9.0;9.1;9.5","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
13 May 2020

UID

swg21655219

Page Feedback