Webi - Cannot execute empty query. (QTJ 00521) (WIS 00000)

[former_member223074]

Hi all,

There is a webi report tht has 4 Data Providers, which works perfectly fine,

When we added couple more Data Providers to the webi report , made our changes and deleted  the first 4 Data providers, as they are no longer needed for my report, when we save and refresh the report it throws the below error.

Cannot execute empty query. (QTJ 00521) (WIS 00000)

We changed the datasource to be pointed to the same BICS connection, it goes to the query panel and still gives the same error when you "Run query", we get the same error

We are in BO 4.0 SP 7, Any work arounds will be helpful.

Thanks,

Anil

[Former Member]

This error happens if enable query stripping is checked which needs to be disabled to fix the issue..

Check the note below

1936256 - Error "Cannot execute empty query. (QTJ 00521)(WIS 00000)" when refreshing Web Intelligenc...

[Former Member]

Hi Durga,

Where exactly I can find "Query Stripping" is checked or not??

Are you talking about Bex Query---> Proterties---> Extended--->Release for OLE DB for OLAP

                               Check  [*]Allow enternal access to this query.

or some thing other, Pls let me know.

Thanks & Regards,

Mahesh.

[arijit_das]

Query Stripping can be checked at 2 places:

1. WebI Query Properties.

2. WebI Document Properties.

This is a property of WebI and not the BEx query.