URGENT!! Post process does not get past prolog

[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,

[Edward Stuart]

What details are available in the Message log on the server when the user runs the process?

[Mems]

Edward,

Thanks for the response.

No message log - the process does not finish.

It just says process started.

Regards,

[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

[Mems]

Edward,

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.

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.

Do you cancel the process before it completes as it is taking longer than usual?

Yes see above

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)

What messages do you see from TM1 when running this process?

No error message process never completes. It just says started by user.

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?

[mattgoff]

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

[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,

[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.

[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?

[Mems]

@Wim

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,