[teiid-issues] [JBoss JIRA] (TEIID-5329) Problem with salesforce url
Johnathon Lee (JIRA)
issues at jboss.org
Tue Sep 18 15:20:00 EDT 2018
[ https://issues.jboss.org/browse/TEIID-5329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Johnathon Lee updated TEIID-5329:
---------------------------------
Fix Version/s: 8.12.16.6_4
> Problem with salesforce url
> ---------------------------
>
> Key: TEIID-5329
> URL: https://issues.jboss.org/browse/TEIID-5329
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Mario Majernik
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 10.3, 10.1.4, 10.2.2, 8.12.16.6_4
>
>
> 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
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list