Skip to Content
avatar image
Former Member

Dynamic sql is throwing dump after upgrade to EHP 7.0

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 29, 2015 at 04:31 PM

    Hello Sreedhar, how did you corrected this error. same error i got after EHP upgrade.

    thanks, Rajagopal.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 02, 2014 at 07:01 PM

    Hi sreedhar,

    Can you send me the dump ?

    Regards,

    Divyanshu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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).

  • Nov 19, 2014 at 12:11 PM

    Maybe SAP-Note 1810104 describes the error.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 14, 2015 at 12:29 PM

    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):

    • Solution: the L_SEL_COND string can no longer have an '.' at end of the string
    • See also Note 1810104 Release change from 7.0, EhP3 or from 7.3, EhP1 to 7.40 => Open SQL

    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

    Add comment
    10|10000 characters needed characters exceeded