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, 26 Sep 2006 12:05:56 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.

I have given the code below.

EXEC SQL PERFORMING CREATE_MESSAGE_TEXT.

SELECT CARRIER, SUM(FREIGHT_CHARGE) INTO :SCAC, :FREIGHT

FROM SHIPMENT_ID@URP_ITP ID, SHIP_CHARGE_DETL@URP_ITP DETL

WHERE ID.SHIP_ID_TYPE = 5

AND ID.EXTERNAL_SHIP_ID = :ITSHIPID

AND ID.SHIPMENT_HANDLE = DETL.SHIPMENT_HANDLE

GROUP BY CARRIER

ENDEXEC.

Kindly provide ur suggestion regarding this dump.

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

Former Member — Tue, 26 Sep 2006 12:14:04 GMT

Hi,

check whether entry exist in table DBCOn

for database.

Regards

amole

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

Former Member — Tue, 26 Sep 2006 12:15:21 GMT

hi,

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

check if OSS note 323151 helps you.

Regards,

Sailaja.

Message was edited by: Sailaja N.L.

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

Former Member — Tue, 28 Nov 2006 09:01:41 GMT

Hi Could not able to find entries in table DBCON. We are not getting this problem always. But we are getting this problem very often.

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

Former Member — Wed, 12 Oct 2011 04:26:37 GMT

Hi Sailaja,

What would be the solution to this error ?

How can we increase the number of secondary database connections?

Thanks

Vijay

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

Former Member — Wed, 12 Oct 2011 05:45:31 GMT

Hi,

the SQL error may have several reasons. 1st we need to know, which database you are using (e.g. Oracle) to find out the meaning of value "-2".

For MSSQL e.g. i have found a web information, that code 2 means timeout.

Regards,

Klaus

Edited by: Klaus Babl on Oct 12, 2011 7:51 AM

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

Former Member — Wed, 12 Oct 2011 08:05:40 GMT

Klaus,

We are using ORACLE database.

Thanks

Vijay