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
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.