Field Map Objects not showing iup

  • Resolved speckmann

    (@speckmann)


    4 years, 6 months ago

    Hey everyone,

    when I try to map fields now objects show up in the salesforce dropdown.
    I tried all points mentioned from the troubleshooting list:
    – Checked OAuth scope
    – Salesforce objects are accessible to user
    – Salesforce objects have no other restrictive permission
    – activated logging
    – Checked the table wp_object_sync_sf_field_map. It exist, but it’s empty.

    When checking the logs, the following error message seems wrong to me:

    “HTTP method:GET URL of API call to Salesforce:http://sobjects API result from Salesforce
    (
    [code] => 0
    [data] =>
    [cached] =>
    [from_cache] =>
    [is_redo] => 1
    )"

    The url is "http://sobjects" . In all other log files the full url including our company-specific subdomain is included e.g.

    Do you have an idea, what could cause this behavior?

    Thanks a lot in advance and best Regards,

    Christoph

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Jonathan Stegall

    (@jonathanstegall)

    4 years, 5 months ago

    I can’t really speak to that. What it sounds like is that it has lost the domain name where your Salesforce instance is. You might need to disconnect the plugin from Salesforce and reauthorize it. But in any case, that’s not an error I have seen before.

    Thread Starter speckmann

    (@speckmann)

    4 years, 2 months ago

    Hey @jonathanstegall,

    I could narrow down the problem a little bit:
    You plugin works like a charm on a fresh installation and even on the same server.

    I reinstalled the plugin and deleted the two corresponding tables manually in the database. However, the options seemed to be stored somewhere else? Do you know where? I couldn’t find it in the plugin docs.

    Otherwise, here is a comparison between the working and non-working environment:

    Working environment:
    API call to Salesforce: https://tam-akademie.my.salesforce.com/services/data/v53.0/query?q=SELECT+Name%2C+Id+from+Contact+LIMIT+100

    Environment, where it is not working:
    API call to Salesforce:http://query?q=SELECT+Name%2C+Id+from+Contact+LIMIT+100

    Do you know where [mycompany].my.salesforce.com is set? I guess I could find the source of the error in this place.

    Thanks a lot in advance,

    Christoph

    Plugin Author Jonathan Stegall

    (@jonathanstegall)

    4 years, 2 months ago

    Yes, all of the plugin options are stored in the wp_options table. I think most likely you’ll need to log the plugin out of Salesforce and re-authorize it.

    Thread Starter speckmann

    (@speckmann)

    4 years, 2 months ago

    Update and could fix it:
    tl;dr: Check your salesforce user properties for special characters and add utf8mb4 support to your database.

    Re-authorization didn’t work unfortunately. I compared all fields in the wp_options table side-by-side and there was one entry missing in the non-working-environment:
    object_sync_for_salesforce_identity

    I tried to copy over the option_value from the working environment but couldn’t save it in the database.
    Error: #1366 – Incorrect string value: ‘\xF0\x9F\x90\xBB\xE2\x80…’ for column ‘option_value’ at row 1

    I tried to google this issue and if understand it correctly, this error is due no support of utf8mb4 characters of the database. https://stackoverflow.com/questions/20411440/incorrect-string-value-xf0-x9f-x8e-xb6-xf0-x9f-mysql

    After I removed this character from the salesforce user profile I could authorize salesforce again and everyone works now as excepted.

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

The topic ‘Field Map Objects not showing iup’ is closed to new replies.