search

classyllama / ClassyLlama_AvaTax

This extension has been deprecated in favor of https://github.com/avadev/Avalara-AvaTax-for-Magento2
Open Software License 3.0
23 stars 15 forks source link

System Message: The AvaTax Queue has 1 document(s) that failed during processing and were not successfully sent to AvaTax #114

Closed pioneerathletics closed 6 years ago

pioneerathletics commented 6 years ago

Hi I have this system message "The AvaTax Queue has 1 document(s) that failed during processing and were not successfully sent to AvaTax". I have checked the error in the queue and this is the message "Record was sent to AvaTax, but error occurred after sending record: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE sales_order SET shipping_address_id = ? WHERE (entit"

Is this something that needs to be followed up on? How can I clear this system message?

Preconditions

  1. Magento 2.1.10, AvaTax 1.2.1
  2. PHP 7.0.24

Steps to reproduce

  1. Order was made an invoice
  2. Error happened when sending to AvaTax

Expected result

  1. AvaTax queue should process normally

Actual result

  1. System message is popping up as mentioned earlier
erikhansen commented 6 years ago

@pioneerathletics The most important part of the queue processing is that the information gets sent to AvaTax. You should be fine to go into the database and delete that queue entry from the avatax_queue table. If this happens again or happens consistently and you have steps to reproduce, feel free to re-open this ticket.

pioneerathletics commented 6 years ago

Thanks Eric for answering my question. Is there any other way to get rid of this message other than deleting the queue straight from the database? I¹m not a database guy, but can find one if need be.

Thanks, Dave Orzechowski Pioneer Athletics dorzechowski@pioneerathletics.com P: 800.877.1500 ext. 3179

From: Erik Hansen notifications@github.com Reply-To: classyllama/ClassyLlama_AvaTax <reply+0130e3d89cab98252910c19494c543870f3fdd882687370e92cf0000000116b828da9 2a169ce1213282e@reply.github.com> Date: Wednesday, March 7, 2018 at 5:25 PM To: classyllama/ClassyLlama_AvaTax ClassyLlama_AvaTax@noreply.github.com Cc: pioneerathletics daveo@pioneerathletics.com, Mention mention@noreply.github.com Subject: Re: [classyllama/ClassyLlama_AvaTax] System Message: The AvaTax Queue has 1 document(s) that failed during processing and were not successfully sent to AvaTax (#114)

@pioneerathletics https://github.com/pioneerathletics The most important part of the queue processing is that the information gets sent to AvaTax. You should be fine to go into the database and delete that queue entry from the avatax_queue table. If this happens again or happens consistently and you have steps to reproduce, feel free to re-open this ticket.

‹ You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/classyllama/ClassyLlama_AvaTax/issues/114#issuecomment-3 71307259 , or mute the thread https://github.com/notifications/unsubscribe-auth/ATDj2BZ-RhyxNaHpt6ktEJntG xjk4OIJks5tcF5agaJpZM4ShGHp .

{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4b b","name":"GitHub"},"entity":{"external_key":"github/classyllama/ClassyLlama _AvaTax","title":"classyllama/ClassyLlama_AvaTax","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143 418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"h ttps://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6 -9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/classyllama/ClassyLlama_AvaTax"}},"updates ":{"snippets":[{"icon":"PERSON","message":"@erikhansen in #114: @pioneerathletics The most important part of the queue processing is that the information gets sent to AvaTax. You should be fine to go into the database and delete that queue entry from the avatax_queue table. If this happens again or happens consistently and you have steps to reproduce, feel free to re-open this ticket."}],"action":{"name":"View Issue","url":"https://github.com/classyllama/ClassyLlama_AvaTax/issues/114#i ssuecomment-371307259"}}}

erikhansen commented 6 years ago

@pioneerathletics Unfortunately there is no way to delete the row from within the admin and it will need to be deleted from the database. Alternatively, you could just ignore that row.