Salesforce Connection Setup Issue

[KarthikG]

Hi All,

I am doing a connection to Salesforce application integration into Saviynt. We selected the connection type Salesforce, connection part we are passing required parameters (Client Id, Client secret, Refresh token, Redirect URL, Instance URL), When the connection in Saviynt am getting the error like connection failed. 

By using those same parameters, are working successfully from Postman? we are able to generate the access token postman but in Saviynt we are getting the error.

I don't have an idea why am getting that error can you please help on that.

Regards,

Karthik

[sudeshjaiswal]

Hello @KarthikG,

Below could be the reason why this could be failing 

1. While creating an application you must have enabled the check box “Require Secret for Refresh Token Flow “ this needs to be unchecked, please refer to the documentation section “Registering the Connector in Salesforce “ this will have a list of options we need to select and Do not select. 
2. If point one is true, please uncheck the option on target and retry authentication or create a new application without selecting  “Require Secret for Refresh Token Flow “
3. There could also be the chance if incorrect credential details are passed in the connection parameters. For example, presence of an additional [SPACE] in the credentials or incorrect Client ID, Client Secret, Instance URL, or Call back URL.
   
4. Check for debug logs in EIC and capture the error message from logs and share your log analysis with the log snippet.
   
   Thanks.

[KarthikG]

Hello @sudeshjaiswal.

Previously in a Salesforce application the option “Require Secret for Refresh Token Flow “is in enable state.

After that we unchecked the option and we tried to test the connection, but we got the connection failed message. So is fine are else we need to create new application without selecting Require Secret for Refresh Token Flow. 

We are passing the correct credential details are passed in the connection parameters. From the logs in EIC and capture the error message from the logs and attached the below logs FYR which we are getting There is no debug logs.

Thanks.

[sudeshjaiswal]

Hello @KarthikG ,

Please create the new connection and try again.

Thanks

[KarthikG]

Hello @sudeshjaiswal 

After creating the new connection, it was successful.

Then after we given ACCOUNT_FIELD_QUERY we had given below query.

SELECT Id, Name, Account_Owner, Account_Type, Account_Status
FROM Account
WHERE Account_Status = 'Active'

and FIELD_MAPPING_JSON as well as STATUS_THRESHOLD_CONFIG after that we created the job Application Data Import (Single Threaded) for Accounts Import was failing form the JOB Logs Error in getResultId : Cannot get property 'result' on null object FYR attached the screenshot.

From the Log Viewer attached the Logs which getting.

Could please help on that as well.

Thanks,

Karthik

[sudeshjaiswal]

Hello @KarthikG,

You are only suppose to pass the field name not the whole query in the  ACCOUNT_FIELD_QUERY.

For Ref: https://docs.saviyntcloud.com/bundle/Salesforce-v23x/page/Content/Configuring-the-Integration-for-Im... 

Thanks

[KarthikG]

Hello @sudeshjaiswal 

As per the docs we made necessary changes as per the requirement after we run the job Application Data Import (Single Threaded) for Import Accounts. But we are getting an (error: Cannot get property 'result' on null object) 

From the Log Viewer attached the Logs which getting.

Thanks,

Karthik

[sudeshjaiswal]

Hello @KarthikG,

Could you please provide the connection parameters snippet and debug logs in a text file for easy review? Additionally, please verify that all prerequisites are met and that the necessary permissions have been granted.

Thanks

[KarthikG]

Hello @sudeshjaiswal 

I attached below connection parameters which we had given in connection AND attached the debugs logs in a text file.

 

 

Thanks

[rushikeshvartak]

Please change below config [Remove spaces & follow sequence]

OBJECT_TO_BE_IMPORTED : PermissionSet,Profile,Role

[sudeshjaiswal]

Hellol @KarthikG,

Thanks for the sharing the json and logs,
I can see there is a space in the OBJECT_TO_BE_IMPORTED, Please remove the space and try to import the accounts again. 
And share the fresh log.

Thanks.

[KarthikG]

Hello @sudeshjaiswal 

I attached the fresh log, but still same issue Cannot get property 'result' on null object.

Thanks.

[KarthikG]

Hello @sudeshjaiswal 

We are getting the error like connection refused, RabbitMQ(5972) while run the JOB these are log.

Can you please help me out from issue. 

Thanks

[sudeshjaiswal]

Hello @KarthikG,

The redirect-uri in connections params syntax should be as follows: https://xxx.salesforce.com/services/oauth2/success

Thanks

[KarthikG]

Hello @sudeshjaiswal 

We have made necessary changes, but still same issue Cannot get property 'result' on null object.

We are getting the same error as connection refused, RabbitMQ (5972) while run the JOB these are log.

Thanks

Karthik