This topic contains 9 replies, has 3 voices, and was last updated by atwix 9 years, 5 months ago.
- Topic
Hi there!
I’m trying to sync ORO with Magento but getting some erros on “orders” import.
This is my command line:
1php app/console oro:cron:integration:sync --integration-id=312345Loading entity by id: 19426Loading entity by id: 19427PHP Fatal error: Allowed memory size of 3221225472 bytes exhausted (tried to allocate 312644 bytes) in /var/www/html/orocrm/vendor/oro/platform/src/Oro/Bundle/IntegrationBundle/Provider/SOAPTransport.php on line 69Yes, you read right, 3GB of memory_limit on my PHP. This is my ‘app/logs/dev.log’:
12345SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'OroCRM\Bundle\MagentoBundle\Entity\Customer-5929' for key 'idx_entity'Following orders were not imported: 100019781, 100019782, 100019783, 100019784, 100019785, 100019786, 100019787, 100019788, 100019789, 100019791, 100019792, 100019793, 100019795, 100019794, 100019796, 100019797, 100019798, 100019799, 100019800, 100019801, 100019802, 100019803, 100019806, 100019807, 100019808) [] [][2014-11-02 13:17:46] batch.WARNING: The Oro\Bundle\IntegrationBundle\ImportExport\Writer\PersistentBatchWriter was unable to handle the following item: [] (REASON: An exception occurred while executing 'INSERT INTO oro_search_item (entity, alias, record_id, title, changed, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)' with params ["OroCRM\\Bundle\\MagentoBundle\\Entity\\Customer", "orocrm_magento_customer", 14287, "XXXX XXXXX", 0, "2014-11-02 18:17:46", "2014-11-02 18:17:46"]:I have more errors like this one, but I tried to run this last sql query manually:
1INSERT INTO oro_search_item (entity, alias, record_id, title, changed, created_at, updated_at) VALUES ("OroCRM\\Bundle\\MagentoBundle\\Entity\\Customer", "orocrm_magento_customer", 14287, "XXXX XXXXX", 0, "2014-11-02 18:17:46", "2014-11-02 18:17:46");I got this error:
1Duplicate entry 'OroCRM\Bundle\MagentoBundle\Entity\Customer-14287' for key 'idx_entity'I removed this index and right now I’m running the sync again. I’ll let you guys know about the results.
1ALTER TABLE `oro_search_item` DROP INDEX `idx_entity`;Thanks.
The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.