ORA-01400: cannot insert NULL into ACT

Troubleshooting

Problem

ORA-01400: cannot insert NULL into ACT_AUTHENTICATE

Symptom

Customer receives the ORA-01400 on ACT_AUTHENTICATE table error in the Visibiilty log. Tested and found issue is when the bp Connect Direct Server Begin Session service does not use the RemoteUserId and instead uses proxy to set a userid.

Error Message

[2007-11-14 18:38:07.826] ERROR SQL Error Code: 1400
[2007-11-14 18:38:07.826] ERROR SQL State: 23000
java.sql.SQLException: ORA-01400: cannot insert NULL into ("GIS_USER"."ACT_AUTHENTICATE"."PRINCIPAL")

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3422)
        at sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at com.sterlingcommerce.woodstock.mailbox.db.SQLWrapper.forwardMethod(SQLWrapper.java:65)
        at com.sterlingcommerce.woodstock.mailbox.db.StatementWrapper.invoke(StatementWrapper.java:144)
        at $Proxy1.execute(Unknown Source)
        at com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWarehouse$1.body(DmiVisEventWarehouse.java:281)
        at com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation._runInTransaction(DatabaseOperation.java:301)
        at com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.runInTransaction(DatabaseOperation.java:152)
        at com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWarehouse$Worker.executeState

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Extensions","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Adapters","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

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.

Historical Number

NFX2257

Was this topic helpful?

Document Information

Modified date:
25 February 2019

UID

swg21553095

Tips