-
1. Re: Help working with SalesForce in Teiid : Errors - TEIID30504 salesforce: TEIID30481
shawkins Mar 17, 2017 2:11 PM (in response to johncockson)That does look odd. Do you see the data source being created/added in the server log? And what is the full stack trace for the error in log?
-
2. Re: Help working with SalesForce in Teiid : Errors - TEIID30504 salesforce: TEIID30481
johncockson Mar 17, 2017 3:28 PM (in response to shawkins)Hi Steven,
Here is the trace and little bit of context. I see the translator is loaded and the vdb is loaded, however, I do not see the data source being added. That being said, I haven't spotted any of the functioning sources being added. I will continue to dig in.
16:35:18,029 DEBUG [org.teiid.TRANSPORT] (NIO8) processing message:MessageHolder: key=1094 contents=Invoke interface org.teiid.client.DQP.executeRequest
16:35:18,029 INFO [org.teiid.COMMAND_LOG] (NIO8) +GbQ3VMXtoC6 START USER COMMAND: startTime=2017-03-14 16:35:18.029 requestID=+GbQ3VMXtoC6.0 txID=null sessionID=+GbQ3VMXtoC6 applicationName=JDBC principal=a vdbName=salesforce vdbVersion=1.2.0 sql=Select Launch_Manager__c from salesforce.account
16:35:18,029 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 Request Thread +GbQ3VMXtoC6.0 with state NEW
16:35:18,029 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 +GbQ3VMXtoC6.0 Result set caching is disabled.
16:35:18,029 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 +GbQ3VMXtoC6.0 executing Select Launch_Manager__c from salesforce.account
16:35:18,033 INFO [org.teiid.PLANNER] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6
============================================================================
USER COMMAND:
SELECT salesforce.Account.Launch_Manager__c FROM salesforce.Account
----------------------------------------------------------------------------
OPTIMIZE:
SELECT salesforce.Account.Launch_Manager__c FROM salesforce.Account
----------------------------------------------------------------------------
GENERATE CANONICAL:
SELECT salesforce.Account.Launch_Manager__c FROM salesforce.Account
CANONICAL PLAN:
Project(groups=[salesforce.Account], props={PROJECT_COLS=[salesforce.Account.Launch_Manager__c]})
Source(groups=[salesforce.Account])
============================================================================
EXECUTING PlaceAccess
AFTER:
Project(groups=[salesforce.Account], props={PROJECT_COLS=[salesforce.Account.Launch_Manager__c]})
Access(groups=[salesforce.Account], props={SOURCE_HINT=null, MODEL_ID=Schema name=salesforce, nameInSource=null, uuid=mmuuid:8c761aa9-3756-4485-bfa1-9f5749b86068})
Source(groups=[salesforce.Account])
============================================================================
EXECUTING RaiseAccess
AFTER:
Access(groups=[salesforce.Account], props={SOURCE_HINT=null, MODEL_ID=Schema name=salesforce, nameInSource=null, uuid=mmuuid:8c761aa9-3756-4485-bfa1-9f5749b86068})
Project(groups=[salesforce.Account], props={PROJECT_COLS=[salesforce.Account.Launch_Manager__c]})
Source(groups=[salesforce.Account])
============================================================================
EXECUTING AssignOutputElements
AFTER:
Access(groups=[salesforce.Account], props={SOURCE_HINT=null, MODEL_ID=Schema name=salesforce, nameInSource=null, uuid=mmuuid:8c761aa9-3756-4485-bfa1-9f5749b86068, OUTPUT_COLS=[salesforce.Account.Launch_Manager__c]})
Project(groups=[salesforce.Account], props={PROJECT_COLS=[salesforce.Account.Launch_Manager__c], OUTPUT_COLS=[salesforce.Account.Launch_Manager__c]})
Source(groups=[salesforce.Account], props={OUTPUT_COLS=[salesforce.Account.Launch_Manager__c]})
============================================================================
EXECUTING CalculateCost
AFTER:
Access(groups=[salesforce.Account], props={SOURCE_HINT=null, MODEL_ID=Schema name=salesforce, nameInSource=null, uuid=mmuuid:8c761aa9-3756-4485-bfa1-9f5749b86068, OUTPUT_COLS=[salesforce.Account.Launch_Manager__c], EST_CARDINALITY=-1.0})
Project(groups=[salesforce.Account], props={PROJECT_COLS=[salesforce.Account.Launch_Manager__c], OUTPUT_COLS=[salesforce.Account.Launch_Manager__c], EST_CARDINALITY=-1.0})
Source(groups=[salesforce.Account], props={OUTPUT_COLS=[salesforce.Account.Launch_Manager__c], EST_COL_STATS={salesforce.Account.Launch_Manager__c=[-1.0, -1.0, -1.0]}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING PlanSorts
AFTER:
Access(groups=[salesforce.Account])
Project(groups=[salesforce.Account])
Source(groups=[salesforce.Account])
============================================================================
EXECUTING CollapseSource
AFTER:
Access(groups=[salesforce.Account], props={SOURCE_HINT=null, MODEL_ID=Schema name=salesforce, nameInSource=null, uuid=mmuuid:8c761aa9-3756-4485-bfa1-9f5749b86068, OUTPUT_COLS=[salesforce.Account.Launch_Manager__c], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT salesforce.Account.Launch_Manager__c FROM salesforce.Account})
============================================================================
CONVERTING PLAN TREE TO PROCESS TREE
PROCESS PLAN =
AccessNode(0) output=[salesforce.Account.Launch_Manager__c] SELECT salesforce.Account.Launch_Manager__c FROM salesforce.Account
============================================================================
----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
AccessNode(0) output=[salesforce.Account.Launch_Manager__c] SELECT salesforce.Account.Launch_Manager__c FROM salesforce.Account
============================================================================
16:35:18,033 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 ProcessTree for +GbQ3VMXtoC6.0 AccessNode(0) output=[salesforce.Account.Launch_Manager__c] SELECT salesforce.Account.Launch_Manager__c FROM salesforce.Account
16:35:18,033 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@7e4da1dd(+GbQ3VMXtoC6)
16:35:18,033 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 after getOrCreateTransactionContext : +GbQ3VMXtoC6 NONE ID:NONE
16:35:18,033 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 Creating TupleBuffer: 1281 [salesforce.Account.Launch_Manager__c] [class java.lang.String] batch size 4096 of type PROCESSOR
16:35:18,033 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 +GbQ3VMXtoC6.0.0.3 Create State
16:35:18,034 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 +GbQ3VMXtoC6.0.0.3 Blocking on source query +GbQ3VMXtoC6.0.0.3
16:35:18,034 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 +GbQ3VMXtoC6.0 Blocking on source request(s).
16:35:18,034 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue2518) +GbQ3VMXtoC6 Running task for parent thread Worker2_QueryProcessorQueue2517
16:35:18,034 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2517) +GbQ3VMXtoC6 Request Thread +GbQ3VMXtoC6.0 - processor blocked
16:35:18,034 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue2518) +GbQ3VMXtoC6 +GbQ3VMXtoC6.0.0.3 Processing NEW request: SELECT salesforce.Account.Launch_Manager__c FROM salesforce.Account
16:35:18,034 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue2518) +GbQ3VMXtoC6 ERROR SRC COMMAND: endTime=2017-03-14 16:35:18.034 requestID=+GbQ3VMXtoC6.0 sourceCommandID=0 executionID=3 txID=null modelName=salesforcetranslatorName=salesforce-34 sessionID=+GbQ3VMXtoC6 principal=a
16:35:18,034 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue2518) +GbQ3VMXtoC6 Connector worker process failed for atomic-request=+GbQ3VMXtoC6.0.0.3: org.teiid.translator.TranslatorException: TEIID30481 Failed to find the Connection Factory with JNDI name java:/salesforce34. Please check the name or deploy the Connection Factory with specified name.
at org.teiid.dqp.internal.datamgr.ConnectorManager.getConnectionFactory(ConnectorManager.java:335)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:324)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_91]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_91]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_91]
at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_91]
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220)
at com.sun.proxy.$Proxy24.execute(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_91]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91]
Caused by: javax.naming.NameNotFoundException: salesforce34 -- service jboss.naming.context.java.salesforce34
at org.jboss.as.naming.ServiceBasedNamingStore.lookup(ServiceBasedNamingStore.java:106)
at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:207)
at org.jboss.as.naming.InitialContext$DefaultInitialContext.lookup(InitialContext.java:235)
at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:193)
at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:189)
at javax.naming.InitialContext.lookup(InitialContext.java:417) [rt.jar:1.8.0_91]
at javax.naming.InitialContext.lookup(InitialContext.java:417) [rt.jar:1.8.0_91]
at org.teiid.dqp.internal.datamgr.ConnectorManager.getConnectionFactory(ConnectorManager.java:327)
... 18 more
16:35:18,044 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 Request Thread +GbQ3VMXtoC6.0 with state PROCESSING
16:35:18,044 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 +GbQ3VMXtoC6.0.0.3 Remove State
16:35:18,044 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 +GbQ3VMXtoC6.0.0.3 Processing Close : SELECT salesforce.Account.Launch_Manager__c FROM salesforce.Account
16:35:18,044 DEBUG [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 END SRC COMMAND: endTime=2017-03-14 16:35:18.044 requestID=+GbQ3VMXtoC6.0 sourceCommandID=0 executionID=3 txID=null modelName=salesforcetranslatorName=salesforce-34 sessionID=+GbQ3VMXtoC6 principal=a finalRowCount=0 cpuTime(ns)=9581384
16:35:18,045 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 QueryProcessor: closing processor
16:35:18,045 INFO [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 ERROR USER COMMAND: endTime=2017-03-14 16:35:18.045 requestID=+GbQ3VMXtoC6.0 txID=null sessionID=+GbQ3VMXtoC6 principal=a vdbName=salesforce vdbVersion=1.2.0 finalRowCount=null
16:35:18,045 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 TEIID30020 Processing exception for request +GbQ3VMXtoC6.0 'TEIID30504 salesforce-34: TEIID30481 Failed to find the Connection Factory with JNDI name java:/salesforce34. Please check the name or deploy the Connection Factory with specified name.'. Originally TeiidProcessingException 'salesforce34 -- service jboss.naming.context.java.salesforce34' ServiceBasedNamingStore.java:106.: org.teiid.core.TeiidProcessingException: TEIID30504 salesforce-34: TEIID30481 Failed to find the Connection Factory with JNDI name java:/salesforce34. Please check the name or deploy the Connection Factory with specified name.
at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:161) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:393) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:477) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-9.1.1.jar:9.1.1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91]
Caused by: org.teiid.translator.TranslatorException: TEIID30481 Failed to find the Connection Factory with JNDI name java:/salesforce34. Please check the name or deploy the Connection Factory with specified name.
at org.teiid.dqp.internal.datamgr.ConnectorManager.getConnectionFactory(ConnectorManager.java:335) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:324) [teiid-engine-9.1.1.jar:9.1.1]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_91]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_91]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_91]
at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_91]
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220) [teiid-engine-9.1.1.jar:9.1.1]
at com.sun.proxy.$Proxy24.execute(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-9.1.1.jar:9.1.1]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-9.1.1.jar:9.1.1]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_91]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-9.1.1.jar:9.1.1]
... 6 more
Caused by: javax.naming.NameNotFoundException: salesforce34 -- service jboss.naming.context.java.salesforce34
at org.jboss.as.naming.ServiceBasedNamingStore.lookup(ServiceBasedNamingStore.java:106) [wildfly-naming-10.0.0.Final.jar:10.0.0.Final]
at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:207) [wildfly-naming-10.0.0.Final.jar:10.0.0.Final]
at org.jboss.as.naming.InitialContext$DefaultInitialContext.lookup(InitialContext.java:235) [wildfly-naming-10.0.0.Final.jar:10.0.0.Final]
at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:193) [wildfly-naming-10.0.0.Final.jar:10.0.0.Final]
at org.jboss.as.naming.NamingContext.lookup(NamingContext.java:189) [wildfly-naming-10.0.0.Final.jar:10.0.0.Final]
at javax.naming.InitialContext.lookup(InitialContext.java:417) [rt.jar:1.8.0_91]
at javax.naming.InitialContext.lookup(InitialContext.java:417) [rt.jar:1.8.0_91]
at org.teiid.dqp.internal.datamgr.ConnectorManager.getConnectionFactory(ConnectorManager.java:327) [teiid-engine-9.1.1.jar:9.1.1]
... 18 more
16:35:18,046 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 Removing tuplesource for the request +GbQ3VMXtoC6.0
16:35:18,046 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 Removing TupleBuffer: 1281
16:35:18,046 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 +GbQ3VMXtoC6.0 Finished Processing
16:35:18,047 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2519) +GbQ3VMXtoC6 org.teiid.core.TeiidProcessingException: TEIID30504 salesforce-34: TEIID30481 Failed to find the Connection Factory with JNDI name java:/salesforce34. Please check the name or deploy the Connection Factory with specified name. Sending error to client +GbQ3VMXtoC6.0
-
3. Re: Help working with SalesForce in Teiid : Errors - TEIID30504 salesforce: TEIID30481
johncockson Mar 17, 2017 4:47 PM (in response to shawkins)One more item found in log that seems useful.
20:43:59,642 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 50) WFLYCTL0013: Operation ("add") failed - address: ([
("subsystem" => "resource-adapters"),
("resource-adapter" => "salesforce-34")
]) - failure description: "WFLYJCA0073: Failed to load module for RA [org.jboss.teiid.resource-adapter.salesforce-34]"
I don't see any reason the resource adapter would have trouble loading. I believe it is in order here.
-
4. Re: Help working with SalesForce in Teiid : Errors - TEIID30504 salesforce: TEIID30481
shawkins Mar 17, 2017 8:29 PM (in response to johncockson)Use the main slot for the resource adapter. There may have been something left over from [TEIID-4028] adding salesforce-34 resource adapter does not work through the cli - JBoss Issue Tracker that still refers to using slot 34
-
5. Re: Help working with SalesForce in Teiid : Errors - TEIID30504 salesforce: TEIID30481
rareddy Mar 18, 2017 5:34 AM (in response to johncockson)What is the Teiid version you are working with?
-
6. Re: Help working with SalesForce in Teiid : Errors - TEIID30504 salesforce: TEIID30481
johncockson Mar 20, 2017 12:01 PM (in response to shawkins)Thanks Steven!