java.sql.SQLIntegrityConstraintViolationException

ORA-01400: cannot insert NULL into ("RBACXSERVICE"."ACCOUNTS"."NAME")

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web380

  • via Oracle Community by 967853, 11 months ago
    ORA-01400: cannot insert NULL into ("RBACXSERVICE"."ACCOUNTS"."NAME")
  • ORA-01400: cannot insert NULL into ("WAARP"."HOSTCONFIG"."BUSINESS")
  • via Kuali JIRA by Juancho Baino, 11 months ago
    ORA-01400: cannot insert NULL into ("KFS"."GL_ID_BILL_T"."FIN_OBJ_TYP_CD")
  • Stack trace

    • java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("RBACXSERVICE"."ACCOUNTS"."NAME") at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212) at com.vaau.rbacx.dao.ibatis.SqlMapAccountDao.batchUpdateAccounts(SqlMapAccountDao.java:303) at com.vaau.rbacx.dao.ibatis.SqlMapAccountDao.insertAccounts(SqlMapAccountDao.java:291) at com.vaau.rbacx.manager.AccountManagerImpl.createAccounts(AccountManagerImpl.java:182) at com.vaau.rbacx.manager.AccountManagerImpl.createOrUpdateAccounts(AccountManagerImpl.java:154) at com.vaau.rbacx.core.support.RbacxDataImporterImpl.importAccounts(RbacxDataImporterImpl.java:915) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy68.importAccounts(Unknown Source) at com.vaau.rbacx.iam.file.csv.CSVAccountFileReader.importAccounts(CSVAccountFileReader.java:314) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("RBACXSERVICE"."ACCOUNTS"."NAME") at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:9215) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9315) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:242) at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124) at $Proxy35.executeBatch(Unknown Source) at com.ibatis.sqlmap.engine.execution.DefaultSqlExecutor$Batch.executeBatch(DefaultSqlExecutor.java:633) at com.ibatis.sqlmap.engine.execution.DefaultSqlExecutor.executeBatch(DefaultSqlExecutor.java:116) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.executeBatch(SqlMapExecutorDelegate.java:770) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.executeBatch(SqlMapSessionImpl.java:184) at com.vaau.rbacx.dao.ibatis.SqlMapAccountDao$2.doInSqlMapClient(SqlMapAccountDao.java:315) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209) ... 20 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 month ago
    Unknown user
    Once, 1 month ago
    Unknown user
    Once, 1 month ago
    Unknown user
    Once, 1 month ago
    Unknown user
    Once, 1 month ago
    20 more bugmates