Question Re: WebI Objects are missing in Query panel in Technology Q&A

WebI Objects are missing in Query panel

former_member189295 — Mon, 06 Nov 2017 11:33:44 GMT

Hi,

We are facing a strange issue with our webi reports.

The universe name and the objects previously used to create the report are not displayed in the Query Panel after the upgrade of BI4.1 SP05 to SP09. In SP05 the issue is not present.

I have found a workaround for this, whereby if I open the report in Webi Rich Client, refresh it and save it back, then the objects are again displayed in the same report when later opened via Webi (thin client), and can subsequently be edited.

I have found the SAP KBA# 2007655 - WebI Objects from Result Objects are missing in Query panel with sub query BI 4.0 SP9 and BI 4.1

But as we are facing the issue in SP09, the recommendation is not applicable.

I assume somehow the reports are not updating after the upgrade.

Can you please give any idea ?

Re: WebI Objects are missing in Query panel

Former Member — Mon, 06 Nov 2017 13:25:12 GMT

May be a bug. Is it happening for all the webi reports? Or few. I have not seen the issue.

Re: WebI Objects are missing in Query panel

Former Member — Mon, 06 Nov 2017 17:53:48 GMT

Hi ,

Yeah ,its bug in HTML mode with BI 4.2 SP3 Patch 3 .

2405456 - Migrated Web Intelligence report do not show universe objects in HTML interface

as work around use Java applet mode.

it is resolved in BI 4.2 SP3 Patch 4 and higher .

Regards

Sateesh B

Re: WebI Objects are missing in Query panel

former_member189295 — Tue, 07 Nov 2017 08:11:33 GMT

Hi,

we have tested the some of these reports in SP8 env, where they are working fine in both BILaunchpad and WRC. Raised the issue with SAP and they have tested one sample report in SP9 Patch 7, but saying that the issue is not reproducible. As par the kba the issue should get resolved in SP5 and it can be assumed that SP9 is a cumulative update of the previous patches.

Is it possible that the reports are not picking up the update after the upgrade ? Because when we are opening them in WRC and saving it, after that the values are seen in BILaunchpad in every mode.

Re: WebI Objects are missing in Query panel

former_member189295 — Fri, 10 Nov 2017 12:18:02 GMT

It seems that the connection is breaking after the upgrade and when we are opening the reports in WRC, saving it and exporting back to repository, connection is getting restored.

Re: WebI Objects are missing in Query panel

former_member189295 — Thu, 07 Dec 2017 07:02:10 GMT

The issue seems to be a bug with SAP claimed to get resolved in SP05. Though the issue doesn't appear in SP05, it reappears in SP09. Finally it is resolved in SP09 Patch7

Re: WebI Objects are missing in Query panel

hans_segers — Fri, 09 Mar 2018 12:41:44 GMT

We have this issue in : SAP BI 4.2 SP5 Patch 100 :

- only when running the webtier on IBM Websphere

- only in Web Intelligence HTML (not in JAVA, not in Rich Client : so not a permissions issue in the unx)

- not in : when running on Apache Tomcat

Re: WebI Objects are missing in Query panel

former_member491508 — Tue, 26 Jun 2018 15:00:52 GMT

I am facing the same issue in BI 4.2 SP05 Patch2. Web Application Server is Apache Tomcat. Is it a bug on SP05 patch2 ?

Re: WebI Objects are missing in Query panel

former_member491508 — Tue, 26 Jun 2018 15:25:40 GMT

In BI 4.2 SP05 Patch2, even if we save the report through WRC, it doesn't work in HTML mode. It works only in Applet mode.