topic DBIF_DSQL2_SQL_ERROR CX_SY_NATIVE_SQL_ERROR geting this dump how can i resolve in Application Development and Automation Discussions

DBIF_DSQL2_SQL_ERROR CX_SY_NATIVE_SQL_ERROR geting this dump how can i resolve

Former Member — Thu, 20 Aug 2015 06:44:27 GMT

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

Re: DBIF_DSQL2_SQL_ERROR CX_SY_NATIVE_SQL_ERROR geting this dump how can i resolve

Former Member — Thu, 20 Aug 2015 09:41:34 GMT

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?

Re: DBIF_DSQL2_SQL_ERROR CX_SY_NATIVE_SQL_ERROR geting this dump how can i resolve

Former Member — Thu, 20 Aug 2015 10:40:22 GMT

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,