UDI-31626: Operation Generated ORACLE Error 31626
Last updated on MAY 01, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 22.214.171.124 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 07-Apr-2016***
Import of a dumpfile created under 12.1 with VERSION=126.96.36.199.0 produces a failure on import of the dumpfile into 188.8.131.52.0.
Import: Release 184.108.40.206.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 220.127.116.11.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.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
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