teiid-designer-issues
April 2018
teiid-designer-issues@lists.jboss.org
- 1 participants
- 55 discussions
[JBoss JIRA] (TEIIDDES-3191) Problem with salesforce url
by Steven Hawkins (JIRA)
Steven Hawkins created TEIIDDES-3191:
----------------------------------------
Summary: Problem with salesforce url
Key: TEIIDDES-3191
URL: https://issues.jboss.org/browse/TEIIDDES-3191
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 11.1.3
Reporter: Mario Majernik
Priority: Blocker
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)
6 years
- 1
- 0
[JBoss JIRA] (TEIIDDES-3190) Problem with import from salesforce
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3190?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-3190:
------------------------------------------
So there may be two separate issues here. We need one issue spawned to cover the salesforce url on the Teiid / JDV side, and this issue can remain to cover the NPE on the Designer side.
> 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)
6 years
- 1
- 0
[JBoss JIRA] (TEIIDDES-3190) Problem with import from salesforce
by Mario Majernik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3190?page=com.atlassian.jira.plu... ]
Mario Majernik commented on TEIIDDES-3190:
------------------------------------------
[~shawkins] I tried to change the URL and it works fine for Teiid Connection import. I can import properly import tables from SF,
but not for Salesforce Import. I changed URL from empty/default to given and test connection (ping) worked. After clicking Finish button on the end of Salesforce import dialog I get NullPointer:
!ENTRY org.teiid.designer.modelgenerator.salesforce.ui 4 4 2018-04-25 11:38:47.230
!MESSAGE There was an import error.
!STACK 0
java.lang.NullPointerException
at org.teiid.designer.modelgenerator.salesforce.model.impl.SalesforceFieldImpl.getType(SalesforceFieldImpl.java:46)
at org.teiid.designer.modelgenerator.salesforce.RelationalModelgenerator.setColumnType(RelationalModelgenerator.java:351)
at org.teiid.designer.modelgenerator.salesforce.RelationalModelgenerator.addColumnsToTable(RelationalModelgenerator.java:271)
at org.teiid.designer.modelgenerator.salesforce.RelationalModelgenerator.addTableToModel(RelationalModelgenerator.java:195)
at org.teiid.designer.modelgenerator.salesforce.RelationalModelgenerator.createRelationalModel(RelationalModelgenerator.java:130)
at org.teiid.designer.modelgenerator.salesforce.SalesforceImportWizardManager.createModel(SalesforceImportWizardManager.java:250)
at org.teiid.designer.modelgenerator.salesforce.SalesforceImportWizardManager.runFinish(SalesforceImportWizardManager.java:209)
at org.teiid.designer.modelgenerator.salesforce.ui.wizards.SalesforceToRelationalImportWizard$1.run(SalesforceToRelationalImportWizard.java:154)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
> 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)
6 years
- 1
- 0
[JBoss JIRA] (TEIIDDES-3190) Problem with import from salesforce
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3190?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-3190:
------------------------------------------
This doesn't appear to directly be a designer issue. It looks like salesforce decommissioned using www urls for login, which is what we have set as the default since the 22 api in the resource adapter config:
Can you try setting up the resource adapter to have the URL property
https://login.salesforce.com/services/Soap/u/34.0 instead of https://www.salesforce.com/services/Soap/u/34.0
If that works, we'll move this jira over to teiid to correct the ra.xml files with the now invalid defaults.
> 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)
6 years
- 1
- 0
[JBoss JIRA] (TEIIDDES-3190) Problem with import from salesforce
by Mario Majernik (JIRA)
Mario Majernik created TEIIDDES-3190:
----------------------------------------
Summary: 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)
6 years
- 1
- 0
[JBoss JIRA] (TEIIDDES-2782) Copy paste sql to the transformation editor is not parsable
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2782?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2782:
-----------------------------------
Steps to Reproduce:
# import project from the attachment
# open transformation editor in the producer (SchemaModel/ResultSetDocument)
# copy the query from this
{code:java}
SELECT
convert(ID, double) AS producerID, NAME
FROM
TvGuideStaging.PRODUCTION_HOUSES
{code}
# Validate SQL
Alternate SQL
{code:java}
SELECT
'A' as x
{code}
was:
# import project from the attachment
# open transformation editor in the producer (SchemaModel/ResultSetDocument)
# copy the query from this
{code:java}
SELECT
convert(ID, double) AS producerID, NAME
FROM
TvGuideStaging.PRODUCTION_HOUSES
{code}
# Validate SQL
> Copy paste sql to the transformation editor is not parsable
> -----------------------------------------------------------
>
> Key: TEIIDDES-2782
> URL: https://issues.jboss.org/browse/TEIIDDES-2782
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Transformations
> Affects Versions: 10.0.1
> Environment: Windows 10 Pro N
> Windows 7 Enterprise
> Reporter: Matej Kralik
> Assignee: Ted Jones
> Priority: Critical
> Fix For: 11.1.3
>
> Attachments: XmlStagingProject.zip, endOfFile.mkv
>
>
> When I copy a sql query from any source (notepad, web browser ...) and paste it to the transformation editor show me that "The query is not parsable.Error in parsing of sql - null ."
> When I deleted all newlines from sql query or I wrote it myself to the editor, sql query was validated.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years
- 1
- 0
[JBoss JIRA] (TEIIDDES-3189) NPE after set function category during creating UDF
by Matej Kralik (JIRA)
Matej Kralik created TEIIDDES-3189:
--------------------------------------
Summary: NPE after set function category during creating UDF
Key: TEIIDDES-3189
URL: https://issues.jboss.org/browse/TEIIDDES-3189
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 11.1.3
Reporter: Matej Kralik
Priority: Blocker
Attachments: NPE_UDF.mkv, wizard.png
In the "Create User Defined Function" wizard I fill in name of the _Function Category_ but the wizard still shows error: "User defined function category is undefined" (wizard.png) and during typing the name of the function category, the Unhandled event loop exceptions (NPE) are throwing in the error log. Stack trace:
{code:java}
java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:460)
at org.teiid.designer.relational.model.RelationalProcedure.handleInfoChanged(RelationalProcedure.java:578)
at org.teiid.designer.relational.model.RelationalProcedure.setFunctionCategory(RelationalProcedure.java:355)
at org.teiid.designer.transformation.ui.editors.ViewProcedureEditorPanel$16.modifyText(ViewProcedureEditorPanel.java:680)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:180)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5348)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1348)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4602)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4183)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:818)
at org.eclipse.jface.window.Window.open(Window.java:794)
at org.teiid.designer.transformation.ui.actions.CreateViewProcedureAction.run(CreateViewProcedureAction.java:190)
at org.teiid.designer.transformation.ui.actions.CreateViewProcedureAction.run(CreateViewProcedureAction.java:174)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:473)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:565)
at org.eclipse.jface.action.ActionContributionItem.lambda$4(ActionContributionItem.java:397)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5348)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1348)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4602)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4183)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1150)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1039)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:153)
at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:680)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:594)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:151)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
at org.eclipse.equinox.launcher.Main.run(Main.java:1499)
at org.eclipse.equinox.launcher.Main.main(Main.java:1472)
{code}
When I want to continue and I select JAR file from the system, the wizard doesn't fill in the UDF Jar Path. (Maybe this behavior is caused by NPE before) However, TD imports JAR to the workspace so I must set JAR again from the workspace. After that, the error from the top of the wizard is disappeared and I am able to finish the wizard. After that, empty error windows appears.
I have uploaded the video with this behavior to the attachment too.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years
- 1
- 0
[JBoss JIRA] (TEIIDDES-3188) Generate model from DDL with UDF doesn't work
by Matej Kralik (JIRA)
Matej Kralik created TEIIDDES-3188:
--------------------------------------
Summary: Generate model from DDL with UDF doesn't work
Key: TEIIDDES-3188
URL: https://issues.jboss.org/browse/TEIIDDES-3188
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs
Affects Versions: 11.1.3
Environment: Windows
Fedora
Reporter: Matej Kralik
Priority: Blocker
Attachments: generate_from_ddl.png, generate_from_xml.png, viewUdfModel.ddl, viewUdfVDB-vdb.xml
Generate models and VDB from dynamic VDB (XML file) which contains UDF function doesn't work. After click on generate button, "the problem occurred" windows appears (generate_from_xml.png) with
{code:java}
An exception occurred while performing a VDB operation
* null
{code}
An exception stack trace is not available in the Error log.
Also, generate view model from the DDL file which contains UDF function doesn't work. The last step in the wizard shows NullPointerException (generate_from_ddl.png) and in the log is this stack trace:
{code:java}
java.lang.Exception: java.lang.NullPointerException
at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:54)
at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:116)
at org.teiid.designer.ddl.importer.ui.DdlImportDifferencesPage$1.run(DdlImportDifferencesPage.java:232)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
Caused by: java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:460)
at org.teiid.designer.relational.model.RelationalProcedure.handleInfoChanged(RelationalProcedure.java:578)
at org.teiid.designer.relational.model.RelationalProcedure.setJavaMethodName(RelationalProcedure.java:321)
at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.processTeiidProcedureOptions(TeiidDdlImporter.java:1189)
at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.processTeiidStandardOptions(TeiidDdlImporter.java:996)
at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.processOptions(TeiidDdlImporter.java:975)
at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createVirtualProcedure(TeiidDdlImporter.java:684)
at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createObject(TeiidDdlImporter.java:894)
at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.importNode(TeiidDdlImporter.java:778)
at org.teiid.designer.ddl.importer.DdlImporter.importTeiidDdl(DdlImporter.java:322)
at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:163)
at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:151)
at org.teiid.designer.ddl.importer.DdlImporter$1.tryToDo(DdlImporter.java:132)
at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:41)
... 3 more
{code}
I have tried all these cases with TD 11.1.1 and they work.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years
- 1
- 0
[JBoss JIRA] (TEIIDDES-2782) Copy paste sql to the transformation editor is not parsable
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2782?page=com.atlassian.jira.plu... ]
Paul Richardson commented on TEIIDDES-2782:
-------------------------------------------
[~blafond]
Testing / debugging brings the following conclusions:
# Adding a t == null check at the top of Teiid9ParserTokenManager.calculateOffset (can be added into jjt file for permanence) mitigates the parser error. This, I think has to be the most appropriate fix since everything in that method requires the presence of a token. I am not sure there is much else that can be done about these '\r'. Trying to duplicate this with '\n' or '\t' seems impossible and even copying the text into notepad then into the editor works fine.
# Whether the fix above is added or not, the comment handling still breaks in various situations and performs oddly, despite there being several quite complex unit tests in TestQuery9Parser. All the unit tests pass but there still remains an issue with comments moving around and disappearing. This, I think, represents an unrelated bug that would need to be investigated separately.
> Copy paste sql to the transformation editor is not parsable
> -----------------------------------------------------------
>
> Key: TEIIDDES-2782
> URL: https://issues.jboss.org/browse/TEIIDDES-2782
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Transformations
> Affects Versions: 10.0.1
> Environment: Windows 10 Pro N
> Windows 7 Enterprise
> Reporter: Matej Kralik
> Assignee: Ted Jones
> Priority: Critical
> Fix For: 11.1.3
>
> Attachments: XmlStagingProject.zip, endOfFile.mkv
>
>
> When I copy a sql query from any source (notepad, web browser ...) and paste it to the transformation editor show me that "The query is not parsable.Error in parsing of sql - null ."
> When I deleted all newlines from sql query or I wrote it myself to the editor, sql query was validated.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years
- 1
- 0
[JBoss JIRA] (TEIIDDES-2782) Copy paste sql to the transformation editor is not parsable
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2782?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2782:
----------------------------------------
[~phantomjinx] Paul. I debugged this in Windows and the SQL contains "\r\n" chars. The Teiid runtime's parser has no issue with these chars because the parser treats as special tokens and ignores them.
The feature you added that supports embedded comments and multi-line comments breaks this basic parsing (without any comments). At some point the token ends up being "null" which results in NPE's. I can add simple checks for "null" token in the Teiid8Parser.jjt but it partially breaks the comment feature and any embedded comment get's tacked on to the END of the SQL.
Also, with my partial fix, the parsing of our System Functions via SQL.sql files on Windows, results in the same NPE even without any comments in the SQL.
Bottom line is I'd like your help Monday understanding your comments feature code changes and how we can adapt to get past this Windows line feed char issue. Thx
> Copy paste sql to the transformation editor is not parsable
> -----------------------------------------------------------
>
> Key: TEIIDDES-2782
> URL: https://issues.jboss.org/browse/TEIIDDES-2782
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Transformations
> Affects Versions: 10.0.1
> Environment: Windows 10 Pro N
> Windows 7 Enterprise
> Reporter: Matej Kralik
> Assignee: Ted Jones
> Priority: Critical
> Fix For: 11.1.3
>
> Attachments: XmlStagingProject.zip, endOfFile.mkv
>
>
> When I copy a sql query from any source (notepad, web browser ...) and paste it to the transformation editor show me that "The query is not parsable.Error in parsing of sql - null ."
> When I deleted all newlines from sql query or I wrote it myself to the editor, sql query was validated.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years
- 1
- 0