IY88467: ORACLE ERROR: [ORA-01400: CANNOT INSERT NULL INTO "REPORTER"."RE PORTER_MEMBERS"."OWN] - SQLCODE[-1400]

APAR status

• Closed as fixed if next.

Error description

• Specific Binary:
  Last-modified-by:
  Product: Reporter
  Component:
  Priority: Med
  Severity: Critical
  Version N.n:
  Product Group:
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users running in reporter mode and       *
  *                 populating the reporter.members table from   *
  *                 the ObjectServer equivalent.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: It is not possible to populate the      *
  *                      reporter database members table         *
  *                      keyfield with unique values from the    *
  *                      ObjectServer. Thsi requires             *
  *                      concatenation of OwnerUID and OwnerGID  *
  *                      fields. Concatenation requires the      *
  *                      ability to convert non-string data      *
  *                      types to sting types.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  ****************************************************************
  It is not possible to populate the reporter database members
  table keyfield with unique values from the ObjectServer. Thsi
  requires concatenation of OwnerUID and OwnerGID fields.
  Concatenation requires the ability to convert non-string data
  types to sting types.
  

Problem conclusion

Temporary fix

Comments

• This problem is solved by adding conversion operators to the
  map file parsing: TO_STRING, TO_TIME, TO_INTEGER.
  
  Date of Release: 06/29/07 Fix Pack Name: gateway-nco-g-oracle
  

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

Applicable component levels

• R100 PSY

     UP