Troubleshooting
Problem
I am noticing Scheduled Job Exceptions related to UID chain on my Guardium collector, for example: Session Inference Error in Session UID Chain Data You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near 'exit EOF)->(32059,oracle,sqlplus -s 1
Cause
Session Inference does not handle handle escapes (\) and quotes in UID_CHAIN causing these exceptions.
Environment
v9.5
Resolving The Problem
The problem is resolved in GPU p750 (not yet released at the time of writing) and will be available on fix central.
For GPU p600 or p700 Please open up a PMR with IBM Guardium support to provide an ad_hoc patch that has the fix for this issue:
V9.5 GPU600 - SqlGuard-9.0p624.tgz.enc
v9.5 GPU700 - SqlGuard-9.0p710.tgz.enc
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21999579