Does JBoss EAP 6.1, Teiid 8.6, Teiid Designer 8.3, and the SalesForce connector work?

[bbuikema]

I am unable to get JBoss EAP 6.1, Teiid 8.6, Teiid Designer 8.3, and the SalesForce connector to work, and I'm wondering if there is a simple config problem, or maybe they just don't work yet.

At the teiid server, I get the following error:

13:02:38,185 ERROR [org.jboss.remoting.remote.connection] (Remoting "brian2-macbook-air:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer

13:02:38,186 ERROR [org.jboss.remoting.remote.connection] (Remoting "brian2-macbook-air:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer

13:02:38,189 ERROR [org.jboss.remoting.remote.connection] (Remoting "brian2-macbook-air:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer

13:02:38,255 ERROR [org.jboss.remoting.remote.connection] (Remoting "brian2-macbook-air:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer

13:02:38,255 ERROR [org.jboss.remoting.remote.connection] (Remoting "brian2-macbook-air:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer

13:02:38,257 ERROR [org.jboss.remoting.remote.connection] (Remoting "brian2-macbook-air:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer

13:02:38,296 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3)  IJ020001: Required license terms for file:/Users/dev/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/salesforce/main/./

13:02:38,423 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3)  IJ020001: Required license terms for file:/Users/dev/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/salesforce/main/./

13:02:38,433 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-3)  MSC000001: Failed to start service jboss.ra.deployment.PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel_1: org.jboss.msc.service.StartException in service jboss.ra.deployment.PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel_1: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel]

  at org.jboss.as.connector.services.resourceadapters.deployment.ResourceAdapterXmlDeploymentService.start(ResourceAdapterXmlDeploymentService.java:131)

  at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]

  at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]

  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [classes.jar:1.6.0_51]

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [classes.jar:1.6.0_51]

  at java.lang.Thread.run(Thread.java:680) [classes.jar:1.6.0_51]

Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel]

  at org.jboss.as.connector.services.resourceadapters.deployment.ResourceAdapterXmlDeploymentService.start(ResourceAdapterXmlDeploymentService.java:115)

  ... 5 more

Caused by: org.jboss.jca.deployers.common.DeployException: IJ020060: Unable to inject: org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory property: url value: https://cs30.salesforce.com/services/Soap/u/29.0

  at org.jboss.jca.deployers.common.AbstractResourceAdapterDeployer.createObjectsAndInjectValue(AbstractResourceAdapterDeployer.java:1913)

  at org.jboss.as.connector.services.resourceadapters.deployment.ResourceAdapterXmlDeploymentService$AS7RaXmlDeployer.doDeploy(ResourceAdapterXmlDeploymentService.java:183)

  at org.jboss.as.connector.services.resourceadapters.deployment.ResourceAdapterXmlDeploymentService.start(ResourceAdapterXmlDeploymentService.java:108)

  ... 5 more

13:02:38,438 INFO  [org.jboss.as.controller] (management-handler-thread - 2)  JBAS014774: Service status report

JBAS014777:   Services which failed to start:      service jboss.ra.deployment.PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel_1: org.jboss.msc.service.StartException in service jboss.ra.deployment.PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel_1: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel]

At the designer, I get the following error:

TEIID70006 {"JBAS014671: Failed services" => {"jboss.ra.deployment.PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel_1" => "org.jboss.msc.service.StartException in service jboss.ra.deployment.PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel_1: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel]

    Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel]

    Caused by: org.jboss.jca.deployers.common.DeployException: IJ020060: Unable to inject: org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory property: url value: https://cs30.salesforce.com/services/Soap/u/29.0"}}

Thanks

[rareddy]

Brian,

Yes, it works. This is not a new feature for Teiid.

How did you create the data source for the SalesForce? The "URL" property is defined in the lower case, it needs to be all upper case. the Connector framework in JBoss AS does not accept improper casing.

If you used Designer to create datasource, please tell us steps you took, that would be a bug.

Ramesh..

[mdrillin]

It may be that we don't support v29 of the SF api yet.  I'm not sure when the SF connector was built last, but we still default to v22 of the api.  could try changing to v22 to see if it will connect.

[bbuikema]

Hi Ramesh,

Yes I am using the Teiid Designer v8.3.  Am I right to assume you're are saying that the URL property value must be in upper case within the connection profile?  For example, "HTTPS://CS30.SALESFORCE.COM/SERVICES/SOAP/U/29.0".  Please confirm.

My steps thus far, are simply to

1) start my external jboss running teiid 8.6 and my teiid instance within the designer

2) create a teiid model project

3) import a salesforce model

4) supply un, pw, and url

5) test connection...

6) select a table from the model, e.g., Account

6) select preview data

All help is much appreciated!

Brian

[rareddy]

Brian,

Yes, you are correct. Preview is not working. I could recreate it very easily. The issue is when Designer trying to create a data source in the JBoss AS, it is using a wrong property name, "url" instead of "URL". JBoss AS connector mechanism seems to be very restrictive on the names of the properties.

Please create JIRA here Teiid Designer - JBoss Issue Tracker

Workarounds

1) After the error dialog pops up, click ok. Then go the JBoss AS server installation find "standalone/configuration/standalone-teiid.xml" file and search for "PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel" (or what ever error said), then change the property name to "URL" instead of "url". Save and restart the server and try again previewing.

2) In imports itself, there is another import option called "Teiid Connection >> Source Model", using this wizard create connection to sales force and create a source model. This one understands the property correctly. Once the model is created you can use preview on this model.

Ramesh..

[rareddy]

Logged [TEIIDDES-2013] Preview with SalesForce data source does not wrok - JBoss Issue Tracker