Registration

Dear SCN Member,
In order to fully benefit from what SCN has to offer, please register at:
http://scn.sap.com/login.jspa
Thank you,
The SCN team
We are improving! The SCN wiki will not be available for new content submission starting August 7th 6PM CET until August 10th 6PM CET.
Please plan your SCN wiki tasks accordingly.
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