|
ERROR : A fatal error occurred while creating/updating com.silverpeas.workflow.engine.instance.WorkingUser using SQL: INSERT INTO "sb_workflow_workinguser" ("id","instanceid","userid","usersrole","state","role","groupid") VALUES (?,?,?,?,?,?,?)
|
|
org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint
|
|
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
|
|
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:283)
|
|
at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:315)
|
|
at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:645)
|
|
at org.exolab.castor.persist.LockEngine.create(LockEngine.java:568)
|
|
at org.castor.persist.AbstractTransactionContext.walkObjectsToBeCreated(AbstractTransactionContext.java:816)
|
|
at org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1211)
|
|
at org.exolab.castor.jdo.engine.LocalDatabaseImpl.commit(LocalDatabaseImpl.java:161)
|
|
at com.silverpeas.workflow.engine.TaskDoneRequest.process(WorkflowEngineThread.java:380)
|
|
at com.silverpeas.workflow.engine.WorkflowEngineThread.run(WorkflowEngineThread.java:182)
|
|
14/11/11-16:39:39,641 - ERROR : This transaction has been aborted and rolled back: Nested error: org.exolab.castor.jdo.PersistenceException: Nested error: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint: ERROR: null value in column "role" violates not-null constraint: Nested error: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint: ERROR: null value in column "role" violates not-null constraint
|
|
org.exolab.castor.jdo.TransactionAbortedException: Nested error: org.exolab.castor.jdo.PersistenceException: Nested error: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint: ERROR: null value in column "role" violates not-null constraint: Nested error: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint: ERROR: null value in column "role" violates not-null constraint
|
|
at org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1227)
|
|
at org.exolab.castor.jdo.engine.LocalDatabaseImpl.commit(LocalDatabaseImpl.java:161)
|
|
at com.silverpeas.workflow.engine.TaskDoneRequest.process(WorkflowEngineThread.java:380)
|
|
at com.silverpeas.workflow.engine.WorkflowEngineThread.run(WorkflowEngineThread.java:182)
|
|
Caused by: org.exolab.castor.jdo.PersistenceException: Nested error: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint: ERROR: null value in column "role" violates not-null constraint
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:339)
|
|
at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:315)
|
|
at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:645)
|
|
at org.exolab.castor.persist.LockEngine.create(LockEngine.java:568)
|
|
at org.castor.persist.AbstractTransactionContext.walkObjectsToBeCreated(AbstractTransactionContext.java:816)
|
|
at org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1211)
|
|
... 3 more
|
|
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint
|
|
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
|
|
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:283)
|
|
... 8 more
|
|
Caused by: org.exolab.castor.jdo.PersistenceException: Nested error: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint: ERROR: null value in column "role" violates not-null constraint
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:339)
|
|
at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:315)
|
|
at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:645)
|
|
at org.exolab.castor.persist.LockEngine.create(LockEngine.java:568)
|
|
at org.castor.persist.AbstractTransactionContext.walkObjectsToBeCreated(AbstractTransactionContext.java:816)
|
|
at org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1211)
|
|
at org.exolab.castor.jdo.engine.LocalDatabaseImpl.commit(LocalDatabaseImpl.java:161)
|
|
at com.silverpeas.workflow.engine.TaskDoneRequest.process(WorkflowEngineThread.java:380)
|
|
at com.silverpeas.workflow.engine.WorkflowEngineThread.run(WorkflowEngineThread.java:182)
|
|
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint
|
|
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
|
|
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:283)
|
|
... 8 more
|
|
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint
|
|
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
|
|
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:283)
|
|
at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:315)
|
|
at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:645)
|
|
at org.exolab.castor.persist.LockEngine.create(LockEngine.java:568)
|
|
at org.castor.persist.AbstractTransactionContext.walkObjectsToBeCreated(AbstractTransactionContext.java:816)
|
|
at org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1211)
|
|
at org.exolab.castor.jdo.engine.LocalDatabaseImpl.commit(LocalDatabaseImpl.java:161)
|
|
at com.silverpeas.workflow.engine.TaskDoneRequest.process(WorkflowEngineThread.java:380)
|
|
at com.silverpeas.workflow.engine.WorkflowEngineThread.run(WorkflowEngineThread.java:182)
|
|
14/11/11-16:39:39,641 - ERROR : A fatal error occurred while creating/updating com.silverpeas.workflow.engine.error.WorkflowErrorImpl using SQL: INSERT INTO "sb_workflow_error" ("id","instanceid","stepid","errormessage","stacktrace","userid","actionname","actiondate","userrole","statename") VALUES (?,?,?,?,?,?,?,?,?,?)
|
|
org.postgresql.util.PSQLException: ERROR: value too long for type character varying(200)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
|
|
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:283)
|
|
at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:315)
|
|
at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:645)
|
|
at org.exolab.castor.persist.LockEngine.create(LockEngine.java:568)
|
|
at org.castor.persist.AbstractTransactionContext.walkObjectsToBeCreated(AbstractTransactionContext.java:816)
|
|
at org.castor.persist.AbstractTransactionContext.create(AbstractTransactionContext.java:776)
|
|
at org.exolab.castor.jdo.engine.AbstractDatabaseImpl.create(AbstractDatabaseImpl.java:276)
|
|
at com.silverpeas.workflow.engine.error.ErrorManagerImpl.saveError(ErrorManagerImpl.java:64)
|
|
at com.silverpeas.workflow.engine.TaskDoneRequest.process(WorkflowEngineThread.java:382)
|
|
at com.silverpeas.workflow.engine.WorkflowEngineThread.run(WorkflowEngineThread.java:182)
|
|
14/11/11-16:39:39,641 - ERROR : workflowEngine.EX_ERROR_PROCESSING_REQUEST | MODULE : workflowEngine.WorkflowEngineThread | Erreur lors du traitement d'une requ?te de la liste d'attente (com.silverpeas.workflow.engine.TaskDoneRequest@18685b2)
|
|
Probl?me dans l'ajout d'une requ?te de type tache effectu?e
|
|
nested (Deepest) :
|
|
org.exolab.castor.jdo.TransactionAbortedException: Nested error: org.exolab.castor.jdo.PersistenceException: Nested error: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint: ERROR: null value in column "role" violates not-null constraint: Nested error: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint: ERROR: null value in column "role" violates not-null constraint
|
|
at org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1227)
|
|
at org.exolab.castor.jdo.engine.LocalDatabaseImpl.commit(LocalDatabaseImpl.java:161)
|
|
at com.silverpeas.workflow.engine.TaskDoneRequest.process(WorkflowEngineThread.java:380)
|
|
at com.silverpeas.workflow.engine.WorkflowEngineThread.run(WorkflowEngineThread.java:182)
|
|
Caused by: org.exolab.castor.jdo.PersistenceException: Nested error: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint: ERROR: null value in column "role" violates not-null constraint
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:339)
|
|
at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:315)
|
|
at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:645)
|
|
at org.exolab.castor.persist.LockEngine.create(LockEngine.java:568)
|
|
at org.castor.persist.AbstractTransactionContext.walkObjectsToBeCreated(AbstractTransactionContext.java:816)
|
|
at org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1211)
|
|
... 3 more
|
|
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint
|
|
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
|
|
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:283)
|
|
... 8 more
|
|
Caused by: org.exolab.castor.jdo.PersistenceException: Nested error: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint: ERROR: null value in column "role" violates not-null constraint
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:339)
|
|
at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:315)
|
|
at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:645)
|
|
at org.exolab.castor.persist.LockEngine.create(LockEngine.java:568)
|
|
at org.castor.persist.AbstractTransactionContext.walkObjectsToBeCreated(AbstractTransactionContext.java:816)
|
|
at org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1211)
|
|
at org.exolab.castor.jdo.engine.LocalDatabaseImpl.commit(LocalDatabaseImpl.java:161)
|
|
at com.silverpeas.workflow.engine.TaskDoneRequest.process(WorkflowEngineThread.java:380)
|
|
at com.silverpeas.workflow.engine.WorkflowEngineThread.run(WorkflowEngineThread.java:182)
|
|
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint
|
|
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
|
|
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:283)
|
|
... 8 more
|
|
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "role" violates not-null constraint
|
|
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
|
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
|
|
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
|
|
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
|
|
at org.exolab.castor.jdo.engine.SQLStatementCreate.executeStatement(SQLStatementCreate.java:283)
|
|
at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:315)
|
|
at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:645)
|
|
at org.exolab.castor.persist.LockEngine.create(LockEngine.java:568)
|
|
at org.castor.persist.AbstractTransactionContext.walkObjectsToBeCreated(AbstractTransactionContext.java:816)
|
|
at org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1211)
|
|
at org.exolab.castor.jdo.engine.LocalDatabaseImpl.commit(LocalDatabaseImpl.java:161)
|
|
at com.silverpeas.workflow.engine.TaskDoneRequest.process(WorkflowEngineThread.java:380)
|
|
at com.silverpeas.workflow.engine.WorkflowEngineThread.run(WorkflowEngineThread.java:182)
|
|
14/11/11-16:39:39,641 - ERROR : workflowEngine.EX_ERROR_PROCESSING_REQUEST | MODULE : workflowEngine.WorkflowEngineThread | Erreur lors du traitement d'une requ?te de la liste d'attente (com.silverpeas.workflow.engine.TaskDoneRequest@18685b2, EXCEPTION : com.silverpeas.workflow.api.WorkflowException: workflowEngine.EX_ERR_PROCESS_ADD_TASKDONE_REQUEST)
|