JBossDeveloper

Hi Ramesh,

I tried to deploy the VDB which you had attached but I  the VDB is not getting deployed and throwing an error

DEPLOYMENTS IN ERROR:
  Deployment "vfszip:/C:/CAFlow/jboss-5.1.0.GA/server/default/deploy/SecAdmin.vd
b/" is in error due to the following reason(s): java.io.IOException: User Define
d Function (UDF) model "FunctionDefinitions.xmi" not found in the VDB

Please suggest.

Thanks

Rakesh.

Hi Ramesh,

I think you have forgor to attach the VDB file to the discussion reply.

Kindly attach the VDB.

Thanks

Rakesh

Hi Ramesh,

The VDB is Deployed successfully but when I execute the function I am getting the following error

I had also attached the jar file for the UDF.

Also find the modified attached VDB File .

Can you please look into this and help me solving the problem.

14:51:02,860 ERROR [PROCESSOR] Unexpected exception for request jhL0jfjJzmma.0
[TeiidComponentException]Function celsiusToFahrenheit is marked in the function
metadata as a function that must be evaluated at the source.
        at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:943)
        at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:637)
        at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:607)
        at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectN
ode.java:235)
        at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(Proj
ectNode.java:195)
        at org.teiid.query.processor.relational.RelationalNode.nextBatch(Relatio
nalNode.java:260)
        at org.teiid.query.processor.relational.RelationalPlan.nextBatch(Relatio
nalPlan.java:106)
        at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcess
or.java:157)
        at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.jav
a:107)
        at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector
.java:67)
        at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWor
kItem.java:247)
        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkIte
m.java:177)
        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.
java:49)
        at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.j
ava:190)
        at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.j
ava:187)
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon
text.java:176)
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon
text.java:187)
        at org.teiid.dqp.internal.process.StatsCapturingWorkManager$WorkWrapper.
run(StatsCapturingWorkManager.java:102)
        at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205)
        at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:
260)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
utor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:907)
        at java.lang.Thread.run(Thread.java:619)

Thanks

Rakesh

Hi Ramesh,

It worked. Thanks for the information.

I was using ALLOWED as the PUSHDOWN method in the FunctionsDefinitions.xmi file.

As mentioned in the documentation it should be working fine if we specify the pushdown method as "ALLOWED" as well right?.

Thanks

Rakesh