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

[former_member186228]

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

[Former Member]

Hi Jithin,

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

Hope this helps.

Regards

Sandeep

[former_member186228]

Hi sandeep,

This Note is or long2blob convertion. I am getting error while doing reorg of /BI0/E0IC_C03. Which is not having any long field entry.

In the error it is indicating ORA-04098: trigger 'SAPBWP./BI0/0500000005#$' is invalid and failed re-validation.  which is BW temporary object (triger) which is not remove from database after compression.

Regards,

Jithin

[JamesZ]

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