1 Reply Latest reply: Jan 11, 2012 3:13 PM by Ramesh Reddy RSS

    Error while creating a procedure

    Vikash Agrawal Newbie

      Hello,

       

      I am new to teiid and in process of evaluation multiple items.

       

      What I have done is :

       

      1. I Have two progress databases where my core business is running.

      2. I have created a virtual database say in BussVDB using Teiid.

      3. Now I want to create a procedure in the Virtual database so that I can use that in my application.

      4. I just tried with the below syntax and getting the error as:

       

      CREATE PROCEDURE

      BEGIN

      select LoanNumber from MSS.PUB.MORTGAGE;

      END

      ---------------

      2011-11-17 16:46:42,874 ERROR [org.teiid.PROCESSOR] (Worker21_QueryProcessorQueue22117) Unexpected exception for request /9huo5MoZxAj.0

      java.lang.NullPointerException

                at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveVirtualGroupElements(UpdateProcedureResolver.java:91)

                at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveCommand(UpdateProcedureResolver.java:132)

                at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:294)

                at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:147)

                at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:287)

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

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

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

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

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

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

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

                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$Worker.runTask(ThreadPoolExecutor.java:886)

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

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

       

       

      Same kind of error is coming using Virtaul Procedure also.

       

      My basic idea is to create a procedure which can give me set of data rom multiple tables.

       

      I am using 7.5 Final of Teiid Server and designer...

       

       

      Thanks for the help.