What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

cannot run `oms:check-condition` with parameters, it works just fine without them, but once I run `o

U01G4K5E0J2
U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet
in Help

cannot run oms:check-condition with parameters, it works just fine without them, but once I run oms:check-condition --limit=1 or oms:check-condition --store-name=AT Im getting

Propel\Runtime\Exception\PropelException - Exception: Error populating \Orm\Zed\Sales\Persistence\SpySalesOrderItem object

did anyone encounter similar problem?

«1

Comments

  • Valerii Trots
    Valerii Trots SRE @ Spryker Sprykee Posts: 1,654 ✨ - Novice

    oms:check-condition --store-name=AT should be APPLICATION_STORE=AT console oms:check-condition I believe.

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    APPLICATION_STORE=AT vendor/bin/console oms:check-condition --store-name=AT same thing, Error populating \Orm\Zed\Sales\Persistence\SpySalesOrderItem

  • Valerii Trots
    Valerii Trots SRE @ Spryker Sprykee Posts: 1,654 ✨ - Novice

    Shouldn't it be just APPLICATION_STORE=AT vendor/bin/console oms:check-condition and not APPLICATION_STORE=AT vendor/bin/console oms:check-condition --store-name=AT?

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    I think you are focusing on wrong aspect of this, --limit option also causes this issue

  • Valerii Trots
    Valerii Trots SRE @ Spryker Sprykee Posts: 1,654 ✨ - Novice

    Latest spryker-shop/suite works without problems.

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    are you certain that orders are processed there? because I can run this for NL store, that has no orders, and don't get any exception

  • Valerii Trots
    Valerii Trots SRE @ Spryker Sprykee Posts: 1,654 ✨ - Novice

    Let me experiment a bit more then. 🙂

  • Valerii Trots
    Valerii Trots SRE @ Spryker Sprykee Posts: 1,654 ✨ - Novice

    I have no project with a real PSP integrated, but with dummy payment it still works ok.

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    Ive managed to find out what causes this issue

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    Error parsing date/time value: '6589a069-1ad5-547d-ae24-66b9f3bc3a56'

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    for some reason spy_sales_order_item uuid gets passed to updated_at

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    could this be caused by table column order?

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    I've noticed that in my table product_offer_reference, remuneration_amount and uuid columns come after created_at and updated_at

  • Valerii Trots
    Valerii Trots SRE @ Spryker Sprykee Posts: 1,654 ✨ - Novice

    I'm not a propel expert but IMO shouldn't be.
    Who is the PSP? Is it Spryker's integration from spryker-eco namespace?

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    exception is thrown before conditionsa re checked

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    when getting sales order items from db

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    so it's spryker/oms that's causing this

  • Valerii Trots
    Valerii Trots SRE @ Spryker Sprykee Posts: 1,654 ✨ - Novice

    I'll try to clarify internally.

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    no plugin is executed

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    well, if you want to know my guess is that querySalesOrderItemsByProcessIdStateIdsAndQueryCriteria method of OmsQueryContainer is most likely the culprit or at least involved

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    since it is called only if you provide limit or store name

  • Valerii Trots
    Valerii Trots SRE @ Spryker Sprykee Posts: 1,654 ✨ - Novice

    I've posted this thread internally and will provide any feedback I'll get.

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    ok, thanks

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    @valerii.trots hey, is there any news on this issue?

  • Valerii Trots
    Valerii Trots SRE @ Spryker Sprykee Posts: 1,654 ✨ - Novice

    As promised, will post any feedback but there was no so far. Will remind about it one more time.

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    sure, thanks for the update

  • Valentina Guseva
    Valentina Guseva Sprykee Posts: 1 🧑🏻‍🚀 - Cadet

    Hi @valerii.trots! Do you have feedback? Does it make sense to raise a support ticket for this?

  • Valerii Trots
    Valerii Trots SRE @ Spryker Sprykee Posts: 1,654 ✨ - Novice

    Unfortunately neither original question nor follow up one got any feedback internally.
    Either the support ticket needs to be created but it will get into our queue, or solution architects need to be involved. IDK to be honest.
    Maybe @tom.lehner will have ideas later today when he will start working around 14:00.

  • Thomas Lehner
    Thomas Lehner Support Engineer @ Spryker Posts: 289 🏛 - Council (mod)

    @U01G4K5E0J2 hi, and sorry that this dragging on for quite a bit and it seems like we need to go the bureaucratic way to get you help here. Can i ask you to create a case for us for this with steps necessary to reproduce this problem? Also, please let us know in the ticket what business impact this problem has for you and by when you will need it solved to prevent it becoming a blocker

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    @U01JZE2ELCF @tom.lehner I've created a case ID: 00002257

Categories