sql error in the database when accessing a table in BW Extracts

[Former Member]

I got the below error.

There are IDocs in the source system ALE outbox that did not arrive the ALE inbox of BI.

Upon checking the TRFC, i saw more detail error as "sql error in the database when accessing a table"

Here is the code from the Function module "IDOCS_OUTPUT_TO_R3".

Please note that this error occurs only once every day out of 3 extractions from ECC to BW.

Can somebody suggest what 's wrong?

Please note that i'm not a BW guy, but had to support the Prod. BW env.

Thanks in Advance,

-

---

PORTION OF CODE GOES HERE----

---

SELECT SINGLE * FROM EDIPOA WHERE PORT EQ EDIPOA-PORT.

IF SY-SUBRC NE 0.

SAVE_MSGID = 'E0'.

SAVE_MSGNO = '032'.

SAVE_MSGV1 = EDIPOA-PORT.

SAVE_MSGV2 = TEXT-028.

PERFORM ERROR_HANDLING TABLES I_EDIDC

USING TEXT-019

PORT_ERROR.

THis is the only SQL i see in the code. anything wrong with this? Thanks

Edited by: Dhimbak on May 14, 2009 10:43 PM

[Former Member]

Hi All,

Just in case someone gets a similar error, it was due to the database extents reached the max. allotted size, and were unable to extend any further. once the space for the extents allocated, everything was ok. thanks