search cancel

Clarity PPM: Post Upgrade OOTB NSQL Query Invalid

book

Article ID: 188409

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

After upgrading to the latest version of Clarity, the INSTALL_FOLDER\checkinstall\check-logs\postcheck-results.html  
show invalid queries. For example,

check-invalid-nsql.xml
WARNING
Invalid NSQL queries were found in the database. You must correct those invalid NSQL queries.
Please see the <C:\INSTALL_FOLDER\checkinstall\check-logs/invalid_nsql_queries.txt file for invalid NSQL queries and the procedure to correct them.

The following NSQL Queries are invalid : 
Query name=Data Warehouse Audit(ID=cop.admDWHAudit)
Query name=Data Warehouse Error(ID=cop.admDWHError)
Query name=Issues Listing(ID=cop.issuesListingLinkable)
Query name=Project Status Issues(ID=csp.prjStatusIssues)

 

Resolution

The parsing/detection is inaccurate, hence the incorrect information in the post check and invalid_nsql_queries.txt file.
The post check warning can be ignored as there is no issue with the upgrade.

Attachments