SQL error "-2" occured when executing EXEC SQL

[Former Member]

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.

[Former Member]

Hi,

check whether entry exist in table DBCOn

for database.

Regards

amole

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi Sailaja,

What would be the solution to this error ?

How can we increase the number of secondary database connections?

Thanks

Vijay

[Former Member]

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

[Former Member]

Klaus,

We are using ORACLE database.

Thanks

Vijay