search

msupply-foundation / open-msupply

Open mSupply represents our most recent advancement in the Logistics Management Information System (LMIS), expanding on more than two decades of development inherited from the well-established legacy of the original mSupply.
https://msupply.foundation/open-msupply/
Other
20 stars 12 forks source link

No inbound shipment created from internal order sent from oms fulfilled by mSupply #5005

Open jmbrunskill opened 2 hours ago

jmbrunskill commented 2 hours ago

What went wrong? 😲

Following instructions here: https://github.com/msupply-foundation/open-msupply/issues/4989

Created internal order from within OMS and sent it to remote legacy instance. image

Confirmed sent

Sync

In Legacy open requisition

image

And click Supply Quantity for the line then Create Customer Invoice

In the Customer Invoice, click Re-distribute All to assign the line to stock

image

Click Confirm then Ok then Say Finalise

image

Sync

Nothing shows up under inbound shipment in the recieving store.

sync_log shows

ForeignKeyViolation("\"FOREIGN KEY constraint failed\"")

Expected behaviour 🤔

Inbound invoice should appear in OMS...

How to Reproduce 🔨

See steps above

Your environment 🌱

jmbrunskill commented 2 hours ago

Looks like possibly missing the user account ?

2024-10-04 18:05:54.118490000 [WARN] <service/src/user_account.rs:101>:Failed to insert store permissions(foreign key constraint is violated "FOREIGN KEY constraint failed"): StorePermissions { user_store_join: UserStoreJoinRow { id: "9DD3E61F8C304C4387A86A3BB0930065", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: "8EEB0338E20D4A849EDEEB89740162E5", is_default: false }, permissions: [UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3a434cee5eeb", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: RequisitionMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3a59d1d5fe4a", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: StocktakeQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3a6241467ccc", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: NamePropertiesMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3a7cd8436012", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: LogQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3a8aaa0ca8e0", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: SensorQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3a9a704eab90", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: SupplierReturnQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3aa6219ead3e", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: StocktakeMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3ab7b8fb5d89", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: RnrFormMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3acdb540baca", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: OutboundShipmentQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3add8c5d4e86", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: RnrFormQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3aea94134ccf", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: InventoryAdjustmentMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3afcd290fa44", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: CustomerReturnQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3b08ed8473fc", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: OutboundShipmentMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3b137c07b077", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: ColdChainApi, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3b27a43d39b5", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: CreateRepack, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3b3d5c27952d", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: CustomerReturnMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3b47186946d3", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: ItemNamesCodesAndUnitsMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3b5c0036bf42", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: Report, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3b60b67bb521", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: PatientQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3b73ddd49636", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: PrescriptionMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3b8f744ada44", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: StoreAccess, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3b94b905a7be", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: RequisitionQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3ba3d64e88bc", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: InboundShipmentMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3bb001fbcf5a", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: SensorMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3bce365a17eb", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: PatientMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3bd92c4a7b50", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: AssetCatalogueItemMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3befccca761d", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: InboundShipmentQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3bf1c86cc377", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: ItemMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3c074257f143", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: StockLineQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3c165c4ded66", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: AssetMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3c2505256f85", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: SupplierReturnMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3c304479426b", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: LocationMutate, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3c440c963933", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: RequisitionSend, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3c51ffb6fc59", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: EditCentralData, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3c6b40c4fb41", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: PrescriptionQuery, context_id: None }, UserPermissionRow { id: "019255eb-8fbc-7841-9ec1-3c7cbe85f2fc", user_id: "0763E2E3053D4C478E1E6B6B03FEC207", store_id: Some("8EEB0338E20D4A849EDEEB89740162E5"), permission: StockLineMutate, context_id: None }] }

Although this appears to relate to my admin user which does exist!