I was thinking of checking for  BUDGET_AMT2 in the input-forms.xml file,
but now that I think about it some more, I don't think this file
contains table field names.  And I think your error is indicating that
the code is trying to access a table with a field name of  BUDGET_AMT2,
which like you said doesn't make sense sinse there are no fields by that
name in the database.
 
You may need to put some debug statements in the code to get more info.
Let me think about it a bit more and see if I have any other ideas.
Perhaps some one else in the list will have more help to offer you.
 
-Jose
 

________________________________

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, November 30, 2007 10:38 AM
To: Blanco, Jose; [email protected]
Subject: Re: [Dspace-tech] SQLException When Ingesting Items


Jose,
 
Please bear with me, I am just a lowly Sys Admin down in the basement.
What exactly would I be looking for the input-forms.xml?
 
I have searched every file within the DSpace source (which is 1.4.2 BTW)
for the string budget in either upper or lower case. There is no
reference to that anywhere.
 
--Thanks, Chris
 

        -------------- Original message -------------- 
        From: "Blanco, Jose" <[EMAIL PROTECTED]> 
        
        check your input-forms.xml file.
        
        
________________________________

        From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
        Sent: Friday, November 30, 2007 10:24 AM
        To: [email protected]
        Cc: [EMAIL PROTECTED]
        Subject: [Dspace-tech] SQLException When Ingesting Items
        
        
         
        The environment is:
         
        Solaris 10 Zone
        Tomcat 5.5.23
        Java 1.6.0
        Apache 2.0.59
        Oracle 9.2.0.6
         
        When attempting to ingest items into Dspace the browser displays
the error "Internal System Error"
         
        The DSpace log file contains the error below. The strangest
thing about this error is the refernece to the DB Object BUDGET_AMT2 as
there is no such object within the DSpace schema. This problem is a show
stopper and I am completely stuck.
         
        Any and all help is greatly appreciated.
         
        --Thanks, Chris
         
        "Internal System Error" and the following message is written to
/www/logs/raw/dspace.log :

        2007-11-19 18:28:34,922 WARN
org.dspace.app.webui.servlet.DSpaceServlet @ lucza
[EMAIL PROTECTED]:session_id=82509F072162C9B62D06055336AFD337:ip_addr=130.
14.71.40

        :database_error:java.sql.SQLException: ORA-00904: "BUDGET_AMT2":
invalid identifier

-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell.  From the desktop to the data center, Linux is going
mainstream.  Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to