Page 1 of 1

TI Process slow

Posted: Mon Apr 16, 2018 11:25 pm
by AskAndAnswer
There are two processes - Process 1 and Process 2. Process 1 runs very quickly when executed independently. When it's executed from Process 2, it takes a while to complete hanging on the Epilog procedures. Process 2 is generally very slow, but ExecuteProcess (Process 1) is the first command in the Prolog, so there is no reason why it would hang.

Another issue is that Process 2 worked normally a month ago, now it takes a while to complete. The source is DB2 table, and it runs without delay. What could potentially cause the slowdown?

Re: TI Process slow

Posted: Tue Apr 17, 2018 2:10 pm
by PavoGa
Sometimes the user interface is misleading as to what is really going on, e.g. seeming to be hanging up on the Epilog procedure. Your post does not mention if you have confirmed the observed performance in the server log itself by reviewing the time that Process 1 actually executes. Based on what else is happening in the prolog of Process 2, the progress window may report that the epilog of Process 1 is running when it is actually completing the balance of Process 2's prolog.

May need more information to diagnose this as well. Like what are the processes doing exactly besides reading from DB2?

Re: TI Process slow

Posted: Tue Apr 17, 2018 10:22 pm
by AskAndAnswer
It turned out to be a feeder issue in one of the target cubes. Thank you.