Error editing or creating BEX VARIABLES

[Former Member]

Hi, anyone know how to fix this bug??

when i tried to edit or add a variable on a new query in Query designer an exception occur and the follow error appears "UNCAUGHT_EXCEPTION"

Error analysis |

An exception occurred which is explained in detail below.

The exception, which is assigned to class 'CX_RSR_PROPAGATE_X', was not caught

and

therefore caused a runtime error.

The reason for the exception is:

An error occurred when getting data from the processor.

The occurrence of the exception is closely related to the occurrence of

a previous exception "CX_SY_NO_HANDLER", which was raised in the program

"CL_RSMD_RS_BUILD_QUERY========CP",

specifically in line 1 of the (include) program

"CL_RSMD_RS_BUILD_QUERY========CM00Y".

The cause of the exception was:

An exception with the type CX_RS_SQL_ERROR_SILENT occurred, but was neither

handled locally, nor declared in a RAISING clause

The occurrence of the exception is closely related to the occurrence of

a previous exception "CX_RS_SQL_ERROR_SILENT", which was raised in the program

"CL_RSDRS_SQL_QUERY============CP",

specifically in line 291 of the (include) program

"CL_RSDRS_SQL_QUERY============CM00J".

The cause of the exception was:

No text available for this exception

The occurrence of the exception is closely related to the occurrence of

a previous exception "CX_SQL_EXCEPTION", which was raised in the program

"CL_SQL_RESULT_SET=============CP",

specifically in line 71 of the (include) program

"CL_SQL_RESULT_SET=============CM006".

The cause of the exception was:

| ORA-00904: "T0000"."LANGU": invalid identifier

could anyone help me to solve this problem?

Thx

[Former Member · Accepted solution]

Ok do this

If you Drag an InfoObject into Colums or Rows first Click on save (Query). Then Drag restrct based on Variable. Then Click on Save. This should be fine. Then change the Variable. If this does not work check whether that variable is available in the table "RSZGLOBV".

[Former Member · Accepted solution]

Thanks but the problem still there, the main problem is when i select any variable of any infoProvider, because when i dragged the restriction variable, the dump error appears and the query designer freezes without the chance of saving or doing anything else.

The same problem appears creating a new variable..

although on the table RSZGLOBV all the variables created are there.. any suggestion?

[former_member188325 · Accepted solution]

i had different problem after creataing variables in RSZGLOBV table. i was not able to create new variable from Query designer or open existing variable after creating a variable on one char in RSZGLOBV table. Everything worked fine after deleting that variable from RSZGLOBV table.(setting all values to 0).Try it out if possible.

[Former Member · Accepted solution]

guys i debugged the Query to reach the error and finally i've got this query

SELECT "0000000032" , "0000000032_TXTSH" , "0000000032_TXTMD"

FROM (

SELECT "S0000"."CURRENCY" AS "0000000032" ,"T0000"."TXTSH" AS "0000000032_TXTSH" ,"T0000"."TXTMD" AS "0000000032_TXTMD"

FROM ( "/BI0/SCURRENCY" "S0000" ) LEFT OUTER JOIN "TCURT" "T0000

"TCURT" "T0000" ON "S0000"."CURRENCY" ="T0000"."CURRENCY" AND ("T0000"."LANGU"= 'S')

ORDER BY "0000000032" ASC

On the table TCURT doesn't exist the field langu but i don't know why on any query is calling it

please help

[Former Member]

Let us know SP level.

How are you trying to add or edit it? Where did you debugg it?

Nagesh Ganisetti.

[Former Member]

My SP level is 14

To add or edit variables i used Query designer (BEX 7.0) and to debbug the error i used the transacction SE38 adding a breakpoint into the program "CL_RSDRS_SQL_QUERY============CM00J" that's where i found the Query.

[Former Member]

thanks problem solved taking 0UNIT infoobject from BC

.

Recomendation: when you are migrating from 3.5 to 7.0 reactivate all the business content objects.

Regards