-
15. Re: How to add FunctionDefinitions.xmi to VDB using Designer 7.0
rakeshsagar Aug 5, 2010 3:30 AM (in response to rareddy)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 VDBPlease suggest.
Thanks
Rakesh.
-
16. Re: How to add FunctionDefinitions.xmi to VDB using Designer 7.0
rareddy Aug 5, 2010 2:16 PM (in response to rakeshsagar)Oops, I am sorry when I re-packaged the VDB, I did it wrong and let the root directory in place. Also, it seems like in 7.0 we calculated the "path" information incorrectly for the Function model (that has been since fixed). I am attaching the correct VDB now and I tested on 7.0 release too.
If you rebuild the VDB again, just make the same changes I made, then you will be fine. Once the 7.1.0-CR2 is out, if upgrade to that version of the server then you do not need to make this manual modifications anymore.
Ramesh..
-
17. Re: How to add FunctionDefinitions.xmi to VDB using Designer 7.0
rakeshsagar Aug 6, 2010 2:35 AM (in response to rareddy)Hi Ramesh,
I think you have forgor to attach the VDB file to the discussion reply.
Kindly attach the VDB.
Thanks
Rakesh
-
18. Re: How to add FunctionDefinitions.xmi to VDB using Designer 7.0
rareddy Aug 6, 2010 10:29 AM (in response to rakeshsagar)sorry, here it is.
-
SecAdminNew.vdb.zip 29.6 KB
-
-
19. Re: How to add FunctionDefinitions.xmi to VDB using Designer 7.0
rakeshsagar Aug 9, 2010 5:34 AM (in response to rareddy)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
-
TeiidUDF.jar 1.3 KB
-
SecAdmin.vdb.zip 29.4 KB
-
-
20. Re: How to add FunctionDefinitions.xmi to VDB using Designer 7.0
rareddy Aug 9, 2010 11:14 AM (in response to rakeshsagar)You may have marked this function's "pushdown" property as "REQUIRED" in the Designer. When this property is set, you are telling Teiid that this function needs to be evaluated by the physical source, which does not seem to be your situation. Fix it in the Designer and set it to "NEVER" and re-deploy. Read here.
Ramesh..
-
21. Re: How to add FunctionDefinitions.xmi to VDB using Designer 7.0
rakeshsagar Aug 10, 2010 2:45 AM (in response to rareddy)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