Warning In P6WebAccess.html Log: "Bound SQL Exception: java.lang.Exception: SQL SELECT STATEMENT" (Doc ID 1629104.1)

Last updated on MARCH 10, 2014

Applies to:

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

Symptoms

 When loading the activity applet in P6 when connecting to a SQL Server database, the follownig WARN message is written to the P6WebAccess.html log file:

########### BOUND SQL EXPECTED ############
java.lang.Exception: SQL SELECT STATEMENT
[number value]
     at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
     at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
     at com.primavera.bo.base.LDBEngineImpl.selectObjects(Unknown Source)
     at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
     at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
     at com.primavera.bo.rules.calc.ActivityCE.calc_ProjectWbsId(Unknown Source)
     at com.primavera.bo.schema.dispatch.ActivityCEDispatch.dispatch(Unknown Source)
     at com.primavera.bo.rules.calc.ActivityCE.dispatch(Unknown Source)
     at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
     at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
     at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
     at com.primavera.bo.base.server.ServerDAOImpl.loadPrmRowSet(Unknown Source)
     at com.primavera.bo.base.server.ServerActivityDAO.loadPrmRowSet(Unknown Source)
     at com.primavera.bo.remotable.ReqMgr.getObjects(Unknown Source)
     at com.primavera.bo.remotable.qproxy.ReqMgr.getObjects(Unknown Source)
     at com.primavera.bo.DBReqMgr.getObjects(Unknown Source)
     at com.primavera.bo.base.client.ClientDAOImpl.load(Unknown Source)
     at com.primavera.bo.base.client.ClientDAOImpl.load(Unknown Source)
     at com.primavera.guisupport.activities.data.ActivitiesDataLoader.loadActivities(Unknown Source)
     at com.primavera.guisupport.activities.data.ActivitiesDataLoader.loadActivities(Unknown Source)
     at com.primavera.guisupport.activities.data.ActivitiesDataLoader$1.execute(Unknown Source)
     at com.primavera.guisupport.activities.data.ActivitiesDataLoader$1.execute(Unknown Source)
     at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
     at java.lang.Thread.run(Thread.java:722)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms