My Oracle Support Banner

"Unable to load data. Request sent with invalid data" When Attempting to View Activities in P6Web (Doc ID 2671547.1)

Last updated on JUNE 08, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8.7.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to view activities in P6 web, the following error occurs:

ERROR

Unable to load data
Request sent with invalid data

The following is reported in the P6WebAccess.html file:

[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/activities/gridData/load (User Id: XXX DB Id: 1) com.primavera.rest.common.exception.RemoteDataErrorResponseExceptionMapper ?:? Unable to load data for activities
com.primavera.bo.remoting.RemoteDataException: Unable to load data for activities
  at com.primavera.lwfsupport.activities.ActivitiesLWFDataLoader.load(ActivitiesLWFDataLoader.java:750)
  at com.primavera.rest.service.activities.ActivitiesServiceImpl.loadGridData(ActivitiesServiceImpl.java:606)
  ...
  Caused by: com.primavera.bo.base.DBEngineException: DBEngine.executeSelect() error while executing: {SELECT DISTINCT task.task_id, (select task2.task_code from task task2 where task2.task_id = taskpred.pred_task_id) task_code, (select task2.task_id from task task2 where task2.task_id = taskpred.pred_task_id) task_id_1, lag_hr_cnt, pred_type FROM task, taskpred, (select proj_id from project where orig_proj_id is null) p WHERE p.proj_id = taskpred.pred_proj_id AND taskpred.task_id=task.task_id AND EXISTS (SELECT TOP 5001 task.task_id FROM projwbs alias_projwbs,calendar,project,projwbs,task LEFT OUTER JOIN discussion ON task.task_id=discussion.task_id,(TASK uf940 LEFT OUTER JOIN udfvalue uv940 ON (uf940.task_id=uv940.fk_id AND uv940.udf_type_id=940)),(task task1388 LEFT OUTER JOIN taskactv taskactv1388 ON task1388.task_id=taskactv1388.task_id AND task1388.proj_id=taskactv1388.proj_id AND taskactv1388.actv_code_type_id=1388 LEFT OUTER JOIN actvcode actvcode1388 ON taskactv1388.actv_code_id=actvcode1388.actv_code_id) t1 WHERE t1.task_id=task.task_id and task.proj_id=alias_projwbs.proj_id AND alias_projwbs.proj_node_flag='Y' AND task.task_id=task1388.task_id AND task1388.proj_id=task.proj_id AND task.proj_id=project.proj_id AND (task.wbs_id=projwbs.wbs_id AND task.proj_id=projwbs.proj_id) AND uf940.task_id=TASK.task_id AND task.clndr_id=calendar.clndr_id AND (( (UPPER(task.status_code) <> UPPER('TK_Complete') OR task.status_code IS NULL ) AND ( UPPER(uv940.udf_text) LIKE UPPER('%Klas%') OR actvcode1388.actv_code_id = 35105 ) )) AND task.proj_id IN (select proj_id from projshar where session_id = ?)) ORDER BY 1,2}
  [4552]--Incorrect syntax near 't1'.
  at com.primavera.bo.base.DBEngineImpl.executeSelect(DBEngineImpl.java:1111)
  at com.primavera.bo.base.DBEngineImpl.executeSelect(DBEngineImpl.java:946)
  at com.primavera.bo.base.DBEngineImpl.executeSelect(DBEngineImpl.java:941)
  ...
  Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 't1'.
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:440)
  ...

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
Cause
Solution
References


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