UBE getting in processing for longer not getting done.
Dear All,
While running the reports its getting into processing and not getting done.
The scenario is that after some enhancement and promoted to PY and then to PD.
1. In PD the report is taking more than hours to get done and previously it was take hardly 2 minutes.
2. In PY sometimes report is getting done quickly and some times stuck in processing state and lastly we have to terminate the job.
Please help me out in this.
TR -9.1.3.1
AR -9.0
DB-DB2
--------------------------------- DEBUG----------------------------------
Oct 11 12:51:05.401000 - 4744/5140 **** jdeDebugInit -- output disabled in INI file.
Oct 11 12:51:19.318000 - 3760/5712 FOREIGN_THREAD Entering JDB_GetUser