Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

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

  • Creator
    Topic
  • #24312

    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
  • #24384
    Mike Kudelya
    Mike Kudelya
    Oro Core

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

    #24403

    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!

    #24404
    Mike Kudelya
    Mike Kudelya
    Oro Core

    Yes, cron job. For example:

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

    #24447

    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!

    #24477
    Mike Kudelya
    Mike Kudelya
    Oro Core

    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.

    #24541

    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!

    #24562
    Mike Kudelya
    Mike Kudelya
    Oro Core

    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:

    #24572

    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)

You must be logged in to reply to this topic.

ssossossosso