ARCHIVED QUOTES NOT GETTING DELETED AFTER THE VALUE SET FOR CLEANING UP ARCHIVED IS PASSED
(Doc ID 3057385.1)
Last updated on NOVEMBER 07, 2024
Applies to:
Oracle BigMachines CPQ Cloud Service - Version 23 B Patch 5 and laterInformation in this document applies to any platform.
Symptoms
When many quotes are archived simultaneously, and the archive date for these quotes exceeds the configured archive expiration days limit, the cleanup job fails to remove the archives as expected.
An error message such as below will appear in the bm.log file:
"Caused by: oracle.jdbc.OracleDatabaseException: ORA-01745: invalid host/bind variable name"
A similar issue may occur if quotes are archived with an initial archive expiration days setting (e.g., 30 days), but this setting is later reduced to a lower value (e.g., 10 days) before the initially archived quotes are deleted.
Changes
The archive expiration days setting got changed on the site before the current set of archived quotes are deleted.
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 |
| Changes |
| Cause |
| Solution |
| References |