post stopped due to error ORA-28100 (4220149)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

post stopped due to error ORA-28100
Description

Post stopped due to ORA-28100 policy function schema string is invalid
Cause

Oracle schema is dropped after the policy associated with the function is added to the object. Oracle's reccommendation is to drop the policy and re-create it with a policy function owned by valid user or re-create the user and policy function under the new user
Resolution

Workaround:
Login as SYSDBA and Grant "EXEMPT ACCESS POLICY" to the SharePlex user .

SQL> Grant EXEMPT ACCESS POLICY to <SharePlex Oracle User>;
OR can skip the error.
1. Added 28100 error to the $SP_SYS_VARDIR/data/oramsglist and increment the error count value on first line and saved changes
2. instructed post to continue on error by sp_ctrl> set param SP_OPO_CONT_ON_ERR 1
3. Start post

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title