My Oracle Support Banner

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 JULY 25, 2019

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 = XXXXX) and tp.proj_id = ps.proj_id and session_id = XXXXX) 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 = XXXXX) and pred_proj_id = ps.proj_id and session_id = XXXXX))
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-XX.X.X.XXX
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-XX.X.X.XXX 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

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.