IBM Support

ORA-01400: cannot insert NULL into ACT_AUTHENTICATE *|* -2F65E1F8CC80FC58852579170079A90A- *|*

Question & Answer


Question

ORA-01400: cannot insert NULL into ACT_AUTHENTICATE *|* -2F65E1F8CC80FC58852579170079A90A- *|*

Answer

Technote (troubleshooting)


Problem(Abstract)

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


Resolving the problem

Please apply Gentran Integration Suite Release 4.2 Build 4212 or later.
Please apply Gentran Integration Suite Release 4.3 Build 4309 or later.

Cross reference information
SegmentProductComponentPlatformVersionEdition
CommerceSterling B2B IntegratorAdapters

Historical Number

NFX2257

Product Alias/Synonym

Function Area


Connect Direct Interop

Escalation ID


1368326

Fix ID


44713 38806

Severity


Normal

Type


NormalFix

Build


4212 4309

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
12 October 2021

UID

ibm10765467