[ 
http://jira.dspace.org/jira/browse/DS-366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=10785#action_10785
 ] 

Stuart Lewis commented on DS-366:
---------------------------------

From dspace-tech:

Hi Pierre,
 
we had ORA-01408 and ORA-00942 warnings in the ant fresh-install. The ORA-01408 
were due to the creation of an index on a fiedl with unique key constraint. The 
ORA-00942 warnings are due to an additional whiteline in the creation of the 
table WorkflowItem and TasklistItem. These tables and corresponding views are 
not created by the fresh-install. Consequently creation of collections and 
submissions went wrong. We had to manually create both tables.
 
We are installing DSpace 1.5.2 on Linux SLES with oracle10g.
 
Best wishes,
Francis

> ora-00942 when running ant fresh install and no metadata saved when 
> submitting a naew item
> ------------------------------------------------------------------------------------------
>
>                 Key: DS-366
>                 URL: http://jira.dspace.org/jira/browse/DS-366
>             Project: DSpace 1.x
>          Issue Type: Bug
>    Affects Versions: 1.5.2
>         Environment: Windows server 2003  + Oracle 10g
>            Reporter: Vernédal
>            Priority: Critical
>         Attachments: 3-ant_fresh_install.log
>
>   Original Estimate: 2 weeks
>  Remaining Estimate: 2 weeks
>
> When i submit a new item in a collection, no metadata are saved, even before 
> i have to confirm submission they are shown "null" 
> These metadatas are stored in my database ( METADATAVALUE table ) but are not 
> displayed before confirm submission or when i try to edit the file ( null 
> appear each time ) 
> And "null pointer exception " in dspace.log 
> I noticed that the fresh install processus end with BUILD successfull, 
> dispite "ORA-00942: Table ou vue inexistante" in the log . These "ora- " 
> doesn't come from the database_schema.sql wich has been correctly execute. 
> I have tried the same install with postgresql => everything is correct 
> It seems to be an oracle issue 
> has Anyone faced that issue ? 
> where can i find some statistics about usage of dspace => % of 
> linux/postgresql % of linux/oracle % of Windows/postgresql % of 
> windows/oracle => it would be a way for me to justify postgresql usage ( more 
> supported )
> ( sorry for my english :-(   )

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.dspace.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to