From: Dave B. <db...@pc...> - 2005-01-27 16:06:04
|
Hey Alberto, Nice work on the debugging, but the final result of wdkQuery that you included is not the expected output. From what I can tell, the problem arises in using the Postgres Sequence. In these tables, we are actually trying to insert the next primary key of a table as defined by the Sequence for that table. Unfortunately, instead it looks like we are getting a string that is the name of the sequence! (query_result_2_sq, for example). I will look into this; not sure exactly what the problem is yet. Dave On Wed, 26 Jan 2005, davila wrote: > Hi Dave, > > Please have a look on what we have done... > > Errors description when running "wdkQuery": > > In the "PostgreSQL.java" file we edited: > > line 117: > String alterSql = "alter table " + tableName + " add i varchar(100)"; > > We changed "number(12)" to "varchar(100)" because in the next line it makes an update and try to insert characters in that field that was "number(12)" then it was only accepting numbers. > > Error: > [poliana@phytomonas gus_home]$ wdkQuery -model toyModel -query > RnaIds.ByDbESTLib -params NumEstLibs 6 AssemblyConsistency 80 > Failed executing sql: > update query_result_2 set i = ('query_result_2_sq') > > org.gusdb.wdk.model.WdkModelException: > org.postgresql.util.PSQLException: ERROR: invalid input syntax for > type numeric: " query_result_2_sq" > > org.gusdb.wdk.model.WdkModelException: > org.postgresql.util.PSQLException: ERROR: invalid input syntax for > type numeric: " query_result_2_sq" > > ---------------------------------------------------------------------------------------------------------------------- > > Yet in the "PostgreSQL.java" file we changed line 56: > > return " select LOCALTIMESTAMP(0)"; to: > > return "LOCALTIMESTAMP(0)"; > > The "select" was removed then postgresql can recognize that. > > ---------------------------------------------------------------------------------------------------------------------- > > In "ResultFactory.java", lines 312 until 346: > > In the following error, it assumes the "nextID" variable as being > "gus.QueryInstance_pkseq" and returns the error because this field should receive a numeric value: we changed the variable to a numeric value (in the script) to test and the data were inserted with success. > > [poliana@phytomonas gus_home]$ wdkQuery -model toyModel -query > RnaIds.ByDbESTLib -params NumEstLibs 6 AssemblyConsistency 80 > Failed executing sql: > insert into gus.QueryInstance (query_instance_id, query_name, cached, > session_id, dataset_name, start_time, param0, param1) values > (gus.QueryInstance_pkseq, 'RnaIds.ByDbESTLib', 1, null, null, now(), > '6', '80') > > org.gusdb.wdk.model.WdkModelException: > org.postgresql.util.PSQLException: ERROR: relation "gus" does not > exist > > org.gusdb.wdk.model.WdkModelException: > org.postgresql.util.PSQLException: ERROR: relation "gus" does not > exist > > ----------------------------------------------------------------------------------------------------------- > After debugging that, we got this: > > [poliana@phytomonas gus_home]$ wdkQuery -model toyModel -query > RnaIds.ByDbESTLib -params NumEstLibs 6 AssemblyConsistency 80 > 92484435 query_result_2_sq > 92484471 query_result_2_sq > 92484523 query_result_2_sq > 92484578 query_result_2_sq > 92484601 query_result_2_sq > 92484678 query_result_2_sq > 92484682 query_result_2_sq > 92484686 query_result_2_sq > 92484695 query_result_2_sq > 92484703 query_result_2_sq > 92484708 query_result_2_sq > 92484710 query_result_2_sq > 92484731 query_result_2_sq > 92484741 query_result_2_sq > 92484752 query_result_2_sq > 92484755 query_result_2_sq > 92484758 query_result_2_sq > 92484764 query_result_2_sq > 92484767 query_result_2_sq > 92484768 query_result_2_sq > 92484772 query_result_2_sq > 92484779 query_result_2_sq > 92484780 query_result_2_sq > 92484801 query_result_2_sq > 92484835 query_result_2_sq > 92484836 query_result_2_sq > 101853404 query_result_2_sq > > So... is the latter the expected output for "wdkQuery" ? If so, then looks like we have lot of debugging to do, if not maybe we are just not invoking/using the commands properly... as usual, any further suggestions are greatly appreciated ;-) > > Alberto > > > -----Original Message----- > From: Dave Barkan [mailto:db...@pc...] > Sent: Tue 1/25/2005 2:05 PM > To: davila > Cc: Steve Fischer; Michael Saffitz; marc jackson; gus...@li...; yo...@de...; pol...@gm...; Linair Maria Campos; Pablo Mendes > Subject: Re: [Gusdev-gusdev] Problem building WDK on Fedora > The wdkXml command is working fine. That means that the provided model > has no errors in it (thank goodness). > > The problem with the following command > >> [poliana@phytomonas gus_home]$ wdkQuery -model toyModel -query >> RnaIds.ByDbESTLib -params NumEstLibs 6 ApiTaxon "Neospora caninum" > > is that ApiTaxon is no longer a paramter used in that query (as the > message indicates). You probably took that command from our wdk > wiki documentation; apparently the command is out of date and will be changed. Sorry about > that! Try running the following command to test wdkQuery: > > % wdkQuery -model toyModel -query RnaIds.ByDbESTLib > -params NumEstLibs 6 AssemblyConsistency 80 > >> Also, may we ask for any further example on how to use the WDK >> utilities ? > > Examples to use the other wdk utilities are provided on the wdk wiki. I > checked them and they are up to date and should work. If you need the > url for that, here it is: > > http://www.gusdb.org/wiki/index.php/Gus%20Wdk%201.1 > > Let me know if there is anything else. > > Thanks, > Dave > > >> >> Thanks, Alberto >> >> >> >> On Thu, 2005-01-20 at 17:45 -0500, Dave Barkan wrote: >>> Hey Alberto, >>> >>> Sorry for the delay on this; it is an issue with the Regression test which >>> we supply with the WDK project. You might be right that it is a problem >>> with the path. I will take a look. >>> >>> For now, failures in the regression test do not necessarily indicate a >>> critical issue with your installation of the WDK, especially if the >>> wdkSanity test works. However, the regression test does need some >>> tweaking to account for recent changes to expected behavior, so I will >>> check it out and report back. >>> >>> Thanks, >>> Dave >>> >>> On Tue, 18 Jan 2005, Alberto Davila wrote: >>> >>>> Thanks Steve ! >>>> >>>> We managed to pass that error. >>>> >>>> Now, when trying "wdkRegressionTest": >>>> >>>> [poliana@phytomonas gus_home]$ wdkRegressionTest >>>> --commandListFile=/usr/local/GUS/gus_home/data/WDKToySite/Model/regressionTest/sampleRegressionTestCommands >>>> >>>> running regression test newCacheTest >>>> >>>> sh: line 1: /newCacheTest.out: Permission denied >>>> diff: /newCacheTest.out: No such file or directory >>>> diff: >>>> /usr/local/GUS/gus_home/data/WDK/ToyModel/regressionTest/expectedResult/newCacheTest.out: >>>> No such file or directory >>>> >>>> Error! Test newCacheTest failed! >>>> The observed result of the test was different than the expected result >>>> of a test previously run. >>>> To see the difference, run diff /newCacheTest.out >>>> /usr/local/GUS/gus_home/data/WDK/ToyModel/regressionTest/expectedResult/newCacheTest.out >>>> >>>> Received error in critical test newCacheTest. Ending regression test >>>> at /usr/local/GUS/gus_home/bin/wdkRegressionTest line 115, <GEN0> line >>>> 3. >>>> >>>> Is the path >>>> "/usr/local/GUS/gus_home/data/WDK/ToyModel/regressionTest/expectedResult/newCacheTest.out" >>>> correct ? Just realized we have this PATH: >>>> "/usr/local/GUS/gus_home/data/WDKToySite/Model/regressionTest" instead. >>>> >>>> Regards, Alberto >>>> >>>> >>>> >>>> At 20:44 17/1/2005, Steve Fischer wrote: >>>>> i think the problem is that we have the oracle driver hard coded. >>>>> >>>>> take a look in $PROJECT_HOME/WDK/Model/bin/wdkCache. >>>>> >>>>> my $cmd = "java -Djdbc.drivers=oracle.jdbc.driver.OracleDriver >>>>> -DconfigDir=$GUS_HOME/config -DcmdName=wdkCache -classpath $CLASSPATH >>>>> org.gusdb.wdk.model.ResultFactory $args"; >>>>> >>>>> as a workaround, in the files in that directory, change to postgres >>>>> drivers. >>>>> >>>>> we'll make it configurable. >>>>> >>>>> you'll also need to write a new class for postrgres. >>>>> >>>>> the Oracle version is: >>>>> >>>>> $PROJECT_HOME/WDK/Model/src/java/org/gusdb/wdk/model/implementation/Oracle.java >>>>> >>>>> you'll need to make a similar class for postgres. then, in the file >>>>> $PROJECT_HOME/WDKToySite/Model/config/toyModel-config.xml >>>>> >>>>> you'll need to refer to that class: >>>>> <modelConfig login="yourLoginHere" >>>>> password="yourPasswordHere" >>>>> connectionUrl="yourConnectionUrlHere" >>>>> queryInstanceTable="QueryInstance" >>>>> maxQueryParams="50" >>>>> platformClass="org.gusdb.wdk.model.implementation.Oracle" >>>>> initialSize="3" >>>>> maxActive="20" >>>>> maxIdle="3" >>>>> minIdle="3" >>>>> maxWait="500"/> >>>>> >>>>> >>>>> >>>>> Alberto Davila wrote: >>>>> >>>>>> Hi Dave, >>>>>> >>>>>> You are right... that output seem to be fine... however we cannot use WDK, >>>>>> here are more logs: >>>>>> >>>>>> [poliana@phytomonas gus_home]$ wdkCache -model toyModel -new >>>>>> >>>>>> Making cache table gus.QueryInstance >>>>>> >>>>>> Failed executing sql: >>>>>> create table gus.QueryInstance (query_instance_id number(12) not null, >>>>>> query_name varchar2(100) not null, cached number(1) not >>>>>> null,result_table varchar2(30), start_time date not null, end_time >>>>>> date, dataset_name varchar2(100), session_id varchar2(50), param0 >>>>>> varchar2(200), param1 varchar2(200), param2 varchar2(200), param3 >>>>>> varchar2(200), param4 varchar2(200), param5 varchar2(200), param6 >>>>>> varchar2(200), param7 varchar2(200), param8 varchar2(200), param9 >>>>>> varchar2(200), param10 varchar2(200), param11 varchar2(200), param12 >>>>>> varchar2(200), param13 varchar2(200), param14 varchar2(200), param15 >>>>>> varchar2(200), param16 varchar2(200), param17 varchar2(200), param18 >>>>>> varchar2(200), param19 varchar2(200), param20 varchar2(200), param21 >>>>>> varchar2(200), param22 varchar2(200), param23 varchar2(200), param24 >>>>>> varchar2(200), param25 varchar2(200), param26 varchar2(200), param27 >>>>>> varchar2(200), param28 varchar2(200), param29 varchar2(200), param30 >>>>>> varchar2(200), param31 varchar2(200), param32 varchar2(200), param33 >>>>>> varchar2(200), param34 varchar2(200), param35 varchar2(200), param36 >>>>>> varchar2(200), param37 varchar2(200), param38 varchar2(200), param39 >>>>>> varchar2(200), param40 varchar2(200), param41 varchar2(200), param42 >>>>>> varchar2(200), param43 varchar2(200), param44 varchar2(200), param45 >>>>>> varchar2(200), param46 varchar2(200), param47 varchar2(200), param48 >>>>>> varchar2(200), param50 varchar2(200)) >>>>>> >>>>>> FAILED >>>>>> >>>>>> org.gusdb.wdk.model.WdkModelException: java.sql.SQLException: No suitable >>>>>> driver >>>>>> at >>>>>> org.gusdb.wdk.model.ResultFactory.createCache(ResultFactory.java:136) >>>>>> at org.gusdb.wdk.model.ResultFactory.main(ResultFactory.java:524) >>>>>> Caused by: java.sql.SQLException: No suitable driver >>>>>> at java.sql.DriverManager.getConnection(DriverManager.java:532) >>>>>> at java.sql.DriverManager.getConnection(DriverManager.java:171) >>>>>> at >>>>>> org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:94) >>>>>> at >>>>>> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) >>>>>> at >>>>>> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) >>>>>> at >>>>>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140) >>>>>> at >>>>>> org.gusdb.wdk.model.implementation.SqlUtils.execute(SqlUtils.java:206) >>>>>> at >>>>>> org.gusdb.wdk.model.ResultFactory.createCache(ResultFactory.java:127) >>>>>> ... 1 more >>>>>> >>>>>> >>>>>> We have the Postgres JDBC installed and its PATH (export >>>>>> CLASSPATH=/usr/local/GUS/gus_home/lib/java/pg74.215.jdbc3.jar) properly >>>>>> set (such as stated in the manual, we have choosen the JDBC version based >>>>>> on jsdk and postgres installed versions), then decided to make a test with >>>>>> the JDBC (just in case...) : >>>>>> >>>>>> [poliana@phytomonas gus_home]$ java -classpath . HelloPostgresql banco >>>>>> user 'senha' >>>>>> hello >>>>>> >>>>>> Connection to PostgreSQL 7.4.6 successful. >>>>>> >>>>>> Executing this command: create table jdbc_demo (code int, text >>>>>> varchar(20)) >>>>>> >>>>>> Executing this command: insert into jdbc_demo values (1,'One') >>>>>> >>>>>> Executing this command twice: insert into jdbc_demo values (3,'Four') >>>>>> >>>>>> Executing this command: update jdbc_demo set text = 'Three' where code = 3 >>>>>> >>>>>> 2 rows were update by this statement >>>>>> >>>>>> >>>>>> >>>>>> Now demostrating a prepared statement... >>>>>> The Statement looks like this: insert into jdbc_demo values (?,?) >>>>>> >>>>>> Looping three times filling in the fields... >>>>>> >>>>>> 10... >>>>>> >>>>>> 11... >>>>>> >>>>>> 12... >>>>>> >>>>>> Now executing the command: select * from jdbc_demo >>>>>> code = 1; text = One >>>>>> >>>>>> code = 3; text = Three >>>>>> >>>>>> code = 3; text = Three >>>>>> >>>>>> code = 10; text = HiHo >>>>>> >>>>>> code = 11; text = HiHo >>>>>> >>>>>> code = 12; text = HiHo >>>>>> >>>>>> Executing this command: drop table jdbc_demo >>>>>> >>>>>> Could it be that the command "wdkCache -model toyModel -new" is trying to >>>>>> build the WDK based on the "Oracle version of GUS" ? We are using the >>>>>> Postgres version built with the scripts from Jeetendra... >>>>>> >>>>>> Thanks in advance for any further help ;-) >>>>>> >>>>>> Cheers, Alberto >>>>>> >>>>>> >>>>>> >>>>>> At 12:50 13/1/2005, Dave Barkan wrote: >>>>>> >>>>>>> Hi Alberto, >>>>>>> >>>>>>> The output that you sent is actually fine! There are no error messages >>>>>>> that I can see, and the output indicates that you built successfully. >>>>>>> The "no existing files, doing nothing" message is a simple statement that >>>>>>> shouldn't concern you. >>>>>>> >>>>>>> Are there any other symptoms that lead you to believe there is a problem >>>>>>> with the build? >>>>>>> >>>>>>> Dave >>>>>>> >>>>>>> On Thu, 13 Jan 2005, Alberto Davila wrote: >>>>>>> >>>>>>>> HI Dave, >>>>>>>> >>>>>>>> Thanks... >>>>>>>> >>>>>>>> I think we made a mistake trying to build "GUS" instead the >>>>>>>> "WDKToySite", then we started again, have a look: >>>>>>>> >>>>>>>> [poliana@phytomonas gus_home]$ build WDKToySite install -append >>>>>>>> >>>>>>>> ant -f /usr/local/GUS/project_home/install/build.xml install >>>>>>>> -Dproj=WDKToySite -DtargetDir=/usr/local/GUS/gus_home -Dcomp= >>>>>>>> -DprojectsDir=/usr/local/GUS/project_home -Dappend=true -logger >>>>>>>> org.apache.tools.ant.NoBannerLogger | grep ']' >>>>>>>> >>>>>>>> [echo] . >>>>>>>> [echo] Installing WDK/Model >>>>>>>> [copy] Copying 13 files to /usr/local/GUS/gus_home/bin >>>>>>>> [mkdir] Created dir: /usr/local/GUS/gus_home/lib/xml >>>>>>>> [copy] Copying 2 files to /usr/local/GUS/gus_home/lib/xml >>>>>>>> [mkdir] Created dir: /usr/local/GUS/gus_home/lib/rng >>>>>>>> [copy] Copying 2 files to /usr/local/GUS/gus_home/lib/rng >>>>>>>> [mkdir] Created dir: /usr/local/GUS/gus_home/lib/perl/WDK/Model >>>>>>>> [copy] Copying 24 files to >>>>>>>> /usr/local/GUS/gus_home/lib/perl/WDK/Model >>>>>>>> [copy] Copying 10 files to /usr/local/GUS/gus_home/lib/java >>>>>>>> [mkdir] Created dir: /usr/local/GUS/gus_home/doc/WDK/Model >>>>>>>> [copy] Copying 9 files to /usr/local/GUS/gus_home/doc/WDK/Model >>>>>>>> [jar] Building jar: /usr/local/GUS/gus_home/lib/java/WDK-Model.jar >>>>>>>> [echo] . >>>>>>>> [echo] IMPORTANT REMINDER: If you have not already done so, >>>>>>>> please copy any .jar needed for database connectivity (such as >>>>>>>> oracle-classes12.jar) into /usr/local/GUS/gus_home/lib/java. The WDK >>>>>>>> does not supply these. See the installation instructions available at >>>>>>>> www.gusdb.org/wdk for details. >>>>>>>> [echo] . >>>>>>>> [echo] . >>>>>>>> [echo] Installing WDK/Controller >>>>>>>> [copy] Copying 3 files to /usr/local/GUS/gus_home/lib/java >>>>>>>> [jar] Building jar: >>>>>>>> /usr/local/GUS/gus_home/lib/java/WDK-Controller.jar >>>>>>>> [echo] . >>>>>>>> [echo] Installing WDK/View >>>>>>>> [copy] Copying 2 files to /usr/local/GUS/gus_home/lib/java >>>>>>>> [concat] No existing files and no nested text, doing nothing >>>>>>>> [echo] . >>>>>>>> [echo] Installing WDKToySite/Model >>>>>>>> [copy] Copying 5 files to /usr/local/GUS/gus_home/config >>>>>>>> [mkdir] Created dir: /usr/local/GUS/gus_home/doc/WDKToySite/Model >>>>>>>> [copy] Copying 1 file to >>>>>>>> /usr/local/GUS/gus_home/doc/WDKToySite/Model >>>>>>>> [mkdir] Created dir: /usr/local/GUS/gus_home/data/WDKToySite/Model >>>>>>>> [copy] Copying 13 files to >>>>>>>> /usr/local/GUS/gus_home/data/WDKToySite/Model >>>>>>>> [concat] No existing files and no nested text, doing nothing >>>>>>>> >>>>>>>> Here is our ".bashrc" file: >>>>>>>> >>>>>>>> [root@phytomonas poliana]# more .bashrc >>>>>>>> # .bashrc >>>>>>>> >>>>>>>> PATH=$PATH:/usr/local/pgsql/bin; export PATH >>>>>>>> PATH=$PATH:/usr/java/j2sdk1.4.2_06/bin; export PATH >>>>>>>> PATH=$PATH:/usr/local/apache-ant-1.6.2/bin; export PATH >>>>>>>> export ANT_HOME=/usr/local/apache-ant-1.6.2 >>>>>>>> export JAVA_HOME=/usr/java/j2sdk1.4.2_06 >>>>>>>> export CATALINA_HOME=/usr/local/jakarta-tomcat-5.0.28 >>>>>>>> export GUS_HOME=/usr/local/GUS/gus_home >>>>>>>> export PROJECT_HOME=/usr/local/GUS/project_home >>>>>>>> export GUS_CONFIG_FILE=$GUS_HOME/.gus.properties >>>>>>>> PATH=$GUS_HOME/bin:$PROJECT_HOME/install/bin:$ANT_HOME/bin:$PATH; export >>>>>>>> PATH >>>>>>>> export PERL5LIB=/usr/local/GUS/gus_home/lib/perl >>>>>>>> >>>>>>>> Here is the software/system we are using: >>>>>>>> >>>>>>>> Ant: apache-ant-1.6.2 >>>>>>>> TomCat: jakarta-tomcat-5.0.28 >>>>>>>> Java: Java(TM) 2 Runtime Environment, Standard Edition (build >>>>>>>> 1.4.2_06-b03) >>>>>>>> Java HotSpot(TM) Client VM (build 1.4.2_06-b03, mixed mode) >>>>>>>> Postgres: postgresql-7.4.6 >>>>>>>> Perl: 5.8.3 >>>>>>>> Fedora Core 1 >>>>>>>> Kernel: 2.4.22-1.2199.nptl >>>>>>>> >>>>>>>> and, we are using the scripts for the "PostgreSQL" version posted by >>>>>>>> Jeetendra (by the way, Jeetendra plugins are working fine, "SubmitRow" >>>>>>>> went OK then just using "LoadTaxon", the load iof the latter is taking >>>>>>>> more than 48 hours ... and still running...) >>>>>>>> >>>>>>>> any further suggestions to debug the WDK install ? >>>>>>>> >>>>>>>> Thanks, Alberto >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> At 13:49 10/1/2005, Dave Barkan wrote: >>>>>>>> >>>>>>>>> Hello, >>>>>>>>> This error message is usually indicative of the build system being >>>>>>>>> unable to connect to your database instance. >>>>>>>>> Make sure that you have configured your $GUS_CONFIG_FILE and your >>>>>>>>> environment variables as detailed in steps 5 and 9 of the GUS >>>>>>>>> installation instructions at >>>>>>>>> http://www.gusdb.org/documentation/install-setup.html >>>>>>>>> Off the top of my head, that is the most likely solution to your >>>>>>>>> problem, but if that doesn't work, I would suggest asking your DBA if >>>>>>>>> they can think of anything regarding your local connection and database >>>>>>>>> instance. >>>>>>>>> Dave >>>>>>>>> On Fri, 7 Jan 2005, davila wrote: >>>>>>>>> >>>>>>>>>> Hi Marc, >>>>>>>>>> We just tried to install the WDK 1.1. by using: >>>>>>>>>> build GUS install -append >>>>>>>>>> then got this errors: >>>>>>>>>> ... >>>>>>>>>> [javac] >>>>>>>>>> /usr/local/GUS/project_home/GUS/Model/src/java/org/gusdb/model/DoTS/AAFamilyExperiment_Table.java:24: >>>>>>>>>> illegal start of expression >>>>>>>>>> [javac] tableAtts.put("modification_date", new >>>>>>>>>> GUSTableAttribute("modification_date", "date", "java.lang.notdefyet", >>>>>>>>>> -1, , -1, false, false) ); >>>>>>>>>> [javac] ^ >>>>>>>>>> [javac] >>>>>>>>>> /usr/local/GUS/project_home/GUS/Model/src/java/org/gusdb/model/DoTS/AAFamilyExperiment_Table.java:24: >>>>>>>>>> ')' expected >>>>>>>>>> [javac] tableAtts.put("modification_date", new >>>>>>>>>> GUSTableAttribute("modification_date", "date", "java.lang.notdefyet", >>>>>>>>>> -1, , -1, false, false) ); >>>>>>>>>> [javac] ^ >>>>>>>>>> [javac] 100 errors >>>>>>>>>> BUILD FAILED >>>>>>>>>> /usr/local/GUS/project_home/install/build.xml:26: The following error >>>>>>>>>> occurred while executing this line: >>>>>>>>>> /usr/local/GUS/project_home/GUS/build.xml:73: The following error >>>>>>>>>> occurred while executing this line: >>>>>>>>>> /usr/local/GUS/project_home/install/build.xml:221: The following error >>>>>>>>>> occurred while executing this line: >>>>>>>>>> /usr/local/GUS/project_home/install/build.xml:240: Compile failed; see >>>>>>>>>> the compiler error output for details. >>>>>>>>>> I saw you got a similar problem and solved it. Could you kindly share >>>>>>>>>> how did you solve that ? >>>>>>>>>> We use: >>>>>>>>>> Java: Java(TM) 2 Runtime Environment, Standard Edition (build >>>>>>>>>> 1.4.2_06-b03) >>>>>>>>>> Java HotSpot(TM) Client VM (build 1.4.2_06-b03, mixed mode) >>>>>>>>>> Apache Ant version 1.6.2 compiled on July 16 2004 >>>>>>>>>> Thanks, Alberto >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> From: marc jackson <dechon@ho...> >>>>>>>>>> Re: problems building gus on redhat linux >>>>>>>>>> 2004-12-17 10:21 >>>>>>>>>> That wasn"t it, but things are resolved. For now. :) >>>>>>>>>> Thanks for your help! >>>>>>>>>> Regards, >>>>>>>>>> Marc >>>>>>>>>> >From: Steve Fischer <sfischer@pc...> >>>>>>>>>> >To: marc jackson <dechon@ho...> >>>>>>>>>> >CC: gusdev-gusdev@li... >>>>>>>>>> >Subject: Re: [Gusdev-gusdev] problems building gus on redhat linux >>>>>>>>>> >Date: Fri, 17 Dec 2004 07:36:37 -0500 >>>>>>>>>> > >>>>>>>>>> >Marc- >>>>>>>>>> > >>>>>>>>>> >i suspect that you haven"t defined the environment variable >>>>>>>>>> >$GUS_CONFIG_FILE. >>>>>>>>>> > >>>>>>>>>> >it should be discussed in the docs. >>>>>>>>>> > >>>>>>>>>> >steve >>>>>>>>>> > >>>>>>>>>> >[sfischer@cottus ~]$ echo $GUS_CONFIG_FILE >>>>>>>>>> >/home/sfischer/.gus.properties >>>>>>>>>> >[sfischer@cottus ~]$ more $GUS_CONFIG_FILE >>>>>>>>>> >databaseLogin=your_login >>>>>>>>>> >databasePassword=your_password >>>>>>>>>> > >>>>>>>>>> >readOnlyDatabaseLogin=your_login >>>>>>>>>> >readOnlyDatabasePassword=your_password >>>>>>>>>> > >>>>>>>>>> >dbiDsn=dbi:Oracle:host=cbilbld.pcbi.upenn.edu;sid=cbilbld >>>>>>>>>> #your >>>>>>>>>> >dsn string here >>>>>>>>>> > >>>>>>>>>> >coreSchemaName=Core >>>>>>>>>> >userName=sfischer #your user name here >>>>>>>>>> >group=CBIL # your group name here >>>>>>>>>> >project=GUS # your project here >>>>>>>>>> >[sfischer@cottus ~]$ >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> >marc jackson wrote: >>>>>>>>>> > >>>>>>>>>> >>Hello, >>>>>>>>>> >> I"m having a problem getting GUS to install/compile. I"ve >>>>>>>>>> been >>>>>>>>>> >>able to configure the database, but when I go to run the >>>>>>>>>> "ga" >>>>>>>>>> >>command to bootstrap in data. it pukes. In working with Ed >>>>>>>>>> >>Robinson, we got to the 2nd build. Specifically: >>>>>>>>>> >> build GUS install -append returns the following error: >>>>>>>>>> >> [exec] Required property "group" must be specified in at >>>>>>>>>> >>/opt/gus/gus_home/lib/perl/CBIL/Util/PropertySet.pm line 53. >>>>>>>>>> >>BUILD FAILED >>>>>>>>>> >>/opt/gus/project_home/install/build.xml:26: The following >>>>>>>>>> error >>>>>>>>>> >>occurred while executing this line: >>>>>>>>>> >>/opt/gus/project_home/GUS/build.xml:190: exec returned: -1 >>>>>>>>>> >> any help would be appreacited. >>>>>>>>>> >> Regards, >>>>>>>>>> >> Marc >>>> >>>> > |