ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

16.0.1 Postupgrade APP Error: com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_UNKNOWN_SEC_OBJECT, Info: EVCONTRACT

book

Article ID: 237206

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

When accessing Agencies, Contracts or Control Accounts, instead of displaying the menu,

It instead displays the error : Error 501 - Not Implemented

image.png

In one reported case study, the following error is reported in the APP log after upgrade to 16.0.1:

com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_UNKNOWN_SEC_OBJECT, Info: EVCONTRACT
 at com.niku.union.persistence.nsql.handlers.SecurityHandler.handleMatch(SecurityHandler.java:65)
 at com.niku.union.persistence.nsql.Utils.parse(Utils.java:142)
 at com.niku.union.persistence.nsql.NSQLStatementSet.parseNSQL(NSQLStatementSet.java:722)
 at com.niku.union.persistence.nsql.NSQLStatementSet.<init>(NSQLStatementSet.java:228)
 at com.niku.union.persistence.nsql.NSQLStatementSet.<init>(NSQLStatementSet.java:132)

Cause

The Earned Value Management Add-in is no longer supported.

 

Environment

Release : 16.0.1

 

Resolution

This is reported as DE64538.

Workaround

Option 1: If EVMS objects are no longer required or needed, XOG out the information.
XOG EVM Information

Option 2:
Review the installation folders created from the upgrade installation.

1. Make a copy of the current Clarity install folder.
2. Copy the clarity_15.9.3.740\META-INF\evms folder to the current installation \evms folder.
3. Copy the clarity_15.9.3.740\lib\evms.jar file to the current installation \lib folder
4. Copy all evms_*.properties files from the clarity_15.9.3.740\resource folder to the current installation\resource folder.
5. Restart the APP services

 

Additional Information

Further issues encountered:

1. Getting caption issues.

[en - Agencies]
[en - Contracts]
[en - Control+Accounts]

2. Unable to bring up instances:

Contract: test1 - Properties - [en - Main] - Error 500 - Internal Server Error

APP logs show issues with each object clicked

ERROR 2022-03-24 14:19:27,624 [http-nio-80-exec-7] xbl.ODFObjectQueryHandler (clarity:admin:session:odf.objectProperties) ODF could not retrieve object: evagency
ERROR 2022-03-24 14:19:27,640 [http-nio-80-exec-7] niku.xql2 (clarity:admin:session:odf.objectProperties) Invalid XML datasource C:\1570\clarity\META-INF\evms\config\evmsDescriptor.xml
ERROR 2022-03-24 14:19:27,640 [http-nio-80-exec-7] niku.xql2 (clarity:admin:session:odf.objectProperties) Invalid data source caused by source xml:C:\1570\clarity\META-INF\evms\config\evmsDescriptor.xml name compDescriptor
ERROR 2022-03-24 14:19:27,640 [http-nio-80-exec-7] niku.xql2 (clarity:admin:session:odf.objectProperties) Internal Processing exception
com.niku.xql2.XQLDataSourceException: Invalid XML datasource C:\1570\clarity\META-INF\evms\config\evmsDescriptor.xml


ERROR 2022-03-25 17:04:09,929 [http-nio-80-exec-8] web.WebActionController (clarity:admin:session:evms.evContractProperties) 
com.niku.union.web.WebException: Service call failed for portlet: evms.evContractProperties

ERROR 2022-03-25 17:08:55,718 [http-nio-80-exec-12] niku.union (clarity:admin:session:evms.controlAccountList) The resource bundle evms_view could not be found

Attachments