topic Re: SQL error "-2" occured when executing EXEC SQL in Application Development and Automation Discussions

SQL error "-2" occured when executing EXEC SQL

Former Member — Tue, 29 Aug 2006 12:31:42 GMT

Hi all,

An error occured when executing a shipment transaction.

There is a native SQL code written in a Z function module,where the dump occurs.

Runtime errors:DBIF_DSQL2_SQL_ERROR

Exception:CX_SY_NATIVE_SQL_ERROR.

The error points to a selection from a different database.

Kindly provide ur suggestion regarding this dump.

Regards,

Priya

Re: SQL error "-2" occured when executing EXEC SQL

Former Member — Tue, 29 Aug 2006 12:53:11 GMT

hi priya,

check out this link...

http://searchsap.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid21_gci1115445_tax299330,00.html?bucket=ETA&topic=299330

the note 594508 may be helpful..

reward points if it is helpful...

Re: SQL error "-2" occured when executing EXEC SQL

Former Member — Tue, 29 Aug 2006 12:54:07 GMT

Hi Priya,

there are mostly some clother information the in developer trace (transaction ST11)

- call the program and let it dump

- take a look in the short dump to get the number of the workprocess

- go to the ST11 and double click to the file dev_wxx, where xx is the number from step 2

- go to the end of the list

Good luck,

Stefan

Re: SQL error "-2" occured when executing EXEC SQL

Former Member — Tue, 29 Aug 2006 12:59:09 GMT

Also.. post the native SQL code so we can help!

Re: SQL error "-2" occured when executing EXEC SQL

Former Member — Tue, 29 Aug 2006 13:08:00 GMT

hi,

This is because the maximum number of secondary database connections was exceeded.

Regards,

Sailaja.

Re: SQL error "-2" occured when executing EXEC SQL

Former Member — Tue, 29 Aug 2006 13:46:34 GMT

The native SQL code where it dumped was,

EXEC SQL.

SELECT SHIPMENT_STATUS INTO :SHIP_STATUS

FROM SHIPMENT_DN@PROD_ITP DN, SHIPMENT_ID@PROD_ITP ID

WHERE ID.SHIP_ID_TYPE = 5

AND ID.EXTERNAL_SHIP_ID = :ITSHIPID

AND ID.SHIPMENT_HANDLE = DN.SHIPMENT_HANDLE

ENDEXEC.

Regards,

Priya