IBM Support

Error Running TI Process When Importing CSV File. Error: Prolog Procedure Line (0): Unable To Open Data Source

Troubleshooting


Problem

Error occurs when running a TI process that imports a csv file.
Preview displays the correct data.

Symptom

Error: Prolog procedure line (0): Unable to open data source "\\data\s\prod\tm1\Data\Loadfiles\test.csv"

Cause

The path specified for Data Source Name on Server is incorrect

Diagnosing The Problem

NOTE:
The values for "Data Source Name" and "Data source Name on Server" should be different.

Data Source Name - this is the path used by the architect client - the full path is required to where the csv exists. (click the browse and select the csv file.
Data Source Name on Server - this is the path used by the TM1 server - it should be "relative"to the TM1 data directory. (the folder where the tm1 objects are in)

In addition, it is important to understand that TM1 has only access to files which exist under or relative to the TM1 data directory.  

If one uses relative paths, then the relative path needs to be relative to the TM1 data directory. But other than that, the files can be anywhere in the \\data\ directory as long as the path name for 'data source name on server' is specified using via s:\... or relative to the data directory. 

Whether or not the tm1 server only has access to it's own data directory is off by default, and can be turned on via a support ticket:
Controlling TM1 Server access to data in shared folders:
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_cloud_mg.2.0.0.doc/c_tm1_cloud_controlling_access.html

Resolving The Problem

1. Confirm the directory where all the tm1 objects? 
This is the starting point.

STEPS:
The following steps are assuming the objects are in the data directory under TM1.

1. One would first create a folder named "loadfiles" under S:\prod\tm1\data\ 
Thus, any files you need to load are all in one folder under the data directory.
NOTE: This folder can be named anything, it is used to simplify the setup.

2. The paths would be as follows:
  Data Source Name:  \\data\s\prod\tm1\data\loadfiles\xxx.csv  (if the Preview displays data then this path is correct, no changes required)
and
  Data Source Name on Server:     .\loadfiles\test.csv   
(here one removes all directories up to where the objects exist...ie: data) or   take the .\ out and just be:    loadfiles\xxx.csv                                            
 Note there is a dot and a backslash for the second path.  (the dot \slash relates to the data directory where all the objects are stored)

3. Make sure to SAVE each time you make a change to the path or the error will continue as it is picking up the last saved change

NOTE:
If the preview works and displays data, this means thee first box in TI process is fine and no changes required, change the second box path only.

[{"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Planning Analytics","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 September 2021

UID

swg21992096

Page Feedback