When Loading Activities Using the P6 Integration API the Error "com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect Syntax Near the Keyword 'order' " Occurs (Doc ID 2454029.1)

Last updated on APRIL 03, 2019

Applies to:

Symptoms

When attempting to use the P6 Integration API to loadActivities, the following error occurs.

ERROR
-----------------------
com.primavera.PhoenixException: DBEngine.executeSelect: {select task_id, count(*) Unread from discussion where not exists (select * from discussion_read where discussion.discussion_id = discussion_read.discussion_id and discussion_read.user_id = ? and discussion.task_id in ((SELECT TOP 1025 task.task_id FROM task WHERE(task.proj_id = 4417) ) order by task.task_id asc)) group by task_id} [91]

Original Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'order'.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Call loadActivities passing the list of fields as Activity.getMainFields()

e.g. lstActs = elm.loadActivities(Activity.getMainFields(), "ProjectObjectId=1234", "Name asc");

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.