2:31 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-3190?page=com.atlassian.jira.plu...
]
Matus Makovy edited comment on TEIIDDES-3190 at 4/27/18 8:30 AM:
-----------------------------------------------------------------
So, today I looked into this.
I logged 3 JIRAs:
* TEIIDDES-3196 - Importing from Salesforce through Teiid Connection Import doesn't
work - blocker
* TEIIDDES-3195 - Preview VDB from salesforce source model has wrong namespace set -
critical
* TEIIDDES-3194 - Importing from Salesforce using Salesforce importer uses wrong URL to
connect - critical
** This is maybe more a Teiid issue (TEIID-5329), so I will maybe close this right away
(sorry)
All of these talk about salesforce 22. According to Barry if we want to support Salesforce
34 we need to do more enhancements in designer.
I will close this one(3190), since I think it is not needed anymore. The NPE is there when
you try to import from SF-34.
was (Author: mmakovy):
So, today I looked into this.
I logged 3 JIRAs:
* TEIIDDES-3196 - Importing from Salesforce through Teiid Connection Import doesn't
work - blocker
* TEIIDDES-3195 - Preview VDB from salesforce source model has wrong namespace set -
critical
* TEIIDDES-3194 - Importing from Salesforce using Salesforce importer uses wrong URL to
connect - critical
** This is maybe more a Teiid issue (TEIID-5329), so I will maybe close this right away
(sorry)
All of these talk about salesforce 22. According to Barry if we want to support Salesforce
34 we need to do more enhancements in designer.
I will close this one(3190), since I think it is not needed anymore. The NPE is there when
you try to import from SF-34.
Problem with import from salesforce
-----------------------------------
Key: TEIIDDES-3190
URL: https://issues.jboss.org/browse/TEIIDDES-3190
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 11.1.3
Reporter: Mario Majernik
Priority: Blocker
Attachments: sales.png
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)
2513
days inactive
2513
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
participants (1)
-
Matus Makovy (JIRA)