Re: [GUSDEV] Re: GUS 3.5 installation failure

[Jian Lu <jl...@vb...>]

I have modified gus_schema.xml for different tableapaces and commented 
that line of Java code. The installation is successful.

Michael Saffitz wrote:

>You'll also need to comment out line 95 in
>$PROJECT_HOME/GUS/Schema/src/java/org/gusdb/schema/InstallSchemaTask.java
>
>This is experimental and "not supported"
>
>Just out of curiosity, why do you want more than one tablespace?
>
>--Mike
>
>
>On 6/27/05 3:38 PM, "Jian Lu" <jl...@vb...> wrote:
>
>  
>
>>Yes, that is only change I made. Before I had ant 1.6.4.
>>
>>So if I modify the gus_shema.xml for different tablespaces, the
>>installation will skip tablespace defined in gus.config. Is that right?
>>
>>
>>Michael Saffitz wrote:
>>
>>    
>>
>>>Hi Jian,
>>>
>>>That's very strange-- I'm running with ant 1.6.2 here without issue.  Just
>>>to confirm-- the only change you made was to move to ant 1.6.5?
>>>
>>>GUS 3.5 by default installs into a single tablespace (as defined in the
>>>gus.config file).  If you want it to install into more than one, you'd need
>>>to update the gus_schema.xml to use the proper tablespaces for the relevant
>>>objects, and comment out the lines in the DBAdmin sources that do tablespace
>>>name translation.
>>>
>>>If having more than one tablespace is a feature you'd like, submit a feature
>>>request in the issue tracker.
>>>
>>>Also, since you had a failed install, you'll need to make sure that any
>>>objects that were created (i.e. Users) are deleted before trying again.
>>>
>>>I'll create an issue to make sure that the documentation is updated to
>>>include more details about configuring the tablespaces.
>>>
>>>--Mike
>>>
>>>On 6/27/05 3:17 PM, "Jian Lu" <jl...@vb...> wrote:
>>>
>>> 
>>>
>>>      
>>>
>>>>I ran installation again under apache-ant 1.6.5. It went through for
>>>>schema installation. I had the following error:
>>>>
>>>>[InstallSchema] INFO: Writing Database
>>>>
>>>>BUILD FAILED
>>>>/home/brcgusts/GUS/project_home/install/build.xml:28: The following
>>>>error occurred while executing this line:
>>>>/home/brcgusts/GUS/project_home/GUS/build.xml:92: java.io.IOException:
>>>>Error executing SQL: '
>>>>ALTER USER PROT QUOTA UNLIMITED ON GUS' Error: ORA-00959: tablespace
>>>>'GUS' does not exist
>>>>
>>>>It sounds like looking for tablespace called GUS which defined within
>>>>gus.config file:
>>>>
>>>># Username, group, and project info from the relevant Core tables
>>>>
>>>>userName=$ENV{USER}
>>>>group=dba
>>>>project=GUS
>>>>
>>>>tablespace=GUS
>>>>
>>>>My question: does GUS 3.5 uses only one tablespace called GUS? As I
>>>>know, GUS 3.0 has at least 12 tablespaces. Please clarify it. Thanks.
>>>>
>>>>
>>>>
>>>>-------------------------------------------------------
>>>>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_id=7477&alloc_id=16492&op=click
>>>>_______________________________________________
>>>>Gusdev-gusdev mailing list
>>>>Gus...@li...
>>>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>>   
>>>>
>>>>        
>>>>
>>> 
>>>
>>>      
>>>
>
>  
>