Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2678

Cannot execute VDB which include UDF

XMLWordPrintable

      When I want execute VDB which include view Table with user define function, show me this dialog in the teiid designer : "Cannot execute VDB - still loading" and server show this stack trace:

      ERROR [stderr] (teiid-async-threads - 1) Exception in thread "teiid-async-threads - 1" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "ConcatNull", since its invocation class "userdefinedfunctions.ConcatNull" could not be found.
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:285)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:190)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:91)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:85)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:265)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:291)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:202)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.jboss.VDBService.access$1100(VDBService.java:85)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.jboss.VDBService$6.run(VDBService.java:411)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.jboss.VDBService$7.run(VDBService.java:442)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at java.lang.Thread.run(Thread.java:745)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.jboss.threads.JBossThread.run(JBossThread.java:122)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) Caused by: java.lang.ClassNotFoundException: userdefinedfunctions.ConcatNull from [Module "deployment.UdfVdb.vdb:main" from Service Module Loader]
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
      14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) 	at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
      14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) 	at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
      14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) 	at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
      14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) 	at java.lang.Class.forName0(Native Method)
      14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) 	at java.lang.Class.forName(Class.java:348)
      14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
      14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) 	at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:275)
      14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) 	... 13 more
      

        1. user-defined-function-example.zip
          57 kB
        2. Windows 7.png
          Windows 7.png
          160 kB
        3. windowsUDF.zip
          66 kB

            parichar@redhat.com Paul Richardson
            mkralik@redhat.com Matej Kralik
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: