Troubleshooting
Problem
Using Dynamic Query Mode (DQM) package or report data sources in Transformer results in looping prompt when trying to read the data source. The reports run successfully in Cognos Analytics 11.
Symptom
In Transformer, building a cube, testing a data source, generating categories, or any action that attempts to connect and query the DQM data source in the Transformer model prompt suer for database signon. No error message.
Cause
Transformer is a 32-bit application and DQM data source connections use 64-bit JDBC.
Environment
Applied to Transformer versions 10.2.2 and Transformer 11.x.
Resolving The Problem
Transformer is able to use DQM data sources to build Powercubes despite being a 32-bit application.
This functionality can be enabled by adding a setting to the cogtr.xml file. See documentation references listed below for additional
information.
Steps:
1. Confirm if Transformer is using the cogtr.xml file in the Transformer install directory or in the Windows Virtual Store
<installation_location>/configuration/cogtr.xml
C:\Users\<username>\AppData\Local\VirtualStore\Program Files (x86)\ibm\cognos\c11\configuration\cogtr.xml
2. Open the file in a text editor and add the following setting in the <Section Name="Transformer"> section
<Section Name="Transformer">
<Preference Name="AllowDQ" Value="1"/>
3. Save the file and restart Transformer.
For Cognos 11.x the syntax of the entry changed and requires the use of the ".sample" file.
1. Back up the existing cogtr.xml and make a copy of the cogtr.xml.sample. Rename the copy to cogtr.xml
2. Add the following to the General section under the Transformer section.
<Section Name="Transformer">
<Preference Name="AllowDQ" Value="1"/>
<Section Name="Transformer">
<Preference Name="AllowDQ" Value="1"/>
3. Save the file and restart Transformer.
NOTE - if issue persists, see the following for possible reason/solution: https://www.ibm.com/support/pages/node/1126353
Related Information
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m3p000000hBXZAA2","label":"PowerPlay-\u003ETransformer"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
14 June 2023
UID
swg21976704