Account Migration Manager Cannot Migrate Accounts On Oracle 11g R2 (Doc ID 1336230.1)

Last updated on MAY 01, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.
*** Checked for relevance on 05-01-2016 ***

Symptoms

In an Oracle 11g R2 DB setup, although the controller log reports all jobs as completed, the output of  "pin_cmt -r" still reports them as IN_PROGRESS. For example:

pin_amt -r list_jobs
-----------------------------------------------------------------------------------------------------------
Fri Dec 17 page 1
AMT jobs

Total Failed Succ.
Account Account Account Proc. Job creation
Job Name User Name Job ID batches batches batches Job Status time [sec] time
------------ ---------- --------------------- -------- -------- -------- ---------- ----------- --------------
Ack
Accounts event
-------- -----
account_sear pin08 89889 1 0 0 IN_PROGRES 0 Fri, 10 Dec 2010,
ch.cfg S 05:15 PM
1




Controller log:

main - 12/17/10 11:51:34:428 - AMT Controller: Release 1.0
main - 12/17/10 11:51:34:428 - (c) Copyright 2001 Portal Software. All rights reserved.
main - 12/17/10 11:51:34:430 - local port: 18566
main - 12/17/10 11:51:34:838 - connnection = oracle.jdbc.driver.T2CConnection@121ab80
main - 12/17/10 11:51:35:007 - Worker: threadNumber = 1
main - 12/17/10 11:51:35:102 - connnection = oracle.jdbc.driver.T2CConnection@c980c9
main - 12/17/10 11:51:35:104 - setFActive = true
main - 12/17/10 11:51:35:104 - setFExit = false
main - 12/17/10 11:51:35:104 - Worker: threadNumber = 2
main - 12/17/10 11:51:35:196 - connnection = oracle.jdbc.driver.T2CConnection@1d256fa
main - 12/17/10 11:51:35:198 - setFActive = true
main - 12/17/10 11:51:35:198 - setFExit = false
main - 12/17/10 11:51:35:214 - Monitor: threadNumber = 1
main - 12/17/10 11:51:35:312 - connnection = oracle.jdbc.driver.T2CConnection@19360e2
main - 12/17/10 11:51:35:312 - mUserName = pin08p mUserPassword = pin08p mConnectionUrl = null
main - 12/17/10 11:51:35:313 - setFActive = true
main - 12/17/10 11:51:35:313 - setFExit = false
1 - 12/17/10 11:51:35:314 - INFO :: Monitor :: run() : AMT monitor is running ...
1 - 12/17/10 11:51:35:314 - INFO :: Monitor :: run() : Checking for any common accounts with Rerate jobs...
1 - 12/17/10 11:51:35:335 - DEBUG :: Monitor :: run() : Fetching IN_PROGRESS job , job_id = 89889
1 - 12/17/10 11:51:35:336 - DEBUG :: Monitor :: run() : All groups in job(89889) is FINISHED.
0 - 12/17/10 11:51:39:273 - connection accepted: Socket[addr=/126.177.77.233,port=56403,localport=18566]
0 - 12/17/10 11:51:39:275 - received cmd = status
1 - 12/17/10 11:53:15:358 - INFO :: Monitor :: run() : Checking for any common accounts with Rerate jobs...
1 - 12/17/10 11:53:15:360 - DEBUG :: Monitor :: run() : Fetching IN_PROGRESS job , job_id = 89889
1 - 12/17/10 11:53:15:361 - DEBUG :: Monitor :: run() : All groups in job(89889) is FINISHED.
1 - 12/17/10 11:54:55:379 - INFO :: Monitor :: run() : Checking for any common accounts with Rerate jobs...
1 - 12/17/10 11:54:55:382 - DEBUG :: Monitor :: run() : Fetching IN_PROGRESS job , job_id = 89889
1 - 12/17/10 11:54:55:383 - DEBUG :: Monitor :: run() : All groups in job(89889) is FINISHED.
1 - 12/17/10 11:56:35:401 - INFO :: Monitor :: run() : Checking for any common accounts with Rerate jobs...
1 - 12/17/10 11:56:35:404 - DEBUG :: Monitor :: run() : Fetching IN_PROGRESS job , job_id = 89889
1 - 12/17/10 11:56:35:408 - DEBUG :: Monitor :: run() : All groups in job(89889) is FINISHED.

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