TM1 Forum

Error: Prolog procedure line (O); Unable to open data source "Sub Misc Projects".

Can anyone help me with what this is telling me.??

KarenB60 wrote:Error: Prolog procedure line (O); Unable to open data source "Sub Misc Projects".

Can anyone help me with what this is telling me.??

Moved from General (where for a brief moment I thought we'd hit 500 posts) to the correct forum.

It means that:
- Your process has a data source, the type of which you haven't specified but if I had to bet from the name it's probably a dimension subset; and
- That source does not exist.

If it is a dimension subset, make sure that it hasn't been deleted, and that it's a public subset.

G'Day Captain Kirk.....

Thanks - we did find a missing Dimension Subset but the order in which my Data Source seems to be the wrong order as the Dimensions

My Dimensions in the cube are:

Forecast-Scenario
Misc-Proj-Measures
Sub Misc-Projects
Month

but my Data source view when I preview is:

Forecast-Scenario
Misc-Proj-Measures
Month
Sub Misc-Projects

Do you know how I can get these in the right order...........?

Many Thanks

Have the dimensions been reordered since cube creation. There is something about it in this thread http://www.tm1forum.com/viewtopic.php?f=18&t=5284.

Hi Duncan - thanks for this. No nothing seems to have changed from last month end to this..... very strange..........!!
I'll have a good read up on this link tomorrow

Thanks

Had a message from moby91 saying it had been fixed in the latest hotfix of 9.5.2 FP2. Has the server been patched recently?

This is what he said

if you are using TM1 9.5.2 FP1, you may have run into the defect logged as APAR PM49187:
Process based on a view created by TI on a reordered cube uses the reordered dim order not the original cube dim order

The Hotfix 2 for TM1 9.5.2 FP1 includes a patch addressing that defect.

Duncan P wrote:Had a message from moby91 saying it had been fixed in the latest hotfix of 9.5.2 FP2. Has the server been patched recently?

This is what he said

if you are using TM1 9.5.2 FP1, you may have run into the defect logged as APAR PM49187:
Process based on a view created by TI on a reordered cube uses the reordered dim order not the original cube dim order

The Hotfix 2 for TM1 9.5.2 FP1 includes a patch addressing that defect.

Ayup.And that's why for years I've been bitching to IBM that they need to publicly release hotfix documentation as they release each hotfix and without exception. Only in that way can admins in the field can know not only what issues have been fixed but what issues are out there that might bite them. But no, for reasons best known to their own little brains they still refuse to do so...