The SCN wiki will not be available for new content submission starting September 11th 6PM CET until September 14th 6PM CET. Please plan your SCN wiki tasks accordingly.
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
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".
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".