How To
Summary
When trying to add a New Listener Definition in E-mail Listeners application in a Maximo environment with Oracle database, you receive the error: BMXAA4211E - Database error number 1400 has occurred when performing on INBOUNDCMMCFG.
Steps
1. After receiving the error in UI BMXAA4211E - Database error number 1400 has occurred when performing on INBOUNDCMMCFG, open the System.Out log files and check the error ORA-01400: cannot insert NULL into ("MAXIMO"."INBOUNDCOMMCFG"."ROWSTAMP")
2. Run Integrity Checker tool and check the error:
ERROR BMXAA0478E: The ROWSTAMP trigger was not found for the following tables: INBOUNDCMMCFG
At this point, you realized that the rowstamp trigger does not exist or needs to be recreated on the database for table INBOUNDCOMMCFG.
Important: Do not run Integrity Checker in Repair Mode to fix this error.
3. In database, run the following statements:
create or replace trigger INBOUNDCOMMCFG_T
before insert or update on INBOUNDCOMMCFG
for each row
declare
nextval integer;
begin
select maxseq.NEXTVAL into nextval from dual;
:new.rowstamp := nextval;
end;
4. Go to E-mail Listeners application, and add a New Listener Definition.
Related Information
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbU1AAK","label":"System Administration-\u003EE-Mail Listeners"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6.1"}]
Was this topic helpful?
Document Information
Modified date:
06 May 2024
UID
ibm17150236