Skip to Content
avatar image
Former Member

How to troubleshoot SQL error when copying cube

I was successful in creating Info Package and running it to copy data frin cube 1 to cube2. However, I get an error when

Running the package. My source cube has 1.9 million rows. However, Info Package only loaded 30,120 records. Looking in monitor logs, it shows me following error stack:

System error in program SAPLRS_EXECPTION and from RS_EXEPTION_TO_MESSAGE

SQL Error 0

Unknown error in SQL Interface

Errors in source system

When I click on long text button for Unknown error in SQL interface:

The SQL interface of the application server (DBSL) has reported an unknown error. This error can be caused by:

- Overflows when aggregated data is read from the database in ABAP. If this occurs, the definition for the corresponding key figure must be changed.

- Internal errors

It seems to be some kind of Overflow error. Is there any way to get more information on the cause

Of this erroru2026.

THANKS A LOT.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 28, 2009 at 02:11 PM

    Hello,

    please look at the developer trace of the work process which is processing your request.

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi ,

      it's not an intentional behavior of the BI system - you are dealing with an error in the low level API of the BW system

      accessing the Oracle database.

      it seems to me you should check service.sap.com Bug notes regarding the invalid cursor copying cubes / while extracting.

      Or open a support request to SAP.

      bye

      yk