IBM Support

webMethods Knowlegebase : Database Schema Creation - "ORA-01400: cannot insert NULL..." (1775438)

Troubleshooting


Problem

After run " ./dbConfigurator.sh -a create -d oracle -pr MWS -v latest -l "jdbc:wm:oracle://IP_ADRESS:1234;serviceName=SAGDB" -u MWSUSR9 -p MWSUSR9 …”

Error message encounter:

------------------------------------------------------------

Summary of installation errors

------------------------------------------------------------

Error in executing file …/common/db/scripts/oracle/mws/46/create/ora_mws_c_dml_tracking.sql

SQL error [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("MWSUSR9"."COMPONENT_EVENT"."COMPONENT_EVENT_ID")...

Document Location

Worldwide


[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSVYEV","label":"IBM webMethods Integration"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"My webMethods Server (MWS)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Red Hat Enterprise Linux"}],"Version":"9.9"},{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSAWP1J","label":"IBM webMethods BPM"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"My webMethods Server (MWS)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Red Hat Enterprise Linux"}],"Version":"9.9"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFIWYE","label":"IBM webMethods B2B"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"My webMethods Server (MWS)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Red Hat Enterprise Linux"}],"Version":"9.9"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSQG2X","label":"IBM webMethods Managed File Transfer"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"My webMethods Server (MWS)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Red Hat Enterprise Linux"}],"Version":"9.9"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM webMethods Integration

Component:
My webMethods Server (MWS)

Software version:
9.9

Operating system(s):
Red Hat Enterprise Linux

Document number:
7214224

Modified date:
20 March 2025

UID

ibm17214224

Manage My Notification Subscriptions