My Oracle Support Banner

'ODI-17596: Query to retrieve value for native sequence "._CURRVAL" has failed' Is Received when Using ODI 12c and LOGLVEL=6 to Fetch the Current Value of a Netezza Database Sequence (Doc ID 2757112.1)

Last updated on JUNE 08, 2023

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 to 12.2.1.4.210321 [Release 12c]
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 to 12.2.1.4.210321
Information in this document applies to any platform.

Symptoms

When attempting to execute an Oracle Data Integrator (ODI) 12c Package, Mapping, Procedure or Scenario that uses a Netezza database sequence:

Error message received when executing the flow using a log level of 6:

The issue can be reproduced at will with the following steps:

  1. Use ODI 12c, and the genuine Netezza technology defined in the ODI Studio > Topology UI.
      
  2. Create a Sequence in the Netezza database.
      
  3. In ODi Studio > Designer, create an ODI Sequence and set:
      Sequence configuration: Native sequence
      Schema: <LOGICAL SCHEMA ON SOME NETEZZA DATASERVER>
      Native sequence name: <SEQUENCE NAME>
      
  4. Create a Mapping, Procedure or Package the uses the Sequence above.
     
  5. Execute the Mapping, Procedure or Package with a log level = 5. Observe the execution succeeds.
     
  6. Execute the same with log level = 6, and observe the ODI-17596 error message received.

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!

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