Troubleshooting
Problem
I uploaded data into my Guardium appliance using the custom table upload process. I defined aliases for this custom data to show in reports. When viewing the custom data in the reports, the alias is not being applied.
Cause
If custom data was uploaded with leading or trailing white space characters, the alias will not match it.
Diagnosing The Problem
1. Confirm that the data in the report with missing aliases is from a custom table. The custom query will be defined in v10 Reports -> Report Configuration Tools -> Custom Query Builder. v9 Tools -> Report Building -> Custom Query Builder.
2. Confirm Aliases are defined for the values in v10 Setup -> Tools and Views -> Alias Builder. v9 Tools -> Alias Builder.
3. Confirm Show Aliases is on in the report runtime parameters
4. Confirm the values have white space characters using the application debugger. This step to confirm the white space is only applicable in v10 debugger. Although the solution may still apply to v9.
i) Start the application must_gather. Set the debug timer for a few minutes (enough time to do step ii) when prompted.
ii) Go to the report where aliases are not applied and refresh
iii) After the must gather finishes, unzip the resulting .tgz file and look in the debug log <date>-debug.log.
iv) When the report was run in the GUI there will be an entry showing the values and aliases. Searching for "alias" will find it e.g.
{"alias":"?gt0\u003d7\u0026v0\u003dR7120L++","col2":"123","col1":"ABCDEF1 ","id":1},
{"alias":"?gt0\u003d7\u0026v0\u003dR0110L++","col2":"132","col1":"ABCDEF2 ","id":2},
{"alias":"?gt0\u003d7\u0026v0\u003dR0260L++","col2":"234","col1":"ABCDEF3 ","id":3}
...
Note that the bold values e.g. ABCDEF1 are followed by white space characters, indicating the problem.
Resolving The Problem
The white space can be removed when the data is uploaded as part of the custom table upload procedure.
In v10 Reports -> Report Configuration Tools -> Custom Table Builder. v9 Tools -> Report Building -> Custom Table Builder.
When uploading the data, change the SQL statement to use a function like TRIM() to remove white space. Depending on the datasource type, an equivalent function may be used.
SQL statement that may contain white space: select PROGRAM from table1;
SQL statement to remove white space: select TRIM(PROGRAM) from table1;
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21998576