on 07-02-2014 7:23 PM
Hi All,
My customer recently upgraded to EHP 7.0.
I have one query like below :
select * from (ls_table_list-tabname) into
table <table>
where (condition).
where ls_table-tabname is the table name, <table> is with the structure of same table and condition is very simple where condition. (id = 'XXXXX').
We are getting dump with "CX_SY_DYNAMIC_OSQL_SYNTAX" and the dump message is "
When parsing a dynamic statement, an error occurred.
Before upgrade same statements were working fine.
Please send us the response asap. Its urgent.
Thanks in advance,
Sreedhar
I have had a very similar Issue. Identical select works OK in our NOT upgraded system (D04) but NO Longer in our upgraded system (P03):
Some code extract:
CREATE DATA <sel_crit>-ref_t_annn
TYPE STANDARD TABLE OF (<sel_by_table>-tabname).
ASSIGN <sel_crit>-ref_t_annn->* TO <t_annn>.
SELECT *
FROM (<sel_by_table>-tabname)
INTO TABLE <t_annn>
WHERE (l_sel_cond).
Some Data:
<SEL_BY_TABLE>-TABNAME = A902
<T_ANNN> Standard table of struct A902
L_SEL_COND = KAPPL = <sel_crit>-konh_vakey-kappl AND KSCHL = <sel_crit>-konh_vakey-kschl AND VKORG = <VKORG> AND VTWEG = <VTWEG> AND KUNNR = <KUNNR> AND MATNR = <MATNR> AND KFRST = <KFRST> AND KNUMH = <sel_crit>-knumh. <= Point @ End to be removed
L_SEL_COND = | P03 | D04 | ||
KAPPL = <sel_crit>-konh_vakey-kappl AND | V | V | ||
KSCHL = <sel_crit>-konh_vakey-kschl AND | PR00 | PR00 | ||
VKORG = <VKORG> AND | S010 | S010 | ||
VTWEG = <VTWEG> AND | 20 | 20 | ||
KUNNR = <KUNNR> AND | 0000012453 | 0000012453 | ||
MATNR = <MATNR> AND | 000000000000043501 | 000000000000043501 | ||
KFRST = <KFRST> AND | ||||
KNUMH = <sel_crit>-knumh. | 0000655662 | 0000655662 |
I remarked that in the exception class CX_SY_DYNAMIC_OSQL_SYNTAX a new Text was introduced 'SQL_PARSER_ERROR' but can't really find any explanation.
So I'm still no longer searching for help.
Dirk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sreedhar, how did you corrected this error. same error i got after EHP upgrade.
thanks, Rajagopal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Maybe SAP-Note 1810104 describes the error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi sreedhar,
Can you send me the dump ?
Regards,
Divyanshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Divyanshu,
Following is the text of Short dump :
Category ABAP Programming Error
Runtime error SAPSQL_PARSE_ERROR
Exception CX_SY_DYNAMIC_OSQL_SYNTAX
ABAP program / GETPF / SAPLTABLE_CONTENT_CHECK
Application component not assigned
Date and Time 07.02.2014 14:57:48
Short text
When parsing a dynamic statement, an error occurred.
What happened?
Error in ABAP application program.
The current ABAP program "/ GETPF / SAPLTABLE_CONTENT_CHECK" had to be canceled
be as it appears on
an instruction is encountered, which unfortunately can not be executed.
Error Analysis
There is an exception has occurred, which is discussed further below.
The exception, which is assigned to the class 'CX_SY_DYNAMIC_OSQL_SYNTAX'
was in the procedure "/ GETPF / TABLE_CONTENT_CHECK" "(FUNCTION)" neither
intercepted,
still propagated by a RAISING clause.
Since the caller of the procedure is not with the occurrence of the exception
could be expected, the running program was terminated.
Error was at below statement :
SELECT * FROM (ls_table_list-tabname) INTO |
TABLE <table> |
WHERE (condition). |
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.