My Oracle Support Banner

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 2.2.0.0.0 to 2.3.0.0.0 [Release 2.2 to 2.3]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms


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.

Setup
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)

Changes

 

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


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