Mailing-List: contact dev-help@oodt.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@oodt.apache.org
Received-SPF: pass (athena.apache.org: local policy)
From: "Verma, Rishi (317I)" <Rishi.Verma@jpl.nasa.gov>
To: "dev@oodt.apache.org" <dev@oodt.apache.org>
Date: Tue, 23 Aug 2011 10:06:56 -0700
Subject: Re: CAS-Workflow 04-SNAPSHOT maven test failure
Thread-Topic: CAS-Workflow 04-SNAPSHOT maven test failure
Thread-Index: AcxhtxoxLkZzcZqLSXGWtVKBj/bFAQ==
Message-ID: <8F848D93-D9ED-4066-B6CA-367B169D3F2D@jpl.nasa.gov>
References: <CA7885AD.D1A3%cecilia.cheng@jpl.nasa.gov>
In-Reply-To: <CA7885AD.D1A3%cecilia.cheng@jpl.nasa.gov>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Hi Cecilia,

Thanks for your response. Could you elaborate what you mean by "creating th=
em"?

I would expect building & testing WM would not require any extra work by a =
user.

I think the problem is the test-case [1] (look at method testWorkflowCondit=
ions()) may need some modification. That test-case queries DataSourceWorkfl=
owRepository to get a workflow by the ID number "1". Perhaps some pre-condi=
tions need to be set here? JIRA issue OODT-205 [2] talks about this. Sure e=
nough though, if I ignore this particular test, the build is successful and=
 all other WM tests succeed.=20

[1] http://svn.apache.org/repos/asf/oodt/trunk/workflow/src/test/org/apache=
/oodt/cas/workflow/repository/TestWorkflowDataSourceRepository.java
[2] https://issues.apache.org/jira/browse/OODT-205

Thanks,
rishi

On Aug 22, 2011, at 10:16 PM, Cheng, Cecilia S (388K) wrote:

> Hi,
>=20
> 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?
>=20
> -- cecilia
>=20
> On 8/22/11 6:18 PM, "Verma, Rishi (317I)" <Rishi.Verma@jpl.nasa.gov> wrot=
e:
>=20
>> Hi everyone,
>>=20
>> 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?
>>=20
>> TEST FAILURE:
>> Running=20
>> org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository
>> Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.273 se=
c <<<
>> FAILURE!
>>=20
>> 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=20
>> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.=
java:2
>> 61)
>>       at=20
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.com=
mitTas
>> k(DataSourceWorkflowRepository.java:1393)
>>       at=20
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.get=
Global
>> WorkflowConditionsTask(DataSourceWorkflowRepository.java:1587)
>>       at=20
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.han=
dleGlo
>> balWorkflowConditions(DataSourceWorkflowRepository.java:1572)
>>       at=20
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.get=
Workfl
>> owById(DataSourceWorkflowRepository.java:195)
>>       at=20
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.get=
Workfl
>> owById(DataSourceWorkflowRepository.java:165)
>>       at=20
>> org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository=
.testW
>> orkflowConditions(TestWorkflowDataSourceRepository.java:114)
>>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>       at=20
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav=
a:39)
>>       at=20
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor=
Impl.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=20
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav=
a:39)
>=20