Market Message Portal Issue - UNIION ALL
(Doc ID 2767336.1)
Last updated on AUGUST 16, 2024
Applies to:
Oracle Utilities Framework - Version 4.4.0.3.0 to 4.4.0.3.0 [Release 4.4]Information in this document applies to any platform.
Goal
Market Message Portal Issue - UNION ALL
Market Message Portal Issue - When we search for Market Message using
Market Message Type throws an error because of the generation of issue.
This issue exists only in the cloud environment. It works in an On-Premise environment
UNION ALL keyword is being converted to UNIONALL by CustomSQL Parser
Steps to replicate:-
1.Create a custom zone(CM), use UNION ALL in zone query.
2.Attach the zone to the portal.
3.Navigate to the Portal and go to the Zone.
NOTE:
spl.runtime.customSQLSecurity property should be enabled to be able to recreate the issue
Actual output: Error Message Number 11007,11013
Expected output: no error should not be encountered
Solution
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
Goal |
Solution |
References |