[
https://issues.jboss.org/browse/TEIIDDES-1876?page=com.atlassian.jira.plu...
]
Paul Richardson commented on TEIIDDES-1876:
-------------------------------------------
Stacktrace of error:
{code}
13:32:05,559 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876:
Starting deployment of "PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_EMPLO
YEEDATA_source.vdb" (runtime-name:
"PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_EMPLOYEEDATA_source.vdb")
13:32:05,592 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50029 VDB
PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_EMPLOYEEDATA_source.1 model
"EMPLOYEEDA
TA_source" metadata is currently being loaded. Start Time: 10/3/13 1:32 PM
13:32:05,595 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB
PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_EMPLOYEEDATA_source.1 model
"EMPLOYEEDATA_source" metadata loaded. End Time: 10/3/13 1:32 PM
13:32:05,610 ERROR [org.jboss.threads.executor] (teiid-async-threads - 3) Task execution
failed for task org.teiid.jboss.VDBService$6@11b9d4d:
org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF
"buildFullName", since its invocation class
"org.teiid.core.designer.examples.NameBuilder" could not be found.
at
org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:324)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:225)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:99)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:86)
[teiid-runtime-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:262)
[teiid-runtime-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:290)
[teiid-runtime-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:191)
[teiid-runtime-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.jboss.VDBService.access$1000(VDBService.java:92)
[teiid-jboss-integration-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.jboss.VDBService$6.run(VDBService.java:407)
[teiid-jboss-integration-8.4.0.Final.jar:8.4.0.Final]
at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806)
at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:847)
at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: java.lang.ClassNotFoundException: org.teiid.core.designer.examples.NameBuilder
from [Module
"deployment.PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_EMPLOYEEDATA_source.vdb:main"
from Service Module Loader]
at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:196)
[jboss-modules.jar:1.2.0.Final-redhat-1]
at
org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:444)
[jboss-modules.jar:1.2.0.Final-redhat-1]
at
org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:432)
[jboss-modules.jar:1.2.0.Final-redhat-1]
at
org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:432)
[jboss-modules.jar:1.2.0.Final-redhat-1]
at
org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:374)
[jboss-modules.jar:1.2.0.Final-redhat-1]
at
org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:119)
[jboss-modules.jar:1.2.0.Final-redhat-1]
at java.lang.Class.forName0(Native Method) [rt.jar:1.7.0_25]
at java.lang.Class.forName(Class.java:270) [rt.jar:1.7.0_25]
at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:314)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
... 14 more
13:32:05,617 INFO [org.jboss.as.server] (management-handler-thread - 8) JBAS018559:
Deployed
"PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_EMPLOYEEDATA_source.vdb"
(runtime-name :
"PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_EMPLOYEEDATA_source.vdb")
13:32:06,748 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50026 VDB
"PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_project.1[]" undeployed.
13:32:06,756 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015877:
Stopped deployment PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_project.vdb
(runtime-name: PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_project.vdb) in 10ms
13:32:06,779 INFO [org.jboss.as.repository] (management-handler-thread - 10) JBAS014901:
Content removed from location
/opt/jboss-7.1/standalone/data/content/a1/6ca16955470d0543a92a037d29f6971fb585eb/content
13:32:06,779 INFO [org.jboss.as.server] (management-handler-thread - 10) JBAS018558:
Undeployed "PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_project.vdb"
(runtime-name:
"PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_project.vdb")
13:32:06,820 INFO [org.jboss.as.repository] (management-handler-thread - 11) JBAS014900:
Content added at location
/opt/jboss-7.1/standalone/data/content/a2/bc54dcbd639038aa590f7f58e933c9aa62d2f6/content
13:32:06,821 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876:
Starting deployment of
"PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_project.vdb"
(runtime-name:
"PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_project.vdb")
13:32:06,864 INFO [org.jboss.as.server] (management-handler-thread - 11) JBAS018559:
Deployed "PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_project.vdb"
(runtime-name :
"PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_project.vdb")
13:32:13,863 WARN [org.teiid.SECURITY] (New I/O worker #2) null TEIID40011 Processing
exception 'TEIID40046 VDB
"PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_project" version
"latest" does not exist.' for session null. Exception type
org.teiid.client.security.LogonException thrown from
org.teiid.services.SessionServiceImpl.getActiveVDB(SessionServiceImpl.java:259). Enable
more detailed logging to see the entire stacktrace.
13:39:45,483 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50026 VDB
"PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_EMPLOYEE_VIEWS.1[EMPLOYEE_VIEWS{}]"
undeployed.
13:39:45,488 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015877:
Stopped deployment PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_EMPLOYEE_VIEWS.vdb
(runtime-name: PREVIEW_83d2c246-065f-4667-a958-48d5a121b74b_TestUDF_EMPLOYEE_VIEWS.vdb) in
6ms
{code}
Incorrect UDF class path/name results in Invalid JDBC
username/password message trying to preview
-------------------------------------------------------------------------------------------------
Key: TEIIDDES-1876
URL:
https://issues.jboss.org/browse/TEIIDDES-1876
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview, VDB & Execution
Affects Versions: 8.3
Reporter: Barry LaFond
Assignee: Paul Richardson
Fix For: 8.3
Attachments: TestUDF.zip
1) open the attached Model Project Set for testing UDFs
2) set-up and start an EAP 6.1 + Teiid 8.4.x server
3) Select and preview "EMPLOYEE_VIEWS.EMPLOYEEDATA" table
4) Get an error dialog stating: "Validate the JDBC username & password in the
default Teiid Instance"
5) Select "buildFullName()" procedure and change Java Class to:
org.teiid.designer.examples.NameBuilder and SAVE
6) Select and preview same table
7) Preview works
Don't know if we can discover the REAL error, but this is confusing
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira