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

Former Member — Thu, 14 May 2009 20:28:50 GMT

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

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

Former Member — Fri, 15 May 2009 13:18:10 GMT

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

topic sql error in the database when accessing a table in BW Extracts in Application Development and Automation Discussions

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

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