Error: " TCVirtualDBEngine.RefreshRowsByKey: table=(WBS), Exception=(Field 'wbs_id' not found)" When Attempting to Open a Project in P6 Professional With Client-Side Cache Enabled (Doc ID 2243911.1)

Last updated on MARCH 22, 2017

Applies to:

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

Symptoms

When Attempting to Open a Project in P6 Professional With Client-Side Cache Enabled the following error is observed:

TCVirtualDBEngine.RefreshRowsByKey: table=(WBS), Exception=(Field 'wbs_id' not found), sql=( Select pw.* from project p, projwbs pw where p.proj_id in (
(select distinct tp.pred_proj_id from taskpred tp, projshar ps where tp.pred_proj_id not in (select proj_id from projshar where session_id = 16533) and tp.proj_id = ps.proj_id and session_id = 16533) UNION (select distinct tp.proj_id from taskpred tp, projshar ps where tp.proj_id not in (select proj_id from projshar where session_id = 16533) and pred_proj_id = ps.proj_id and session_id = 16533))
and p.proj_id = pw.proj_id and orig_proj_id is null
)

The following error is noted in the p6cloudconnect log:

Session -1 -- privuser:: (PM.exe) -- UTF-8 -- 4EC9-58C8-10.0.0.166
DB Connection oracle.jdbc.driver.T4CConnection@14a95af0
Request type: UNKNOWN
Command text:
Parameter count: 0
Block count: 335
Avg data block size: 170192 bytes (before compression)
Total data size: 57014529 bytes (before compression)
Total job time spent to push in the queue: 1223 ms
Total job time: 5614 ms (not including compression)

java.lang.ArrayIndexOutOfBoundsException: 101

Session -1 -- privuser:: (PM.exe) -- UTF-8 -- 4EC9-58C8-10.0.0.166 DB
Connection oracle.jdbc.driver.T4CConnection@14a95af0 Request type: UNKNOWN
Command text: Parameter count: 0 Block count: 335 Avg data block size: 170192
bytes (before compression) Total data size: 57014529 bytes (before
compression) Total job time spent to push in the queue: 1223 ms Total job
time: 5614 ms (not including compression)
java.lang.ArrayIndexOutOfBoundsException: 101
at
com.primavera.cloud.worker.Request.updateRequestStatistics(Request.java:257)
at com.primavera.cloud.worker.Request.dispatchRequest(Request.java:369)
at
com.primavera.cloud.worker.Request.processClientRequests(Request.java:84)
at com.primavera.cloud.worker.Worker.processRequests(Worker.java:170)
at com.primavera.cloud.worker.Worker.execute(Worker.java:67)
at
com.primavera.client.CloudClientServlet.doPost(CloudClientServlet.java:189)

STEPS TO REPRODUCE:
1. Log-in to P6 Pro for Cloudconnect with Client-side cache enabled
2. Open project
3. Observe Error

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