Device_service_t Is Not Updated Properly For Migrated Data . (Doc ID 1389920.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0 and later   [Release: 7.4.0 and later ]
Information in this document applies to any platform.

Symptoms

When we migrate Accounts from Primary to Secondary and the Devices reside in Primary schema, the /device objects still show the Primary schema references for Account and Service Objects although both have been migrated to the Secondary schema.

Symptoms:
-----------------

nap(20232)> robj - 0.0.0.1 /device 434867
# number of field entries allocated 24, used 23
0 PIN_FLD_POID POID [0] 0.0.0.1 /device/num 434867 15
0 PIN_FLD_CREATED_T TSTAMP [0] (1301048239) Fri Mar 25 21:17:19 2011
0 PIN_FLD_MOD_T TSTAMP [0] (1317967894) Fri Oct 07 17:11:34 2011
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "A"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1 0
0 PIN_FLD_DESCR STR [0] ""
0 PIN_FLD_DEVICE_ID STR [0] "61485206503"
0 PIN_FLD_MANUFACTURER STR [0] ""
0 PIN_FLD_MODEL STR [0] ""
0 PIN_FLD_SOURCE STR [0] "XXXXXXX"
0 PIN_FLD_STATE_ID INT [0] 2
0 PIN_FLD_SERVICES ARRAY [0] allocated 20, used 2
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1020316 0   ***Shows /account residing in Primary Schema even after migration
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/mcommerce 1025956 0
0 PIN_FLD_SERVICES ARRAY [1] allocated 20, used 2
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1020316 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/telephony 1024100 0
0 PIN_FLD_SERVICES ARRAY [2] allocated 20, used 2
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1020316 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/sms 1027172 0
0 PIN_FLD_SERVICES ARRAY [3] allocated 20, used 2
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1020316 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/gprs 1025636 0
0 PIN_FLD_SERVICES ARRAY [4] allocated 20, used 2
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1020316 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/mms 1026404 0
0 PIN_FLD_SERVICES ARRAY [5] allocated 20, used 2
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1020316 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/vlive 1024868 0
0 PIN_FLD_SERVICES ARRAY [6] allocated 20, used 2
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1020316 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/umts/telephony 1027940 0
0 PIN_FLD_SERVICES ARRAY [7] allocated 20, used 2
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1020316 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/data 1025252 0
0 PIN_FLD_SERVICES ARRAY [8] allocated 20, used 2
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1020316 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/fax 1026788 0
0 PIN_FLD_SERVICES ARRAY [9] allocated 20, used 2
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1020316 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/subscription 1027748 0  ***Shows /service residing in Primary Schema even after migration
0 PIN_FLD_DEVICE_NUM SUBSTRUCT [0] allocated 20, used 19
1 PIN_FLD_CATEGORY_ID INT [0] 0
1 PIN_FLD_CATEGORY_VERSION INT [0] 1
1 PIN_FLD_NETWORK_ELEMENT STR [0] ""
1 PIN_FLD_ORIG_NETWORK_ID STR [0] ""
1 PIN_FLD_PERMITTED STR [0] "sales"
1 PIN_FLD_RECENT_NETWORK_ID STR [0] ""
1 PIN_FLD_VANITY ENUM [0] 1
1 VF_FLD_ATTACHED_MVNO STR [0] "XXXXXXX"
1 VF_FLD_EXPIRATION_T TSTAMP [0] (0) <null>
1 VF_FLD_MNP_DATA STR [0] ""
1 VF_FLD_NAME STR [0] ""
1 VF_FLD_NON_PORTABLE INT [0] 0
1 VF_FLD_PAYINDICATOR STR [0] "02"
1 VF_FLD_REASON_CODE STR [0] ""
1 VF_FLD_RELEASED_T TSTAMP [0] (0) <null>
1 VF_FLD_RESERVATION_NO STR [0] ""
1 VF_FLD_TYPE ENUM [0] 0
1 VF_FLD_USERID POID [0] 0.0.0.0 0 0
1 VF_FLD_USER_NAME STR [0] ""


Since the account is migrated its not there in primary schema , as shown below:

nap(20232)> robj - 0.0.0.1 /account 1020316
PCM_OP_READ_OBJ failed: err 3:PIN_ERR_NOT_FOUND, field 0/16:PIN_FLD_POID,
loc 4:PIN_ERRLOC_DM, errclass 4:PIN_ERRCLASS_APPLICATION, rec_id 0, resvd 30001
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 1020316 0
0 PIN_FLD_ERR_BUF ERR [0]
<location=PIN_ERRLOC_DM:4 class=PIN_ERRCLASS_APPLICATION:4 errno=PIN_ERR_NOT_FOUND:3>
<field num=PIN_FLD_POID:7,16 recid=0 reserved=30001 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>


Account and Service objects are migrated to Secondary schema, as shown below:

nap(21268)> robj - 0.0.0.3 /account 1020316   *** Secondary Schema
# number of field entries allocated 44, used 43
0 PIN_FLD_POID POID [0] 0.0.0.3 /account 1020316 43
0 PIN_FLD_CREATED_T TSTAMP [0] (1317967832) Fri Oct 07 17:10:32 2011
0 PIN_FLD_MOD_T TSTAMP [0] (1317967894) Fri Oct 07 17:11:34 2011
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_AAC_ACCESS STR [0] ""
0 PIN_FLD_AAC_PACKAGE STR [0] ""
0 PIN_FLD_AAC_PROMO_CODE STR [0] ""
0 PIN_FLD_AAC_SERIAL_NUM STR [0] ""
0 PIN_FLD_AAC_SOURCE STR [0] ""
0 PIN_FLD_AAC_VENDOR STR [0] ""
0 PIN_FLD_ACCESS_CODE1 STR [0] ""
0 PIN_FLD_ACCESS_CODE2 STR [0] ""
0 PIN_FLD_ACCOUNT_NO STR [0] "910002012"
0 PIN_FLD_ACCOUNT_TAG STR [0] ""
0 PIN_FLD_ACCOUNT_TYPE ENUM [0] 1
0 PIN_FLD_ATTRIBUTE INT [0] 0
0 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.3 /balance_group 1021852 0
0 PIN_FLD_BRAND_OBJ POID [0] 0.0.0.3 /account 1 0
0 PIN_FLD_BUSINESS_TYPE ENUM [0] 0
0 PIN_FLD_CLOSE_WHEN_T TSTAMP [0] (0) <null>
0 PIN_FLD_CURRENCY INT [0] 36
0 PIN_FLD_CURRENCY_SECONDARY INT [0] 0
0 PIN_FLD_CUSTOMER_SEGMENT_LIST STR [0] "1001|2001|3001|4001"
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1317967793) Fri Oct 07 17:09:53 2011
0 PIN_FLD_GL_SEGMENT STR [0] "."
0 PIN_FLD_GROUP_OBJ POID [0] 0.0.0.0 0 0
0 PIN_FLD_INCORPORATED_FLAG ENUM [0] 0
0 PIN_FLD_INTERNAL_NOTES BUF [0] flag/size/offset 0x0 0 0 NULL data ptr
0 PIN_FLD_ITEM_POID_LIST STR [0] "0.0.0.3|/item/misc 1023900 0"
0 PIN_FLD_LASTSTAT_CMNT STR [0] ""
0 PIN_FLD_LAST_STATUS_T TSTAMP [0] (1317967793) Fri Oct 07 17:09:53 2011
0 PIN_FLD_LINEAGE STR [0] "/0.0.0.3:1020316/"
0 PIN_FLD_LOCALE STR [0] "en_US"
0 PIN_FLD_NAME STR [0] "PIN Account Object"
0 PIN_FLD_NEXT_ITEM_POID_LIST STR [0] "0.0.0.3|/item/misc 1019996 0"
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_RESIDENCE_FLAG ENUM [0] 0
0 PIN_FLD_STATUS ENUM [0] 10100
0 PIN_FLD_STATUS_FLAGS INT [0] 0
0 PIN_FLD_TIMEZONE_ID STR [0] ""
0 PIN_FLD_VAT_CERT STR [0] ""
0 PIN_FLD_NAMEINFO ARRAY [1] allocated 20, used 20
1 PIN_FLD_ADDRESS STR [0] "1||||1|THREE|Street|DODGES FERRY"
1 PIN_FLD_CANON_COMPANY STR [0] "brm, complex020502"
1 PIN_FLD_CANON_COUNTRY STR [0] "AU"
1 PIN_FLD_CITY STR [0] ""
1 PIN_FLD_COMPANY STR [0] "BRM, COMPLEX020502"
1 PIN_FLD_CONTACT_TYPE STR [0] "Account Holder"
1 PIN_FLD_COUNTRY STR [0] "Australia"
1 PIN_FLD_EMAIL_ADDR STR [0] "ausit@gmail.com"
1 PIN_FLD_FIRST_CANON STR [0] "complex020502"
1 PIN_FLD_FIRST_NAME STR [0] "COMPLEX020502"
1 PIN_FLD_LAST_CANON STR [0] "brm"
1 PIN_FLD_LAST_NAME STR [0] "BRM"
1 PIN_FLD_MIDDLE_CANON STR [0] "brm, complex020502"
1 PIN_FLD_MIDDLE_NAME STR [0] "BRM, COMPLEX020502"
1 PIN_FLD_SALUTATION STR [0] ""
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_STATE STR [0] "TAS"
1 PIN_FLD_TITLE STR [0] "Miss"
1 PIN_FLD_ZIP STR [0] "7173"
1 PIN_FLD_PHONES ARRAY [0] allocated 20, used 2
2 PIN_FLD_PHONE STR [0] "61449098765"
2 PIN_FLD_TYPE ENUM [0] 8


