-
Bug
-
Resolution: Obsolete
-
Blocker
-
None
-
11.1.3
-
None
Import from salesforce do not work on TD 11.1.3 (neither with Teiid Connection import nor with Saleforce import)
Last step: see sales.png image
Server log:
4:25:34,589 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015876: Starting deployment of "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml")
14:25:34,616 ERROR [stderr] (MSC service thread 1-2) ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
14:25:34,619 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-2) TEIID40118 VDB importVDB.1 added to the repository
14:25:34,620 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB importVDB.1 model "importVDBSrcModel" metadata is currently being loaded. Start Time: 4/24/18 2:25 PM
14:25:34,677 INFO [org.jboss.as.server] (management-handler-thread - 7) JBAS015859: Deployed "importVDB-vdb.xml" (runtime-name : "importVDB-vdb.xml")
14:25:36,253 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (teiid-async-threads - 4) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: com.sforce.ws.ConnectionException: Failed to send request to https://www.salesforce.com/services/Soap/u/34.0
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.login(SalesforceConnectionImpl.java:178)
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.<init>(SalesforceConnectionImpl.java:88)
at org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory$1.getConnection(SalesForceManagedConnectionFactory.java:98)
at org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory$1.getConnection(SalesForceManagedConnectionFactory.java:93)
at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:71) [teiid-api-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:858)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:413)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:457)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:429)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:344)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:317)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:499)
at org.teiid.resource.spi.WrappedConnectionFactory.getConnection(WrappedConnectionFactory.java:58) [teiid-api-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:181) [teiid-api-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:202) [teiid-api-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:72)
at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_162]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_162]
at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_162]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: com.sforce.ws.ConnectionException: Failed to send request to https://www.salesforce.com/services/Soap/u/34.0
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:121) [force-wsc-34.0.0.jar:]
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.java:1402) [force-partner-api-34.0.0.jar:]
at org.teiid.resource.adapter.salesforce.TeiidPartnerConnection.login(TeiidPartnerConnection.java:54)
at com.sforce.soap.partner.PartnerConnection.<init>(PartnerConnection.java:426) [force-partner-api-34.0.0.jar:]
at org.teiid.resource.adapter.salesforce.TeiidPartnerConnection.<init>(TeiidPartnerConnection.java:46)
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.login(SalesforceConnectionImpl.java:158)
... 23 more
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:210) [rt.jar:1.8.0_162]
at java.net.SocketInputStream.read(SocketInputStream.java:141) [rt.jar:1.8.0_162]
at sun.security.ssl.InputRecord.readFully(InputRecord.java:465) [jsse.jar:1.8.0_162]
at sun.security.ssl.InputRecord.read(InputRecord.java:503) [jsse.jar:1.8.0_162]
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:983) [jsse.jar:1.8.0_162]
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:940) [jsse.jar:1.8.0_162]
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) [jsse.jar:1.8.0_162]
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246) [rt.jar:1.8.0_162]
at java.io.BufferedInputStream.read1(BufferedInputStream.java:286) [rt.jar:1.8.0_162]
at java.io.BufferedInputStream.read(BufferedInputStream.java:345) [rt.jar:1.8.0_162]
at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:735) [rt.jar:1.8.0_162]
at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:678) [rt.jar:1.8.0_162]
at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:706) [rt.jar:1.8.0_162]
at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1587) [rt.jar:1.8.0_162]
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1492) [rt.jar:1.8.0_162]
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:263) [rt.jar:1.8.0_162]
at com.sforce.ws.transport.JdkHttpTransport.getContent(JdkHttpTransport.java:200) [force-wsc-34.0.0.jar:]
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:97) [force-wsc-34.0.0.jar:]
... 28 more
14:25:36,263 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID31178 Could not obtain connection for schema importVDBSrcModel, but one is required for metadata load. : org.teiid.translator.TranslatorException: TEIID31178 Could not obtain connection for schema importVDBSrcModel, but one is required for metadata load.
at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:76) [teiid-engine-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) [teiid-engine-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_162]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_162]
at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_162]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: org.teiid.translator.TranslatorException: TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/salesForceDS
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:183) [teiid-api-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:202) [teiid-api-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:72) [teiid-engine-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
... 8 more
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/salesForceDS
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:410) [ironjacamar-core-impl-1.0.39.Final-redhat-1.jar:1.0.39.Final-redhat-1]
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:317) [ironjacamar-core-impl-1.0.39.Final-redhat-1.jar:1.0.39.Final-redhat-1]
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:499) [ironjacamar-core-impl-1.0.39.Final-redhat-1.jar:1.0.39.Final-redhat-1]
at org.teiid.resource.spi.WrappedConnectionFactory.getConnection(WrappedConnectionFactory.java:58) [teiid-api-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:181) [teiid-api-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
... 10 more
Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying to create a connection: null
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:454) [ironjacamar-core-impl-1.0.39.Final-redhat-1.jar:1.0.39.Final-redhat-1]
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:457) [ironjacamar-core-impl-1.0.39.Final-redhat-1.jar:1.0.39.Final-redhat-1]
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:429) [ironjacamar-core-impl-1.0.39.Final-redhat-1.jar:1.0.39.Final-redhat-1]
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:344) [ironjacamar-core-impl-1.0.39.Final-redhat-1.jar:1.0.39.Final-redhat-1]
... 14 more
Caused by: javax.resource.ResourceException: com.sforce.ws.ConnectionException: Failed to send request to https://www.salesforce.com/services/Soap/u/34.0
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.login(SalesforceConnectionImpl.java:178)
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.<init>(SalesforceConnectionImpl.java:88)
at org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory$1.getConnection(SalesForceManagedConnectionFactory.java:98)
at org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory$1.getConnection(SalesForceManagedConnectionFactory.java:93)
at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:71) [teiid-api-8.12.11.6_4-redhat-64-12.jar:8.12.11.6_4-redhat-64-12]
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:858) [ironjacamar-core-impl-1.0.39.Final-redhat-1.jar:1.0.39.Final-redhat-1]
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:413) [ironjacamar-core-impl-1.0.39.Final-redhat-1.jar:1.0.39.Final-redhat-1]
... 17 more
Caused by: com.sforce.ws.ConnectionException: Failed to send request to https://www.salesforce.com/services/Soap/u/34.0
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:121)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.java:1402)
at org.teiid.resource.adapter.salesforce.TeiidPartnerConnection.login(TeiidPartnerConnection.java:54)
at com.sforce.soap.partner.PartnerConnection.<init>(PartnerConnection.java:426)
at org.teiid.resource.adapter.salesforce.TeiidPartnerConnection.<init>(TeiidPartnerConnection.java:46)
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.login(SalesforceConnectionImpl.java:158)
... 23 more
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:210) [rt.jar:1.8.0_162]
at java.net.SocketInputStream.read(SocketInputStream.java:141) [rt.jar:1.8.0_162]
at sun.security.ssl.InputRecord.readFully(InputRecord.java:465) [jsse.jar:1.8.0_162]
at sun.security.ssl.InputRecord.read(InputRecord.java:503) [jsse.jar:1.8.0_162]
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:983) [jsse.jar:1.8.0_162]
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:940) [jsse.jar:1.8.0_162]
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) [jsse.jar:1.8.0_162]
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246) [rt.jar:1.8.0_162]
at java.io.BufferedInputStream.read1(BufferedInputStream.java:286) [rt.jar:1.8.0_162]
at java.io.BufferedInputStream.read(BufferedInputStream.java:345) [rt.jar:1.8.0_162]
at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:735) [rt.jar:1.8.0_162]
at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:678) [rt.jar:1.8.0_162]
at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:706) [rt.jar:1.8.0_162]
at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1587) [rt.jar:1.8.0_162]
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1492) [rt.jar:1.8.0_162]
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:263) [rt.jar:1.8.0_162]
at com.sforce.ws.transport.JdkHttpTransport.getContent(JdkHttpTransport.java:200)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:97)
... 28 more
- is cloned by
-
TEIID-5329 Problem with salesforce url
- Resolved