DRT error: study.participantcohortdatasetid does not exist: /home/Support/LabKey Support Forum

DRT error: study.participantcohortdatasetid does not exist

LabKey Support Forum (Inactive)

View Message

DRT error: study.participantcohortdatasetid does not exist

wnels2

2008-01-28 13:24

Status: Closed

I just updated and ran the drt: I'm getting an error in the Junit tests. Does this look familiar to anyone?
Thanks,
Bill

Labkey server throws this:

INFO DbSchema 2008-01-28 16:13:25,875 8080-Processor23 : Loading DbSchema "study"
ERROR Table 2008-01-28 16:13:26,765 8080-Processor23 : SQL Exception
org.postgresql.util.PSQLException: ERROR: column study.participantcohortdatasetid does not exist

Ant output:

     [java] Clicking button with image src /Delete.button
     [java] Navigating to /admin/showErrorsSinceMark.view
     [java] WARNING: getString(getTitle) saw a bad result OK,
     [java] WARNING: getString(getTitle) saw a bad result OK,
     [java] =============== Completed SeleniumBasicTest (1 of 11) ==============
===
     [java] ETest failed. Page html dumped to:
     [java] C:\CPAS\server\test\build\logs\200801281613SeleniumBasicTest.htm
l

     [java] Time: 137.672
     [java] There was 1 error:
     [java] 1) testSteps(org.labkey.test.web.SeleniumBasicTest)junit.framework.A
ssertionFailedError: There were errors during the test run
     [java] at org.labkey.test.web.BaseSeleniumWebTest.checkErrors(BaseSelen
iumWebTest.java:692)
     [java] at org.labkey.test.web.BaseSeleniumWebTest.testSteps(BaseSeleniu
mWebTest.java:596)
     [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
sorImpl.java:39)
     [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
hodAccessorImpl.java:25)
     [java] at org.junit.internal.runners.OldTestClassRunner.run(OldTestClas
sRunner.java:35)
     [java] at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:
32)
     [java] at org.labkey.test.Runner.runTest(Runner.java:175)
     [java] at org.labkey.test.Runner.runTests(Runner.java:589)
     [java] at org.labkey.test.Runner.main(Runner.java:531)

     [java] FAILURES!!!
     [java] Tests run: 1, Failures: 0, Errors: 1

     [java] ============= Time Report ==============
     [java] SeleniumBasicTest 2:17 100%
     [java] SeleniumJUnitTest 0:00 0%
     [java] SeleniumSecurityTest 0:00 0%
     [java] SeleniumExpTest 0:00 0%
     [java] FlowTest 0:00 0%
     [java] SeleniumMessagesTest 0:00 0%
     [java] XTandemTest 0:00 0%
     [java] SeleniumWikiTest 0:00 0%
     [java] SeleniumStudyTest 0:00 0%
     [java] SeleniumNabTest 0:00 0%
     [java] SeleniumIssuesTest 0:00 0%
     [java] ----------------------------------------
     [java] Total duration: 2:17

     [java] Completed 2008-01-28 16:13

BUILD FAILED
C:\CPAS\server\build.xml:1605: The following error occurred while executing this
line:
C:\CPAS\server\test\build.xml:356: The following error occurred while executing
this line:
C:\CPAS\server\test\build.xml:261: The following error occurred while executing
this line:
C:\CPAS\server\test\build.xml:642: Java returned: 1

Total time: 2 minutes 23 seconds

brittp responded:	2008-01-28 14:42
Hi Bill, That message indicates that your database and schema file are out of sync for the study module. On 1/23, I checked in new SQL scripts that added those columns (\server\modules\study\src\META-INF\study\scripts\[sql server/postgres]\study-2.31-2.32.sql), updated the study.xml file, and bumped the study module's version from 2.31 to 2.32. The error you're seeing implies that the upgrade script didn't run as expected. Is this happening on PostgreSQL or SQL Server? Did you see any SQL script failures during upgrade after your first post-update startup? What version of the study module is installed on your system now? (This is viewable via the admin console.) Thanks, Britt

wnels2 responded:	2008-01-29 10:31
Hi Britt, It's happening on PostgreSQL. I didn't notice and script failures. The current version is 2.30 on the admin page. The study-2.31-2.32.sql file is there. study.xml appears to have been updted. C:\CPAS\server\modules\study\src\META-INF>svn info study.xml Path: study.xml Name: study.xml URL: https://hedgehog.fhcrc.org/tor/stedi/trunk/server/modules/study/src/META-IN F/study.xml Repository Root: https://hedgehog.fhcrc.org/tor/stedi Repository UUID: a4ab64de-fbdc-0310-83ae-be1847ca59a0 Revision: 7889 Node Kind: file Schedule: normal Last Changed Author: brittp@labkey.com Last Changed Rev: 7875 Last Changed Date: 2008-01-23 13:53:16 -0500 (Wed, 23 Jan 2008) Text Last Updated: 2008-01-28 15:35:50 -0500 (Mon, 28 Jan 2008) Checksum: 5456d3ee819e82b074cd1d5fcf2a98f8 Thanks for your help, Bill

wnels2 responded:	2008-01-29 10:38
Running the database tests give me. Where/when would I see script errors displayed. I can drop everthing and scratch from scratch with this install. Checking Container Column References... Checking PropertyDescriptor and DomainDescriptor consistency... Checking Schema consistency with tableXML... ERROR: Inconsistency in Schema study ERROR: Table Study Column name participantcohortdatasetid found in Xml but not in database. ERROR: Table Study Column name participantcohortproperty found in Xml but not in database. ERROR: Table Visit Column name cohortid found in Xml but not in database. ERROR: Table DataSet Column name cohortid found in Xml but not in database. ERROR: Table Participant Column name cohortid found in Xml but not in database. ERROR: Table Plate Column name Type found in Xml but not in database. ERROR: TableName cohort type TABLE found in Xml but not in database. Database Consistency checker complete

adam responded:	2008-01-29 10:48
If you have updated to and compiled all the latest files then your Study module version should be 2.32, NOT 2.30. - Check the module version in the StudyModule.java constructor. If it's not 2.32 then your SVN update didn't get all the current files. - If the version is 2.32 then the file must not have been compiled. Try a rebuild.

wnels2 responded:	2008-01-29 11:18
Clean and rebuild is working. Thanks.