SQL Error 156 For Algorithm IPFCRAGG (MS SQL Server)
(Doc ID 848099.1)
Last updated on MARCH 19, 2019
Applies to:Oracle Utilities Customer Care and Billing - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 2.2 to 2.3]
Information in this document applies to any platform.
This problem can occur on any platform.
SQL error 156 occurs when using the data derivation algorithm IPFCRAGG. SQL Error Code 156 in
CIPISAGX XQ010 SELECT.
-- Steps To Reproduce:
The intention of this setup was to produce a curve from the interval registers. This was done by
setting up a new Interval Profile type that uses the Algorithm IPFCRAGG.
From the SA Page, the Derive Interval Data button is clicked.
Error encountered during processing.
Interval Profile Type (new)
Add above to existing Interval Profile rel type
SA Type E-INTREG has Interval Profile Relationship Type = KWH CON
Using SA below, added Interval Profile Rel type for KWH CON
New Interval Profile ID (blank)
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