Error while creating a procedure
agarwalk Nov 17, 2011 8:07 AMHello,
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.