Error: Prolog procedure line (0): Unable to open data source
-
- Posts: 18
- Joined: Fri Aug 11, 2017 6:24 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 7
Error: Prolog procedure line (0): Unable to open data source
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
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
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Error: Prolog procedure line (0): Unable to open data source
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
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
-
- Posts: 18
- Joined: Fri Aug 11, 2017 6:24 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 7
Re: Error: Prolog procedure line (0): Unable to open data source
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
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
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Error: Prolog procedure line (0): Unable to open data source
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?
Is it to load data? If it is to load data what is the data source the data is to be loaded from?
-
- Posts: 18
- Joined: Fri Aug 11, 2017 6:24 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 7
Re: Error: Prolog procedure line (0): Unable to open data source
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
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
- Community Contributor
- Posts: 338
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Error: Prolog procedure line (0): Unable to open data source
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...
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...
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Posts: 18
- Joined: Fri Aug 11, 2017 6:24 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 7
Re: Error: Prolog procedure line (0): Unable to open data source
Hello Elessar,
we are using Performance Modeler.
Thank You ,
Rajesh
we are using Performance Modeler.
Thank You ,
Rajesh
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Error: Prolog procedure line (0): Unable to open data source
What other file types exist in the folder:
"s:\prod\dfv_proforma\data\"
"s:\prod\dfv_proforma\data\"
-
- Posts: 18
- Joined: Fri Aug 11, 2017 6:24 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 7
Re: Error: Prolog procedure line (0): Unable to open data source
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
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
- Community Contributor
- Posts: 338
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Error: Prolog procedure line (0): Unable to open data source
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.
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.
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Error: Prolog procedure line (0): Unable to open data source
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:
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.
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:
or check the Prolog for reference to DataSourceNameForServerwe 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".
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.