nap(20774)> robj - 0.0.0.3 /service/subscription 1027748  *** Secondary Schema
# number of field entries allocated 35, used 34
0 PIN_FLD_POID POID [0] 0.0.0.3 /service/subscription 1027748 10
0 PIN_FLD_CREATED_T TSTAMP [0] (1317967886) Fri Oct 07 17:11:26 2011
0 PIN_FLD_MOD_T TSTAMP [0] (1317967894) Fri Oct 07 17:11:34 2011
0 PIN_FLD_READ_ACCESS STR [0] "S"
0 PIN_FLD_WRITE_ACCESS STR [0] "S"
0 PIN_FLD_AAC_ACCESS STR [0] ""
0 PIN_FLD_AAC_PACKAGE STR [0] ""
0 PIN_FLD_AAC_PROMO_CODE STR [0] ""
0 PIN_FLD_AAC_SERIAL_NUM STR [0] ""
0 PIN_FLD_AAC_SOURCE STR [0] ""
0 PIN_FLD_AAC_VENDOR STR [0] ""
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.3 /account 1020316 0
0 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.3 /balance_group 1026724 0
0 PIN_FLD_CLOSE_WHEN_T TSTAMP [0] (0) <null>
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1317967793) Fri Oct 07 17:09:53 2011
0 PIN_FLD_ITEM_POID_LIST STR [0] "0.0.0.3|/item/cycle_forward 1024420 0"
0 PIN_FLD_LASTSTAT_CMNT STR [0] ""
0 PIN_FLD_LAST_STATUS_T TSTAMP [0] (1317967793) Fri Oct 07 17:09:53 2011
0 PIN_FLD_LOGIN STR [0] ""
0 PIN_FLD_NAME STR [0] "PIN Service Object"
0 PIN_FLD_NEXT_ITEM_POID_LIST STR [0] ""
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_PASSWD STR [0] "XXXX"
0 PIN_FLD_PASSWD_EXPIRATION_T TSTAMP [0] (0) <null>
0 PIN_FLD_PASSWD_STATUS ENUM [0] 0
0 PIN_FLD_PROFILE_OBJ POID [0] 0.0.0.0 0 0
0 PIN_FLD_SERVICE_ID STR [0] ""
0 PIN_FLD_STATUS ENUM [0] 10100
0 PIN_FLD_STATUS_FLAGS INT [0] 0
0 PIN_FLD_SUBSCRIPTION_OBJ POID [0] 0.0.0.0 0 0
0 PIN_FLD_TYPE ENUM [0] 0
0 PIN_FLD_ALIAS_LIST ARRAY [0] allocated 20, used 1
1 PIN_FLD_NAME STR [0] "505038232900902"
0 PIN_FLD_ALIAS_LIST ARRAY [1] allocated 20, used 1
1 PIN_FLD_NAME STR [0] "61485206503"
0 PIN_FLD_SUB_ORDER_INFO SUBSTRUCT [0] allocated 20, used 4
1 PIN_FLD_NAME STR [0] "Miss COMPLEX020502 BRM"
1 PIN_FLD_PROD_NAME STR [0] "$79 Unlimited Cap July 2010"
1 VF_FLD_S_DEALER STR [0] ":"
1 VF_FLD_THREE_INDICATOR ENUM [0] 0

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