TM1 Forum

Posted: **Wed Mar 13, 2013 3:12 pm**

Hi forum members,

I'm getting an error on my Cognos Express Installation when i am trying to execute a chore. When i execute the process (that's in the chore) stand-alone, the process works.

1732 [e5] INFO 2013-03-13 14:27:52.138 TM1.Chore Chore ImportCubeBudget executed by user Cognos Express\Cognos Express Administrator_CAMID(_CognosExpress_administrator_)
1732 [e5] INFO 2013-03-13 14:27:52.138 TM1.Process Process import_ Budget vs Realisation Sales Cube1 executed by chore ImportCubeBudget
1732 [e5] ERROR 2013-03-13 14:27:52.153 TM1.Process Process "import_ Budget vs Realisation Sales Cube1": : Execution was aborted. Error file: <TM1ProcessError_20130313142752_import_ Budget vs Realisation Sales Cube1.log>
1732 [e5] INFO 2013-03-13 14:27:52.153 TM1.Chore Chore ImportCubeBudget finished executing
1732 [e5] INFO 2013-03-13 14:37:40.157 TM1.Process Process "_FileAccessProcess" executed by user "Cognos Express\Cognos Express Administrator_CAMID(_CognosExpress_administrator_)"
1732 [e5] ERROR 2013-03-13 14:37:40.157 TM1.Process Process "_FileAccessProcess": : Execution was aborted. Error file: <TM1ProcessError_20130313143740__FileAccessProcess.log>
1732 [e5] INFO 2013-03-13 14:37:40.251 TM1.Process Process "import_ Budget vs Realisation Sales Cube1" executed by user "Cognos Express\Cognos Express Administrator_CAMID(_CognosExpress_administrator_)"
1732 [e5] INFO 2013-03-13 14:37:40.298 TM1.Process Process "import_ Budget vs Realisation Sales Cube1": finished executing normally, elapsed time 0.05 seconds

Contents of the error file:

Error: Prolog procedure line (0): Unable to open data source "d:/program files (x86)/ibm/cognos express/xcelerator/custom/tm1data/cxmd\import_ Budget vs Realisation Sales Cube1.blb".

And the contents of the fileaccessprocess.log file.

Error: Prolog procedure line (4): ProcessError()

Could someone help out with this? I allready tried to re-create the process and the chore. The file that is mentioned in the error does not exist, a file with the same name but with a ".pro" extension exists.

Additional note: i 've been using Performance Modeler to build this model.

Posted: **Thu Mar 14, 2013 2:18 am**

Never seen this before but then I have never touched PM

Looks like it could be permissions.
Especially if it works as a process but not withing a chore.

Might be related to this http://www.tm1forum.com/viewtopic.php?f=3&t=7684
In which case I would stop the "IBM Cognos Analytic Server - CXMD" and change it to use an account rather than the local system account.
Ensure this account has admin access to the server and the directory file you are trying to open.

If this fails I would alter the data source of the process to be a view rather than a blb file

TM1 Forum

Process failing when in Chore

Process failing when in Chore

Re: Process failing when in Chore