DM_ORACLE Is Not Handling The Encryption Correctly If Field Value In CREATE_OBJ Is NULL (Doc ID 759426.1)

Last updated on APRIL 28, 2014

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.
*** Checked for relevance on 04-28-2014 ***

Symptoms

When PCM_OP_CREATE_OBJ Opcode is invoked and when encryption is set for the field, dm_oracle fails to handle encryption for the field having NULL value.

dm_oracle fails with following error :

 

E Wed Jan 1 00:11:54 2020 <m/c> dm:10927 md5xor.c(20):232 1:<machine>:<program>:0:0:0:0:0
      psiu_encrypt() bad input
E Wed Jan 1 00:11:54 2020 <m/c> dm:10927 dm_subr.c(116):6602 1:<machine>:<program>:0:0:0:0:0 
      psiu_encrypt failed in encrypt_field_value() for field , err 4
E Wed Jan 1 00:11:54 2020 <m/c> dm:10927 dm_sql_mapping.c(79):1967 1:<machine>:<program>:0:0:0:0:0 
      binding_info_of_field() encryption failed for field , err=4(PIN_ERR_BAD_ARG)
E Wed Jan 1 00:11:54 2020 <m/c> dm:10927 dm_do_ops.c(73):1943 1:<machine>:<program>:0:0:0:0:0 
      do_create_create m_i_c_l() tbl profile_t, field 0/0, err=4(PIN_ERR_BAD_ARG)
E Wed Jan 1 00:11:54 2020 <m/c> dm:10927 dm_do_ops.c(73):2195 1:<machine>:<program>:0:0:0:0:0 
      do_create_create do_create... field name 9/30000, err=4(PIN_ERR_BAD_ARG)


Steps to reproduce :

  1. Using class browser in developer center,edit the class and set the field properties to "Encryptable"
  2. From testnap,call PCM_OP_CREATE_OBJ opcode to create object of the above class type,while calling PCM_OP_CREATE_OBJ either pass NULL value for the field OR do not pass that field in the input flist ( so that by default opcode will try to pass NULL)
  3. PCM_OP_CREATE_OBJ fails, notice that dm_oracle fails to handle encryption for the field having NULL value.

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