[teiid-issues] [JBoss JIRA] Commented: (TEIID-1388) Appears to be a limit of only one functional SalesForce connector in Teiid at a time.

Fri Dec 10 15:07:52 EST 2010

    [ https://issues.jboss.org/browse/TEIID-1388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12569373#comment-12569373 ] 

John Doyle commented on TEIID-1388:
-----------------------------------

This is in the server log.  I've tried turning off the ModifySOAPAddress attribute for JBoss WS in the JMX console, but it has no effect.

15:00:46,312 INFO  [ReflectionServiceFactoryBean] Creating Service {urn:partner.soap.sforce.com}SforceService from WSDL: vfszip:/NotBackedUp/jdoyle/soa-5.1-er5/jboss-soa-p-5/jboss-as/server/default/deploy/teiid/connectors/salesforce-api-7.1.1.jar/partner_v17.wsdl
15:00:46,538 INFO  [AddressRewritingEndpointInfo] Setting new service endpoint address in wsdl: https://www.salesforce.com/services/Soap/u/17.0
15:00:47,595 WARN  [AbstractServerConfig] Unable to calculate 'WebServiceSecurePort', using default '8443'
15:00:47,595 INFO  [AddressRewritingEndpointInfo] Setting new service endpoint address in wsdl: https://127.0.0.1:8443/services/Soap/u/17.0
15:00:47,928 INFO  [HttpsURLConnectionFactory] The cipher suites have not been configured, falling back to cipher suite filters.
15:00:47,928 INFO  [HttpsURLConnectionFactory] The cipher suite filters have not been configured, falling back to default filters.
15:00:47,929 INFO  [HttpsURLConnectionFactory] The cipher suites have been set to SSL_RSA_WITH_RC4_128_MD5, SSL_RSA_WITH_RC4_128_SHA, TLS_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_DSS_WITH_AES_128_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA, SSL_RSA_WITH_DES_CBC_SHA, SSL_DHE_RSA_WITH_DES_CBC_SHA, SSL_DHE_DSS_WITH_DES_CBC_SHA, SSL_RSA_EXPORT_WITH_RC4_40_MD5, SSL_RSA_EXPORT_WITH_DES40_CBC_SHA, SSL_DHE_RSA_EXPORT_WITH_DES40_CBC_SHA, SSL_DHE_DSS_EXPORT_WITH_DES40_CBC_SHA, TLS_KRB5_WITH_RC4_128_SHA, TLS_KRB5_WITH_RC4_128_MD5, TLS_KRB5_WITH_3DES_EDE_CBC_SHA, TLS_KRB5_WITH_3DES_EDE_CBC_MD5, TLS_KRB5_WITH_DES_CBC_SHA, TLS_KRB5_WITH_DES_CBC_MD5, TLS_KRB5_EXPORT_WITH_RC4_40_SHA, TLS_KRB5_EXPORT_WITH_RC4_40_MD5, TLS_KRB5_EXPORT_WITH_DES_CBC_40_SHA, TLS_KRB5_EXPORT_WITH_DES_CBC_40_MD5.  
15:00:52,364 INFO  [ReflectionServiceFactoryBean] Creating Service {urn:partner.soap.sforce.com}SforceService from WSDL: vfszip:/NotBackedUp/jdoyle/soa-5.1-er5/jboss-soa-p-5/jboss-as/server/default/deploy/teiid/connectors/salesforce-api-7.1.1.jar/partner_v17.wsdl
15:00:52,395 INFO  [AddressRewritingEndpointInfo] Setting new service endpoint address in wsdl: https://127.0.0.1:8443/services/Soap/u/17.0
15:00:52,573 WARN  [AbstractServerConfig] Unable to calculate 'WebServiceSecurePort', using default '8443'
15:00:52,573 INFO  [AddressRewritingEndpointInfo] Setting new service endpoint address in wsdl: https://127.0.0.1:8443/services/Soap/u/17.0
15:00:52,580 INFO  [HttpsURLConnectionFactory] The cipher suites have not been configured, falling back to cipher suite filters.
15:00:52,580 INFO  [HttpsURLConnectionFactory] The cipher suite filters have not been configured, falling back to default filters.
15:00:52,581 INFO  [HttpsURLConnectionFactory] The cipher suites have been set to SSL_RSA_WITH_RC4_128_MD5, SSL_RSA_WITH_RC4_128_SHA, TLS_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_DSS_WITH_AES_128_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA, SSL_RSA_WITH_DES_CBC_SHA, SSL_DHE_RSA_WITH_DES_CBC_SHA, SSL_DHE_DSS_WITH_DES_CBC_SHA, SSL_RSA_EXPORT_WITH_RC4_40_MD5, SSL_RSA_EXPORT_WITH_DES40_CBC_SHA, SSL_DHE_RSA_EXPORT_WITH_DES40_CBC_SHA, SSL_DHE_DSS_EXPORT_WITH_DES40_CBC_SHA, TLS_KRB5_WITH_RC4_128_SHA, TLS_KRB5_WITH_RC4_128_MD5, TLS_KRB5_WITH_3DES_EDE_CBC_SHA, TLS_KRB5_WITH_3DES_EDE_CBC_MD5, TLS_KRB5_WITH_DES_CBC_SHA, TLS_KRB5_WITH_DES_CBC_MD5, TLS_KRB5_EXPORT_WITH_RC4_40_SHA, TLS_KRB5_EXPORT_WITH_RC4_40_MD5, TLS_KRB5_EXPORT_WITH_DES_CBC_40_SHA, TLS_KRB5_EXPORT_WITH_DES_CBC_40_MD5.  
15:00:52,589 WARNING [PhaseInterceptorChain] Interceptor for {urn:partner.soap.sforce.com}SforceService#{urn:partner.soap.sforce.com}login has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: Could not send Message.
        at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:64)
        at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:243)
        at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:484)
        at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:310)
        at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:262)
        at org.apache.cxf.frontend.ClientProxy.invokeSync(ClientProxy.java:73)
        at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:124)
        at $Proxy441.login(Unknown Source)
        at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.login(SalesforceConnectionImpl.java:109)
        at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.<init>(SalesforceConnectionImpl.java:76)
        at org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory$1.getConnection(SalesForceManagedConnectionFactory.java:102)
        at org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory$1.getConnection(SalesForceManagedConnectionFactory.java:99)
        at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:70)
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:639)
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:547)
        at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:74)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:519)
        at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:550)
        at sun.net.NetworkClient.doConnect(NetworkClient.java:158)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:394)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:529)
        at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:272)
        at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:329)
        at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:172)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:793)
        at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:158)
        at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:896)
        at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(HttpsURLConnectionImpl.java:230)
        at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleHeadersTrustCaching(HTTPConduit.java:1954)
        at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.onFirstWrite(HTTPConduit.java:1906)
        at org.apache.cxf.io.AbstractWrappedOutputStream.write(AbstractWrappedOutputStream.java:42)
        at org.apache.cxf.io.AbstractThresholdOutputStream.write(AbstractThresholdOutputStream.java:69)
        at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.close(HTTPConduit.java:1972)
        at org.apache.cxf.transport.AbstractConduit.close(AbstractConduit.java:66)
        at org.apache.cxf.transport.http.HTTPConduit.close(HTTPConduit.java:640)
        at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:62)
        ... 16 more

> Appears to be a limit of only one functional SalesForce connector in Teiid at a time.
> -------------------------------------------------------------------------------------
>
>                 Key: TEIID-1388
>                 URL: https://issues.jboss.org/browse/TEIID-1388
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>    Affects Versions: 7.1.1
>         Environment: Teiid 7.1.1 in EDS ER5, JBDS Beta2, RHEL 5.1
>            Reporter: John Doyle
>            Assignee: John Doyle
>            Priority: Blocker
>
> It appears they only one SalesForce connector can be run at a time.  If you preview a model from Designer and there are no SF connections in Teiid, it works.  When you create a DS for the VDB and deploy, the VDB cannot get connections from SalesForce.  If you delete the preview VDB and Datasource, then the deployed VDB begins working.
> I originally suspected that the problem might be that we are running out of connections; SalesForce limits you to 5 simultaneous connections per username/password.  But I deployed the two DataSources with different credentials, and the result did not change.  Need to investigate more.
> Think that we do need to default the SF DS to a pool of 1 and then doc that it should be bumped to 5 for production.  The current default is 10, and that should never be.  Even 5 will exhaust the limit with just a preview connection.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira