1 2 Previous Next 18 Replies Latest reply: Feb 16, 2012 4:26 PM by Vineela Gampa RSS

Exception doing insert to a Temp table on Teiid 7.6

Vineela Gampa Novice

Hi

 

Iam seeing the below error during insert to a Temptable.I dont understand whats wrong with it. It was working fine on 7.3 earlier. Not sure if the teiid version is the problem or there is some other problem thats going on.

 

ava.lang.RuntimeException: java.lang.Exception: Exception org.teiid.jdbc.TeiidSQLException: Expected argument to be an instance of org.teiid.metadata.AbstractMetadataRecord; was instance of org.teiid.query.metadata.TempMetadataID occurred on statement insert into #zJc6J7SL SELECT CHORUS_B.userid, CHORUS_B.sysid, CHORUS_B.zip, CHORUS_B.phone, CHORUS_B.name, 'demodata.user' AS "__objecttype__" FROM demodata."user" AS CHORUS_B

 

 

Below is the snippet code which i use to insert to a Temptable.

 

logger.debug("Actual query passed : " + query);

        final String modifiedQuery = getQueryToBeInsertedToTempTable(query);

        final String insertQuery = "insert into #" + tableName + " " + modifiedQuery;

        logger.debug("Insert query for temp table : " + insertQuery);

        this.materializedDBExecutorProvider.get().execute(insertQuery, args);

 

Thanks

