We are uploading data from 0CO_OM_CCA_9 from R/3 to ODS & subsequently to cube. Upload till ODS is fine but when we are trying to push the data from ODS to Cube we are facing an error. We have 20 Million data records. Each data package contains 10000 records, so there are 200+ packages. Now while updating to the cube some of the packages are unable to generate update mesages from the cube. so some of the packages are remaining in yellow states whereas the following packages are turning green. And ultimately those packages are throwing a runtime error. When we check the log we found out DBIF_RSQL_SQL_ERROR" with exception CX_SY_OPEN_SQL_DBC.
The log states:
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not ca
procedure "WRITE_ICFACT" "(FORM)", nor was it propagated by a RAISING cla
Since the caller of the procedure could not have anticipated that the
exception would occur, the current program is terminated.
The reason for the exception is:
The database system recognized that your last operation on the database
would have led to a deadlock.
Therefore, your transaction was rolled back.
We tried with reducing the data record per packet size but it didnt help. Would really appreciate any solution.