Forums

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

Forums OroCommerce Schema update failed ORO 1.5

This topic contains 3 replies, has 2 voices, and was last updated by Andrey Yatsenko Andrey Yatsenko 2 months, 3 weeks ago.

  • Creator
    Topic
  • #33105

    Rio
    Participant

    Hi, masters

    Does any body knows how to resolve “schema update failed” when update schema custom product attribute
    ex: Material type: select

    I faced this error ::

    [2018-06-26 14:56:11] app.ERROR: Consuming interrupted by exception. “Entity of type ‘Extend\Entity\EV_Product_Material_75e30b1f’ for IDs id() was not found” {“exception”:”[object] (Doctrine\\ORM\\EntityNotFoundException(code: 0): Entity of type ‘Extend\\Entity\\EV_Product_Material_75e30b1f’ for IDs id() was not found at /opt/bitnami/apache2/htdocs/devb2b/vendor/doctrine/orm/lib/Doctrine/ORM/EntityNotFoundException.php:47)”} {“processor”:”Oro\\Bundle\\WebsiteSearchBundle\\Engine\\AsyncMessaging\\SearchMessageProcessor”,”message_id”:”oro.5b31f0f26b2805.97289062″,”message_body”:”{\”class\”:[\”Oro\\\\Bundle\\\\ProductBundle\\\\Entity\\\\Product\”],\”context\”:{\”entityIds\”:[2,3,4,5,6,137,138,139,140,141,142,143,144,145,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,190,191,192,193,218,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294],\”websiteIds\”:[1]}}”,”message_properties”:{“oro.message_queue.client.topic_name”:”oro.website.search.indexer.reindex”,”oro.message_queue.client.processor_name”:”oro_website_search.async_messaging.search_message.processor”,”oro.message_queue.client.queue_name”:”oro.default”,”oro.security.token”:”organizationId=1;userId=1;userClass=Oro\\Bundle\\UserBundle\\Entity\\User;roles=ROLE_ADMINISTRATOR”,”oro-redeliver-count”:15},”message_headers”:{“content_type”:null,”message_id”:”oro.5b31f0f26b2805.97289062″,”timestamp”:0},”message_priority”:0,”job_id”:330853,”job_name”:”website_search_reindex|9c29250de7b7d7047345bdd7a63fec57″,”job_data”:[]}

    [2018-06-26 14:56:11] console.ERROR: An error occurred while running command “‘oro:message-queue:consume’ –env=prod”. Entity of type ‘Extend\Entity\EV_Product_Material_75e30b1f’ for IDs id() was not found {“exit_code”:0,”exception”:”[object] (Doctrine\\ORM\\EntityNotFoundException(code: 0): Entity of type ‘Extend\\Entity\\EV_Product_Material_75e30b1f’ for IDs id() was not found at /opt/bitnami/apache2/htdocs/devb2b/vendor/doctrine/orm/lib/Doctrine/ORM/EntityNotFoundException.php:47)”,”arguments”:{“command”:”oro:message-queue:consume”},”options”:{“env”:”prod”}} []

    Even I cannot remove this attribute and it cause reproduce the error log on prod.log. Anybody knows how to resolve it ?

    Thanks in Advance

Viewing 3 replies - 1 through 3 (of 3 total)
  • Author
    Replies
  • #33106
    Andrey Yatsenko
    Andrey Yatsenko
    Moderator

    In error logs, you attached there is no info about failed schema update, it just trying to index an entity that was deleted or detached from the UOW.

    Probably you need to remove all search related messages from the queue manually and start to reindex from scratch.
    But before new reindex error with detaching or triggering reindex on deleted entity should be fixed.

    About the original question, the most common problem with failed schema update related to bad permission configuration for an application, follow the steps from installation guide to fix it:
    https://oroinc.com/b2b-ecommerce/doc/1.6/install-upgrade/installation-quick-start-dev/commerce-crm-ee#installation-orocommerce-crm-ee-readme (search for “permissions” in the article).

    To restore after broken schema update you can trigger it again manually from the console. there are severl commands triggered one by one when you update schema from the UI. You can find them at this method:
    https://github.com/oroinc/platform/blob/master/src/Oro/Bundle/EntityExtendBundle/Extend/EntityProcessor.php#L98

    #33107

    Rio
    Participant

    Hi Andrey,

    Thanks for fast respond, just ignored the schema update failed, let’s discuss about the website reindex error … I’ve been executing related your link post ::

    ‘oro:entity-extend:update-config’
    ‘oro:entity-extend:cache:warmup’

    then I stop the running job website_search:reindex then I run php app/console oro:website:reindex but still appear the error below ::

    Starting reindex task for all mapped entities…

    [Doctrine\ORM\EntityNotFoundException]
    Entity of type ‘Extend\Entity\EV_Product_Material_75e30b1f’ for IDs id() was not found

    Do have any suggestion? Thx

    #33108
    Andrey Yatsenko
    Andrey Yatsenko
    Moderator

    You still need to remove from queue old messages related to search reindex. An error looks same as above because the same message with the link to deleted or detached entity trying to be processed.

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

You must be logged in to reply to this topic.

You will be redirected to [title]. Would you like to continue?

Yes No
ssossossossossosso