My Oracle Support Banner

Market Message Portal Issue - UNIION ALL (Doc ID 2767336.1)

Last updated on OCTOBER 26, 2022

Applies to:

Oracle Utilities Customer Cloud Service - Version 20C and later
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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.