Clarity

Hi Team,

   When I am trying to XOG out a project (only custom info,15.3 version), I am getting "SQL exception error".

Please find below error.

<Record>
<KeyInformation>
<column name="odf_object_code">project</column>
<column name="odf_pk">5009000</column>
</KeyInformation>
<ErrorInformation>
<Severity>FATAL</Severity>
<Description />
<Exception><![CDATA[SQL Exception with error code : 936]]></Exception>
</ErrorInformation>
</Record>
</Records>

And also when I try to save from Project Properties page I got following error.

ErrorError 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

Any suggestions on this issue?

Did you check Logs for detailed error message? It can point to specific problem such as attribute with dynamic look up etc.

In logs ..

ERROR 2018-03-08 05:32:57,189 [http-nio-80-exec-123] object.ODFObjectImpl (clarity:admin:5368050__9418BBC3-66E3-4E33-BB96-2495316B3CCA:projmgr.projectPropertiesPost)
com.niku.union.persistence.PersistenceException: An error occurred getting statement: odf-pmd.catsprjstatusrep.update-child-partition*project*.odf_ca_catsprjstatusrep from resolver.

ERROR 2018-03-08 05:32:57,189 [http-nio-80-exec-123] service.ODFService (clarity:admin:5368050__9418BBC3-66E3-4E33-BB96-2495316B3CCA:projmgr.projectPropertiesPost) processRequest Exception
com.niku.union.odf.exception.ODFException: Error updating subobject partitions project instance

It appears that the error is related to Status Report instances. Are you able to update the status report instances for that specific project?

I am not able to create any status report to any project

I just deleted Status report object and created it again. This fixed the issue. Now I am able to XOG and save the projects without any issue.