• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 6 replies
  • Answers 2 answers
  • Subscribers 5 subscribers
  • Views 6311 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Integrations

Salesforce Integration failure

TJ
A Score Level 2

Hi,

Today, the Salesforce integration in my application has suddenly stopped with 'invalid credentails' error message. However, I see credentials are valid and I can even see a successful attempt marked in salesforce log. 

Can someone please help me in resolving this issue.

Appian version: 17.3

Salesforce function: a!sfcQuery()

Salesforce instance: ap6

Salesforce showing successful attempts: 

Stacktrace: 16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) ConnectorRuntimeException [title=Could not connect, com.appian.integration.core.exception.ConnectorRuntimeException: Failed to connect to the external system [key=salesforce]. The site-wide credentials may be incorrect. Please ask an administrator to update the credentials in the Third-Party Credentials page in the Administration Console. Connection failure details: null]
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appian.integration.salesforce.service.SalesforceConnectionFactory.createPartnerConnection(SalesforceConnectionFactory.java:62)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appian.integration.salesforce.service.SalesforceConnectionFactory.createSalesforceService(SalesforceConnectionFactory.java:45)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appian.integration.salesforce.function.QueryFunction.salesforceQuery_appian_internal(QueryFunction.java:49)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at sun.reflect.GeneratedMethodAccessor1244.invoke(Unknown Source)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at java.lang.reflect.Method.invoke(Method.java:498)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.process.expression.CustomFunction$1.call(CustomFunction.java:797)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:25)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.process.expression.CustomFunction.evaluate(CustomFunction.java:792)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.process.expression.CustomFunction.evalDynamic0(CustomFunction.java:240)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.process.expression.CustomFunction.evalDynamic(CustomFunction.java:228)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.process.expression.CustomFunction.eval0(CustomFunction.java:200)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.core.expr.DefaultEvaluable.eval(DefaultEvaluable.java:179)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.process.expression.ExpressionEvaluator.evaluate(ExpressionEvaluator.java:304)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.core.expr.FunctionCallDelegate$ExternalFunctionCallWithContext.eval(FunctionCallDelegate.java:296)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.core.expr.FunctionCallDelegate.evalCacheableFunctionCall(FunctionCallDelegate.java:126)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.core.expr.FunctionCallDelegate.evalFunctionCall(FunctionCallDelegate.java:92)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.core.expr.AppianScriptContextTop.evalExternalFunction(AppianScriptContextTop.java:349)
16:00:30,510 INFO [stdout] (ajp-/0.0.0.0:8009-7) at com.appiancorp.core.expr.AppianScriptContextChild.evalExternalFunction(AppianScriptContextChild.java:185)

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    Hi can you please cross check the password+acces_token, username etc.

    As per my understanding, you are trying to connect to Salesforce SOAP API having its version either 27.0 or 28.0, if so then please cross check the following:

    1. Salesforce API version is still 27.0 or 28.0 ( it's shouldn't be upgraded to latest version)
    2. Service type is SOAP
    2. cross check access_token+password along with others once again from salesforce side

    If you think, these all conditions are satisfying but still you are unable to communicate then I recommend use any Third party client such as SOAPUI etc.. and have a look whether are you able to communicate to salesforce? If no , then this indicates, there is nothing to do from you end (make sure to have a close look over the API version)

    Hope this will help you to determine the root cause of this issue.
  • 0 in reply to aloks0189
    Alok,
    What is the impact of Salesforce API version?
    What if it is upgraded?
  • 0
    Certified Lead Developer
     in reply to sanjays754
    Sanjay

    Salesforce Connector functions only work with Salesforce SOAP API version 27.0 or 28.0 as per the documentation. SO if your Salesforce API is other than these versions then connector functions wont be able to connect to these services.

    Hence If you are working with some other version of API then i recommend make the use of Integration Object of Appian to interact with Salesforce.
Reply Children
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.