IBM Support

Schedule/ execute a process using TM1 Package Connector simultaneous could return TR0319 error

Troubleshooting


Problem

Customer situation triggers process execution from external application by users. Here it could happen that the process is executed at the same time or parallel which then cause the TR0319 error.

Symptom

When TI processes using IBM Cognos packages are scheduled/ executed at the same time one process could fail with:
(TR0319) Error opening '<xxx.mdl>'
Error: Prolog procedure line (0): Unable to open data source "<yyy>"

Cause

The temporary created .mdl file cannot be created/ accessed by the 2nd or following processes and returns the corresponding error message.
It has been seen when the TM1 process reads lots of data from SAP BW.

This situation is most times porperly handled by TM1 server and is seen very seldom.

Environment

IBM Cognos TM1 10.1.1, 10.2.0 FP1, 10.2.2*
IBM Cognos TM1 Package Connector 10.2.1 GA
IBM Cognos BI 10.2.1 FP2, 10.2.1 FP5

*only in customer environment

Diagnosing The Problem

It's very hard to replicate!

Diagnosis starts on the fact that there one process is executed in parallel or very closely one after another where the above error situation could occur.
Another point is that the process takes a certain amount of time to finish as described under 'Cause' section.

Resolving The Problem

Avoid parallel process execution.
Review the processes and apply filters to reduce the amount of data and thus the time the process needs to work on.

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Package Connector","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1;10.2;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21695444