"no data to retrieve" issue

[Former Member]

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!!!

[Former Member]

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???

[abhinav_shrivastava1]

Hi Ruben,

Lets try to narrowdown the scenrio:

BI version? 4.0/3.1 (Should be 4.0, Confirm this)

Universe type? UNX/UNV (Should be UNX, but please confirm)

-Does it ever worked before?

-Have you tried checking the behavior without @Execute?

-Does it happen with new report also with single query?

-Authentication type? Are you using SSO in connection?

-Check the behavior from administrator account.

-Using WebI rich client using 3-tier mode or 2 tier mode? Can you confirm the problem with 2 Tier mode.

Please share any additional observation if any.

-Abhi

[Former Member]

Hi Abhi.

BI version? 4.0/3.1 (Should be 4.0, Confirm this)

• Version 4.0

Universe type? UNX/UNV (Should be UNX, but please confirm)

• Universe type: UNX

-Does it ever worked before?

• No. This is the first development.

-Have you tried checking the behavior without @Execute?

• How????? I need a filter with the last 5 years available to the users... the only way I know is assigning LOVs to Year field.

-Does it happen with new report also with single query?

• If I build the equivalent query in Information Design Tool it runs always correctly. It also runs fine in the Query Editor in Webi. However it does not run in the report.

-Authentication type? Are you using SSO in connection?

• No security implemented. No SSO. I have a developer profile.

-Check the behavior from administrator account.

• It is not possible right now...

-Using WebI rich client using 3-tier mode or 2 tier mode? Can you confirm the problem with 2 Tier mode

• How can i see in which mode Rich Client is?

Hope it helps, thank you!!!!!

[former_member188911]

Hi Ruben,

in order to use stored procedures you need to use UNV universes

Thanks and regards

Simone

[Former Member]

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.

[Former Member]

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.

[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!!!!!