Error: "PRMDB-0353-5: PRM DBAccess Error: Error executing query. Error: SQL statement to execute cannot be empty or null" When Restoring Baseline With Client Side Cache Enabled

(Doc ID 2311635.1)

Last updated on OCTOBER 09, 2017

Applies to:

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

Symptoms

Restoring a baseline in P6 Professional with Client Side Cache enabled throws the following exception:

*****************************************************
* EXCEPTION REPORT *
*****************************************************
Date: 09-26-17 12 AM

Executable: PM.exe
Application: Primavera P6 Professional 17
Event Code: PRMDB-0353-5
Message:
PRM DBAccess Error: Error executing query. Error: SQL
statement to execute cannot be empty or null

-- privuser::siva (PM.exe) -- UTF-8 -- 2EA1-C5A5-
192.168.122.240
DB Connection
oracle.jdbc.driver.T4CConnection@3ea9bf60
Request type: EXECUTE_SQL
Command text:
Parameter count: 0
Block count: 0
Total data size: 0 bytes (before compression)
Total job time spent to push in the queue: 0 ms
Total job time: 0 ms (not including compression)
.

Context:
1: TDevxMainForm.actProjectBaselineMaintainExecute
2: TDevxMainForm.BeforeFormShow
3: TfrmEPS.mnuOpenProjectClick
4: TCFormManager.SetToolbar
5: TDevxMainForm.BeforeFormShow
6: TfrmLogin.FormCreate
7:
8:
9:
10:

Detail:
Type: EprmDBSQLExecutionFailure
Object Type: TCUltraButton

Database Error:
Error Code: 0

System Info
===========
Username: sinagire Hostname: SLC05ENY
OS Version: Windows NT ver 6.2, build 9200, ((unknown))

Changes

 

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