1 2 Previous Next 18 Replies Latest reply on Feb 16, 2012 4:26 PM by gamvi01

    Exception doing insert to a Temp table on Teiid 7.6

    gamvi01

      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
          shawkins

          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
            gamvi01

            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
              gamvi01

              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
                shawkins

                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
                  shawkins

                  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
                    gamvi01

                    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
                      shawkins

                      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
                        gamvi01

                        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
                          shawkins

                          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
                            gamvi01

                            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
                              shawkins

                              Vineela,

                               

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

                               

                              Steve

                              • 12. Re: Exception doing insert to a Temp table on Teiid 7.6
                                gamvi01

                                Sure. Thanks.

                                • 13. Re: Exception doing insert to a Temp table on Teiid 7.6
                                  shawkins

                                  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
                                    gamvi01

                                    Sure will verify and will post the result.

                                    1 2 Previous Next