Data loading issue from ODS to Cube

[Former Member]

Hi,

We are first loading data into a ODS(ZODSBILL) and from ODS the data is loaded into the Cube(ZCSDBILL) .Now we are facing with the data loading issue from ODS(ZOSDBILL) to Cube (ZCSDBILL).The Data is not getting Loaded into the cube.

__________________________________________________

The status reads as follows:

Short dump in the Warehouse

Diagnosis

The data update was not completed. A short dump has probably been logged in BW providing information about the error.

System response

"Caller 70" is missing.

____________________________________________________

The short dump text is as follows:

Runtime Error DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

ShrtText

An SQL error occurred when accessing a table.

How to correct the error

Database error text........: "SQL system error. MSGID= Job=811817/D6464/WP00"

Internal call code.........: "[RSQL/OPEN//BIC/DZCSDBILLB ]"

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

___________________________________________________________

The SM21 log is as follows:

Database error -901 at SEL access to table /BIC/DZCSD

___________________________________________________________

Thnxs in advance

[dorothea_stein]

Hi Sachin,

On DB4, SQL -901 usually points to a database internal error. Make sure you have the latest "SAP Info APAR" applied. If the problem persists, you should open a PMR at IBM.

BTW: If you look at the job jog of the work process that took the error, you'll find the root cause for the SQL -901 in the message right before the SQL0901. That will help IBM. With that symptom you can also search for PTFs yourself at http://www-912.ibm.com/a_dir/as4ptf.nsf/$$search?openform

Best regards,

Dorothea

[former_member204746]

ORA-00901: invalid CREATE command

Cause: The CREATE command was not followed by a valid CREATE option.

Action: Correct the syntax.

so, open a case with SAP.