Hi, I think the WORKFLOW_TASK_ID is created upon a trigger, using a sequence. Have you created them? WORKFLOW_INSTANCES_SEQ and WORKFLOW_INSTANCES_TRIGGER?
-- cecilia On 8/22/11 6:18 PM, "Verma, Rishi (317I)" <[email protected]> wrote: > Hi everyone, > > I'm receiving a maven test failure when attempting to build (mvn package) > CAS-Workflow (the latest trunk code). Does anyone have insight into this > particular failure or is anyone able to reproduce? > > TEST FAILURE: > Running > org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository > Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.273 sec <<< > FAILURE! > > STACKTRACE: > java.sql.SQLException: Attempt to insert null into a non-nullable column: > column: WORKFLOW_TASK_ID table: WORKFLOW_TASKS > at org.hsqldb.jdbc.Util.sqlException(Unknown Source) > at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) > at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) > at > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:2 > 61) > at > org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.commitTas > k(DataSourceWorkflowRepository.java:1393) > at > org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getGlobal > WorkflowConditionsTask(DataSourceWorkflowRepository.java:1587) > at > org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.handleGlo > balWorkflowConditions(DataSourceWorkflowRepository.java:1572) > at > org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkfl > owById(DataSourceWorkflowRepository.java:195) > at > org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkfl > owById(DataSourceWorkflowRepository.java:165) > at > org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository.testW > orkflowConditions(TestWorkflowDataSourceRepository.java:114) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.j > ava:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at junit.framework.TestCase.runTest(TestCase.java:164) > at junit.framework.TestCase.runBare(TestCase.java:130) > at junit.framework.TestResult$1.protect(TestResult.java:106) > at junit.framework.TestResult.runProtected(TestResult.java:124) > at junit.framework.TestResult.run(TestResult.java:109) > at junit.framework.TestCase.run(TestCase.java:120) > at junit.framework.TestSuite.runTest(TestSuite.java:230) > at junit.framework.TestSuite.run(TestSuite.java:225) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
