cancel
Showing results for 
Search instead for 
Did you mean: 

The status of "QUERY_VIEW_DATA_PROVIDER" "DP_1" may only change during comm

Former Member
0 Kudos

We are getting this error message when trying to run a query over the portal.

When I run the query from a web browser it works with the URL but when I try and exceute the query from the portal I get the error message below

The status of "QUERY_VIEW_DATA_PROVIDER" "DP_1" may only change during command processing

Any help will be rewarded.

Thanks

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

We experienced the same problem. It was caused by having a (SAP-exit) variable on 0FISCPER, without restricting 0FISCVARNT. When also restricting 0FISCVARNT to a fiscal year/period, the problem is gone.

Probably there is a note to fix it, although I couldn't find it.

Cheers,

Daniel

Former Member
0 Kudos

I have 0FISCVARNT in my infocube, but i can't find in in Bex? that's why I can't restrict.

What can I do?

I built another query with customer exit variable on calmonth, but it doesn't work.

sbastien_francal2
Active Participant
0 Kudos

Hello Richard,

Since we upgraded to SP15, we get the same error message when running some of our queries via the web.

Did you find a solution to your problem? If you did, could you please tell us what and how you did?

Thank you in advance,

Former Member
0 Kudos

Hi,

What is the SP level of your EP and BI systems