4 Replies Latest reply on Feb 2, 2018 12:08 PM by kevinyjn

    Why I got error on deploying VDB when I used UDF?

    kevinyjn

      I 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.