One or more projects fail to open throwing the following error: "Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator."

Document ID : KB000019484
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

Some projects fail to open throwing the following error: "Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator." Sometimes this occurs post upgrade, but it can happen at other times as well, particularly when a multi value lookup value is changed to a blank value and the old value may still be stuck in the database for the lookup.

The app-ca.log file shows the following error:

ERROR 2013-10-28 13:33:50,494 [http-bio-8080-exec-544] niku.xql2
(clarity:admin:6758105__5E52B4FC-309B-4EA9-9A3B-61C89366163C:projmgr.project
Properties)
Internal Processing exception java.lang.NumberFormatException
at java.math.BigDecimal.<init>(BigDecimal.java:470)
at java.math.BigDecimal.<init>(BigDecimal.java:739)
at
com.niku.odf.object.ObjectInstanceImpl.setupAssocRows(ObjectInstanceImpl.jav
a:304)
at
com.niku.odf.object.ODFAbstractObjectImpl.getMultiValuedAttributeValues(ODFA
bstractObjectImpl.java:2756)
at
com.niku.odf.object.ODFAbstractObjectImpl.readInstance(ODFAbstractObjectImpl
.java:2290)

Environment:

Applies to all supported PAS environments for specified releases.

Resolution:

Query these tables by replacing '?' with the internal ID of the affected project.

select * from inv_investments where id = ?
select * from odf_multi_valued_lookups where id = ?
select * from odf_ca_project where id = ?

The odf_multi_valued_lookups table contains a NULL value for the affected project. Please update the row with the correct value.

If the lookup value is blank, temporarily populate it with a value and save. This can be done by adding the affected attribute to the project list, populating a value for the attribute from the project list, and clicking Save. (Typically, the last modified Multi Value Lookup(s) for the project are the impacted lookups, which can be  found  by running the query: select * from odf_multi_valued_lookups where id = ? .