Vineela

  • 1. Re: Exception doing insert to a Temp table on Teiid 7.6
    Steven Hawkins Master

    Vineela,

     

    Just trying a similar situation, an insert against an implicitly created session scoped temp table using a query expression against a physical table worked just fine for me.  Can you provide a stacktrace to more fully capture where the issue may be coming from?

     

    Steve

  • 2. Re: Exception doing insert to a Temp table on Teiid 7.6
    Vineela Gampa Novice

    iam posting the complete stack trace

    Caused by: java.lang.Exception: Exception org.teiid.jdbc.TeiidSQLException: Expected argument to be an instance of org.teiid.metadata.AbstractMetadataRecord; was instance of org.teiid.query.metadata.TempMetadataID occurred on statement insert into #zJc6J7SL SELECT CHORUS_B.userid, CHORUS_B.sysid, CHORUS_B.zip, CHORUS_B.phone, CHORUS_B.name, 'demodata.user' AS "__objecttype__" FROM demodata."user" AS CHORUS_B

        at com.ca.chorus.db.DbExecutor.handleSqlException(DbExecutor.java:391)

        at com.ca.chorus.db.DbExecutor.access$3(DbExecutor.java:383)

        at com.ca.chorus.db.DbExecutor$10.call(DbExecutor.java:492)

        at com.ca.chorus.db.DbExecutor$10.call(DbExecutor.java:1)

        at com.ca.chorus.aop.guice.IPerfTracer$1.trace(IPerfTracer.java:25)

        at com.ca.chorus.db.DbExecutor.execute(DbExecutor.java:467)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.insertIntoTempTable(ObjectsServiceImpl.java:3054)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:2352)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:897)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:871)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:687)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:608)

        at com.ca.mfui.chorusR2.server.service.ITObjectsServiceTest.testGetObjectsAgainstTempTable(ITObjectsServiceTest.java:874)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:601)

        at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)

        at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

        at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)

        at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)

        at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)

        at com.ca.mfui.chorusR2.server.service.ScopeDecoratingRunner$1$1.call(ScopeDecoratingRunner.java:42)

        ... 26 more

    Caused by: org.teiid.jdbc.TeiidSQLException: Expected argument to be an instance of org.teiid.metadata.AbstractMetadataRecord; was instance of org.teiid.query.metadata.TempMetadataID

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

        at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:617)

        at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:70)

        at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:537)

        at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

        at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

        at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

        at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:220)

        at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:255)

        at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:601)

        at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:110)

        at $Proxy27.read(Unknown Source)

        at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:349)

        at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:335)

        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:546)

        at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:211)

        at com.ca.chorus.db.LeakDetectingPreparedStatement.execute(LeakDetectingPreparedStatement.java:187)

        at com.ca.chorus.db.DbExecutor$10.call(DbExecutor.java:481)

        ... 46 more

    Caused by: [TeiidException]Expected argument to be an instance of org.teiid.metadata.AbstractMetadataRecord; was instance of org.teiid.query.metadata.TempMetadataID

    1 [IllegalArgumentException]Expected argument to be an instance of org.teiid.metadata.AbstractMetadataRecord; was instance of org.teiid.query.metadata.TempMetadataID

        at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172)

        at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:725)

        at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:462)

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:314)

        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

        at java.lang.Thread.run(Thread.java:722)

    Caused by: java.lang.IllegalArgumentException: Expected argument to be an instance of org.teiid.metadata.AbstractMetadataRecord; was instance of org.teiid.query.metadata.TempMetadataID

        at org.teiid.core.util.ArgCheck.isInstanceOf(ArgCheck.java:354)

        at org.teiid.core.util.ArgCheck.isInstanceOf(ArgCheck.java:338)

        at org.teiid.query.metadata.TransformationMetadata.getFullName(TransformationMetadata.java:258)

        at org.teiid.dqp.internal.process.multisource.MultiSourceMetadataWrapper.getFullName(MultiSourceMetadataWrapper.java:108)

        at org.teiid.dqp.internal.process.multisource.MultiSourceMetadataWrapper.isMultiSource(MultiSourceMetadataWrapper.java:355)

        at org.teiid.query.metadata.BasicQueryMetadataWrapper.isMultiSource(BasicQueryMetadataWrapper.java:362)

        at org.teiid.query.metadata.BasicQueryMetadataWrapper.isMultiSource(BasicQueryMetadataWrapper.java:362)

        at org.teiid.query.validator.ValidationVisitor.validateMultisourceInsert(ValidationVisitor.java:338)

        at org.teiid.query.validator.ValidationVisitor.visit(ValidationVisitor.java:247)

        at org.teiid.query.sql.lang.Insert.acceptVisitor(Insert.java:187)

        at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:52)

        at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.preVisitVisitor(PreOrPostOrderNavigator.java:134)

        at org.teiid.query.validator.Validator$1.preVisitVisitor(Validator.java:85)

        at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:300)

        at org.teiid.query.sql.lang.Insert.acceptVisitor(Insert.java:187)

        at org.teiid.query.validator.Validator.executeValidation(Validator.java:95)

        at org.teiid.query.validator.Validator.validate(Validator.java:49)

        at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:332)

        at org.teiid.dqp.internal.process.Request.validateQuery(Request.java:301)

        at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:404)

        at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:138)

        at org.teiid.dqp.internal.process.Request.processRequest(Request.java:459)

        at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:506)

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:276)

        ... 8 more

  • 3. Re: Exception doing insert to a Temp table on Teiid 7.6
    Vineela Gampa Novice

    I debugged more. I see its failing when ResultsFuture<Boolean> executeSql(String[] commands, boolean isBatchedCommand, ResultsMode resultsMode, boolean synch)

     

    final RequestMessage reqMessage = createRequestMessage(commands, isBatchedCommand, resultsMode);

            ResultsFuture<ResultsMessage> pendingResult = execute(reqMessage, synch); -- intern calls DQPWorkContext.execute - > whih throws this exception..Couldnt debug this class for some reason.

            final ResultsFuture<Boolean> result = new ResultsFuture<Boolean>();

            pendingResult.addCompletionListener(new ResultsFuture.CompletionListener<ResultsMessage>() {

                @Override

                public void onCompletion(ResultsFuture<ResultsMessage> future) {

                    try {

                        postReceiveResults(reqMessage, future.get()); 

                        result.getResultsReceiver().receiveResults(hasResultSet());

                    } catch (Throwable t) {

                        result.getResultsReceiver().exceptionOccurred(t);

                    }

                }

            });

  • 4. Re: Exception doing insert to a Temp table on Teiid 7.6
    Steven Hawkins Master

    Vineela,

     

    The issue here is with the multisource metadata construction.  Can you log this as a JIRA and I'll address it in 7.7.

     

    Thanks,

    Steve

  • 5. Re: Exception doing insert to a Temp table on Teiid 7.6
    Steven Hawkins Master

    Vineela,

     

    I went ahead and logged/worked this under https://issues.jboss.org/browse/TEIID-1939

     

    Thanks,

    Steve

  • 6. Re: Exception doing insert to a Temp table on Teiid 7.6
    Vineela Gampa Novice

    Steve,

     

    Is this due to multisource models only ??We have one multisource model in our vdb ..If i remove that do you think it works just fine?

  • 7. Re: Exception doing insert to a Temp table on Teiid 7.6
    Steven Hawkins Master

    Vineela,

     

    Yes, there should be no issue if none of the models are multi-source.

     

    Steve

  • 8. Re: Exception doing insert to a Temp table on Teiid 7.6
    Vineela Gampa Novice

    Hi Steve,

     

    was it checked to this branch http://anonsvn.jboss.org/repos/teiid/branches/7.7.x/. Which files are changed for this ? We actually got files form 7.7 branch. But its still not working for us.  I can verify those files for your changes,.

  • 9. Re: Exception doing insert to a Temp table on Teiid 7.6
    Steven Hawkins Master

    Yes, this is in 7.7.x.  You can see the change set from the issue: https://source.jboss.org/changelog/Teiid?cs=3883

     

    Steve

  • 10. Re: Exception doing insert to a Temp table on Teiid 7.6
    Vineela Gampa Novice

    Hi Steve,

     

    Your fix didnt fix it . Iam seeing the below exception now.

     

    java.lang.RuntimeException: java.lang.Exception: Exception org.teiid.jdbc.TeiidSQLException: Multisource insert with query expression not allowed not allowed, should have been caught in validation. occurred on statement insert into #Jm1OX7hL SELECT CHORUS_B.userid, CHORUS_B.sysid, CHORUS_B.zip, CHORUS_B.phone, CHORUS_B.name, 'demodata.user' AS "__objecttype__" FROM demodata."user" AS CHORUS_B

        at com.ca.mfui.chorusR2.server.service.ScopeDecoratingRunner$1$1.call(ScopeDecoratingRunner.java:52)

        at com.ca.mfui.chorusR2.server.service.ScopeDecoratingRunner$1$1.call(ScopeDecoratingRunner.java:1)

        at com.google.inject.servlet.ServletScopes$4.call(ServletScopes.java:251)

        at com.ca.mfui.chorusR2.server.service.ScopeDecoratingRunner$1.evaluate(ScopeDecoratingRunner.java:55)

        at com.ca.mfui.chorusR2.server.service.CompositeMethodRule$1.evaluate(CompositeMethodRule.java:31)

        at com.ca.mfui.server.TransactionDecoratingRule$1$1.call(TransactionDecoratingRule.java:42)

        at com.ca.mfui.server.TransactionDecoratingRule$1$1.call(TransactionDecoratingRule.java:1)

        at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:23)

        at com.ca.chorus.aop.guice.IPerfTracer$1.trace(IPerfTracer.java:19)

        at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31)

        at com.ca.mfui.server.TransactionDecoratingRule$1.evaluate(TransactionDecoratingRule.java:34)

        at com.ca.mfui.chorusR2.server.service.CompositeMethodRule$1.evaluate(CompositeMethodRule.java:31)

        at com.google.guiceberry.junit4.GuiceBerryRule$1.evaluate(GuiceBerryRule.java:55)

        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)

        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)

        at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)

        at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)

        at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)

        at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)

        at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)

        at org.junit.runners.ParentRunner.run(ParentRunner.java:236)

        at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:49)

        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)

        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

    Caused by: java.lang.Exception: Exception org.teiid.jdbc.TeiidSQLException: Multisource insert with query expression not allowed not allowed, should have been caught in validation. occurred on statement insert into #Jm1OX7hL SELECT CHORUS_B.userid, CHORUS_B.sysid, CHORUS_B.zip, CHORUS_B.phone, CHORUS_B.name, 'demodata.user' AS "__objecttype__" FROM demodata."user" AS CHORUS_B

        at com.ca.chorus.db.DbExecutor.handleSqlException(DbExecutor.java:408)

        at com.ca.chorus.db.DbExecutor.access$300(DbExecutor.java:36)

        at com.ca.chorus.db.DbExecutor$10.call(DbExecutor.java:509)

        at com.ca.chorus.db.DbExecutor$10.call(DbExecutor.java:485)

        at com.ca.chorus.aop.guice.IPerfTracer$1.trace(IPerfTracer.java:25)

        at com.ca.chorus.db.DbExecutor.execute(DbExecutor.java:484)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.insertIntoTempTable(ObjectsServiceImpl.java:3060)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:2352)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:898)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:872)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:688)

        at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:609)

        at com.ca.mfui.chorusR2.server.service.ITObjectsServiceTest.testGetObjectsAgainstTempTable(ITObjectsServiceTest.java:885)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)

        at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

        at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)

        at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)

        at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)

        at com.ca.mfui.chorusR2.server.service.ScopeDecoratingRunner$1$1.call(ScopeDecoratingRunner.java:42)

        ... 26 more

    Caused by: org.teiid.jdbc.TeiidSQLException: Multisource insert with query expression not allowed not allowed, should have been caught in validation.

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

        at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:617)

        at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:70)

        at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:537)

        at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

        at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

        at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

        at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:220)

        at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:255)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:110)

        at $Proxy27.read(Unknown Source)

        at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:349)

        at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:335)

        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:546)

        at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:211)

        at com.ca.chorus.db.LeakDetectingPreparedStatement.execute(LeakDetectingPreparedStatement.java:187)

        at com.ca.chorus.db.DbExecutor$10.call(DbExecutor.java:498)

        ... 46 more

    Caused by: [TeiidException]Multisource insert with query expression not allowed not allowed, should have been caught in validation.

    1 [AssertionError]Multisource insert with query expression not allowed not allowed, should have been caught in validation.

        at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172)

        at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:736)

        at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:472)

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:314)

        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

        at java.lang.Thread.run(Thread.java:722)

    Caused by: java.lang.AssertionError: Multisource insert with query expression not allowed not allowed, should have been caught in validation.

        at org.teiid.dqp.internal.process.multisource.MultiSourcePlanToProcessConverter.convertNode(MultiSourcePlanToProcessConverter.java:116)

        at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertPlan(PlanToProcessConverter.java:109)

        at org.teiid.query.optimizer.relational.PlanToProcessConverter.convert(PlanToProcessConverter.java:94)

        at org.teiid.dqp.internal.process.multisource.MultiSourcePlanToProcessConverter.convert(MultiSourcePlanToProcessConverter.java:95)

        at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:251)

        at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:190)

        at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:436)

        at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:138)

        at org.teiid.dqp.internal.process.Request.processRequest(Request.java:459)

        at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:516)

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:276)

        ... 8 more

  • 11. Re: Exception doing insert to a Temp table on Teiid 7.6
    Steven Hawkins Master

    Vineela,

     

    The fix addressed the original exception.  This is a coming from a different issue.  I'll let you know.

     

    Steve

  • 13. Re: Exception doing insert to a Temp table on Teiid 7.6
    Steven Hawkins Master

    Vineela,

     

    See the next change set for https://issues.jboss.org/browse/TEIID-1939.  Sorry, I should have seen that follow-on issue initially.

     

    Steve

  • 14. Re: Exception doing insert to a Temp table on Teiid 7.6
    Vineela Gampa Novice

    Sure will verify and will post the result.

1 2 Previous Next