IZ04968: ORACLE ERROR WHEN INSERTING CLOB FIELD WITH LARGE NUMBER OF CHARS: ORA-21560: ARGUMENT 2 IS NULL, INVALID, OR OUT OF RANGE

APAR status

• Closed as program error.

Error description

• Impact 4.0 Unable insert large string into oracle datatype
  that has a field CLOB type has a field CLOB type. Customer would
  like to be an to exceed the current value of 4000 characters
  during updates and 32000 character during inserts.
  

Local fix

• There is no work around at this time.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Impact Users who are using Oracle DSA    *
  *                 with CLOB field                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: ORACLE ERROR WHEN INSERTING CLOB FIELD  *
  *                      WITH LARGE NUMBER OF CHARS: ORA-21560:  *
  *                      ARGUMENT 2 IS NULL, INVALID, OR OUT OF  *
  *                      RANGE                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  ****************************************************************
  Steps to replicate:
  
  1) Configure Impact Server and create Oracle DSA 2) Create Data
  Type for table that contains CLOB Field 3) Insert large string
  (>32000 chars)  into clob field 4) View the Data item in Impact
  5) Create a policy to query the current data including the CLOB
  field, and then insert it into the table
  nodes=GetByFilter('DataType_Name','filter',false);
  oldValue=nodes 0 .CLOB_FIELD_NAME;         item=NewObject();
  item.CLOB_FIELD_NAME=oldValue +  ANY OTHER STRING;
  item.KeyField=<value>;        //to insert new row
  AddDataItem('DataType_Name',item);      //update the existing
  field      nodes 0 .CLOB_FIELD_NAME=oldValue +  another updated
  value ; 6) Check the log file and observe the following error:
   ORA-21560: ARGUMENT 2 IS NULL, INVALID, OR OUT OF RANGE
  

Problem conclusion

• Fixed in  Impact 4.0.2
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    NETCOOL
  

Fix information

• Fixed component name

  NETCOOL/IMPACT

• Fixed component ID

  5724O59IS

Applicable component levels

• R400 PSY

     UP