2017734 - ORA-14646 and ORA-14400 at BW load run

When loading data into BW System, system reports an ORA-14400 and the load run terminates with a short dump

Runtime Errors         DBIF_RSQL_SQL_ERROR                                                         
Except.                     CX_SY_OPEN_SQL_DB
and short text: SQL error 14400 when accessing table

When looking at the corresponding work process trace, one can see a preceding error ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes which is issued when trying to create the new partition for which the insert later fails with ORA-14400.

Example for the work process trace:

C Sun May 11 15:41:37 2014
C     OCIStmtExecute() failed with -1=OCI_ERROR
C     SQL error 14646:
C  *** ERROR => Error 14646 in exec_immediate() from oci_execute_stmt(), orpc=0
 [dbsloci.c    12884]
C  {root-id=0026B973B4801EE2BF8D1BCB4CCE986E}_{conn-id=536BA48BB72C39D6E10000000A802D5E}_1
C  *** ERROR => ORA-14646 occurred at SQL stmt (parse error offset=786432)
 [dbsloci.c    12886]
C  {root-id=0026B973B4801EE2BF8D1BCB4CCE986E}_{conn-id=536BA48BB72C39D6E10000000A802D5E}_1
C  Dump statement cache:
C  sc_p=108995aa8,no=101,idc_p=(nil),con=0,act=0,slen=124,smax=1536,#vars=0,stmt=10ab87ca0,table=
C  ALTER TABLE "/BI0/F0SM_ESRST" ADD PARTITION "/BI0/F0SM_ESRST0000000416" VALUES LESS THAN  (000000041\
C  6 ) TABLESPACE "PSAPSR3";
C  dbsl err=99=DBSL_ERR_DB -> dbds err=1=DS_SQLERR, dbdsoci.c:937
C  *** ERROR => ^^ Ds_exec_imm() -> err=1=DS_SQLERR
 [dbdsoci.c    949]
C  {root-id=0026B973B4801EE2BF8D1BCB4CCE986E}_{conn-id=536BA48BB72C39D6E10000000A802D5E}_1
B  ***LOG BY2=> sql error 14646      performing EXE        [dbds         578]
B  ***LOG BY0=> ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes [dbds         578]
B  ***LOG BY1=> sql error 14646      [dbacds       1512]
C  *** ERROR => Error 14400 in stmt_execute() from oci_execute_stmt(), orpc=0
 [dbsloci.c    17260]
C  {root-id=0026B973B4801EE2BF8D1BCB4CCE986E}_{conn-id=536BA48BB72C39D6E10000000A802D5E}_1
C  *** ERROR => ORA-14400 occurred at SQL stmt (parse error offset=0)
 [dbsloci.c    17262]
C  {root-id=0026B973B4801EE2BF8D1BCB4CCE986E}_{conn-id=536BA48BB72C39D6E10000000A802D5E}_1
C  Dump statement cache:
C  sc_p=108992d88,no=25,idc_p=1089afc68,con=0,act=1,slen=153,smax=1536,#vars=21,stmt=10a1a01d0,table=/BI0/F0SM_ESRST
C  INSERT INTO "/BI0/F0SM_ESRST" VALUES(:A0 ,:A1 ,:A2 ,:A3 ,:A4 ,:A5 ,:A6 ,:A7 ,:A8 ,:A9 ,:A10 ,:A11 ,:\
C  A12 ,:A13 ,:A14 ,:A15 ,:A16 ,:A17 ,:A18 ,:A19 ,:A20 );

• Business Warehouse BW
• Business Intelligence BI

KBA , BW-SYS-DB-ORA , BW ORACLE , BC-DB-ORA , Oracle , Problem