IBM Support

Information Server Migration and Backup Recovery tool fails during Oracle's tablespace transportable restore

Troubleshooting


Problem

The IBM InfoSphere Information Server Migration tool's import fails because Oracle fails to restore the source tablespace due to invalid statistics in the backup tablespace from the source repository. The following error is generated in the migration logs: Processing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/FUNCTIONAL_AND_BITM AP/INDEX_STATISTICS Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTI CS] ORA-06502: PL/SQL: numeric or value error LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 8165 ----- PL/SQL Call Stack -----   object      line  object   handle    number  name 2F8A8314     18990  package body SYS.KUPW$WORKER 2F8A8314      8192  package body SYS.KUPW$WORKER 2F8A8314     15575  package body SYS.KUPW$WORKER 2F8A8314      3945  package body SYS.KUPW$WORKER 2F8A8314      8875  package body SYS.KUPW$WORKER 2F8A8314      1649  package body SYS.KUPW$WORKER 385B2954         2  anonymous block

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.7","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 April 2025

UID

swg21589178

Page Feedback