ORA-31693, ORA-06502, And ORA-31605 With LPX Error on Export Datapump

(Doc ID 557434.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.0 to 11.1
This problem can occur on any platform.

Symptoms

- While running an export, the following error messages are generated:

ORA-31693: Table data object "ARISPRD"."AERSEL_QUERY" failed to load/unload and is being skipped due to error:
ORA-06502: PL/SQL: numeric or value error
ORA-31605: the following was returned from LpxXSLResetAllVars in routine kuxslResetParams:
LPX-1: NULL pointer

- LPX error can be another LPX error like:
LPX-00210: expected '<' instead of 'n'

- Checking dictionary objects as in <> shows that everything is OK.

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