P6 Professional Updates Are Not Reflected in the Cloud Database
(Doc ID 2709997.1)
Last updated on DECEMBER 17, 2020
Applies to:Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 19.3 and later
Information in this document applies to any platform.
Changes made by a user in P6 Professional using the CloudConnect driver with the client-side cache enabled (checked) are not reflected in the Cloud database.
Error in primavera.cacheservice.log
<date time> Information Exception Error received from cloud server: System.Exception: Error from cloud server: ORA-02292: integrity constraint (<username>.FK_PROJWBS_PROJECT) violated - child record found
-- privuser1::80003230 (Primavera.CacheService) -- UTF-8 -- 56E8-9922-fe80::bd13:81c6:761e:3261%9-2470d2c6-0fbc-4e1c-a343-c21b1aa5c064
DB Connection oracle.jdbc.driver.T4CConnection@40f449ed
Request type: EXECUTE_SQL
Command text: delete from <username>.PROJECT where proj_id=nnnnn
Information Info Refreshing data encountered errors.
Information Exception System.Exception: Exception while committing the changes to the database.
Unable to retrieve data from cloud server due to network errors! Please retry action! ---> System.Exception: Unable to retrieve data from cloud server due to network errors! Please retry action!
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!