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.