DBIF_DSQL2_SQL_ERROR CX_SY_NATIVE_SQL_ERROR geting this dump how can i resolve

[Former Member]

What can you do?

    Note down which actions and inputs caused the error.

    To process the problem further, contact you SAP system

    administrator.

    Using Transaction ST22 for ABAP Dump Analysis, you can look

    at and manage termination messages, and you can also

    keep them for a long time.

How to correct the error

    Database error text........: "ORA-00911: invalid character"

    Database error code........: 911

    Triggering SQL statement...: "MERGE INTO MIS_MATERIALS@GETZDB A USING ( select

     mara~matnr makt~maktx t006a~mseht AS mseht from MARA INNER JOIN makt ON

     makt~matnr = mara~matnr INNER JOIN t006a AS t006a ON t006a~msehi = mara~meins

     where MANDT = '100' and mtart = 'FERT' and ZZDEST_COUNTR"

    Internal call code.........: "[DBDS/NEW DSQL]"

    Please check the entries in the system log (Transaction SM21).

    If the error occures in a non-modified SAP program, you may be able to

    find an interim solution in an SAP Note.

  If you have access to SAP Notes, carry out a search with the following

  keywords:

  "DBIF_DSQL2_SQL_ERROR" "CX_SY_NATIVE_SQL_ERROR"

  "SAPLZ_TZ_FGROUP" or "LZ_TZ_FGROUPU39"

  "ZTEST_FM"

  If you cannot solve the problem yourself and want to send an error

  notification to SAP, include the following information:

  1. The description of the current problem (short dump)

     To save the description, choose "System->List->Save->Local File

  (Unconverted)".

  2. Corresponding system log

     Display the system log by calling transaction SM21.

     Restrict the time interval to 10 minutes before and five minutes

  after the short dump. Then choose "System->List->Save->Local File

  (Unconverted)".

  3. If the problem occurs in a problem of your own or a modified SAP

  program: The source code of the program

     In the editor, choose "Utilities->More

  Utilities->Upload/Download->Download".

how can i resolve it

[Former Member]

Hello,

Everytime you have this kind of error, google it, sometimes there is a better explaination than ST22:

"ORA-00911: invalid character tips"

It looks like you're trying to save an information in wrong way, something like insert a char in a number field, but in your case, the dump happened in your select, isn't it?

select mara~matnr

          makt~maktx

         t006a~mseht AS mseht

from MARA

INNER JOIN makt ON  makt~matnr = mara~matnr

INNER JOIN t006a AS t006a ON t006a~msehi = mara~meins

  where MANDT = '100'

         and mtart = 'FERT'

         and ZZDEST_COUNTR"  <<<<<<<<<<<<<<------- I guess that's the problem, it's a bit strange

Could you check it?

[Former Member]

By doing what it tells you to do in the dump...

If you don't understand this, please ask one of your colleageus who knows how to resolve short dumps to look at it with you.  It is very hard for people to diagnose short dumps remotely, whereas it is much quicker and easier for the people logged into the system to figure it out and rectify the cause.

Cheers,

G.