HPOS doesn’t complete order sync

  • Resolved ahawtin

    (@ahawtin)


    1 year, 4 months ago

    Hello,

    we are restarting our adoption of HPOS after some difficulties with plug-ins. Our English web site synced order and has HPOS rolling now (although in compatibility mode to start with). The French version of our site (on a different subdomain) won’t however finish syncing orders. The scheduled action to do the sync is failing with the following error:

    wc_run_batch_processéchoué

    • 0 => 'Automattic\\WooCommerce\\Internal\\DataStores\\Orders\\DataSynchronizer'

    Pas de répétition2023-10-25 09:10:50 +0000
    (Il y a 6 heures 35 minutes)

    1. 2023-10-25 09:10:50 +0000
      action créée
    2. 2023-10-25 09:10:50 +0000
      action lancée via WP Cron
    3. 2023-10-25 09:10:50 +0000
      échec de l’action via WP Cron : get_class(): Argument #1 ($object) must be of type object, null given

    The English and French sites are pretty much identical although the French site has LocoTranslate but lacks MultiCurrency. WP and WooCommerce are at identical across the two sites as 6.3.2 and 8.2.1. I welcome any suggestions as to what to do next to debug.

    I had a look at the database tables and sync has correctly updated all but the wp_wc_orders_meta table which is did not complete. I am thinking therefore that the best path forward is to delete HPOS tables using phpMyAdmin which would then allow HPOS to recreate the tables from scratch. Is this a good path forward? I gather that I would need to delete the following four tables:

    wp_wc_orders
    wp_wc_order_addresses
    wp_wc_order_operational_data
    wp_we_order_meta

    Please advise your opinion.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter ahawtin

    (@ahawtin)

    I looked deeper into the HPOS db tables. I now see that wp_wc_order_meta is not completing the transition whereas the other tables are. So there is something odd either about the last order processed or the subsequent one that was about to be processed. I had a look at both orders in wp_postmeta and the records look fine. I will continue to examine the records. It is a bit hard for me to diagnose as the mapping of records in wp_postmeta -> wp_wc_order_meta is not a simple one of one translation. Any hints you could offer would be welcome.

    Thread Starter ahawtin

    (@ahawtin)

    Sorry – I was wrong. I didn’t look at phpMyAdmin correctly. There is one record missing in wp_wc_order_addresses when compared to the other 3 tables. I will look at the order more closely on wp_posts to see what went wrong. So this must be the point at which the schedule action terminated with the error condition stated above. Still quite mysterious to me.

    Thread Starter ahawtin

    (@ahawtin)

    Decided to try dropping the HPOS table and restarting sync. It worked! Running in compatibility mode initially. Will go all in shortly.

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hello @ahawtin,

    I’m glad to hear that you were able to resolve the issue by dropping the HPOS table and restarting the sync. That’s a great troubleshooting step, and it seems to have worked well in this case.

    I’ll be marking the thread as solved for now, but feel free to open a new one if you have any other questions.

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘HPOS doesn’t complete order sync’ is closed to new replies.