No data to retrieve. Query 1

[#1]

Good day,

Please can you advise:

When running a Webi report, I receive the error "No data to retrieve. Query 1".

The report has ran for months and always returned data. The error only started appearing in the last two days.

Regards,

KK1

[former_member207052 · Accepted solution]

As the warning says, there is no data returned bu Query 1.

reasons,

1. Someone revoked your data access or messed up with the security for all users
2. one or more tables the query depends on has been truncated

How to Fix:

1. Take the query and execute it on the DB directly of you have access

Regards,

Naras

[Former Member · Accepted solution]

Thanks Narashimman for the response.

The Webi report sits on top of a BW report. I can run the report successfully off BW and data is returned.

The issue is that I have to rectify this error because the Webi report is e-mailed out automatically by the system to users daily with missing data.

Regards

[Former Member · Accepted solution]

Do you have any prompts on your Report. If so could you please check if those are valid values to fetch data in report?

Regards

Niraj

[Former Member · Accepted solution]

Keith,

Are you using BEx query in your report? If yes, do you get data when you run this BEx query in BEx Analyzer directly bypassing Webi?

If it is not giving data in BEx Analyzer then you will definitely get "No data to fetch" message on Webi.

Are you using BEx query directly or creating universe (UNV) over BEx query?

If not ,are you creating UNX file over DSOs in BW?

If yes and in case you are expecting NO data and want to suppress this message, you may try below blog written by me:

I would like to tell you that "No data to fetch" is NOT an error but warning message. It comes when no result set is received from back end.

Regards,

Yuvraj

[Former Member · Accepted solution]

Thanks Niraj,

It so happens that there are no prompts on the report.

Regards

[former_member207052 · Accepted solution]

Ok, so we can rule out one option and confirm that "Source has data".

Depending on your setup, if you have configured a single user account to read data from BW, Try to log on to BW as that user and verify.

Check Niraj's suggestion to see if any report filters are causing the issue.

Finally, try creating a new sample report with based on same Query1 and try to execute it. This is to rule out any issues with the report itself (very very rare - but just to check if everything is OK)

[Former Member · Accepted solution]

Hi Yuvraj,

Thanks for the response.

Yes, a BEx query is underlying the webi report and I get data when I run the BEx query in BEx Analyzer directly bypassing Webi

I am accessing the BEx query via a BICS connection.

Regards