-[ RECORD 1 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- datid | 375640 datname | euro_test pid | 14074 usesysid | 16393 usename | adempiere application_name | PostgreSQL JDBC Driver client_addr | 127.0.0.1 client_hostname | client_port | 43718 backend_start | 2023-01-26 19:14:45.997147+04 xact_start | query_start | 2023-01-27 10:54:51.429579+04 state_change | 2023-01-27 10:54:51.4373+04 waiting | f state | idle backend_xid | backend_xmin | query | COMMIT -[ RECORD 2 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- datid | 375640 datname | euro_test pid | 12918 usesysid | 16393 usename | adempiere application_name | PostgreSQL JDBC Driver client_addr | 127.0.0.1 client_hostname | client_port | 43218 backend_start | 2023-01-26 18:33:46.730206+04 xact_start | query_start | 2023-01-26 18:34:59.719732+04 state_change | 2023-01-26 18:34:59.725462+04 waiting | f state | idle backend_xid | backend_xmin | query | select ppo.m_product_id,ppo.c_bpartner_id,iscurrentvendor,royaltyamt,royaltypercentage,bp.name,m_product_po_id,validfrom, ppo.order_min,ppo.reorderpoint,ppo.manufacturer,ppo.description,ppo.upc, mfr.c_bpartner_id as mfrid from m_product_po ppo join m_product pro on ppo.m_product_id = pro.m_product_id join c_bpartner bp on ppo.c_bpartner_id = bp.c_bpartner_id left join c_bpartner mfr on (mfr.name = ppo.manufacturer and mfr.isVendor = 'Y') where ppo.m_product_id =780000869 and ppo.ad_client_id =1000000 and ppo.ad_org_id in (0,1000000)order by validfrom desc,ppo.created desc -[ RECORD 3 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- datid | 375640 datname | euro_test pid | 12640 usesysid | 16393 usename | adempiere application_name | PostgreSQL JDBC Driver client_addr | 127.0.0.1 client_hostname | client_port | 43036 backend_start | 2023-01-26 18:25:20.76352+04 xact_start | query_start | 2023-01-26 18:35:02.787621+04 state_change | 2023-01-26 18:35:02.787652+04 waiting | f state | idle backend_xid | backend_xmin | query | select value from m_locator where m_locator_id = (select m_locator_id from m_warehouse_product_po where m_product_id = $1 and isactive = 'Y' and m_warehouse_id = $2 and ad_client_id = $3 ) -[ RECORD 4 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- datid | 77307 datname | euro pid | 17459 usesysid | 16393 usename | adempiere application_name | PostgreSQL JDBC Driver client_addr | 127.0.0.1 client_hostname | client_port | 47158 backend_start | 2023-01-27 10:51:13.469683+04 xact_start | query_start | 2023-01-27 10:54:16.731884+04 state_change | 2023-01-27 10:54:16.731917+04 waiting | f state | idle backend_xid | backend_xmin | query | select coalesce(aa.isserno , 'N') hasserialno, coalesce(aa.islot, 'N') haslot, coalesce(aa.isguaranteedate, 'N') hasguarantee from m_product p left join m_attributeset aa ON (p.m_attributeset_id = aa.m_attributeset_id) where p.m_product_id = $1 -[ RECORD 5 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- datid | 77307 datname | euro pid | 17338 usesysid | 16393 usename | adempiere application_name | PostgreSQL JDBC Driver client_addr | 127.0.0.1 client_hostname | client_port | 47124 backend_start | 2023-01-27 10:49:13.791834+04 xact_start | query_start | 2023-01-27 10:54:07.907674+04 state_change | 2023-01-27 10:54:07.911439+04 waiting | f state | idle backend_xid | backend_xmin | query | SELECT COALESCE(SUM(s.qtyonhand),0) - COALESCE((SELECT SUM(movementqty) AS qty_intransit FROM m_movementline mml JOIN m_movement mm ON (mm.m_movement_id = mml.m_movement_id) WHERE docstatus = 'IP' AND mml.m_locator_id IN (SELECT m_locator_id FROM m_locator WHERE m_warehouse_id = 1010036) AND m_product_id = s.m_product_id), 0) - COALESCE(SUM(s.qtyReserved),0) AS qty_available, ( COALESCE(SUM(s.qtyonhand),0) - COALESCE((SELECT SUM(movementqty) AS qty_intransit FROM m_movementline mml JOIN m_movement mm ON (mm.m_movement_id = mml.m_movement_id) WHERE docstatus = 'IP' AND mml.m_locator_id IN (SELECT m_locator_id FROM m_locator WHERE m_warehouse_id = 1010036) AND m_product_id = s.m_product_id), 0) - COALESCE(SUM(s.qtyReserved),0))/dividerate AS uom_qty_available, u.uomsymbol from M_Storage s join m_locator l on s.m_locator_id = l.m_locator_id inner join M_AttributeSetInstance i on s.M_AttributeSetInstance_id = i.M_AttributeSetInstance_id LEFT JOIN LATERAL (SELECT DISTINCT ON (dividerate) dividerate, c_uom_to_i -[ RECORD 6 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- datid | 77307 datname | euro pid | 17374 usesysid | 16393 usename | adempiere application_name | PostgreSQL JDBC Driver client_addr | 127.0.0.1 client_hostname | client_port | 47144 backend_start | 2023-01-27 10:50:06.853178+04 xact_start | query_start | 2023-01-27 10:54:51.263275+04 state_change | 2023-01-27 10:54:51.270618+04 waiting | f state | idle backend_xid | backend_xmin | query | COMMIT -[ RECORD 7 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- datid | 77307 datname | euro pid | 17132 usesysid | 16393 usename | adempiere application_name | PostgreSQL JDBC Driver client_addr | 127.0.0.1 client_hostname | client_port | 47078 backend_start | 2023-01-27 10:43:27.651672+04 xact_start | query_start | 2023-01-27 10:54:51.254763+04 state_change | 2023-01-27 10:54:51.26229+04 waiting | f state | idle backend_xid | backend_xmin | query | COMMIT -[ RECORD 8 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- datid | 77307 datname | euro pid | 17596 usesysid | 16393 usename | adempiere application_name | psql.bin client_addr | client_hostname | client_port | -1 backend_start | 2023-01-27 10:54:13.816506+04 xact_start | 2023-01-27 10:54:51.632029+04 query_start | 2023-01-27 10:54:51.632029+04 state_change | 2023-01-27 10:54:51.632031+04 waiting | f state | active backend_xid | backend_xmin | 44234329 query | select * from pg_stat_activity; -[ RECORD 9 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- datid | 375640 datname | euro_test pid | 16246 usesysid | 16393 usename | adempiere application_name | PostgreSQL JDBC Driver client_addr | 127.0.0.1 client_hostname | client_port | 46774 backend_start | 2023-01-27 10:16:51.050285+04 xact_start | query_start | 2023-01-27 10:54:10.270274+04 state_change | 2023-01-27 10:54:10.2818+04 waiting | f state | idle backend_xid | backend_xmin | query | INSERT INTO TrxReplicationStatus (trxname,producedby,failedin,reason,issent,isself,iscorrected,AD_Client_ID) values ('POSIBOLT1379_1674802445702','EuroCentral_euro','Eurotest_euro_test','ERROR: insert or update on table "c_orderline" violates foreign key constraint "mwarehouse_corderline" + | Detail: Key (m_warehouse_id)=(1010036) is not present in table "m_warehouse".','N','N','N',1000000)