Page 1 of 1
URGENT!! Post process does not get past prolog
Posted: Mon Nov 11, 2013 8:41 am
by Mems
Hey All,
I have Post process from Planning Income Statement cube to a Reporting Income Statement Cube.
The process has worked for 5 years...
We recently upgraded to TM1 10.1.1 Excel 2010 since then one user is having trouble running only the 1 process (She is able to run all 10 of her other processes).
I can run it from the server\my desktop without any issues (admin login and her login). I have re installed her TM1.
I have deleted and recreated the process. Restarted TM1.
I have also created a "DummyAdmin" account which seemed to work from her desktop but is obviously not sustainable.
The problem seems to come in when the process needs to clear data. It does net get past the prolog. (She does have full rights I have ran the process from her username with success)
It seems to be a combination between that user account and that PC.
I have no more ideas on how to fix this issue.
Any advice will be greatly appreciated.
Regards,
Re: URGENT!! Post process does not get past prolog
Posted: Mon Nov 11, 2013 10:03 am
by Edward Stuart
What details are available in the Message log on the server when the user runs the process?
Re: URGENT!! Post process does not get past prolog
Posted: Mon Nov 11, 2013 11:32 am
by Mems
Edward,
Thanks for the response.
No message log - the process does not finish.
It just says process started.
Regards,
Re: URGENT!! Post process does not get past prolog
Posted: Mon Nov 11, 2013 11:58 am
by Edward Stuart
Does the process error? Do you cancel the process before it completes as it is taking longer than usual?
Does the process call a file on the server that the user may not be able to access with their Windows user account?
What messages do you see from TM1 when running this process? How do you know it does not get past the Prolog?
To assist with responses and getting a resolution please check the request for assistance guidelines:
http://www.tm1forum.com/viewtopic.php?f=3&t=1037
Re: URGENT!! Post process does not get past prolog
Posted: Mon Nov 11, 2013 2:03 pm
by Mems
Edward,
Edward Stuart wrote:To assist with responses and getting a resolution please check the request for assistance guidelines:
I'm not leaving out any information... I wish I was
- the reason for the lack of information is the lack of information.
Edward Stuart wrote:Does the process error?
The process does not complete, it usually takes 5 seconds to run, I did let it run for a day with no success. The following morning I cancelled the process.
Edward Stuart wrote:Do you cancel the process before it completes as it is taking longer than usual?
Yes see above
Edward Stuart wrote:Does the process call a file on the server that the user may not be able to access with their Windows user account?
Nope it uses a cube view to 'post' values from the planning income statement cube to the reporting income statement cube. (RIS cube has no rules)
Edward Stuart wrote:What messages do you see from TM1 when running this process?
No error message process never completes. It just says started by user.
Edward Stuart wrote:How do you know it does not get past the Prolog?
In the process dialog box it says busy with prolog procedure.
The prolog assigns a parameter to a subset and clears values.
Hope this helps?
Re: URGENT!! Post process does not get past prolog
Posted: Mon Nov 11, 2013 4:46 pm
by mattgoff
Mems wrote:Edward Stuart wrote:To assist with responses and getting a resolution please check the request for assistance guidelines:
I'm not leaving out any information... I wish I was
- the reason for the lack of information is the lack of information.
Well, the code in the Prolog would be helpful (Guideline #4).
The typical way to troubleshoot this kind of problem is to remove all code in the offending tab and re-add it line-by-line, running after adding each line to confirm it executes. Alternatively, you could use ASCIIOutput to write a checkpoint after every line. Once you find the bad line, you're probably going to have to figure out a workaround since it sounds like IBM broke something (if nothing else in your environment truly changed).
Addendum: Is this a dynamic subset you're creating? Performance often gets broken in this situation. Can you test with a static subset and see if it completes in a timely fashion?
Matt
Re: URGENT!! Post process does not get past prolog
Posted: Mon Nov 11, 2013 6:02 pm
by Mems
Matt,
Thanks for the advice will test tomorrow.
Code: Select all
#use subset to only filter out the year selected from the input view
subsetdeleteallelements('Fiscal Year','TI_Year_Parameter');
subsetelementinsert('Fiscal Year','TI_Year_Parameter',PYear,1);
#use subset to only filter out the month selected from the input view
subsetdeleteallelements('Month','TI_Month_Parameter');
subsetelementinsert('Month','TI_Month_Parameter',PMonth,1);
#use subset to only filter out the Version selected from the input view
subsetdeleteallelements('Version','TI_Version_Parameter');
subsetelementinsert('Version','TI_Version_Parameter',PVersion,1);
#clear out the values before bringing in the plan
CellPutProportionalSpread( 0, 'Reporting Income Statement', PYear,PMonth,PVersion ,'All Shareholders','All Depots', 'All Brands','All Markets', 'All Acco
unts', ' Total Amount');
Regards,
Re: URGENT!! Post process does not get past prolog
Posted: Mon Nov 11, 2013 7:25 pm
by Duncan P
The other thing you could do is to set up logging as described
here and then add a line to the
tm1s-log.properties file like this
Code: Select all
log4j.logger.TM1.Process.Functions=DEBUG
This will output a message for every function call within the TI process and from these you should be able to track its progress.
Re: URGENT!! Post process does not get past prolog
Posted: Mon Nov 11, 2013 7:33 pm
by Wim Gielis
Hello,
I know that you can use CellPutProportionalSpread to clear cells in a cube. In fact, I wrote an article about it:
http://users.skynet.be/fa436118/wim/tm1 ... ead_EN.htm
Does it work when you use the normal way of clearing cells, that is using ViewZeroOut?
Re: URGENT!! Post process does not get past prolog
Posted: Tue Nov 12, 2013 8:30 am
by Mems
@Wim
Wim Gielis wrote:Hello,
I know that you can use CellPutProportionalSpread to clear cells in a cube. In fact, I wrote an article about it:
http://users.skynet.be/fa436118/wim/tm1 ... ead_EN.htm
Does it work when you use the normal way of clearing cells, that is using ViewZeroOut?
It worked, I have no idea why - like I said the process has been in place for the best part of 5 years.
We use CellPutProportionalSpread to clear cubes about 70% of the time as it seems 'cleaner' to read when you handover (It's just how our company does it) we have never experienced this before.
I will escalate to IBM and give feedback.
Thanks for all the replies it was much appreciated.
Regards,