cancel
Showing results for 
Search instead for 
Did you mean: 

Few Error log and run time error found in BI Prod system

Former Member
0 Kudos

Dear all,

we are facing few runtime errors , system logs and few cancelled jobs found .

Please check the below logs :

SM21 log :

SAP*                          BY  2 Database error 604 at EXE

SAP*                          BY  0 > ORA-00604: error occurred at recursive SQL level 2#ORA-04031

SAP*                          BY  0 > unable to allocate 4120 bytes of shared memory ("shared

SAP*                          BY  0 > pool","select

SAP*                          BY  0 > type#,blocks,extents,...","Typecheck","kgghteInit")

SAP*                          BY  1 Database error 604

SAP*                          BY  2 Database error 4031 at EXE

SAP*                          BY  0 > ORA-04031: unable to allocate 4064 bytes of shared memory

SAP*                          BY  0 > ("shared pool","unknown object","pacdHds_kkpaco","stP_kkpacd

SAP*                          BY  0 > kkpodPacdInit")

SAP*                          BY  1 Database error 4031

SAP*                          BY  2 Database error 4031 at EXE

SAP*                          BY  0 > ORA-04031: unable to allocate 4064 bytes of shared memory

SAP*                          BY  0 > ("shared pool","unknown object","pacdHds_kkpaco","stP_kkpacd

SAP*                          BY  0 > kkpodPacdInit")

SAP*                          BY  1 Database error 4031

ALEREMOTE                     BY  4 Database error 604 at SEL access to table RSREQDONE

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  4 Database error 604 at SEL access to table REPOLOAD

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  4 Database error 4031 at SEL access to table REPOSRC

ALEREMOTE                     BY  0 > ORA-04031: unable to allocate 4120 bytes of shared memory

ALEREMOTE                     BY  0 > ("shared pool","select intcol#, toid,

ALEREMOTE                     BY  0 > versio...","Typecheck","kgghteInit")

ALEREMOTE                     AB  0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

ALEREMOTE                     BY  4 Database error 604 at FET access to table /BI0/PMAT_

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  2 Database error 604 at EXE

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select

ALEREMOTE                     BY  0 > name,intcol#,segcol#,...","Typecheck","kgghteInit")

ALEREMOTE                     AB  2 > Include GP3XNW4OFH4CHNR3S7AO9VLNADE line 3150.

ALEREMOTE                     AB  0 Run-time error "DBIF_DSQL2_SQL_ERROR" occurred

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     AB  1 > Short dump "120826 022029 pssapbw1 _BP3_00 " generated

ALEREMOTE                     BY  4 Database error 604 at SEL access to table T100

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  4 Database error 604 at SEL access to table T100

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  4 Database error 604 at SEL access to table RSREQDONE

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  4 Database error 604 at SEL access to table REPOLOAD

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 2#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select

ALEREMOTE                     BY  0 > o.owner#,o.name,o.nam...","Typecheck","kgghteInit")

ALEREMOTE                     AB  2 > Include ??? line 0000.

ALEREMOTE                     AB  0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

ALEREMOTE                     AB  0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

ALEREMOTE                     BY  4 Database error 604 at SEL access to table REPOLOAD

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 2#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select

ALEREMOTE                     BY  0 > o.owner#,o.name,o.nam...","Typecheck","kgghteInit")

ALEREMOTE                     BY  4 Database error 604 at SEL access to table REPOLOAD

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  2 Database error 604 at EXE

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     AB  2 > Include ??? line 0000.

ALEREMOTE                     AB  0 Run-time error "DBIF_DSQL2_SQL_ERROR" occurred

ALEREMOTE                     BY  4 Database error 604 at SEL access to table REPOLOAD

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     AB  2 > Include ??? line 0000.

ALEREMOTE                     AB  0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

ALEREMOTE                     AB  0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  2 Database error 604 at EXE

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     AB  2 > Include ??? line 0000.

ALEREMOTE                     AB  0 Run-time error "DBIF_DSQL2_SQL_ERROR" occurred

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     AB  1 > Short dump "120826 022030 pssapbw1 _BP3_00 " generated

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     AB  1 > Short dump "120826 022031 pssapbw1 _BP3_00 " generated

ALEREMOTE                     BY  4 Database error 604 at SEL access to table USR02

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     D0  1 Transaction Canceled 00 162 ( DB-Error - 604 )

ALEREMOTE                     BY  4 Database error 604 at SEL access to table USR02

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select col#, grantee#,

ALEREMOTE                     BY  0 > privi...","Typecheck","kgghteInit")

ALEREMOTE                     D0  1 Transaction Canceled 00 162 ( DB-Error - 604 )

ALEREMOTE                     BY  4 Database error 604 at SEL access to table REPOLOAD

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     AB  2 > Include GP3XNW4OFH4CHNR3S7AO9VLNADE line 3150.

ALEREMOTE                     AB  0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

ALEREMOTE                     AB  0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

ALEREMOTE                     BY  2 Database error 604 at EXE

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     AB  2 > Include GP3XNW4OFH4CHNR3S7AO9VLNADE line 3150.

ALEREMOTE                     AB  0 Run-time error "DBIF_DSQL2_SQL_ERROR" occurred

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     BY  2 Database error 604 at FET

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     AB  1 > Short dump "120826 022032 pssapbw1 _BP3_00 " generated

ALEREMOTE                     BY  4 Database error 604 at SEL access to table USR02

ALEREMOTE                     BY  0 > ORA-00604: error occurred at recursive SQL level 1#ORA-04031

ALEREMOTE                     BY  0 > unable to allocate 4120 bytes of shared memory ("shared

ALEREMOTE                     BY  0 > pool","select user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")

ALEREMOTE                     D0  1 Transaction Canceled 00 162 ( DB-Error - 604 )

ALEREMOTE                     BY  2 Database error 603 at EXE

ALEREMOTE                     BY  0 > ORA-00603: ORACLE server session terminated by fatal error

ALEREMOTE                     BY  1 Database error 603

ALEREMOTE                     BY  M SQL error 3114 occurred; work process in reconnect status

ALEREMOTE                     BY  Y Work process has left reconnect status

ALEREMOTE                     AB  0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

ALEREMOTE                     AB  1 > Short dump "120826 022038 pssapbw1 _BP3_00 " generated

ALEREMOTE                     D0  1 Transaction Canceled 00 671 ( DBIF_REPO_SQL_ERROR 20120826022038pssapbw1_BP3_00 ALEREMOTE 590 )

ALEREMOTE                     BY  2 Database error 4031 at EXE

ALEREMOTE                     BY  0 > ORA-04031: unable to allocate 4128 bytes of shared memory

ALEREMOTE                     BY  0 > ("shared pool","DBMS_STATS","PL/SQL MPCODE","BAMIMA: Bam

ALEREMOTE                     BY  0 > Buffer")#ORA-06508: PL/SQL: could not find program unit bein

ALEREMOTE                     BY  0 > called: "SYS.DBMS_STATS"#ORA-06512: at line 1

ALEREMOTE                     BY  1 Database error 4031

ALEREMOTE                     AB  0 Run-time error "UNCAUGHT_EXCEPTION" occurred

ALEREMOTE                     AB  1 > Short dump "120826 022538 pssapbw1 _BP3_00 " generated

ALEREMOTE                     D0  1 Transaction Canceled 00 671 ( UNCAUGHT_EXCEPTION 20120826022538pssapbw1_BP3_00 ALEREMOTE 590 )

ALEREMOTE                     BY  2 Database error 4031 at EXE

ALEREMOTE                     BY  0 > ORA-04031: unable to allocate 4128 bytes of shared memory

ALEREMOTE                     BY  0 > ("shared pool","DBMS_STATS","PL/SQL MPCODE","BAMIMA: Bam

ALEREMOTE                     BY  0 > Buffer")#ORA-06508: PL/SQL: could not find program unit bein

ALEREMOTE                     BY  0 > called: "SYS.DBMS_STATS"#ORA-06512: at line 1

ALEREMOTE                     BY  1 Database error 4031

ALEREMOTE                     AB  0 Run-time error "UNCAUGHT_EXCEPTION" occurred

ALEREMOTE                     AB  1 > Short dump "120826 023856 pssapbw1 _BP3_00 " generated

ALEREMOTE                     D0  1 Transaction Canceled 00 671 ( UNCAUGHT_EXCEPTION 20120826023856pssapbw1_BP3_00 ALEREMOTE 590 )

SAPSYS                        PM  2 Certificate with PSE type >System PSE< has been invalid for 1336 days

ALEREMOTE                     BY  2 Database error 4031 at EXE

ALEREMOTE                     BY  0 > ORA-04031: unable to allocate 4128 bytes of shared memory

ALEREMOTE                     BY  0 > ("shared pool","DBMS_STATS_INTERNAL","PL/SQL MPCODE","BAMIMA

ALEREMOTE                     BY  0 > Bam Buffer")#ORA-06508: PL/SQL: could not find program unit

ALEREMOTE                     BY  0 > being called: "SYS.DBMS_STATS_INTERNAL"#ORA-06512: at

ALEREMOTE                     BY  0 > "SYS.DBMS_STATS", line 21623#ORA-06512: at line 1

ALEREMOTE                     BY  1 Database error 4031

ALEREMOTE                     AB  0 Run-time error "UNCAUGHT_EXCEPTION" occurred

ALEREMOTE                     AB  1 > Short dump "120826 052143 pssapbw1 _BP3_00 " generated

ALEREMOTE                     D0  1 Transaction Canceled 00 671 ( UNCAUGHT_EXCEPTION 20120826052143pssapbw1_BP3_00 ALEREMOTE 590 )

                              Q0  4 Connection to user 8246 (LOGICA_BASIS), terminal 135 (inp-karodeg ) lost

ALEREMOTE                     BY  2 Database error 4031 at EXE

ALEREMOTE                     BY  0 > ORA-04031: unable to allocate 4128 bytes of shared memory

ALEREMOTE                     BY  0 > ("shared pool","DBMS_STATS_INTERNAL","PL/SQL MPCODE","BAMIMA

ALEREMOTE                     BY  0 > Bam Buffer")#ORA-06508: PL/SQL: could not find program unit

ALEREMOTE                     BY  0 > being called: "SYS.DBMS_STATS_INTERNAL"#ORA-06512: at

ALEREMOTE                     BY  0 > "SYS.DBMS_STATS", line 21623#ORA-06512: at line 1

ALEREMOTE                     BY  1 Database error 4031

ALEREMOTE                     AB  0 Run-time error "UNCAUGHT_EXCEPTION" occurred

ALEREMOTE                     AB  1 > Short dump "120826 123326 pssapbw1 _BP3_00 " generated

ALEREMOTE                     D0  1 Transaction Canceled 00 671 ( UNCAUGHT_EXCEPTION 20120826123326pssapbw1_BP3_00 ALEREMOTE 590 )

ALEREMOTE                     BY  2 Database error 22303 at EXE

ALEREMOTE                     BY  0 > ORA-22303: type "SYS"."ODCIOBJECTLIST" not found#ORA-00604:

ALEREMOTE                     BY  0 > error occurred at recursive SQL level 1#ORA-04031: unable to

ALEREMOTE                     BY  0 > allocate 4120 bytes of shared memory ("shared pool","select

ALEREMOTE                     BY  0 > user#,type# from

ALEREMOTE                     BY  0 > user...","Typecheck","kgghteInit")#ORA-06508: PL/SQL: could

ALEREMOTE                     BY  0 > not find program unit being called:

ALEREMOTE                     BY  0 > "SYS.DBMS_STATS"#ORA-06512: at line 1

ALEREMOTE                     BY  1 Database error 22303

ALEREMOTE                     AB  0 Run-time error "UNCAUGHT_EXCEPTION" occurred

ALEREMOTE                     AB  1 > Short dump "120826 162938 pssapbw1 _BP3_00 " generated

LOGICA_APPS                   AB  0 Run-time error "TIME_OUT" occurred

LOGICA_APPS                   AB  1 > Short dump "120826 170618 pssapbw1 _BP3_00 " generated

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  0 > ORA-00054: resource busy and acquire with NOWAIT specified

ALEREMOTE                     BY  2 Database error 54 at EXE

ALEREMOTE                     BY  2 Database error 4031 at EXE

ALEREMOTE                     BY  0 > ORA-04031: unable to allocate 4128 bytes of shared memory

ALEREMOTE                     BY  0 > ("shared pool","DBMS_STATS_INTERNAL","PL/SQL MPCODE","BAMIMA

ALEREMOTE                     BY  0 > Bam Buffer")#ORA-06508: PL/SQL: could not find program unit

ALEREMOTE                     BY  0 > being called: "SYS.DBMS_STATS_INTERNAL"#ORA-06512: at

ALEREMOTE                     BY  0 > "SYS.DBMS_STATS", line 21623#ORA-06512: at line 1

ALEREMOTE                     BY  1 Database error 4031

ALEREMOTE                     AB  0 Run-time error "UNCAUGHT_EXCEPTION" occurred

ALEREMOTE                     AB  1 > Short dump "120826 192240 pssapbw1 _BP3_00 " generated

LOGICA_BASIS DB02OLD          R4  7 Delete session 001 after error 061

St22 error log :

ALEREMOTE590CUNCAUGHT_EXCEPTION
ALEREMOTE590CUNCAUGHT_EXCEPTION
ALEREMOTE590CUNCAUGHT_EXCEPTION
ALEREMOTE590CUNCAUGHT_EXCEPTION
ALEREMOTE590CUNCAUGHT_EXCEPTION
ALEREMOTE590CDBIF_REPO_SQL_ERROR

Runtime Errors         UNCAUGHT_EXCEPTION

Exception              CX_SDB_ORA_PROGRAM_ERROR

Date and Time          26.08.2012 16:29:38

Short text

     An exception occurred that was not caught.

What happened?

     The exception 'CX_SDB_ORA_PROGRAM_ERROR' was raised, but it was not caught

      anywhere along

     the call hierarchy.

     Since exceptions represent error situations and this error was not

     adequately responded to, the running ABAP program

      'CL_SDB_ORA_UPDATE_STATS=======CP' has to be

     terminated.

What can you do?

     Note down which actions and inputs caused the error.

     To process the problem further, contact you SAP system

     administrator.

     Using Transaction ST22 for ABAP Dump Analysis, you can look

     at and manage termination messages, and you can also

     keep them for a long time.

SM37 :

BI_PROCESS_INDEX                               ALEREMOTE

BI_PROCESS_ODSACTIVAT                          ALEREMOTE

BI_PROCESS_ODSACTIVAT                          ALEREMOTEBI_PROCESS_PSAPROCESS                          ALEREMOTE

Kindly advise .

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi John,

Check

Note 1472386 - ORA-04031 out of memory error in BW systems

Note 1635622 - ORA-04031 despite sufficiently sized shared pool

Thanks,

Ravi