TM1 Forum

I wasn't able to find any information on this anywhere else, I was wondering if anyone had an Idea to why this is happening...

Some of my TI processes will say that they are executed by me multiple time hen I run them once. Fore instance I am loading data into a cube from a database using a SQL statement. The Tm1Server.log file will look like this..

48720 INFO 2010-12-13 15:33:47.076 TM1.Process Process "DataloadProcess1" executed by user "AD\User1"
48720 INFO 2010-12-13 15:46:08.315 TM1.SQLAPI Checking Driver Capabilities for database "DataWarehouse"
48720 INFO 2010-12-13 15:46:08.315 TM1.SQLAPI Driver supports SQLFetchScroll
48720 INFO 2010-12-13 15:46:08.456 TM1.Process Process "DataloadProcess1" executed by user "AD\User1"
48720 INFO 2010-12-13 15:56:54.773 TM1.SQLAPI Checking Driver Capabilities for database "DataWarehouse"
48720 INFO 2010-12-13 15:56:54.773 TM1.SQLAPI Driver supports SQLFetchScroll
48720 INFO 2010-12-13 15:56:54.804 TM1.Process Process "DataloadProcess1" executed by user "AD\User1"

I am not clicking anything to run the process more than once. There are other people in the dev model and dev contributor model while these are running. TM1 version 9.5.1

Any ideas?

Thanks,

I vaguely remember something similar happening, but I think it was only when the process was executed by the chore. I think I deleted both the chore and process and rebuilt them both. That made it go away. Never figured out what the actual problem was though.

HTH,
Martin

The process eventually finishes but takes longer than it should. Because of long run time SQL queries it should take about 40 minutes or so but ends up being two hours. One theory we were having is that it is just the tm1server.log over stating. WE have not addressed or fixed the problem, just currently living with it

Is this happening only a particular cube ? Or does this happen on all cubes that have Data load processes ?
It would pay to create a identical dummy cube ( do it only if you have the requisite RAM etc ) and check whether the same happens there or not.
Also What does the TM1.Chore Registering chore: say in your log file ?

Please could you elaborate your statement here "There are other people in the dev model and dev contributor model while these are running."


cheers

Hi,
are you doing batch updates? In general, please check TI documentation for rollback mechanism, this was introduced along with 9.1.
The TI needs to be able to write to destinations, otherwise it will rollback and restart process.

Regards
Gabor

it doesn't seem to depend on which cube I am loading it to. and what I mean by others users working in the model is they would be opening cube views, writing rules and feeders, just not running any other processes. No one is in contributor or web. Luckily enough it seems to effect nothing more than the time it takes to run the process.

mastertito4 wrote:it doesn't seem to depend on which cube I am loading it to. and what I mean by others users working in the model is they would be opening cube views, writing rules and feeders, just not running any other processes. No one is in contributor or web. Luckily enough it seems to effect nothing more than the time it takes to run the process.

If you've got people changing rules, which probably requires a re-evaluation of feeders, at the same time you are running TI load processes then you are just asking for headaches. My recommendation is that you stop ALL development work while running data load routines.