AMM Hangs With Status POST_MIGRATION_WAITING

(Doc ID 1545573.1)

Last updated on SEPTEMBER 21, 2017

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 xxxx 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 xxxx ifw IFW MAJOR [T:1143880000] 31024 - () ERR_ENQUEUE_EVENT | Enqueue event exception ('25215').
26.08.2012 14:14:52 xxxx ifw IFW MAJOR [T:1143880000] 31024 - () ERR_ENQUEUE_EVENT | Enqueue event exception ('').
26.08.2012 14:14:52 xxxx 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 xxxx 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 xxxx 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 cbpbrmra01 ifw IFW CRITICAL [T:1116875072] 31025 - (ifw.DataPool.Listener.Module) ERR_RECEIVE_EVENT | Delivery of bus. event to DAT plugin failed (receiveEvent()).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms