Schema update failed ORO 1.5

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

Topic

[Andrey YatsenkoModerator]

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

[RioParticipant]

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

[Andrey YatsenkoModerator]

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.

[Author]

Replies