IBM Support

Guardium predefined reports may not return any record in non-English edition.

Troubleshooting


Problem

Some of Guardium predefined reports use SQL Exception Description field as a query condition. These reports will not return any record in Japanese/Chinese Edition of Guardium.

Symptom


Here are the reproduction steps:

    1. Prepare Japanese or Chinese edition of Guardium 8.
    2. Open "Returned SQL Error" report.

You won't see any result even though you actually have SQL error records.
    There are 13 predefined reports which use SQL Exception Description field. Here is the list of these reports:

      Exceptions By Type
      Failed User Login Attempts
      New SQL Statements
      SQL Errors
      Exceptions By Server
      Exceptions By Client
      Exceptions By User
      Exceptions Details
      Dropped Requests
      TCP Exceptions
      Failed Login Attempts
      Returned SQL Errors
      EF - Exception

    [{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"8.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

    Log InLog in to view more of this document

    This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

    Document Information

    Modified date:
    16 June 2018

    UID

    swg21501115

    Page Feedback