Troubleshooting
Problem
Reports generated using full outer joins by the Rational Insight report server fail on an Oracle 10g database.
Resolving The Problem
- Use IBM Cognos Framework Manager to change the relationship to left join instead of full outer join.
- Add the following lines to the cogdmor.ini file in the <rational_insight_installation_directory\cognos\bin directory:
- [Exceptions Joins ORACLE<version_number>]
Full_Outer=F
[{"Product":{"code":"SSRL5J","label":"Rational Insight"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"1.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21384817