My Oracle Support Banner

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:

Primavera P6 Professional Project Management - Version 8.3.2.0 to 15.2.0.0 [Release 8.3 to 15.2]
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Workaround:
References


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