IBM Support

Opening Transformer model produces TR1102 and TR1008 errors

Troubleshooting


Problem

Migrating Series 7 Transformer model to Cognos 10. Impromptu Query Definition (IQD) data source files copied across, ODBC connections created and added to the Database section in the ...\ibm\cognos\c\CS7Gateways\bin\cs7g.ini file. In the Transformer model changed the IQD data source paths accordingly. But, testing them via Data Source Viewer results in error: (TR1000) Transformer can't initialize the Data Movement Service (DMS). Upon saving and re-opening the Transformer model, it produces errors: (TR1102) Transformer detected a model error at line in file . (TR1008) Transformer couldn't read the connection information for database [] from COGNOS.INI, from IBM Cognos Impromptu Query Definition (IQD) Runtime Gateway location, or from IQD file.

Cause

On the Transformer server, the Windows 32-bit C:\windows\SysWOW64\MFC71.DLL file was missing.
And, the Transformer executable (cogtr.exe) file was not being run by an Administrator user.

Environment

MS Windows Server 2012 R2 Standard (64-bit)

Diagnosing The Problem

Check for the existence of the Windows 32-bit C:\windows\SysWOW64\MFC71.DLL file.
And, if the Transformer executable (cogtr.exe) file is being run by a non-Administrator user.

Resolving The Problem

On the Transformer server

* Add the Windows 32-bit C:\windows\SysWOW64\MFC71.DLL file, which is required for Transformer to function properly.

And, if required, add it to the Transformer ...\ibm\cognos\c<n>\bin folder too.

* Set the Transformer executable (cogtr.exe) file to "Run as administrator", to resolve permissions issues.

Note, to "Run as Administrator", right-click on the executable file and choose "Run as Administrator" option. However, if the Run as Administrator option is not listed then hold Ctrl+Shift+Alt as you right-click on the executable to show the full menu of options.

Alternatively, right-click on the executable file and choose "Properties", on the "Compatibility" tab, under "Privilege Level", tick "Run this program as an administrator" and click "Change settings for all users" if required.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Transformer","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21962689