UDI-31626: Operation Generated ORACLE Error 31626 (Doc ID 1928501.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 07-Apr-2016***

Symptoms

Import of a dumpfile created under 12.1 with VERSION=11.2.0.3.0 produces a failure on import of the dumpfile into 11.2.0.3.0.

Import: Release 11.2.0.3.0 - Production on Tue May 31 14:05:37 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options

UDI-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-6512: at "SYS.DBMS_DATAPUMP", line 3326
ORA-6512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-6512: at line 1

The error is misleading in that it says "job does not exist".

However, adding the TRACE parameter and examining the Master datapump trace file shows a timezone.dat problem.
When rerunning the Data Pump import with TRACE=1FF0300 we can see in the *dm*.trc file the next:

KUPM:11:08:08.773: Tables exists with TSTZ columns
KUPM:11:08:08.777: exp TSTZ version: 18
KUPM:11:08:08.777: imp TSTZ version: 14
KUPM:11:08:08.777: Need to load secondary TSTZ table version 18
KUPM:11:08:08.778: Error detected by MCP
KUPC:11:08:08.779: Before ENQ: Sending Type: 2022 ID:
KUPC:11:08:08.779: DG,KUPC$S_1_20140916110803,MCP, ,3,Y
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn 329273679 lascn 22
KUPM:11:08:08.780: ORA-39097: Data Pump job encountered unexpected error -30094

 

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