IBM Support

InfoSphere Information Governance Catalog: Lineage reports take excessive amount of time and sometimes gives Oracle database error

Troubleshooting


Problem

In an Oracle database environment, lineage reports take a long time to create, or are never created. The Oracle database error might be displayed: [Oracle JDBC Driver][Oracle]ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Symptom

Lineage report takes an unusually long amount of time or times out. In addition, lineage uses extraordinary amounts of TEMP tablespace.

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Information Governance Catalog","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.5.0.1;11.5;11.3.1.2;11.3.1.0;11.3","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

swg21696795