Forums

Covering OroCommerce, OroCRM, OroPlatform topics, including community updates and company announcements.

Forums Forums Oro Community Problems with sync Magento

This topic contains 8 replies, has 2 voices, and was last updated by  mon 7 years, 4 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #24482

    mon
    Participant

    Hi,

    We have successfully synchronized the magento database.

    But when we want to synchronize the new changes, the Job fails

    the job oro:cron:integration:sync –integration-id=1 -v return:

    Run sync for “Magento Store Integration” integration.
    Start processing “website_dictionary” connector
    Stats: read [2], processed [2], updated [2], added [0], deleted [0], invalid entities: [0]
    Start processing “store_dictionary” connector
    Stats: read [2], processed [2], updated [2], added [0], deleted [0], invalid entities: [0]
    Start processing “customer_group_dictionary” connector
    Stats: read [4], processed [4], updated [4], added [0], deleted [0], invalid entities: [0]
    Start processing “region_dictionary” connector
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:directoryRegionList><sessionId xsi:type=”xsd:string”>f0614d0c81007969e0b6f53c4a0af305</sessionId><country xsi:type=”xsd:string”>AD</country></ns1:directoryRegionList></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Scheduling initial synchronization
    Start processing “customer” connector
    Looking for batch
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:oroCustomerList><sessionId xsi:type=”xsd:string”>f0614d0c81007969e0b6f53c4a0af305</sessionId><filters xsi:type=”ns1:filters”><complex_filter SOAP-ENC:arrayType=”ns1:complexFilter[3]” xsi:type=”ns1:complexFilterArray”><item xsi:type=”ns1:complexFilter”><key xsi:type=”xsd:string”>website_id</key><value xsi:type=”ns1:associativeEntity”><key xsi:type=”xsd:string”>in</key><value xsi:type=”xsd:string”>1</value></value></item><item xsi:type=”ns1:complexFilter”><key xsi:type=”xsd:string”>updated_at</key><value xsi:type=”ns1:associativeEntity”><key xsi:type=”xsd:string”>gt</key><value xsi:type=”xsd:string”>2016-11-18 15:50:15</value></value></item><item xsi:type=”ns1:complexFilter”><key xsi:type=”xsd:string”>updated_at</key><value xsi:type=”ns1:associativeEntity”><key xsi:type=”xsd:string”>lte</key><value xsi:type=”xsd:string”>2016-11-18 17:10:54</value></value></item></complex_filter></filters><pager xsi:type=”ns1:pager”><page xsi:type=”xsd:string”>1</page><pageSize xsi:type=”xsd:string”>100</pageSize></pager></ns1:oroCustomerList></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Start processing “cart” connector
    Looking for batch
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:storeList><sessionId xsi:type=”xsd:string”>f0614d0c81007969e0b6f53c4a0af305</sessionId></ns1:storeList></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Start processing “order” connector
    Looking for batch
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:storeList><sessionId xsi:type=”xsd:string”>f0614d0c81007969e0b6f53c4a0af305</sessionId></ns1:storeList></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Start processing “newsletter_subscriber” connector
    Looking for batch
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:storeList><sessionId xsi:type=”xsd:string”>f0614d0c81007969e0b6f53c4a0af305</sessionId></ns1:storeList></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Completed

    and the job oro:magento:initial:sync –integration-id=1 –skip-dictionary -v return:

    Run initial sync for “Magento Store Integration” integration.
    Syncing connector order_initial starting 2014-01-01 15:02:18 interval 7 days
    Start processing “order_initial” connector
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:login><username xsi:type=”xsd:string”>gestion_tienda_user</username><apiKey xsi:type=”xsd:string”>***</apiKey></ns1:login></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Can someone help me?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Author
    Replies
  • #24483

    Mike Kudelya
    Participant

    What happens if you set full permissions on your soap role ? I think this is magento side issue.

    #24484

    mon
    Participant

    Hi,

    We have created a new user on the magento side and the synchronization has been successful!

    We do the manual synchronization BUT is there any way to automate this process so that it runs every x minutes? A cron Job?

    Thanks in advance!

    #24485

    Mike Kudelya
    Participant

    Yes, cron job. For example:

    */1 * * * * [path]/app/console oro:cron:integration:sync –integration-id=1 >> /dev/null

    #24486

    mon
    Participant

    Hi,

    thank you for your support.

    We still have problems with magento sync.

    If we use a new user of the magento API, it synchronizes perfectly the first time.

    If we resynchronize a second time, the synchronization fails with the following error:

    ——————————————————————————–
    Run sync for “Magento Store Integration” integration.
    Start processing “website_dictionary” connector
    Stats: read [2], processed [2], updated [2], added [0], deleted [0], invalid entities: [0]
    Start processing “store_dictionary” connector
    Stats: read [2], processed [2], updated [2], added [0], deleted [0], invalid entities: [0]
    Start processing “customer_group_dictionary” connector
    Stats: read [4], processed [4], updated [4], added [0], deleted [0], invalid entities: [0]
    Start processing “region_dictionary” connector
    found 0 entities
    found 0 entities
    found 0 entities
    found 0 entities
    found 0 entities
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:directoryRegionList><sessionId xsi:type=”xsd:string”>96f4ce3a21c1c658d3d9ff9fda4d1956</sessionId><country xsi:type=”xsd:string”>AL</country></ns1:directoryRegionList></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Start processing “customer” connector
    Looking for batch
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:oroCustomerList><sessionId xsi:type=”xsd:string”>96f4ce3a21c1c658d3d9ff9fda4d1956</sessionId><filters xsi:type=”ns1:filters”><complex_filter SOAP-ENC:arrayType=”ns1:complexFilter[3]” xsi:type=”ns1:complexFilterArray”><item xsi:type=”ns1:complexFilter”><key xsi:type=”xsd:string”>website_id</key><value xsi:type=”ns1:associativeEntity”><key xsi:type=”xsd:string”>in</key><value xsi:type=”xsd:string”>1</value></value></item><item xsi:type=”ns1:complexFilter”><key xsi:type=”xsd:string”>updated_at</key><value xsi:type=”ns1:associativeEntity”><key xsi:type=”xsd:string”>gt</key><value xsi:type=”xsd:string”>2016-11-23 18:08:12</value></value></item><item xsi:type=”ns1:complexFilter”><key xsi:type=”xsd:string”>updated_at</key><value xsi:type=”ns1:associativeEntity”><key xsi:type=”xsd:string”>lte</key><value xsi:type=”xsd:string”>2016-11-24 18:19:06</value></value></item></complex_filter></filters><pager xsi:type=”ns1:pager”><page xsi:type=”xsd:string”>1</page><pageSize xsi:type=”xsd:string”>100</pageSize></pager></ns1:oroCustomerList></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Start processing “cart” connector
    Looking for batch
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:storeList><sessionId xsi:type=”xsd:string”>96f4ce3a21c1c658d3d9ff9fda4d1956</sessionId></ns1:storeList></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Start processing “order” connector
    Looking for batch
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:storeList><sessionId xsi:type=”xsd:string”>96f4ce3a21c1c658d3d9ff9fda4d1956</sessionId></ns1:storeList></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Start processing “newsletter_subscriber” connector
    Looking for batch
    Stats: read [0], processed [0], updated [0], added [0], deleted [0], invalid entities: [0]
    Errors were occurred:

    [message] Forbidden
    [request] <?xml version=”1.0″ encoding=”UTF-8″?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns1=”urn:Magento” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/”><SOAP-ENV:Body><ns1:storeList><sessionId xsi:type=”xsd:string”>96f4ce3a21c1c658d3d9ff9fda4d1956</sessionId></ns1:storeList></SOAP-ENV:Body></SOAP-ENV:Envelope>

    [response]
    [code] 403

    Completed
    ——————————————————————————–

    Any clue to solve this?

    Thanks!

    #24487

    Mike Kudelya
    Participant

    Hi

    Every time when i’m running the command ‘sessionId’ is changed. Do you have the same behaviour? You can find sessionId by running this command with -vvv

    Please check your orocrm logs (app/logs) and magento logs, maybe you will find there answer.

    Interesting that ‘website_dictionary’, ‘store_dictionary’, ‘customer_group_dictionary’ steps executed successfully, but later we will get the error. Try to find out that error does magento or it appear before connect to it.

    #24488

    mon
    Participant

    Hi Mike,

    We have set up a cron job that is triggered every hour, according to your suggestions (*/1 * * * * [path]/app/console oro:cron:integration:sync –integration-id=1 >> /dev/null)

    Synchronization sometimes works fine (with warnings), but another times it does not work.

    See the log at “Integrations / Magento Store Integration”:

    12:00 PM works fine (see capture1.png)

    1:00 PM it not works (see capture2.png)

    Further, in the “queue job” we have the jobs in “pending” state and we have the daemon status in “Not running” (see capture3.png). This is normal behaviour?

    You can find all the screenshots here

    Thanks for your help!

    #24489

    Mike Kudelya
    Participant

    Hi

    When cron job see that daemon is stopped, it starts daemon again.

    Do you still use api user which have full permissions ?
    Are you using customized magento or not ? Try synchronize brand new magento instance.

    Under ‘System > Configuration > Magento Core API’ try to set Enable WSDL Cache to “No”. Here is my settings:

    #24490

    mon
    Participant

    Hi Mike,

    with Enable WSDL Cache to “No” and SOAP WSDL URL to “<domain>/index.php/api/v2_soap/?wsdl=1” the sync works PERFECT!

    Thanks for your help!

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

The forum ‘Oro Community’ is closed to new topics and replies.

Back to top