Chore: ExecuteProcess() aborted, recursion level too deep

Post Reply
mato
Posts: 3
Joined: Tue Jan 07, 2020 3:35 pm
OLAP Product: TM1
Version: PAL 2.0.6
Excel Version: 2013

Chore: ExecuteProcess() aborted, recursion level too deep

Post by mato » Mon Jan 13, 2020 4:08 pm

Hi TM1 Gurus,

I am getting this error message when running a chore. I found one similar topic but it didn't help much.

Code: Select all

2216   []   INFO   2020-01-13 15:43:04.314   TM1.Process   Process "Data Import - Financial" executed by chore "Data Import - Financial"
2216   []   ERROR   2020-01-13 15:43:04.316   TM1.Process   ExecuteProcess() aborted, recursion level too deep
2216   []   ERROR   2020-01-13 15:43:04.317   TM1.Process   Process "Data Import - Financial": : System stack overflow, process terminated : ExecuteProcess() aborted, recursion level too deep
2216   []   INFO   2020-01-13 15:43:04.317   TM1.Chore   Chore "Data Import - Financial" time = 64.25 seconds
2216   []   INFO   2020-01-13 15:43:04.319   TM1.Chore   Chore "Data Import - Financial" finished executing
From logs I can see that chore ends with this error message when it clashes with different TI process executed by user. Chore tries to run TI process several times, it is always rollbacked end eventually it finishes with this error.

The problem is that once the chore ends with this error message it ends always with this error until I restart server and it doesn't matter if this chore runs automatically or I run it manually. These subsequent executions of chore end immediately with this error. If I run manually TI process which is inside this chore then it finishes successfully. So it looks like that only problem is that chore.

I can understand that when one TI clashes with another TI then it can be rollbacked and finishes with any error. But subsequent executions should be fine. This chore usually runs without any issue.

Have you experienced something like that? Thanks for any hint and help.

Matej

EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: Chore: ExecuteProcess() aborted, recursion level too deep

Post by EvgenyT » Mon Jan 13, 2020 9:15 pm

I think you better of posting actual code of Data Import - Financial. From what I can tell, Data Import - Financial does a ExecuteProcess () that never finishes, a WHILE loop that never meets the condition comes to mind. Hence, the stack overflow.

Thanks

Evgeny

mato
Posts: 3
Joined: Tue Jan 07, 2020 3:35 pm
OLAP Product: TM1
Version: PAL 2.0.6
Excel Version: 2013

Re: Chore: ExecuteProcess() aborted, recursion level too deep

Post by mato » Tue Jan 14, 2020 9:14 am

Hello Evgeny,
thanks for comment.

TI process is quite complex with several ExecuteProcesses. This TI runs in a chore without any problem if it runs standalone without interfering with different TI. Chore always finishes successfully, so there is no infinite loop for sure.

There is problem only if chore clashes with another TI. Then it sometimes ends with this error. And any subsequent execution of this chore ends immediately with this error until restart of server. But when I run just TI process from this chore then it is fine. So basically there is no problem with TI as it runs always fine. Only chore ends with this error.

For now I can live with the fact that chore fails if it clashes with another TI. This another TI runs rarely. But next chore execution should run and not fail with the same error.

Thanks,
Matej

EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: Chore: ExecuteProcess() aborted, recursion level too deep

Post by EvgenyT » Tue Jan 14, 2020 11:04 pm

Hi Mato,

As I stated previously, you need to provide examples of actual code, execution etc.

There are two things that normally cause stack overflow (from my experience):

1. Exceeding 100 recursions with ExecuterProcess. Either WHILE loop or continuous "trashing" when process keeps on re-trying after being blocked by another thread
2. Blowing the feeder stack, 200+ deep.

Thanks

Evgeny

mato
Posts: 3
Joined: Tue Jan 07, 2020 3:35 pm
OLAP Product: TM1
Version: PAL 2.0.6
Excel Version: 2013

Re: Chore: ExecuteProcess() aborted, recursion level too deep

Post by mato » Wed Jan 15, 2020 10:53 am

Hi Evgeny,
1. Exceeding 100 recursions with ExecuterProcess. Either WHILE loop or continuous "trashing" when process keeps on re-trying after being blocked by another thread
In logs I can see that process is rollbacked after 33 times of trying and then it fails. But this is something I can live with if the chore runs for the next time without any problem. The real problem for me is that subsequent executions of chore are failing.

I am attaching server log, these are steps that happened:
  1. Row 1. I executed TI process manually.
  2. Row 349. Chore was executed after about 5s.
  3. Row 458. Process executed from chore was rollbacked. On the next line you can see that chore was restarted from the beginning.
  4. Row 570. Same situation as before, process was rollbacked. This happened 33 times.
  5. Row 2567 - 2577. Process from chore is rollbacked for the last time, error occurred and chore finished executing.
  6. Row 5436. TI process that was started manually finished successfully.
  7. Row 5438. I tried to execute chore manually but it finished executing immediately with the same error.
  8. Row 5446. I executed just TI process from that chore. It finished successfully.
  9. Row 5474. I executed chore again but the same error occured.
After restart chore is running fine again. I can post later also TI processes but I believe that they are running just fine.

Thanks,
Matej
Attachments
tm1server.log
(910.38 KiB) Downloaded 16 times

Post Reply