AMM Hangs With Status POST_MIGRATION_WAITING
(Doc ID 1545573.1)
Last updated on MAY 20, 2022
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]Information in this document applies to any platform.
Symptoms
AMM execution for migrating accounts across schemas works fine till IN_PROGRESS status and hangs at POST_MIGRATION_WAITING. During this time, the Rating functionality is fine and Account Synchronization module doesn’t work after this AMM Status.
During account migration, event, viz. MigrateSource get enqueued into a centralized ACK queue which may reside in a different schema. While trying to enqueue the event, the following error happens.
Excerpts from Pipeline Manager Error Logs:
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31024 - () ERR_ENQUEUE_EVENT | Enqueue event exception ('[SERVERERROR] ORA-25215: user_data type and queue type do not match
ORA-06512: at "SYS.DBMS_AQ", line 169
ORA-06512: at "PIN03.ACCT_SYNC", line 82
ORA-06512: at line 1
').
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31024 - () ERR_ENQUEUE_EVENT | Enqueue event exception ('25215').
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31024 - () ERR_ENQUEUE_EVENT | Enqueue event exception ('').
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31006 - (ifw.DataPool.Listener.Module.Thread_default) ERR_DEQUEUE_EVENT | Dequeue event exception ('[SERVERERROR] ORA-25215: user_data type and queue type do not match
ORA-06512: at "SYS.DBMS_AQ", line 169
ORA-06512: at "PIN03.ACCT_SYNC", line 82
ORA-06512: at line 1
').
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31006 - (ifw.DataPool.Listener.Module.Thread_default) ERR_DEQUEUE_EVENT | Dequeue event exception ('25215').
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31006 - (ifw.DataPool.Listener.Module.Thread_default) ERR_DEQUEUE_EVENT | Dequeue event exception ('rollback transaction').
PIPELINE Router ERROR LOG
26.08.2012 12:01:39 <HOSTNAME> ifw IFW CRITICAL [T:1116875072] 31025 - (ifw.DataPool.Listener.Module) ERR_RECEIVE_EVENT | Delivery of bus. event to DAT plugin failed (receiveEvent()).
ORA-06512: at "SYS.DBMS_AQ", line 169
ORA-06512: at "PIN03.ACCT_SYNC", line 82
ORA-06512: at line 1
').
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31024 - () ERR_ENQUEUE_EVENT | Enqueue event exception ('25215').
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31024 - () ERR_ENQUEUE_EVENT | Enqueue event exception ('').
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31006 - (ifw.DataPool.Listener.Module.Thread_default) ERR_DEQUEUE_EVENT | Dequeue event exception ('[SERVERERROR] ORA-25215: user_data type and queue type do not match
ORA-06512: at "SYS.DBMS_AQ", line 169
ORA-06512: at "PIN03.ACCT_SYNC", line 82
ORA-06512: at line 1
').
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31006 - (ifw.DataPool.Listener.Module.Thread_default) ERR_DEQUEUE_EVENT | Dequeue event exception ('25215').
26.08.2012 14:14:52 ifw IFW MAJOR [T:1143880000] 31006 - (ifw.DataPool.Listener.Module.Thread_default) ERR_DEQUEUE_EVENT | Dequeue event exception ('rollback transaction').
PIPELINE Router ERROR LOG
26.08.2012 12:01:39 <HOSTNAME> ifw IFW CRITICAL [T:1116875072] 31025 - (ifw.DataPool.Listener.Module) ERR_RECEIVE_EVENT | Delivery of bus. event to DAT plugin failed (receiveEvent()).
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |