Syncing issues – Salesforce pull

  • Resolved ncls9

    (@ncls9)


    4 years ago

    Hello,

    Thanks for this great plugin.
    I’m facing problems to pull Salesforce Data to wordpress (woocommerce products). The sync used to work perfectly with the same salesforce org syncing with another wordpress environment : at this time when I created a Salesforce record it created the corresponding woocommerce product, and every time i modified my salesforce record it synced the corresponding product, so the plugin can work well for my need.

    Now I changed to a new wordpress org (i bloqued the settings in Salesforce in the connected app management and created a new one) and the sync doesn’t work anymore. The debug mode says : 

    HTTP method: GET

URL of API call to Salesforce: https://axisgroupe.my.salesforce.com/services/data

API result from Salesforce
Array
(
[code] => 200
[data] => Array
(
[0] => Array
(
[label] => Spring '11
[url] => /services/data/v21.0
[version] => 21.0
)

[1] => Array
(
[label] => Summer '11
[url] => /services/data/v22.0
[version] => 22.0
)

[2] => Array
(
[label] => Winter '12
[url] => /services/data/v23.0
[version] => 23.0
)

[3] => Array
(
[label] => Spring '12
[url] => /services/data/v24.0
[version] => 24.0
)

[4] => Array
(
[label] => Summer '12
[url] => /services/data/v25.0
[version] => 25.0
)

[5] => Array
(
[label] => Winter '13
[url] => /services/data/v26.0
[version] => 26.0
)

[6] => Array
(
[label] => Spring '13
[url] => /services/data/v27.0
[version] => 27.0
)

[7] => Array
(
[label] => Summer '13
[url] => /services/data/v28.0
[version] => 28.0
)

[8] => Array
(
[label] => Winter '14
[url] => /services/data/v29.0
[version] => 29.0
)

[9] => Array
(
[label] => Spring '14
[url] => /services/data/v30.0
[version] => 30.0
)

[10] => Array
(
[label] => Summer '14
[url] => /services/data/v31.0
[version] => 31.0
)

[11] => Array
(
[label] => Winter '15
[url] => /services/data/v32.0
[version] => 32.0
)

[12] => Array
(
[label] => Spring '15
[url] => /services/data/v33.0
[version] => 33.0
)

[13] => Array
(
[label] => Summer '15
[url] => /services/data/v34.0
[version] => 34.0
)

[14] => Array
(
[label] => Winter '16
[url] => /services/data/v35.0
[version] => 35.0
)

[15] => Array
(
[label] => Spring '16
[url] => /services/data/v36.0
[version] => 36.0
)

[16] => Array
(
[label] => Summer '16
[url] => /services/data/v37.0
[version] => 37.0
)

[17] => Array
(
[label] => Winter '17
[url] => /services/data/v38.0
[version] => 38.0
)

[18] => Array
(
[label] => Spring '17
[url] => /services/data/v39.0
[version] => 39.0
)

[19] => Array
(
[label] => Summer '17
[url] => /services/data/v40.0
[version] => 40.0
)

[20] => Array
(
[label] => Winter '18
[url] => /services/data/v41.0
[version] => 41.0
)

[21] => Array
(
[label] => Spring ’18
[url] => /services/data/v42.0
[version] => 42.0
)

[22] => Array
(
[label] => Summer '18
[url] => /services/data/v43.0
[version] => 43.0
)

[23] => Array
(
[label] => Winter '19
[url] => /services/data/v44.0
[version] => 44.0
)

[24] => Array
(
[label] => Spring '19
[url] => /services/data/v45.0
[version] => 45.0
)

[25] => Array
(
[label] => Summer '19
[url] => /services/data/v46.0
[version] => 46.0
)

[26] => Array
(
[label] => Winter '20
[url] => /services/data/v47.0
[version] => 47.0
)

[27] => Array
(
[label] => Spring '20
[url] => /services/data/v48.0
[version] => 48.0
)

[28] => Array
(
[label] => Summer '20
[url] => /services/data/v49.0
[version] => 49.0
)

[29] => Array
(
[label] => Winter '21
[url] => /services/data/v50.0
[version] => 50.0
)

[30] => Array
(
[label] => Spring '21
[url] => /services/data/v51.0
[version] => 51.0
)

[31] => Array
(
[label] => Summer '21
[url] => /services/data/v52.0
[version] => 52.0
)

[32] => Array
(
[label] => Winter '22
[url] => /services/data/v53.0
[version] => 53.0
)

[33] => Array
(
[label] => Spring '22
[url] => /services/data/v54.0
[version] => 54.0
)

)

[from_cache] => 1
[cached] => 1
[is_redo] =>
)

    Can you help me ?

    Thanks a lot

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter ncls9

    (@ncls9)

    4 years ago

    Actually I looked in the action scheduler ( /wp-admin/tools.php?page=action-scheduler )
    All the action are planified but are not executed. When I execute the action manually it works.
    Do someone have an idea from where can this come from ?
    Thanks a lot for your help.

    Plugin Author Jonathan Stegall

    (@jonathanstegall)

    4 years ago

    I think you should turn on debug mode in the plugin settings. It will create a lot of log entries, but you should be able to see more of what is happening.

    Thread Starter ncls9

    (@ncls9)

    4 years ago

    Thanks for this quick answer:
    I noticed that the plugin proposed me an update. I updated the plugin but now I can’t get connect to Salesforce : “The plugin was unable to load a sample of Contacts from Salesforce. This may mean that there are connection issues, or that the authorization has expired”
    ( I tried to uninstall the plugin deleting data. i then tried to create a new connected app in Salesforce). But i Still get this error to connect.

    Plugin Author Jonathan Stegall

    (@jonathanstegall)

    4 years ago

    Okay, well:

    1. See if that connection error persists in version 2.2.2 (I just released it; I become aware that not all Salesforce instances have access to the higher API version).
    2. Still, enable debug mode.

    Thread Starter ncls9

    (@ncls9)

    4 years ago

    Thank you with the 2.2.2 version I no longer have to connexion issue :

    HTTP method: GET

URL of API call to Salesforce: https://axisgroupe.my.salesforce.com/services/data/v54.0/query?q=SELECT+Name%2C+Id+from+Contact+LIMIT+100

SOQL query that was sent to Salesforce

SELECT Name, Id from Contact LIMIT 100

API result from Salesforce
Array
(
[code] => 200
[data] => Array
(
[totalSize] => 100
[done] => 1
[records] => Array
(
[0] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v54.0/sobjects/Contact/0035J00000RH3NBQA1
)

[Name] => stephane milhaud
[Id] => 0035J00000RH3NBQA1

    I also had this log :

    "Success ActionScheduler: the ActionScheduler library has completed its migration. See the log entry content for status on each recurring task.
    Schedule name: salesforce_pull."

    But When I update Salesforce records nothing happens.

    I looked to the planified action tab and i see that there is a pending action
    object_sync_for_salesforce_pull_check_records with the status "Pending"

    Thanks a lot for your help

    Plugin Author Jonathan Stegall

    (@jonathanstegall)

    4 years ago

    Okay. Like I said, if you haven’t, you need to turn on debug mode. It will create a lot of log entries (not just one), but you should be able to use them to determine whether the plugin is running your scheduled tasks. If you can tell for sure that it is not, you might try resaving them. Change the frequency so that it knows it is a new setting, for example.

    Ultimately, what you want to see is a debug entry that runs the periodic query that the plugin should run. For example, if you have the plugin pulling data from Salesforce every 10 minutes, you should be able to see a debug log entry created every 10 minutes that looks for the data that you expect.

    Thread Starter ncls9

    (@ncls9)

    4 years ago

    Hello. Thanks a lot for your support.
    I activated the debug mode and modified and saved the Sheduling (every 7 minutes). The batch doesn’t starts automtically : no log appears in the log tab after 1 hour. So I went in the planified action tab, in pending actions and clicked on execute the query “pull records” . Then all the actions are created as pending. I wait 10 minutes but lines in log table. So I click on execute each task and it created logs : some logs are successfull, others have this error :

    Notice: Because object map 62 already exists, WordPress product 0 was not mapped to Salesforce Id a175J000000gaQKQAY

    The WordPress product with of 0 is already mapped to the Salesforce B25__Resource__c with Id of a175J000000gaQKQAY in the mapping object with id of 62. The Salesforce B25__Resource__c with Id of a175J000000gaQKQAY was created or modified in Salesforce, and would otherwise have been mapped to this WordPress record. No WordPress data has been changed to prevent changing data unintentionally.

    Thread Starter ncls9

    (@ncls9)

    4 years ago

    Hello, I didn’t find the reason of the issue. I tried many changes but there is the same problem : the scheduled action object_sync_for_salesforce_pull_check_records / every X minute is never executed automatically and stays in status “Pending”.
    Did you ever faced this issue ?
    Thanks a lot for your help.

    Plugin Author Jonathan Stegall

    (@jonathanstegall)

    4 years ago

    I haven’t seen that; I’m not really sure what to tell you. You might try deleting the plugin and its options and reinstalling it.

    Thread Starter ncls9

    (@ncls9)

    4 years ago

    My problem is resolved. It was not at all a problem of the plugin. It was a problem from wordpress cron that didn’t execute because of the server (a developer helped me to fix that i didn’t really understand the reason) .The plugin now works ! Thanks a lot for your help.

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Syncing issues – Salesforce pull’ is closed to new replies.

  • 10 replies
  • 2 participants
  • Last reply from: ncls9
  • Last activity: 4 years ago
  • Status: resolved