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 number
IZ04968
Reported component name
NETCOOL/IMPACT
Reported component ID
5724O59IS
Reported release
400
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-09-17
Closed date
2007-12-17
Last modified date
2007-12-17
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSCP78Y","label":"Netcool\/Impact"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"400","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
17 December 2007