Skip to end of metadata
Go to start of metadata

Purpose

The purpose of this article is to resolve the folllowing error:

SAP Work Manager for Maximo
Client version: 5.1.18
Server version: 5.1.18
The following error message is received while creating a new address in Organizations (SP)  Address tab:

This error is in Maximo.  The Syclo Triggers seems to be failing when a new address is added.


BMXAA4211E - Database error number 1400 has occurred when operating on ADDRESS Organization=US Address Code=SANDEEPQ.
ORA-01400: cannot insert NULL into ("MAXIMO"."SYCLOADDRESSUP"."ADDRESSNAME")
ORA-06512: at "MAXIMO.SYCLOADDRESSUPDATE", line 12
ORA-06512: at "MAXIMO.SYCLOADDRESSTRGI", line 2
ORA-04088: error during execution of trigger 'MAXIMO.SYCLOADDRESSTRGI'

CREATE TABLE MAXIMO.SYCLOADDRESSUP
(
   ADDRESSCODE VARCHAR2(50 CHAR) NOT NULL,
   ADDRESSNAME VARCHAR2(100 CHAR) NOT NULL,
   DELETED VARCHAR2(1 CHAR),
   LASTUPDATE DATE NOT NULL,
   ORGID VARCHAR2(8 CHAR),
   ROWSTAMP VARCHAR2(40 CHAR) NOT NULL
)

Overview

The error is an Oracle standard database problem wherein it literally complains that the script or trigger is trying to insert a Null into a column wherein it was defined as "NOT NULL".

Resolution

This is a problem with the Oracle trigger. This is simply resolved by: Making a DB change on the field in the SycloAddress table able to be "NULL" instead of "NOT NULL".

Related Content

Related Documents

Related SAP Notes/KBAs