Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://go.sap.com/community.html
Thank you,
The SAP Community team.
The SAP Community wiki will be closed to new content submissions from December 7 6:00 p.m. CET to December 11 6:00 p.m. CET.
We apologize for the inconvenience, but we need to take the system offline while we improve the platform. Please plan your 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