Skip to Content
author's profile photo Former Member
Former Member

"no data to retrieve" issue

  1. Hello.

I am facing a weird situation when i run any report either in Infoview or in Webi Rich Client.

From time to time, when i run an Infoview report, or a Webi Rich Client pointing to the Infoview report, the system launches the message "no data to retrieve in query 1", indicating the query couldn't fetch any row of data. But if i edit the query and get into the query panel to refresh it, surprisingly it returns the correct data and, yet more, when after refreshing the query i run the report it executes correctly. So it seems that in order to fetch data the report must to be refreshed in the query panel first... which makes no sense.

This behavior occurs when login for the first time, or when has passed some time since last run. Also occurs if the report has no filters (just the option "refresh on open") or if some filter is applied. The queries have been checked in the SQL Server database (source) and always retrieve data.

I know i have something wrong configured, but i cannot guess what. Could you help me solve this situation? Any clue?

Thank you very much in advance!!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2013 at 01:46 PM

    Hi Ruben,

    Based on description, I think its not BO problem but its more of DB problem.

    Instead of checking from BO Side, for best root cause analysis I would suggest to check SQL server DB log to see no. of rows retrieved for a query.

    When ever you don't get results, please note the time and check with DB log; this will allow you to see if you DB really threw any results or not. If it threw results then we can investigate into different parts of BO to see what could be the issue.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for answering, Hardik.

      As you suggested, i've been tracing SQL Server logs to see if BO sends any sql request to the database. I've found out that actually BO does send a sql command to the database, but a wrong one, since it is not executing a List of Values defined in Information Design Tool. Let me explain:

      In the Business Layer i defined a Year filter based in an existing List of Values as follows:

      @Select(ASCEND\Time\Year) in @Execute(Last 5 years - ASCEND)

      That List of Values was designed in Data Foundation by an sql query and was checked the option "Automatic Refresh Before Use".

      I am filtering the BO report query with that filter, expecting to retrieve the last 5 years of data. But when launching the report, the sql requested to the database reads as follow.

      ...

      AND

      ( ( D_TIME.Year ) in (null) )

      So it seems that the List of Values designed in the Data Foundation layer is not being run.

      Is there something amiss??? I'm afraid i'm pretty new with SAP tools...

      Thanks in advance!!!!!

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2013 at 09:30 AM

    Hello again.

    The issue actually is that whenever i logoff from Infoview, all the LOVs reset to null (making the reports fail). To get them informed with values i must logon, get to the Query Editors and refresh the queries. I guess it has something to do with the @Execute function mentioned above, for i think it does not actually execute anything.

    Any help???

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Simone Caneparo

      Thanks Simon.

      So, if I want to use @Execute command i must work against an UNV universe, am I right?? And since asigning LOVs to fields in an universe implies the using of @Execute command, does it mean that LOVs can only be used with UNV universes???

      As you can see, i am pretty new in SAP BO...

      Thanks and Regards!!!

      Rubén.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.