Thanks Jim: After checking the schema of table "dcvalue," I found that the indexes of "dcvalue_pkey" and "dcvalue_item_idx" were lost, somehow after the duplication of dcvalue table. Now the submit process works well, I can upload new items now. Thanks again for all your help~
Best regards, Feng-chien 2007/2/6, Jim Downing <[EMAIL PROTECTED]>: > Hi Feng-chien, > > Feng-chien Chung wrote: > > We were running DSpace 1.3.2 on the redhat linux platform over > > postgreSQL 7.4.3 database with Tomcat server 4.1.27. We have encounter > > some "Internal Server Error" problem when trying to submit a new item > > to a collection. At Step2, just after finish filling the first form > > cantains the fields: Authur, Title, ISSN...etc. Please refer the > > Error log attached later in the end of mail. > <snip/> > > The database part we made a copy table of "dcvalue"(and named it > > dcvalue2), structure only, and import the data we saved, then drop the > > original dcvalue table, and rename the copy table(dcvalue2) back to > > "dcvalue" The system works well when we tried to modify or add > > metadata to the items already exist(uploaded before the system crash), > > but when we try to submit new items, it comes out an Internal Server > > Error. > > > > Do you have any idea that is the error have some relation to the > > recovery process(maybe improper), or is it caused by some other reason > > or configuration? > > Thanks for all your help~ > > > <snip/> > > java.lang.NullPointerException > > at org.dspace.storage.rdbms.TableRow.canonicalize(TableRow.java:549) > > at org.dspace.storage.rdbms.TableRow.hasColumn(TableRow.java:107) > > at org.dspace.storage.rdbms.TableRow.setColumn(TableRow.java:426) > > at > > org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:507) > > at > > org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:314) > > at org.dspace.content.Item.update(Item.java:1291) > > at org.dspace.content.WorkspaceItem.update(WorkspaceItem.java:469) > > > > It's tricky to pinpoint, because the source line numbers in your trace > don't relate to the code that's tagged to the 1.3.2 release, but it > looks like it's failing to find a table or else it can find the table > but not the primary key column. > > Given the problems you've had with the dcvalue table, it seems a likely > suspect - check that it's there ;-) and that the schema is correct: - > > dspace132tmp=# \d dcvalue > Table "public.dcvalue" > Column | Type | Modifiers > -------------+-----------------------+----------- > dc_value_id | integer | not null > item_id | integer | > dc_type_id | integer | > text_value | text | > text_lang | character varying(24) | > place | integer | > source_id | integer | > Indexes: > "dcvalue_pkey" PRIMARY KEY, btree (dc_value_id) > "dcvalue_item_idx" btree (item_id) > Foreign-key constraints: > "dcvalue_dc_type_id_fkey" FOREIGN KEY (dc_type_id) REFERENCES > dctyperegistry(dc_type_id) > "dcvalue_item_id_fkey" FOREIGN KEY (item_id) REFERENCES item(item_id) > > HTH. > > Best regards, > > jim > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier. > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
