cancel
Showing results for 
Search instead for 
Did you mean: 

Report ME1L dump SAPSQL_PARSE_ERROR

0 Kudos

Hi,

We have problem with running report ME1L. When the user has restrictions on plant (WERKS) the user get a runtime error. The error is:

Category ABAP programming error

Runtime Errors SAPSQL_PARSE_ERROR

Except. CX_SY_DYNAMIC_OSQL_SYNTAX

ABAP Program SAPDBIFM

Error analysis:

An exception has occurred which is explained in more detail below. The exception is assigned to class 'CX_SY_DYNAMIC_OSQL_SYNTAX' and was not caught in procedure "PUT_EINE" "(FORM)", nor was it propagated by a RAISING clause. Since the caller of the procedure could not have anticipated this exception, the current program was terminated. The reason for the exception is: The current ABAP program attempted to execute an Open SQL statement containing a dynamic entry. The parser returned the following error: ""~" is invalid here (due to grammar). contains an invalid character or it is a"

I can see when I debugg that when the authorization is checked an internal table, called LT_WHERE_TAB, is filled with value

Row 1: ( ~WERKS = '' OR ( ( WERKS = 'Z' OR WERKS = '2030' OR WERKS = '2020' )

Row 2: ) )


If the user don't have restrictions on plant, it works.


I suspect that the ~ sign is the trouble. Anyone who knows how to solv the problem.

Best Regards

Annsi

Mohamed_Mukhtar
Active Contributor
0 Kudos

Hi,

Please check the below notes

  • 2397651 - ME2*/ME1*: Incorrect data after EHP7 upgrade / SAPSQL_PARSE_ERROR exception
  • 2447294 - SAPSQL_PARSE_ERROR / CX_SY_DYNAMIC_OSQL_SYNTAX in ME1* / ME2* / ME3* / ME91F / ME9F

Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

diana_dai
Active Participant
0 Kudos

Hello Annsi,

Please implement the following notes and retest.

2348724

2402671

Best regards,

Diana