java.sql.SQLException: ORA-01758: table must be empty to add mandatory (NOT NULL) column

Oracle Community | 902046 | 5 years ago
  1. 0

    Error adding a child form to more than one form

    Oracle Community | 5 years ago | 902046
    java.sql.SQLException: ORA-01758: table must be empty to add mandatory (NOT NULL) column
  2. 0

    DB Low performace due to oracle mobile triggers

    Oracle Community | 8 years ago | sjgarciav
    java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
  3. 0

    SQL & PL/SQL :: WEBADI Error ORA-06508 Could Not Find Program Unit Being Called

    bigresource.com | 11 months ago
    java.sql.SQLException: ORA-04054: database link GMAIL.COM does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [OPENJPA-964] Finish updating sql-error-state- codes.xml for query timeout support on other DBs - ASF JIRA

    apache.org | 12 months ago
    java.sql.SQLException: ORA-01013: user requested cancel of current operation
  6. 0

    csDbUnableToStartTransaction() ORA-01013: user requested cancel of current

    Oracle Community | 6 years ago | user12953613
    intradoc.common.ServiceException: !csDbUnableToStartTransaction,!$ORA-01013: user requested cancel of current operation

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-01758: table must be empty to add mandatory (NOT NULL) column

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.executeUpdate
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
      6. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1285)
      8. oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1772)
      9. oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1741)
      9 frames
    3. com.thortech.xl
      tcSDHBean.save
      1. com.thortech.xl.util.JDBCUtils.executeUpdate(Unknown Source)
      2. com.thortech.xl.dataaccess.tcDataBase.writeStatement(Unknown Source)
      3. com.thortech.xl.dataobj.tcDataBase.writeStatement(Unknown Source)
      4. com.thortech.xl.client.events.tcSDHAddForeignConstraint.createColumns(Unknown Source)
      5. com.thortech.xl.client.events.tcSDHAddForeignConstraint.implementation(Unknown Source)
      6. com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source)
      7. com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source)
      8. com.thortech.xl.dataobj.tcDataObj.eventPostInsert(Unknown Source)
      9. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
      10. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
      11. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
      12. com.thortech.xl.ejb.databeansimpl.tcDataObjectBase.save(Unknown Source)
      13. com.thortech.xl.ejb.databeansimpl.tcSDHBean.save(Unknown Source)
      13 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    5. com.evermind.server
      StatefulSessionEJBObject.OC4J_invokeMethod
      1. com.evermind.server.ejb.interceptor.joinpoint.EJBJoinPointImpl.invoke(EJBJoinPointImpl.java:35)
      2. com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
      3. com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
      4. com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
      5. com.evermind.server.ejb.interceptor.system.TxRequiredInterceptor.invoke(TxRequiredInterceptor.java:50)
      6. com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
      7. com.evermind.server.ejb.interceptor.system.SecurityRoleInterceptor.invoke(SecurityRoleInterceptor.java:47)
      8. com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
      9. com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
      10. com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
      11. com.evermind.server.ejb.InvocationContextPool.invoke(InvocationContextPool.java:55)
      12. com.evermind.server.ejb.StatefulSessionEJBObject.OC4J_invokeMethod(StatefulSessionEJBObject.java:844)
      12 frames
    6. Unknown
      tcSDH_RemoteProxy_6ocop18.save
      1. tcSDH_RemoteProxy_6ocop18.save(Unknown Source)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    8. com.evermind.server
      RmiMethodCall.run
      1. com.evermind.server.rmi.RmiMethodCall.run(RmiMethodCall.java:53)
      1 frame
    9. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame