Skip to Content

ORA-04098: trigger 'SAPBWP./BI0/0500000005#$' is invalid and failed re-validation

Hi All,

We are getting error while performing Oracle DB reorg as below,

_______________________________________________________________

BR0301E SQL error -42012 in thread 5 at location tab_onl_reorg-63, SQL statement:

'BEGIN DBMS_REDEFINITION.FINISH_REDEF_TABLE (UNAME => '"SAPBWP"', ORIG_TABLE => '"/BI0/E0IC_C03"', INT_TABLE => '"/BI0/E0IC_C03#$"'); END;'

ORA-42012: error occurred while completing the redefinition

ORA-12008: error in materialized view refresh path

ORA-04098: trigger 'SAPBWP./BI0/0500000005#$' is invalid and failed re-validation

ORA-06512: at "SYS.DBMS_REDEFINITION", line 82

ORA-06512: at "SYS.DBMS_REDEFINITION", line 1522

ORA-06512: at line 1

___________________________________________________________________________

I have check sap note 982120 but there is not report SAP_DROP_OLD_DBTRIGGER_ORA available on our BW system. Our BW is 7.31  SP 15.


Please suggest how to resolve this, if any one face such issue.

Regards,

Jithin M

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 13, 2016 at 10:52 AM

    Hi Jithin,

    Refer SAP note 1831679 - Problems when doing online reorg of PCL2 table

    Hope this helps.

    Regards

    Sandeep

    Add comment
    10|10000 characters needed characters exceeded

    • hi Jithin,

      Please check SAP note 541538 , which saying:


      • ORA-04098: trigger '<user>./BI0/05000...#$' is invalid and failed
                   re-validation

                 Triggers that follow the naming convention /BI0/05 are left over from BW compressions. Delete these triggers at Oracle level or on the basis of Notes 982120 (BW 7.00) and 1061807 (BW 3.x) and repeat the reorganization process.

      You can delete the trigger manually.


      Best regards,
      James