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