SQL Error 156 For Algorithm IPFCRAGG (MS SQL Server)

(Doc ID 848099.1)

Last updated on AUGUST 19, 2009

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.2.0 to 2.3.0
This problem can occur on any platform.


SQL error 156 occurs when using the data derivation algorithm IPFCRAGG. SQL Error Code 156 in

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


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms