Projects Open up Blank in MSP due to an Incorrectly Formatted NSQL Query

Document ID : KB000123015
Last Modified Date : 13/12/2018
Show Technical Document Details
Issue:
When exporting a project from PPM to MSP, MSP opens a blank mpp file with the project ID. The error in the app-ca logs contain the following: 

ERROR 2018-11-16 07:44:13,802 [http-nio-14001-exec-34] niku.xql2 (clarity:admin:13146948__D36E2B32-5AB6-4D09-983D-6B27D0AC1357:schedulers.getProject) SQLException with query: .....

ERROR 2018-11-16 07:44:13,803 [http-nio-14001-exec-34] niku.schedulers (clarity:admin:13146948__D36E2B32-5AB6-4D09-983D-6B27D0AC1357:schedulers.getProject) Error during GetProjectRequest 
java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00907: missing right parenthesis 
Resolution:
These errors indicate that there are spaces missing in the NSQL of a custom lookup. The query used by the NSQL will be included in the first error after 'SQLException with query:'.

Once the NSQL is corrected, the projects will open in MSP including all tasks as expected.