While refreshing a report get- Request processing failed. (XLS 000009)

[former_member552077]

Hi All,

Getting error :" Request processing failed. (XLS 000009)

Request processing failed. (XLS 000009) [] <com.businessobjects.semanticlayer.qt.QTException: Cannot execute empty query. (QTJ 00521)&gt"

While refreshing Dashboard reports on BI Launch pad.

Steps for troubleshooting done so far:

Restarting Dashboard, Connection servers and Data federation server. However the issue remains the same

Environmental Details:

BI 4.0 SP 04 patch5

Client tools : 4.0 SP04 patch 5

Windows server 2008

BW 7.3

[former_member552077]

Update over this issue:

Go to dashboard designer open the non working report and when you edit query for existing one we get error " Some result objects or sort objects that you selected have changed(been renamed, removed or hidden) in the universe.  In the result query the objects are missing.

Kindly find the attached screen shot

There are three reports based on three bex queries and observed for two non working reports One report is working without any errors.

I observed that at the query level in BW side there were no recent changes done.

Could any one help me understand the cause of what could had have happened.

Thanks,

Sairaja

[former_member552077]

To Update.

I am able to create a new DASHBOARD report using webi and designer as well. And able to refresh the report as well.

This happens with the existing reports. Unable to refresh via designer as well for these reports.

-Sai

[former_member552077]

Any suggestions or help more over this..

[former_member182521]

Hello Sai,

Can we refer SAP Note

1698180 - Error:"Request processing failed. (XLS 000009)" when dashboard created on universe query with OLEDB connectivity in Dashboard Designer 4.0 is previewed

Regards,

Mani

[former_member552077]

Hi Manikandan,

Refers to ADAPT and update to SP5.

However, we are been using this for couple of months now and till yest I was able to refresh the report.

It starting from today.

Apart from update, cant we do any other checks?

-Sairaja

[DayaJha]

Hi Sai,

Please refer the below thread regarding While refreshing a report get- Request processing failed. (XLS 000009)

Links:

http://scn.sap.com/thread/3248142

http://scn.sap.com/blogs/ramchk/2012/12/26/error-while-pulling-bex-query-from-query-browser-in-dashb...

Hope this will help you as well.

Thanks,

Daya

[Former Member]

Hello Sai,

Please refer to this article http://service.sap.com/sap/support/notes/1821105 SP5 and patch5.4 are already availble in Support Portal.

I hope this help.

Cheers,

Fadoua

[former_member552077]

Hi Fadoua,

We have to move to SP5 later.

As customer needs this resolved in same patch as it was working earlier.

It was working till yesterday. Not sure what made it throw the error message now.

-Sai