Troubleshooting
Problem
Data is not returned when reporting from a view held in an Oracle database but, when testing the query subject in Framework Manager, data is returned
Cause
The view definition contained the following WHERE clause...
TABLE.COLUMN = USERENV ('LANG');
The underlying table column had a value of 'US' and, when the function was evaluated on the Framework Manager machine, it resolves to 'US' and, hence, returns the data.
However, after the package had been published to the Cognos server and a report is run, no rows are returned because the local LANG value on the server is 'GB'.
Resolving The Problem
Set a system variable NLS_LANG on the Cognos server to something like AMERICAN_AMERICA.WE8MSWIN1252
Was this topic helpful?
Document Information
Modified date:
23 August 2018
UID
ibm10729023