After upgrade to OAS - Call SAPurgeAllCache() from Direct Database Query Analysis throws error
(Doc ID 2971260.1)
Last updated on SEPTEMBER 21, 2023
Applies to:
Oracle Analytics Server - Version 2022 (6.4) and laterInformation in this document applies to any platform.
Symptoms
In OAS, an analysis created using Direct Database Query option and issues the SQL "Call SAPurgeAllCache();". When running this analysis, it fails with driver error like below:
When you use SAPurgeAllCache() from IssueSQL window, it works fine.
Changes
Upgraded to OAS 6.4 from OBIEE 12c
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 |