Troubleshooting
Problem
The environment has been upgraded from Cognos 10.2.1 on Windows to Cognos 11.0.10 on Linux. Due to the operating system change, it is not possible to use JDBC with Oracle 10g 32bit database.
Diagnosing The Problem
The FM model needs to be split into CQM to allow the oracle 32bit datasource to connect, and DQM for the remaining 64-bit jdbc query subjects.
Resolving The Problem
Steps on how to split a Framework Manager Project:
- Create a new CQM FM Model
- During the import select "IBM Cognos Model"
- Select the FM Model you want to split
- Select the querySubjects that are associated with CQM connection
- Save
- Repeat by creating another DQM FM Model and select the DQM querySubjects.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
25 September 2018
UID
ibm10732120