OBIEE 12.2.1.2 post migration few reports are running forever.

Question

Hi ,

we have recently upgraded OBIEE 12.2.1.2 from 12.2.1.0.0. There are few reports which are running forever in dashboard.

There are few solutions we have tried but no luck.

set variable COMPATIBLE_RELEASE='12.2.1.0': in the report prefix.

Also, tried below.

* Go to Middleware\domains\bi\config\fmwconfig\biconfig\OBIJH and take a backup of xdo.cfg
* Edit xdo.cfg and specify the system-temp-dir property. For example: d:	emp
* Re-start the BI services.

Can someone help me out here?

Regards,

prasanna

[Deleted User] · Answer

You're talking about xdo.cfg but then about "filter based on another analysis" ... you're giving a good description of the issue here.

"Report" = BIP Report Object

"Analysis" = OBIEE Answers Object

BluShadow · Answer

*** Moderator Note: Question now moved to the OBIEE product space.  The Getting Started space, where you originally posted this questions, is a great place to introduce yourself and learn about using the Developer Community platform, but is not a suitable place to ask product specific questions, as you are unlikely to find the product experts for those products hanging around in there.  If you search the community you can find the product space that best suits your question before you ask it in future.

User_4A9ZZ · Answer

I found that the root cause is filters has based on another analysis but the issue is not resolved.