Error: Prolog procedure line (0): Unable to open data source

[rajeshdayaneni]

Hi,

we are getting below Error while running TI Process from Performance Modular.Could you please help me in solving this issue.

Error: Prolog procedure line (0): Unable to open data source "s:\preprod\proforma\data\Surcharge_Excel2.blb".



Regards,
Rajesh

[Edward Stuart]

Are you sure you want to be loading from a .blb file?

The typical checks I follow to diagnose a "Unable to open data source error" are:

- Check user account running TM1 Service account has access to the folder/ file in question
- Check file is not already open by a user
- Check file exists

There are, of course, a lot of posts in the forum which can also help with your issue.

P.S. You misspelt Modular, it's Muddler

[rajeshdayaneni]

Hello Edward Stuart,

this .blb file is not available in the specified location.Could you please help me how to create/generate these .blb files.


Thank You,
Rajesh Dayaneni

[Edward Stuart]

What is the requirement of the process?

Is it to load data? If it is to load data what is the data source the data is to be loaded from?

[rajeshdayaneni]

Hello Edward Stuart,

Sorry for the late reply.I was out of station.

Problem description: We have a TI Process that runs 24 other TI Processes to import data from Excel files into 24 different cubes. We are getting this error message and similar messages for all 24 cubes: " Prolog procedure line (0): Unable to open data source "s:\prod\dfv_proforma\data\Load_LDP_Excel2.blb".




Regards,
Rajesh

[Elessar]

Hello,

The processes were created using the Performance Modeler Import functionality, or using Architect?
I guess that .blb files are created by PM for converting Excel files to csv...

[rajeshdayaneni]

Hello Elessar,

we are using Performance Modeler.


Thank You ,
Rajesh

[Edward Stuart]

What other file types exist in the folder:

"s:\prod\dfv_proforma\data\"

[rajeshdayaneni]

Hello Edward Stuart,

Below file types exists in the folder
"s:\prod\dfv_proforma\data\"

CHO,CMA,CUB,DIM,FEEDERS,File Folder,RUX,PRO,VUE


Regards,
Rajesh

[Elessar]

Rajesh,

I'm not familiar with PM, but my guess seems to be correct:
1) The Excel files were imported using the PM's "Import" functionality
2) PM's import created the temporary .blb files to convert the excel file to csv file
3) After the server restart (or savedataall, or something else), the temporary files were deleted.

There are few people on this forum who can help you with PM (everyone hates it, including me)
The best way to load Excel data to TM1 is to connect to them via ODBC, or first load them to an SQL server. Or to convert the files to .csv using a cmd script.

[Edward Stuart]

I would advise that you talk to someone with knowledge of your implementation as to what the process is. Do you have an administrator/ project manager/ developer you can access to discuss this issue with?

It would appear that the data source/ locations for your processes have been removed/ moved/ amended. If all 24 processes present a similar error message it could be that the source location is defined in a control cube and this has been amended?

From here I would search for "Surcharge_Excel2" to identify the correct location of the source files as per:

we are getting below Error while running TI Process from Performance Modular.Could you please help me in solving this issue.

Error: Prolog procedure line (0): Unable to open data source "s:\preprod\proforma\data\Surcharge_Excel2.blb".

or check the Prolog for reference to DataSourceNameForServer

If you are still having issues I would check the commercial forum/ IBM website for details of any business partners in your area that could look to resolve the issue for you or provide a level of training.