Skip to Content
Author's profile photo Sreenivasulu Dasari

How to avoid ” no data to retrieve ” from query popup

Hi All,

We have a scenario to  avoid warning message NO DATA TO RETRIEVE” from data provider while refreshing the report.

No Data1.png

  • De Approvals is one of the Data Provider using in the report. Objects listed in one of the data provider(De Approvals) do not have data retrieved.
  • We tried to avoid warning message by checking options in the information design tool and WebI, however it’s not possible because it’s by design in business objects.
  • We tried to change the code at the SDK level, but maintenance issue’s will comes with any upgrade or patch update, to make sure the SDK changes are not overwritten.
  • So suppressed pop up warning message as workaround with below steps.

Step 1:

Create a Derived table (Derived Table) selecting SYSDATE from DUAL table.

No Data12.png

Step 2:

Alias the same table with different name (Test) and join both the tables.

No Data13.png

  Step 3:

Create a context (Date) using the two tables (Derived Table and Test) then select the join (Derived Table”.SYSDATE” = Test.”SYSDATE”) and change the expression as 1=1.

No Data14.png

Step 4:

Delete the alias table (test) from the data foundation and exclude the join form other context in the Data foundation.

No Data15.png

   Step 5:

Create object SYSDATE in the business layer and map the Derived filed Sysdate.

No Data16.png

  Steps 6:

To verify SysDate, create a Query in the IDT and check whether multiple queries are created for each context.

No Data17.png

  Steps 7:

Check System date is displaying even though other context not displaying data.

No Data18.png

  Step 8:

And then use the SYSDATE object in all the Data providers and then run the report. report don’t display the No date retrieve warning message because sysdate always have current system date.

Hope this helpful.



Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Nimisha Girijan
      Nimisha Girijan

      extremely useful while integrating BO forms to Webdynpro Screens.Thank You So Much.