One Star

Salesforce component error "Cannot be resolved to a variable"

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.

9 REPLIES
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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

Moderator

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

Hi,
Here is a response in your another forum http://www.talendforge.org/forum/viewtopic.php?id=37005. You'd better stick to one forum so that we can pay individule attention on it.
Best regards
Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

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

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.

Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

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

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.
<<<<

Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

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

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!!