Error occurred while Chore was running

Post Reply
User avatar
roei61
Posts: 41
Joined: Wed Aug 22, 2012 5:44 am
OLAP Product: PAX
Version: 2.0.7
Excel Version: 2016
Location: Israel

Error occurred while Chore was running

Post by roei61 »

Hi to all the TM1 experts,

I'm trying to load data from ODBC by a few process.
After the data was loaded into one of the cubes I have a diffrent cube that a process transfers relevent data to it.
All those process are working together in a chore.
Everything was working fine till I start getting the following message:
"Error occurred while chore was running. Please check the message log file".
When I'm looking at the log file I see that the process compeleted successfully with no errors at all, but all my cubes don't have the data.
Did someone handaled such situation?

Thanks in advanced
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Error occurred while Chore was running

Post by rmackenzie »

roei61 wrote:Everything was working fine till I start getting the following message:
"Error occurred while chore was running. Please check the message log file".
When I'm looking at the log file I see that the process compeleted successfully with no errors at all, but all my cubes don't have the data.
Did someone handaled such situation?
So your transfer process completed successfully, but perhaps it was the data load process before that that had the error - did you check that? If that were the case, then the 'successful' process simply didn't have any data to transfer and successfully did that...

You do realise you're asking a question about how to inspect message logs and not anything TM1 specific, right?
Robin Mackenzie
User avatar
roei61
Posts: 41
Joined: Wed Aug 22, 2012 5:44 am
OLAP Product: PAX
Version: 2.0.7
Excel Version: 2016
Location: Israel

Re: Error occurred while Chore was running

Post by roei61 »

Thnaks for your answer.
It's a probably something wrong with the machine and not with the TM1.
All the data was loaded fine but the last process which transfers the data didn't work.
When I run all the process in one chore I got this error, but when I run it step-by-step it finished successfully.
I'm still trying to investigate it and I will gladly publish any conclusions when I will find some.
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: Error occurred while Chore was running

Post by ioscat »

it's possible to be process commit conflict issue
cgaunt
Posts: 33
Joined: Tue Jan 29, 2013 2:52 pm
OLAP Product: TM1
Version: 9.0 SP3 9.5.1 10.1.1
Excel Version: excel 2010 2007 2003

Re: Error occurred while Chore was running

Post by cgaunt »

You should also check that you dont have any parameters being pre-selected in the chore. Open the chore and check the 'Specify Values for Parameters' button for each selected process. That could well epxlain why the TIs work individually, but not when run through the chore.
Post Reply