Receives “Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator” when trying to open a Project

Document ID:  TEC1809966
Last Modified Date:  06/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA PPM

Releases

  • CA PPM:Release:14.4

Components

  • CA PPM PROJECT MANAGEMENTINTERNAL ONLY:PPRPRM
  • CA PPM SAAS PROJECT MANAGEMENT INTERNAL ONLY:ODPRM
Problem:

Can not open Project after removing the value of an Attribute Type Multi-Value Lookup with NSQL.


If Project Object has an attribute Type Multi-Value Lookup that use a Dynamic Lookup:
- when you populate the attribute the record is added into odf_multi_valued_lookups table
- when you remove the value of the attribute, the value in the table is set to NULL and the record is not deleted from odf_multi_valued_lookups table. Due to that, you can not open the Project and get Error 500 - Internal Server Error.


Steps to Reproduce:

1.    In Project Object create an Attribute Type Multi-Value Lookup ('my_mvl_resource'). Associated it with ootb lookup " Resource browse" (ID=SCH_BROWSE_RESOURCE)
2.    Go to Admin side. Go to project List. Add column of mvl created in step 1
3.    Open any project. Confirm it opens fine
4.    Get the ID of the project from the URL, ex: 5024003
Run query:
SELECT * from odf_multi_valued_lookups where attribute='my_mvl_resource' and pk_id=5024003
It doesn't return any row because the field has not been populated.
5.    In project list populate the value of the MVL for that project. Save.
6.    Run again the query:
SELECT * from odf_multi_valued_lookups where attribute='my_mvl_resource' and pk_id=5024003
> 1 row was inserted. Value is the ID of the selected resource
7.    In project list remove the value of the MVL for that project. Save.
8.    Run again the query:
SELECT * from odf_multi_valued_lookups where attribute='my_mvl_resource' and pk_id=5024003
Row was updated. Value is NULL
9.    Try to open the Project again.

Expected Result: 
You should be able to open the project after removing the value of the Attribute Type Multi-Value Lookup.

Actual Result: 
You can not open the Project. You get “Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator”.

Cause:

Caused by CLRT-81345

Resolution:

Closed. Defect is not reproducible on CA PPM v15.1

Additional Information:

app log shows:

 

ERROR 2016-09-16 12:33:44,631 [http-nio-14001-exec-20] web.WebActionController (clarity:admin:30916280__A6196805-F7B5-4EDC-BF35-2C02B7C0684C:projmgr.projectProperties)
com.niku.union.web.WebException: Service call failed for portlet: projmgr.projectPropertiesTOC
at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:932)
at

Caused by: com.niku.union.web.WebException: WebServiceAdapter::processRequest -> failed to process service request
at

Caused by: com.niku.union.service.ServiceException: Service Exception
a

Caused by: com.niku.union.odf.exception.ODFException: Exception occurred loading property view for view locator view: object:project component:projmgr
at

Caused by: com.niku.union.odf.exception.ODFException: Unable to evaluate display condition for code:project.fsv_general
at

Caused by: java.lang.NumberFormatException
at java.math.BigDecimal.<init>(BigDecimal.java:494)
at

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing