Bex Query Designer - RS_EXCEPTION 000

[Former Member]

Hello All,

Am getting below errors in Bex Query designer :

"An exception with the type CX_SY_RANGE_OUT_OF_BOUNDS occurred, but was neither handled locally, nor declared in a RAISING" 

  Notification Number RS_EXCEPTION 000 

"Part-field access (offset = 0, length = 1-) to a data object of the size 30 exceeds valid boundaries." 

  Notification Number RS_EXCEPTION 000

"Data provider could not be created in your Web application."

System Response

Cannot start the Web application.

Query is built on Multi provider, it has some customer exit variables. Am using Sap Logon Version 730.

• Checked in RSRT, issue persist.
• I checked the other Queries from same multiprovider, all are throwing same error in Query designer.
• Checked at Multi provider level, am able to view the data.

Kindly let me know what could be the solution for the issue.

Thanks,

Jaya

[former_member182470]

• I checked the other Queries from same multiprovider, all are throwing same error in Query designer.

Have you used same customer exit variables in all other Queries as well which are built on same MP?

For the testing purpose, delete the customer exit variables from one query and run it. If it executes properly, then the issue is with them.

[Former Member]

Hi Suman,

Yes i removed the customer exit variable and checked, still the issue persist.

[former_member182470]

"Part-field access (offset = 0, length = 1-) to a data object of the size 30 exceeds valid boundaries." 

Please check all the variables what you have used in the query with regards to above error.

[Former Member]

Hi,

I have created new query with same variables and it is working fine. it proves that issue is not with variable.

Is there anything else i need to check?

Thanks,

Jaya

[former_member182470]

You could have regenerated those queries in RSRT.

[Former Member]

Generated the query in system

[sapna_jgurudutt]

Hi Jaya,

What is the Release and SP level applied SAP BW ABAP component?

Can you please refer the following SAP Notes and check whether it helps you:

1611831 - Offset Overload In Case Of Text Rendering

1931054 - CX_SY_RANGE_OUT_OF_BOUNDS error during currency conversion

Thanks & Regards,

Sapna

[Former Member]

Hi Suman,

I created new Query on that MP and added same variables. when i apply infoprovider restriction for measure am getting that Error, if i remove it, am not getting that error.

Is there any specific reason for the same.?

Thanks,

Jaya