|
From: Robert O. <ol...@mc...> - 2005-07-06 16:03:14
|
I'm seeing a similar problem; this is with postgresql 8.0 on a mac =20
running Tiger.
gus.config info about the db:
dbiDsn=3DDBI:Pg:dbname=3Dgus;port=3D10001
jdbcDsn=3Djdbc:postgresql://localhost:10001/gus?user=3Dgus&password=3Dgus
# Login and Password to the RDBMS
databaseLogin=3Dgus
databasePassword=3Dgus
I didn't see any errors on the load, and there's a bunch of stuff in =20
the database; however, I don't see a core.algorithm_row table that =20
perhaps is what is trying to be used:
gus=3D> \dn
List of schemas
Name | Owner
--------------------+-------
core | gus
corever | gus
dots | gus
dotsver | gus
information_schema | olson
pg_catalog | olson
pg_toast | olson
prot | gus
protver | gus
public | olson
rad | gus
radver | gus
sres | gus
sresver | gus
study | gus
studyver | gus
tess | gus
tessver | gus
(18 rows)
gus=3D> \dt core.
List of relations
Schema | Name | Type | Owner
--------+-------------------------+-------+-------
core | algorithm | table | gus
core | algorithmimplementation | table | gus
core | algorithminvocation | table | gus
core | algorithmparam | table | gus
core | algorithmparamkey | table | gus
core | algorithmparamkeytype | table | gus
core | analysisalgorithm | table | gus
core | category | table | gus
core | databasedocumentation | table | gus
core | databaseinfo | table | gus
core | databaseversion | table | gus
core | groupinfo | table | gus
core | projectinfo | table | gus
core | tablecategory | table | gus
core | tableinfo | table | gus
core | usergroup | table | gus
core | userinfo | table | gus
core | userproject | table | gus
(18 rows)
gus=3D> select table_id, name from core.tableinfo where name like '%=20
Algorith%';
table_id | name
----------+----------------------------
592 | AnalysisAlgorithmVer
593 | AlgorithmInvocationVer
594 | AlgorithmParamKeyVer
596 | AlgorithmParamVer
604 | AlgorithmImplementationVer
605 | AlgorithmVer
606 | AlgorithmParamKeyTypeVer
701 | AlgorithmInvocation
702 | Algorithm
704 | AnalysisAlgorithm
706 | AlgorithmParamKeyType
707 | AlgorithmParam
713 | AlgorithmImplementation
714 | AlgorithmParamKey
(14 rows)
errors follow.
Thanks,
--bob
[exec] Warning: No JavaType found for 'modification_date', =20
type: 'timestamp'
[exec] Warning: No JavaType found for 'modification_date', =20
type: 'timestamp'
[copy] Copying 2 files to /Users/olson/GUS/project_home/GUS/=20
Model/src/java/org/gusdb/model/DoTS
[copy] Copying 1 file to /Users/olson/GUS/project_home/GUS/=20
Model/src/java/org/gusdb/model/SRes
[echo] Starting target: JavaModel
[mkdir] Created dir: /Users/olson/GUS/gus_home/schema
[echo] .
[echo] Installing GUS/Model
[copy] Copying 2 files to /Users/olson/GUS/gus_home/bin
[copy] Copying 1546 files to /Users/olson/GUS/gus_home/lib/perl/=20=
GUS/Model
[mkdir] Created dir: /Users/olson/GUS/project_home/GUS/Model/=20
classes
[javac] Compiling 1260 source files to /Users/olson/GUS/=20
project_home/GUS/Model/classes
[javac] /Users/olson/GUS/project_home/GUS/Model/src/java/org/=20
gusdb/model/Core/Algorithm_Row.java:86: cannot resolve symbol
[javac] symbol : class notdefyet
[javac] location: class org.gusdb.model.Core.Algorithm_Row
[javac] public void setModificationDate (notdefyet value)
[javac] ^
[javac] /Users/olson/GUS/project_home/GUS/Model/src/java/org/=20
gusdb/model/Core/Algorithm_Row.java:91: cannot resolve symbol
[javac] symbol : class notdefyet
[javac] location: class org.gusdb.model.Core.Algorithm_Row
[javac] public notdefyet getModificationDate () { return =20
(notdefyet)get_Attribute("modification_date"); }
[javac] ^
[javac] /Users/olson/GUS/project_home/GUS/Model/src/java/org/=20
gusdb/model/Core/AlgorithmInvocation_Row.java:54: cannot resolve symbol
On Jul 4, 2005, at 12:51 AM, Michael Saffitz wrote:
>
> Hi Fabricio,
>
> This is usually indicative that the schema was not properly loaded =20
> into the
> RDBMS. Can you review the output from the very first run (when you =20=
> did
> -installDBSchema) to confirm there were no SQL errors? Can you =20
> connect to
> your DB and confirm that the objects exist-- especially that the
> core.tableinfo table is fully populated.
>
> If the DB was not fully installed, you must resolve the issue =20
> preventing
> installation, and then remove all GUS objects that may have been =20
> partially
> created (i.e. Users/schemas, tables, sequences, etc.) Then you can =20=
> try
> again. (I believe this is outlined in the install docs).
>
> If all of the objects are being fully installed, then it may be =20
> that your
> jdbc connection string has different settings than your perl =20
> connection
> string. Make sure that your $GUS_CONFIG_FILE has the correct =20
> dbiDsn for
> your database.
>
> Let me know how the above goes and we'll figure out the next step.
>
> --Mike
>
> On 7/3/05 10:18 PM, "Fabr=EDcio" <fab...@de...> wrote:
>
>
>> Hello all,
>>
>>
>>
>> We=92re trying to install the new GUS 3.5 release, and we=92re having =
=20
>> a problem
>> when we have to run =93build GUS install -append -installDBSchema=94. =
=20
>> After a
>> time running the building process stops whit many errors like this:
>>
>>
>>
>> [javac]/usr/local/GUS/GUS35/project_home/GUS/Model/src/java/org/=20
>> gusdb/model/
>> Core/AlgorithmInvocation_Row.java:99: cannot resolve symbol
>> [javac]symbol : class notdefyet
>> [javac]location: class org.gusdb.model.Core.AlgorithmInvocation_Row
>> [javac]public notdefyet getModificationDate () { return
>> (notdefyet)get_Attribute("modification_date"); }
>> [javac] ^
>>
>>
>>
>> Despite these errors, the schema was generated in our postgres, =20
>> but we don=92t
>> know if it=92s complete.
>>
>>
>>
>> We tried to build again using only the command =93build GUS install =96=
=20
>> append=94
>> and we put the output in a file as you can see here:
>>
>>
>>
>> http://www.de9.ime.eb.br/~fabricio/out.txt
>>
>>
>>
>> Can you tell us why the notdefyet class isn=92t found?
>>
>>
>>
>> Thanks a lot,
>>
>>
>>
>> Fabr=EDcio.
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=3Dclick
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>
>
|