Encrypted Data Was Not Decryptable For Certain Keys (Doc ID 988192.1)

Last updated on MARCH 14, 2013

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Information in this document applies to any platform.
Checked for relevance on 14-Mar-2013

Symptoms

After using dm_oracle encryption to protect credit card account data, there are many credit card account values that now return jibberish from dm_oracle.

Scenario :

1) Have two instances of dm_oracle running with the crypt entry set to AES in pin.conf.
2) Set the encryption for Address in /payinfo/cc field.
3) Change the AES key in pin.conf entry of both dm_oracle instances.
4) Send the USR2 signal to both the dm_oracle one after the other.
5) Create Credit Card account.
6) Create a /payinfo/cc object from the dm_oracle to which the USR2 signal was sent first.
7) Read the /payinfo/cc object from the other dm_oracle and see the junk values.

> testnap
===> database 0.0.0.1 from pin.conf "userid"
nap(32619)> robj - 0.0.0.1 /payinfo/cc 1565545
# number of field entries allocated 20, used 15
0 PIN_FLD_POID POID [0] 0.0.0.1 /payinfo/cc 1565545 0
0 PIN_FLD_CREATED_T TSTAMP [0] (1262929144) Thu Jan 7 21:39:04 2010
0 PIN_FLD_MOD_T TSTAMP [0] (1262929144) Thu Jan 7 21:39:04 2010
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1568105 0
0 PIN_FLD_ACH INT [0] 0
0 PIN_FLD_DUE_DOM INT [0] 0
0 PIN_FLD_INVOICE_OBJ POID [0] 0.0.0.1 /invoice -1 0
0 PIN_FLD_INV_TYPE ENUM [0] 0
0 PIN_FLD_NAME STR [0] "PIN Payinfo Object"
0 PIN_FLD_PAYMENT_OFFSET INT [0] -1
0 PIN_FLD_PAYMENT_TERM ENUM [0] 0
0 PIN_FLD_RELATIVE_DUE_T TSTAMP [0] (2592000) Fri Jan 30 16:00:00 1970
0 PIN_FLD_CC_INFO ARRAY [0] allocated 20, used 9
1     PIN_FLD_ADDRESS STR [0] "\347\262\373#\223(T\367"    <---- Junk values
1     PIN_FLD_CITY STR [0] "test_new"
1     PIN_FLD_COUNTRY STR [0] "in"
1     PIN_FLD_DEBIT_EXP STR [0] "XXXX"
1     PIN_FLD_DEBIT_NUM STR [0] "XXXX"
1     PIN_FLD_NAME STR [0] "test_new test_new test_new"
1     PIN_FLD_SECURITY_ID STR [0] ""
1     PIN_FLD_STATE STR [0] "test_new"
1     PIN_FLD_ZIP STR [0] "test_new"
nap(32619)> q

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