Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error during extraction through InfoSource: 0CO_OM_OPA_1

Currently we are extracting the data from SAP R/3 System into BW System through InfoSource 0CO_OM_OPA_1 (Orders: Costs and allocations)which is a part of the process chain. But we are getting the error as follows:

-


Idocs missing: No selection information arrived from the source s

Diagnosis

Background processing has not been completed in the source system. A short dump has most probably been logged in the source system.

System response

No selection information arrived from the source s

Procedure

Look for the short dump belonging to your data request in the short dump overview in the source system. Be sure of the correct date and time in the selection screen.

You can get the short dump list using the Wizard or from the monitor detail screen via the path "Environment -> Short dump -> Source system".

-


We have also checked the short dump in R/3 Production System, we are geeting following error details:

Runtime Error DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

An SQL error occurred when accessing a table.

-


Error analysis

-


An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"REOM_OM_READ_COSP_DATA" "(FUNCTION)"

.

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

-


How to correct the error

-


The exception must either be prevented, caught within the procedure

"REOM_OM_READ_COSP_DATA"

"(FUNCTION)", or declared in the procedure's RAISING clause.

To prevent the exception, note the following:

Database error text........: "ORA-01652: unable to extend temp segment by 2560

in tablespace PSAPTEMP"

Internal call code.........: "[RSQL/FTCH/COSP ]"

Please check the entries in the system log (Transaction SM21).

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

use the following search criteria:

-


"DBIF_RSQL_SQL_ERROR" CX_SY_OPEN_SQL_DBC

"SAPLREOM " or "LREOMU08 "

"REOM_OM_READ_COSP_DATA"

-


After this we have also extend temp segment by 2560

in tablespace PSAPTEMP" and after that we have loaded the data manually but we are getting same eror, how to solve this problem. So, please help us to slove this problem.

RAJESH GIRIBUWA

Former Member
Not what you were looking for? View more on this topic or Ask a question