topic Re: Salesforce component error "Cannot be resolved to a variable" in Talend Studio

Salesforce component error "Cannot be resolved to a variable"

Anonymous — Sat, 16 Nov 2024 11:35:49 GMT

Hi i am getting the following error for a salesforce output component.

Starting job ftest at 15:57 04/07/2014.
connecting to socket on port 3923
connected
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Sales_Coach_Section__c cannot be resolved to a variable
at testproject2.ftest_0_1.ftest.tSalesforceInput_1Process(ftest.java:1577)
at testproject2.ftest_0_1.ftest.runJobInTOS(ftest.java:1929)
at testproject2.ftest_0_1.ftest.main(ftest.java:1788)
Job ftest ended at 15:57 04/07/2014.

Re: Salesforce component error "Cannot be resolved to a variable"

Anonymous — Mon, 07 Jul 2014 03:26:55 GMT

Hi,
Could you please upload your salesforce output component setting screenshot into forum so that we can address your issue quickly.
Best regards
Sabrina

Re: Salesforce component error "Cannot be resolved to a variable"

Anonymous — Mon, 07 Jul 2014 09:08:27 GMT

Hi,
Please find attached the setting for the Salesforce Output Component.

Re: Salesforce component error "Cannot be resolved to a variable"

Anonymous — Mon, 07 Jul 2014 09:14:32 GMT

Hi,
Here is a response in your another forum https://community.talend.com/t5/Installing-and-Upgrading/resolved-Not-able-to-run-a-job/td-p/107881. You'd better stick to one forum so that we can pay individule attention on it.
Best regards
Sabrina

Re: Salesforce component error "Cannot be resolved to a variable"

Anonymous — Mon, 07 Jul 2014 09:21:29 GMT

Hi,
Please click on "post reply" (not through the quick post") so that you will get a Image upload box that allows to upload screen captures and images up to 200KB.(Limits: 20 images per post, each image must be less then 1024x768 pixels and 200 KB)
This would be easier for you and more convenient for other users than pasting urls
Have you tried to add start/end quote at Custom Object Name "Sales_Coach_Section__c"?
Best regards
Sabrina

Re: Salesforce component error "Cannot be resolved to a variable"

Anonymous — Mon, 01 Feb 2016 09:24:01 GMT

Hi Sabrina,
I'm facing the same issue with tSalesForceInput component.
I'm trying to load the data from SF to one .csv file, but it throws error.

Re: Salesforce component error "Cannot be resolved to a variable"

Anonymous — Tue, 02 Feb 2016 08:06:15 GMT

Hi,

Exception in thread "main" java.lang.Error: Unresolved compilation problem

Have you checked if there is any missing double quote in your SOQL query?
The screenshot of tSalesForceInput component setting will be preferred.
Best regards
Sabrina

Re: Salesforce component error "Cannot be resolved to a variable"

Anonymous — Tue, 02 Feb 2016 09:47:48 GMT

Hi Sabrina,
Please find the below cases,
1. I'm using only tSalesforce connection component alone and running the job, to verify whether all connections are valid!
-- This throws error as i mentioned below.
2. I have used tSalesforce connection --> tSalesforce Input component and loaded to tLog row, to verify the data fetch!
-- This also throws the same error as mentioned below.

But I have connected SF with Metadata connection, it got successfully connected, but while fetching data it throws this error.
>>>>
connecting to socket on port 3366
connected
Exception in component tSalesforceInput_2
org.apache.axis2.AxisFault: www.salesforce.com
at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:197)
at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:75)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:404)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:231)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:406)
at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229)
at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
at com.salesforce.soap.partner.SforceServiceStub.login(SforceServiceStub.java:17180)
at org.talend.salesforce.SforceBasicConnection.renewSession(SforceBasicConnection.java:77)
at org.talend.salesforce.SforceBasicConnection.init(SforceBasicConnection.java:71)
at org.talend.salesforce.SforceBasicConnection.<init>(SforceBasicConnection.java:49)
at org.talend.salesforce.SforceBasicConnection.<init>(SforceBasicConnection.java:25)
at org.talend.salesforce.SforceBasicConnection$Builder.build(SforceBasicConnection.java:125)
at local_project.my_sf_0_1.my_SF.tSalesforceInput_2Process(my_SF.java:1268)
at local_project.my_sf_0_1.my_SF.runJobInTOS(my_SF.java:2569)
at local_project.my_sf_0_1.my_SF.main(my_SF.java:2426)
Caused by: java.net.UnknownHostException: www.salesforce.com
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.<init>(Unknown Source)
at sun.security.ssl.SSLSocketFactoryImpl.createSocket(Unknown Source)
at org.apache.commons.httpclient.protocol.SSLProtocolSocketFactory.createSocket(SSLProtocolSocketFactory.java:82)
at org.apache.commons.httpclient.protocol.ControllerThreadSocketFactory$1.doit(ControllerThreadSocketFactory.java:91)
at org.apache.commons.httpclient.protocol.ControllerThreadSocketFactory$SocketTask.run(ControllerThreadSocketFactory.java:158)
at java.lang.Thread.run(Unknown Source)
disconnected
Job my_SF ended at 12:45 02/02/2016.
<<<<

Re: Salesforce component error "Cannot be resolved to a variable"

Anonymous — Wed, 03 Feb 2016 02:19:57 GMT

Hi,
What's your salesforce version? Could you please upload screenshot of tSalesForceInput component setting into forum? What does your salesforce webservice URL looks like?
Best regards
Sabrina

Re: Salesforce component error "Cannot be resolved to a variable"

Anonymous — Wed, 03 Feb 2016 04:08:26 GMT

Hi Sabrina,
Please find the requested screen shots below. I have created tSalesforce connections -> tSalesforce Input -> tLog Row.
While building job itself, it throws an error as mentioned. Request you to help on this!!