Why I got error on deploying VDB when I used UDF?
kevinyjn Feb 2, 2018 9:30 AMI used UDF for view rest virtual procedure, there is no error tips before I deploying the VDB, when I do the deploy VDB operation, it comes error every time. Am I lost any thing to do with the UDF defination?
My UDF is defined like this in Utilities.xmi:
and I called my UDF like this:
SELECT Utilities.UpdateOrganizationParent(convert(ksrow.KSDM, string), convert(ksrow.SJKS, string)) AS results;
The VDB deploy error is:
22:22:19,812 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (Worker47_async-teiid-threads70) TEIID40003 VDB Basic.1 is set to ACTIVE
22:22:19,820 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker21_QueryProcessorQueue59) BNO5IxU/Z6EE TEIID30013 Loading materialized view table #MAT_PG_CATALOG.MATPG_DATATYPE
22:22:19,820 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker22_QueryProcessorQueue60) xIT//eY7XeBb TEIID30013 Loading materialized view table #MAT_PG_CATALOG.PG_TYPE
22:22:19,833 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker22_QueryProcessorQueue62) xIT//eY7XeBb TEIID30015 Failed to load materialized view table #MAT_PG_CATALOG.PG_TYPE.: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate (SELECT pg_catalog.getOid(SYS.Schemas.UID) FROM SYS.Schemas WHERE SYS.Schemas.Name = 'SYS' LIMIT 2): TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:728)
at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:194)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:169)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94)
at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:251)
at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102)
at org.teiid.query.tempdata.TempTable.insert(TempTable.java:694)
at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:728)
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109)
at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:626)
at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:562)
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109)
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:394)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1433)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:778)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:726)
... 34 more
Caused by: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:728)
at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:194)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:169)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.query.processor.relational.SubqueryAwareEvaluator.evaluateSubquery(SubqueryAwareEvaluator.java:358)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1431)
... 36 more
Caused by: org.teiid.api.exception.query.FunctionExecutionException: TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:295)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1417)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:756)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:726)
... 46 more
Caused by: java.lang.AssertionError: duplicate uid boolean result
at org.teiid.query.metadata.CompositeMetadataStore.addOid(CompositeMetadataStore.java:199)
at org.teiid.query.metadata.CompositeMetadataStore.assignOids(CompositeMetadataStore.java:192)
at org.teiid.query.metadata.CompositeMetadataStore.getOids(CompositeMetadataStore.java:231)
at org.teiid.query.metadata.CompositeMetadataStore.getOid(CompositeMetadataStore.java:217)
at org.teiid.deployers.PgCatalogMetadataStore$FunctionMethods.getOid(PgCatalogMetadataStore.java:614)
at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:281)
... 49 more
22:22:19,835 WARN [org.teiid.PROCESSOR] (Worker22_QueryProcessorQueue62) xIT//eY7XeBb TEIID30020 Processing exception for request xIT//eY7XeBb.0 'TEIID30328 Unable to evaluate (SELECT pg_catalog.getOid(SYS.Schemas.UID) FROM SYS.Schemas WHERE SYS.Schemas.Name = 'SYS' LIMIT 2): TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid'. Originally ExpressionEvaluationException 'duplicate uid boolean result' CompositeMetadataStore.java:199. Enable more detailed logging to see the entire stacktrace.
22:22:19,837 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker21_QueryProcessorQueue59) BNO5IxU/Z6EE TEIID30013 Loading materialized view table #MAT_PG_CATALOG.PG_TYPE
22:22:19,841 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker21_QueryProcessorQueue64) BNO5IxU/Z6EE TEIID30015 Failed to load materialized view table #MAT_PG_CATALOG.PG_TYPE.: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate (SELECT pg_catalog.getOid(SYS.Schemas.UID) FROM SYS.Schemas WHERE SYS.Schemas.Name = 'SYS' LIMIT 2): TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:728)
at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:194)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:169)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94)
at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:251)
at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102)
at org.teiid.query.tempdata.TempTable.insert(TempTable.java:694)
at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:728)
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109)
at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:626)
at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:562)
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109)
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:394)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:147)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94)
at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:251)
at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102)
at org.teiid.query.tempdata.TempTable.insert(TempTable.java:694)
at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:728)
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109)
at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:626)
at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:562)
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109)
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:394)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1433)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:778)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:726)
... 50 more
Caused by: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:728)
at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:194)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:169)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.query.processor.relational.SubqueryAwareEvaluator.evaluateSubquery(SubqueryAwareEvaluator.java:358)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1431)
... 52 more
Caused by: org.teiid.api.exception.query.FunctionExecutionException: TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:295)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1417)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:756)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:726)
... 62 more
Caused by: java.lang.AssertionError: duplicate uid boolean result
at org.teiid.query.metadata.CompositeMetadataStore.addOid(CompositeMetadataStore.java:199)
at org.teiid.query.metadata.CompositeMetadataStore.assignOids(CompositeMetadataStore.java:192)
at org.teiid.query.metadata.CompositeMetadataStore.getOids(CompositeMetadataStore.java:231)
at org.teiid.query.metadata.CompositeMetadataStore.getOid(CompositeMetadataStore.java:217)
at org.teiid.deployers.PgCatalogMetadataStore$FunctionMethods.getOid(PgCatalogMetadataStore.java:614)
at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:281)
... 65 more
22:22:19,844 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker21_QueryProcessorQueue64) BNO5IxU/Z6EE TEIID30015 Failed to load materialized view table #MAT_PG_CATALOG.MATPG_DATATYPE.: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate (SELECT pg_catalog.getOid(SYS.Schemas.UID) FROM SYS.Schemas WHERE SYS.Schemas.Name = 'SYS' LIMIT 2): TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:728)
at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:194)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:169)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94)
at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:251)
at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102)
at org.teiid.query.tempdata.TempTable.insert(TempTable.java:694)
at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:728)
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109)
at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:626)
at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:562)
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109)
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:394)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:147)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94)
at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:251)
at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102)
at org.teiid.query.tempdata.TempTable.insert(TempTable.java:694)
at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:728)
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109)
at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:626)
at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:562)
at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109)
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:394)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1433)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:778)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:726)
... 50 more
Caused by: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:728)
at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:194)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:169)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.query.processor.relational.SubqueryAwareEvaluator.evaluateSubquery(SubqueryAwareEvaluator.java:358)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1431)
... 52 more
Caused by: org.teiid.api.exception.query.FunctionExecutionException: TEIID30384 Error while evaluating function pg_catalog.getOid
at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:295)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1417)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:756)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:726)
... 62 more
Caused by: java.lang.AssertionError: duplicate uid boolean result
at org.teiid.query.metadata.CompositeMetadataStore.addOid(CompositeMetadataStore.java:199)
at org.teiid.query.metadata.CompositeMetadataStore.assignOids(CompositeMetadataStore.java:192)
at org.teiid.query.metadata.CompositeMetadataStore.getOids(CompositeMetadataStore.java:231)
at org.teiid.query.metadata.CompositeMetadataStore.getOid(CompositeMetadataStore.java:217)
at org.teiid.deployers.PgCatalogMetadataStore$FunctionMethods.getOid(PgCatalogMetadataStore.java:614)
at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:281)
... 65 more
22:22:19,845 WARN [org.teiid.PROCESSOR] (Worker21_QueryProcessorQueue64) BNO5IxU/Z6EE TEIID30020 Processing exception for request BNO5IxU/Z6EE.0 'TEIID30328 Unable to evaluate (SELECT pg_catalog.getOid(SYS.Schemas.UID) FROM SYS.Schemas WHERE SYS.Schemas.Name = 'SYS' LIMIT 2): TEIID30328 Unable to evaluate pg_catalog.getOid(SYS.Schemas.UID): TEIID30384 Error while evaluating function pg_catalog.getOid'. Originally ExpressionEvaluationException 'duplicate uid boolean result' CompositeMetadataStore.java:199. Enable more detailed logging to see the entire stacktrace.