Process failing when in Chore

Post Reply
ErwinD
Posts: 1
Joined: Tue Mar 12, 2013 1:29 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Process failing when in Chore

Post by ErwinD »

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.
User avatar
jameswebber
Community Contributor
Posts: 188
Joined: Sun Nov 21, 2010 8:00 pm
OLAP Product: Cognos Express 10
Version: CE 10.1.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Process failing when in Chore

Post by jameswebber »

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
Post Reply