SQL Error During Lineage Tracing: ORA-22813: Operand Value Exceeds System Limits (Doc ID 2062709.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Enterprise Metadata Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 "Trace Data Impact" from Oracle Enterprise Metadata Management (OEMM) 12.1.3.0.1 in an Oracle table generates the error:

"SQL error during lineage tracing: ORA-22813: operand value exceeds system limits". 

({"error":true,"errorMessage":"SQL error during lineage tracing: ORA-22813: operand value exceeds system limits","errorType":"Lineage Error","errorCodes":"[LNGTRC_E0016]","stackTrace":"
Error Codes - [LNGTRC_E0016]
Request - VizModelLineage
Parameters - showMappingsAsNodes[true] skipCache[false] actionType[loadlineage] tracingDirection[3] viewType[ModelLineage] originalStartingObject[17#2406#0] showInternalObject[false] showNoType[true] startingIds[17#2406#0] cacheId[ReportTree4202015-083124086] objectIds[17#1#0] viewId[ReportTree4202015-083124086] collapseLevel[Features] showControlLinks[false] isBizUI[false] profile[] showSummaryView[true] tracingType[DataImpact] resetCache[false]
MITI.web.common.exceptions.LineageUIException: SQL error during lineage tracing: ORA-22813: operand value exceeds system limits
at MITI.web.common.service.facades.LineageFacadeImpl.getLineageGraph(LineageFacadeImpl.java:284)
at MITI.flash.tabs.VizModelLineage.getLineageTree(VizModelLineage.java:429)
at MITI.flash.tabs.VizModelLineage.buildLineageGraph(VizModelLineage.java:356)
at MITI.flash.tabs.VizModelLineage.performAction(VizModelLineage.java:148)
at MITI.server.servlets.FlashServlet.doPost(FlashServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:662)
Caused by: MITI.server.services.lineage.LineageException: (LNGTRC_E0016) SQL error during lineage tracing: ORA-22813: operand value exceeds system limits
at MITI.server.services.lineage.database.LineageDataSource.handle(LineageDataSource.java:41)
at MITI.util.database.CommonDataSource.handleSQLException(CommonDataSource.java:124)
at MITI.util.database.CommonDataSource.executeTransaction(CommonDataSource.java:83)
at MITI.util.database.CommonDataSource.executeStatement(CommonDataSource.java:54)
at MITI.server.services.lineage.impl.LineageImpl.traceLineage(LineageImpl.java:554)
at MITI.server.services.lineage.common.LineageTracer.traceLineage(LineageTracer.java:1078)
at MITI.server.services.lineage.common.LineageTracer.traceDataLineage(LineageTracer.java:313)
at MITI.server.services.lineage.common.LineageTracer.traceTechnicalData(LineageTracer.java:176)
at MITI.web.common.service.facades.LineageFacadeImpl.getLineageGraph(LineageFacadeImpl.java:227)
... 21 more
Caused by: java.sql.SQLException: ORA-22813: operand value exceeds system limits
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1188)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at MITI.util.database.Query.executeStatement(Query.java:45)
at MITI.util.database.Statement.execute(Statement.java:66)
at MITI.util.database.CommonDataSource$1.run(CommonDataSource.java:50)
at MITI.util.database.CommonDataSource$1.run(CommonDataSource.java:47)
at MITI.util.database.Transaction.execute(Transaction.java:92)
at MITI.util.database.CommonDataSource.executeTransaction(CommonDataSource.java:80)
... 27 more
Caused by:
MITI.server.services.lineage.LineageException: (LNGTRC_E0016) SQL error during lineage tracing: ORA-22813: operand value exceeds system limits
at MITI.server.services.lineage.database.LineageDataSource.handle(LineageDataSource.java:41)
at MITI.util.database.CommonDataSource.handleSQLException(CommonDataSource.java:124)
at MITI.util.database.CommonDataSource.executeTransaction(CommonDataSource.java:83)
at MITI.util.database.CommonDataSource.executeStatement(CommonDataSource.java:54)
at MITI.server.services.lineage.impl.LineageImpl.traceLineage(LineageImpl.java:554)
at MITI.server.services.lineage.common.LineageTracer.traceLineage(LineageTracer.java:1078)
at MITI.server.services.lineage.common.LineageTracer.traceDataLineage(LineageTracer.java:313)
at MITI.server.services.lineage.common.LineageTracer.traceTechnicalData(LineageTracer.java:176)
at MITI.web.common.service.facades.LineageFacadeImpl.getLineageGraph(LineageFacadeImpl.java:227)
at MITI.flash.tabs.VizModelLineage.getLineageTree(VizModelLineage.java:429)
at MITI.flash.tabs.VizModelLineage.buildLineageGraph(VizModelLineage.java:356)
at MITI.flash.tabs.VizModelLineage.performAction(VizModelLineage.java:148)
at MITI.server.servlets.FlashServlet.doPost(FlashServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-22813: operand value exceeds system limits
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1188)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at MITI.util.database.Query.executeStatement(Query.java:45)
at MITI.util.database.Statement.execute(Statement.java:66)
at MITI.util.database.CommonDataSource$1.run(CommonDataSource.java:50)
at MITI.util.database.CommonDataSource$1.run(CommonDataSource.java:47)
at MITI.util.database.Transaction.execute(Transaction.java:92)
at MITI.util.database.CommonDataSource.executeTransaction(CommonDataSource.java:80)
... 27 more
Caused by:
java.sql.SQLException: ORA-22813: operand value exceeds system limits
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1188)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at MITI.util.database.Query.executeStatement(Query.java:45)
at MITI.util.database.Statement.execute(Statement.java:66)
at MITI.util.database.CommonDataSource$1.run(CommonDataSource.java:50)
at MITI.util.database.CommonDataSource$1.run(CommonDataSource.java:47)
at MITI.util.database.Transaction.execute(Transaction.java:92)
at MITI.util.database.CommonDataSource.executeTransaction(CommonDataSource.java:80)
at MITI.util.database.CommonDataSource.executeStatement(CommonDataSource.java:54)
at MITI.server.services.lineage.impl.LineageImpl.traceLineage(LineageImpl.java:554)
at MITI.server.services.lineage.common.LineageTracer.traceLineage(LineageTracer.java:1078)
at MITI.server.services.lineage.common.LineageTracer.traceDataLineage(LineageTracer.java:313)
at MITI.server.services.lineage.common.LineageTracer.traceTechnicalData(LineageTracer.java:176)
at MITI.web.common.service.facades.LineageFacadeImpl.getLineageGraph(LineageFacadeImpl.java:227)
at MITI.flash.tabs.VizModelLineage.getLineageTree(VizModelLineage.java:429)
at MITI.flash.tabs.VizModelLineage.buildLineageGraph(VizModelLineage.java:356)
at MITI.flash.tabs.VizModelLineage.performAction(VizModelLineage.java:148)
at MITI.server.servlets.FlashServlet.doPost(FlashServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

Changes

 

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