Error received during Post:
"ORA-04098: trigger 'OWNER.TRIGGER' is invalid and failed "
Invalid trigger on the table on the target database that post is posting to.
A Long term solution is to correct the validity on the trigger.
WORKAROUND:
1) Set param SP_OPO_CONT_ON_ERR 1.
2) Edit $SP_SYS_VARDIR/data/oramsglist and increment the error count.
3) Add a new line in the $SP_SYS_VARDIR/data/oramsglist and add 4098. For example:
Content:
"oramsglist" 20 lines, 90 characters
20 ----- This is the error count that needs to be incremented to 21 if an error gets added
900
902
908
909
910
911
932
960
1026
1426
1455
1458
1459
1462
1479
1483
1487
1704
2266
1430
4098 -----the newly added error add a new line and add the error
4) Save the file and exit.
5) Restart post.
Alternatively, since this is the target and if the trigger is not required, disable the trigger and start post.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center