Unable to Upload Interval Data With Versioning Enabled (Doc ID 785850.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle Utilities Meter Data Management - Version: 04.53
This problem can occur on any platform.

Symptoms

When trying to modify an interval data cut on an MS SQL server database with versioning enabled, the following error occurs:

Error (0x100000001): [LOADREAD_FAILURE] Failure loading meter read into database:
[Microsoft][ODBC SQL Server Driver][SQL Server]A cursor with the name 'old_Rows' already exists.

This issue can also manifest itself with a different error:

When an interval data cut is modified in MDM and saved, the changes are not saved after the page refresh.

Cause

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