Hi guys,
I am facing a huge problem on my model on TM1. Everything was ok until last friday but today after I tried to run some process it stopped working. When I run some process that run anothers it is aborted and I can't see anything on logfiles of what is going on.
Perhaps could be something related to "stack overflow". But the model last friday was working correctly, and suddenly it stopped.
Someone have already seen something like this?
I deleted all feeders file so tm1 could create then again, but it is the same. When I run these process one by one it works fine. The problem is when I run a process that run anothers.
Could anyone please help me?
Tks,
JR.
TI Problem
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: TI Problem
Hi Jorge
What do you mean by log file? Do you mean a TM1ProcessError log file? The other thing to check is the TM1Server.log. That may show that perhaps the number or type of parameters in a process have changed or a process name has changed and that is why it is failing since the call to execute that process has not been updated. At the very least it should help you to narrow down which process in the chain of A calls B calls C, etc, is failing
Regards
Paul Simon
What do you mean by log file? Do you mean a TM1ProcessError log file? The other thing to check is the TM1Server.log. That may show that perhaps the number or type of parameters in a process have changed or a process name has changed and that is why it is failing since the call to execute that process has not been updated. At the very least it should help you to narrow down which process in the chain of A calls B calls C, etc, is failing
Regards
Paul Simon
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: TI Problem
Hi Paul,
I have this process here that runs ok:
Then I run another process that calls the first one with the same parameters and the process is aborted:
This is very crazy and I could not understand what is happening.
Thank you.
JR
I have this process here that runs ok:
Then I run another process that calls the first one with the same parameters and the process is aborted:
This is very crazy and I could not understand what is happening.
Thank you.
JR
paulsimon wrote: ↑Mon Aug 27, 2018 11:26 pm Hi Jorge
What do you mean by log file? Do you mean a TM1ProcessError log file? The other thing to check is the TM1Server.log. That may show that perhaps the number or type of parameters in a process have changed or a process name has changed and that is why it is failing since the call to execute that process has not been updated. At the very least it should help you to narrow down which process in the chain of A calls B calls C, etc, is failing
Regards
Paul Simon
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: TI Problem
When you run a process via ExecuteProcess, the syntax is normally ExecuteProcess(Param1Name, Param1Value, Param2Name, Param2Value...ParamXName, ParamXValue).
Your code is ExecuteProcess(Param1Value, Param2Value). You are not passing the name of the parameter. If you look at your error message screenshot it is telling you exactly that. Try changing it to:
Your code is ExecuteProcess(Param1Value, Param2Value). You are not passing the name of the parameter. If you look at your error message screenshot it is telling you exactly that. Try changing it to:
Code: Select all
ExecuteProcess('fluxo_caixa_copia_premissas_antecipacao', 'pPeriodoOrigem', pPeriodoOrigem, 'pPeriodoDestino', pPeriodoDestino);
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: TI Problem
Hi!
You are right, I forgot this important detail on execute process.
Sorry about that and thanks for your reply.
Best regards,
JR.
You are right, I forgot this important detail on execute process.
Sorry about that and thanks for your reply.
Best regards,
JR.
tomok wrote: ↑Tue Aug 28, 2018 2:19 pm When you run a process via ExecuteProcess, the syntax is normally ExecuteProcess(Param1Name, Param1Value, Param2Name, Param2Value...ParamXName, ParamXValue).
Your code is ExecuteProcess(Param1Value, Param2Value). You are not passing the name of the parameter. If you look at your error message screenshot it is telling you exactly that. Try changing it to:
Code: Select all
ExecuteProcess('fluxo_caixa_copia_premissas_antecipacao', 'pPeriodoOrigem', pPeriodoOrigem, 'pPeriodoDestino', pPeriodoDestino);