2025-11-06 05:02:47.486 CET [4412] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 05:02:47.486 CET [4412] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 05:02:47.826 CET [1608] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 05:02:47.826 CET [1608] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 05:15:50.190 CET [1608] ERROR:  syntax error at or near "FROM" at character 62
2025-11-06 05:15:50.190 CET [1608] STATEMENT:  SELECT conumber, coline,artnr,qordered,dspwaveid,wavestatus,
	FROM wms.RcpOrdArtGVW 
	Where fulfilltypeq = 'LIT'
	--AND wavestatus = 12
	--AND artnr = '861007'
	AND conumber = '817237735'
	AND state = 'A'
	Order by qordered desc
2025-11-06 05:21:50.573 CET [1608] ERROR:  syntax error at or near "817257864" at character 1
2025-11-06 05:21:50.573 CET [1608] STATEMENT:  817257864
2025-11-06 05:21:55.271 CET [1608] ERROR:  syntax error at or near "817257864" at character 1
2025-11-06 05:21:55.271 CET [1608] STATEMENT:  817257864
2025-11-06 06:09:52.982 CET [1608] ERROR:  syntax error at or near "9" at character 1
2025-11-06 06:09:52.982 CET [1608] STATEMENT:  9
2025-11-06 06:10:00.372 CET [1608] ERROR:  syntax error at or near "9" at character 1
2025-11-06 06:10:00.372 CET [1608] STATEMENT:  9
2025-11-06 06:13:25.165 CET [1608] ERROR:  column "dspwaweid" does not exist at character 157
2025-11-06 06:13:25.165 CET [1608] HINT:  Perhaps you meant to reference the column "rcpordartgvw.dspwaveid".
2025-11-06 06:13:25.165 CET [1608] STATEMENT:  SELECT *
	FROM wms.RcpOrdArtGVW 
	Where fulfilltypeq = 'LIT'
	AND wavestatus = 11
	--AND artnr = '861007'
	--AND conumber = '817257864'
	AND state = 'A'
	Order by dspwaweid desc
2025-11-06 06:26:27.570 CET [1608] ERROR:  syntax error at or near "817251622" at character 1
2025-11-06 06:26:27.570 CET [1608] STATEMENT:  817251622
2025-11-06 06:36:49.059 CET [5716] LOG:  checkpoint starting: time
2025-11-06 06:36:49.684 CET [5716] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.538 s, sync=0.033 s, total=0.626 s; sync files=6, longest=0.011 s, average=0.006 s; distance=13 kB, estimate=76 kB; lsn=7/A41F9A78, redo lsn=7/A41F9A20
2025-11-06 06:36:57.577 CET [5412] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:36:57.577 CET [5248] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:36:57.578 CET [4440] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:36:57.580 CET [3908] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:36:57.582 CET [4156] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:36:57.582 CET [1112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:36:57.585 CET [2892] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:36:57.585 CET [6756] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:43:25.241 CET [5684] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:43:25.244 CET [4476] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:43:25.244 CET [6492] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:43:25.244 CET [4560] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:43:25.246 CET [6680] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:43:25.247 CET [4372] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:48:44.123 CET [3020] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:48:44.124 CET [384] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:48:44.126 CET [2980] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:48:44.126 CET [5068] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:48:44.134 CET [1976] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:48:44.135 CET [2836] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:48:44.136 CET [6488] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.446 CET [3424] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.447 CET [5424] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.447 CET [6976] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.448 CET [1100] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.465 CET [1008] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.466 CET [2064] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.468 CET [5220] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.470 CET [3752] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.474 CET [3780] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.476 CET [2764] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:52:34.477 CET [4160] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 06:58:50.524 CET [3700] WARNING:  PID 5892 is not a PostgreSQL backend process
2025-11-06 06:59:09.966 CET [4692] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 06:59:09.966 CET [4692] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 06:59:10.393 CET [5892] WARNING:  PID 444 is not a PostgreSQL backend process
2025-11-06 06:59:11.249 CET [2388] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 06:59:11.249 CET [2388] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 07:02:57.593 CET [4412] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 07:05:27.380 CET [2876] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 07:05:27.380 CET [2876] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 07:06:01.396 CET [1128] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 07:06:01.396 CET [1128] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 07:07:32.316 CET [5340] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 07:07:32.316 CET [5340] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 07:52:55.790 CET [4144] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 07:52:55.790 CET [4144] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 08:00:26.509 CET [6876] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 08:00:26.509 CET [6876] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 08:00:26.572 CET [6876] ERROR:  syntax error at or near "despatchdate" at character 1
2025-11-06 08:00:26.572 CET [6876] STATEMENT:  despatchdate
2025-11-06 08:01:35.108 CET [6876] ERROR:  column "roa.artnr" must appear in the GROUP BY clause or be used in an aggregate function at character 44
2025-11-06 08:01:35.108 CET [6876] STATEMENT:  SELECT
		COUNT(ROA.conumber) AS orders,
	    ROA.artnr,
		MAX(ROA.packlistdescr) AS description,
		MAX(ROA.classification) AS classification,
		SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND RO.despatchdate = '2025-11-03'
	--  AND RO.datecreated > '2025-11-03 00:00:00'
	--  AND RO.shipmth = 'DPD'
		AND roa.dspwaveid is not null ;
	--  AND ROA.classification LIKE '%BK%' -- BK
	--  AND ROA.classification NOT LIKE '%BK%'  -- nie BK
	
	    --AND ROA.classification  LIKE '%:SINGLE' -- single
		--AND ROA.classification  LIKE '%NO_SINGLE' -- nie single
		
		--AND ROA.classification  LIKE 'SHIP_UNIT%' -- ship
		--AND ROA.classification  LIKE 'NO_SHIP_UNIT%' -- nie ship
		
		--AND ROA.classification  LIKE '%:PACK%'		-- pack size
		--AND ROA.classification  NOT LIKE '%:PACK%' -- nie packsize
		--GROUP BY ROA.artnr
		--ORDER BY ROA.artnr DESC;
2025-11-06 08:27:16.146 CET [1608] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:51:49.802 CET [5716] LOG:  checkpoint starting: time
2025-11-06 08:51:50.758 CET [5716] LOG:  checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.872 s, sync=0.033 s, total=0.957 s; sync files=6, longest=0.009 s, average=0.006 s; distance=29 kB, estimate=71 kB; lsn=7/A4200FE8, redo lsn=7/A4200F90
2025-11-06 08:52:00.126 CET [5620] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.127 CET [652] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.128 CET [3020] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.130 CET [7004] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.135 CET [6040] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.136 CET [3672] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.137 CET [6692] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.138 CET [1236] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.142 CET [5740] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.145 CET [3524] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.146 CET [340] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.150 CET [4996] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.151 CET [4492] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.151 CET [6396] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.152 CET [3156] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:52:00.153 CET [6300] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:53:04.341 CET [3224] ERROR:  syntax error at or near "FROM" at character 190
2025-11-06 08:53:04.341 CET [3224] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered,

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC
2025-11-06 08:53:26.608 CET [4504] ERROR:  syntax error at or near "FROM" at character 190
2025-11-06 08:53:26.608 CET [4504] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered,

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC
2025-11-06 08:54:53.091 CET [5460] ERROR:  syntax error at or near "not" at character 329
2025-11-06 08:54:53.091 CET [5460] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.dspwaveid not null

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC
2025-11-06 08:55:11.502 CET [6604] ERROR:  syntax error at or near "not" at character 329
2025-11-06 08:55:11.502 CET [6604] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.dspwaveid not null

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC
2025-11-06 08:55:53.650 CET [6604] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:55:53.651 CET [1804] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:55:53.651 CET [1028] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:55:53.654 CET [4468] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:55:53.656 CET [216] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:55:53.657 CET [3984] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:55:53.660 CET [7040] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:55:53.660 CET [6700] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:55:53.661 CET [2504] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 08:55:53.662 CET [5460] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:00:16.541 CET [2388] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:02:48.966 CET [6660] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 09:02:48.966 CET [6660] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 09:03:08.452 CET [7100] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 09:03:08.452 CET [7100] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 09:06:12.008 CET [1128] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:06:49.755 CET [5716] LOG:  checkpoint starting: time
2025-11-06 09:06:50.595 CET [5716] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.756 s, sync=0.030 s, total=0.840 s; sync files=5, longest=0.009 s, average=0.006 s; distance=31 kB, estimate=67 kB; lsn=7/A4208D18, redo lsn=7/A4208CC0
2025-11-06 09:07:51.872 CET [2876] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.716 CET [3668] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.717 CET [4776] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.718 CET [5916] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.719 CET [6804] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.720 CET [2888] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.725 CET [3804] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.727 CET [2392] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.727 CET [6892] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.733 CET [4560] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.734 CET [6336] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.735 CET [5100] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.735 CET [6204] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.735 CET [5372] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.749 CET [4580] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.752 CET [5112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.752 CET [5348] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.752 CET [944] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.753 CET [4140] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.756 CET [2992] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.760 CET [5180] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.790 CET [2536] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.791 CET [2624] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.808 CET [3840] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:10:27.828 CET [1724] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:11:49.584 CET [5716] LOG:  checkpoint starting: time
2025-11-06 09:11:49.765 CET [5716] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.111 s, sync=0.024 s, total=0.182 s; sync files=2, longest=0.015 s, average=0.012 s; distance=1 kB, estimate=60 kB; lsn=7/A4209260, redo lsn=7/A4209208
2025-11-06 09:16:49.766 CET [5716] LOG:  checkpoint starting: time
2025-11-06 09:16:50.280 CET [5716] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.430 s, sync=0.031 s, total=0.514 s; sync files=5, longest=0.012 s, average=0.007 s; distance=17 kB, estimate=56 kB; lsn=7/A420DA10, redo lsn=7/A420D9B8
2025-11-06 09:21:49.278 CET [5716] LOG:  checkpoint starting: time
2025-11-06 09:21:49.446 CET [5716] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.107 s, sync=0.014 s, total=0.168 s; sync files=2, longest=0.009 s, average=0.007 s; distance=0 kB, estimate=50 kB; lsn=7/A420DCA8, redo lsn=7/A420DC50
2025-11-06 09:22:08.413 CET [5112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:22:08.415 CET [1652] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:22:08.418 CET [5980] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:22:08.419 CET [4932] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:26:49.438 CET [5716] LOG:  checkpoint starting: time
2025-11-06 09:26:50.284 CET [5716] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.766 s, sync=0.033 s, total=0.847 s; sync files=5, longest=0.012 s, average=0.007 s; distance=32 kB, estimate=49 kB; lsn=7/A4216088, redo lsn=7/A4216030
2025-11-06 09:50:48.910 CET [4704] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.911 CET [6024] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.912 CET [4864] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.913 CET [3580] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.919 CET [2752] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.921 CET [6340] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.936 CET [2788] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.941 CET [6064] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.942 CET [3240] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.942 CET [1100] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.942 CET [1676] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.943 CET [7144] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.943 CET [1876] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.943 CET [656] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:48.948 CET [1892] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:49.003 CET [6488] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:49.004 CET [6100] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:49.005 CET [2876] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:50:49.011 CET [220] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:51:49.298 CET [5716] LOG:  checkpoint starting: time
2025-11-06 09:51:49.468 CET [5716] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.111 s, sync=0.013 s, total=0.170 s; sync files=2, longest=0.008 s, average=0.007 s; distance=1 kB, estimate=44 kB; lsn=7/A42164D0, redo lsn=7/A4216478
2025-11-06 09:54:55.439 CET [5208] WARNING:  PID 1128 is not a PostgreSQL backend process
2025-11-06 09:55:31.345 CET [7028] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:56:40.758 CET [5640] ERROR:  operator does not exist: character varying = integer at character 325
2025-11-06 09:56:40.758 CET [5640] HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
2025-11-06 09:56:40.758 CET [5640] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.artnr = $1
	  AND ROA.wavestatus < 5

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC
2025-11-06 09:56:49.456 CET [5716] LOG:  checkpoint starting: time
2025-11-06 09:56:49.890 CET [5112] ERROR:  operator does not exist: character varying = integer at character 325
2025-11-06 09:56:49.890 CET [5112] HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
2025-11-06 09:56:49.890 CET [5112] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.artnr = $1
	  AND ROA.wavestatus < 5

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC
2025-11-06 09:56:51.094 CET [5716] LOG:  checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.528 s, sync=0.060 s, total=1.639 s; sync files=9, longest=0.010 s, average=0.007 s; distance=70 kB, estimate=70 kB; lsn=7/A4228040, redo lsn=7/A4227FD0
2025-11-06 09:58:40.510 CET [5112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:58:40.511 CET [6480] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:58:40.512 CET [5340] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:58:40.513 CET [5648] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:58:40.518 CET [1652] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:58:40.521 CET [5640] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:58:40.522 CET [2352] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 09:58:40.528 CET [4320] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:00:36.285 CET [4692] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:00:42.685 CET [5196] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 10:00:42.685 CET [5196] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 10:00:43.020 CET [4880] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 10:00:43.020 CET [4880] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 10:01:41.654 CET [2300] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 10:01:41.654 CET [2300] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 10:01:41.718 CET [2300] ERROR:  syntax error at or near "861007" at character 1
2025-11-06 10:01:41.718 CET [2300] STATEMENT:  861007
2025-11-06 10:01:49.095 CET [5716] LOG:  checkpoint starting: time
2025-11-06 10:01:49.487 CET [5716] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.328 s, sync=0.020 s, total=0.393 s; sync files=2, longest=0.011 s, average=0.010 s; distance=10 kB, estimate=64 kB; lsn=7/A422A860, redo lsn=7/A422A808
2025-11-06 10:02:18.483 CET [6876] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:02:28.187 CET [2300] ERROR:  operator does not exist: character varying = integer at character 118
2025-11-06 10:02:28.187 CET [2300] HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
2025-11-06 10:02:28.187 CET [2300] STATEMENT:  SELECT *
	FROM wms.RcpOrdArtGVW 
	Where fulfilltypeq = 'LIT'
	--AND wavestatus = 9
	--AND dspwaveid = '967720'
	AND artnr = 861007
	--AND conumber = '817251622'
	AND state = 'A'
	Order by dspwaveid desc
2025-11-06 10:03:11.574 CET [5888] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:03:11.576 CET [460] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:03:11.576 CET [400] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:03:11.577 CET [5152] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:03:11.579 CET [4628] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:03:11.592 CET [4344] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:03:11.600 CET [3228] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:03:11.601 CET [4656] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:03:11.608 CET [3280] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:04:06.887 CET [5172] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:04:06.889 CET [6336] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:04:06.889 CET [6052] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:04:06.892 CET [5580] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:04:06.893 CET [6224] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:04:06.894 CET [6996] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:04:06.896 CET [4648] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:04:06.896 CET [5360] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:04:06.899 CET [5504] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:05:23.652 CET [2300] ERROR:  column "fulfilltypeq" does not exist at character 48
2025-11-06 10:05:23.652 CET [2300] STATEMENT:  SELECT *
	FROM wms.StockRegularTotalDVW  
	Where fulfilltypeq = 'LIT'
	--AND wavestatus = 9
	--AND dspwaveid = '967720'
	AND artnr = '861007'
	--AND conumber = '817251622'
	--AND state = 'A'
	--Order by dspwaveid desc
2025-11-06 10:16:59.577 CET [2300] ERROR:  syntax error at or near "FROM" at character 93
2025-11-06 10:16:59.577 CET [2300] STATEMENT:  SELECT locname, zone, pickzone, quantity, blocked, blockedin, blockedout, usage, locstate, 
	FROM wms.StockRegularDVW  
	Where artnr = '861007'
	--AND wavestatus = 9
	--AND dspwaveid = '967720'
	--AND artnr = '861007'
	--AND conumber = '817251622'
	--AND state = 'A'
	--Order by dspwaveid desc
2025-11-06 10:26:41.043 CET [2300] ERROR:  syntax error at or near "(" at character 17
2025-11-06 10:26:41.043 CET [2300] STATEMENT:  SELECT artnr SUM(quantity)
	FROM wms.StockRegularDVW  
	Where 0=0
	-- ANDartnr = '008056'
	AND pickzone = 'XWEBPICK'
	AND usage = 'PCK'
	AND blocked = 'N'
	AND blockedout = 'N'
	--AND wavestatus = 9
	--AND dspwaveid = '967720'
	--AND artnr = '861007'
	--AND conumber = '817251622'
	--AND state = 'A'
	--Order by dspwaveid desc
2025-11-06 10:26:45.426 CET [2300] ERROR:  column "stockregulardvw.artnr" must appear in the GROUP BY clause or be used in an aggregate function at character 8
2025-11-06 10:26:45.426 CET [2300] STATEMENT:  SELECT artnr, SUM(quantity)
	FROM wms.StockRegularDVW  
	Where 0=0
	-- ANDartnr = '008056'
	AND pickzone = 'XWEBPICK'
	AND usage = 'PCK'
	AND blocked = 'N'
	AND blockedout = 'N'
	--AND wavestatus = 9
	--AND dspwaveid = '967720'
	--AND artnr = '861007'
	--AND conumber = '817251622'
	--AND state = 'A'
	--Order by dspwaveid desc
2025-11-06 10:36:10.508 CET [4144] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:38:13.084 CET [6360] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:38:13.085 CET [5592] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:38:13.086 CET [2964] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:38:13.088 CET [6492] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:38:13.092 CET [6432] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:38:13.098 CET [4656] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:38:13.099 CET [6076] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:38:13.101 CET [460] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:39:08.724 CET [5780] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:39:08.725 CET [4996] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:39:08.726 CET [2020] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:39:08.727 CET [4844] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:39:08.732 CET [2992] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:39:08.735 CET [5044] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:39:08.737 CET [7144] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:39:08.739 CET [4860] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:41:49.491 CET [5716] LOG:  checkpoint starting: time
2025-11-06 10:41:50.023 CET [5716] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.432 s, sync=0.046 s, total=0.533 s; sync files=5, longest=0.014 s, average=0.010 s; distance=11 kB, estimate=59 kB; lsn=7/A422D7A8, redo lsn=7/A422D750
2025-11-06 10:45:03.929 CET [5100] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:45:03.930 CET [2308] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:45:03.930 CET [3776] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:45:03.931 CET [5136] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:45:03.933 CET [840] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:45:03.935 CET [5804] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:47:13.083 CET [7128] ERROR:  column "articleid" does not exist at character 8
2025-11-06 10:47:13.083 CET [7128] STATEMENT:  SELECT ArticleId, SUM(quantity) as Quantity

	FROM wms.StockRegularDVW  

	WHERE  pickzone = 'XWEBPICK'

	AND usage = 'PCK'

	AND blocked = 'N'

	AND blockedout = 'N'

	GROUP BY artnr
2025-11-06 10:47:42.040 CET [4648] ERROR:  column "articleid" does not exist at character 8
2025-11-06 10:47:42.040 CET [4648] STATEMENT:  SELECT ArticleId, SUM(quantity) as Quantity

	FROM wms.StockRegularDVW  

	WHERE  pickzone = 'XWEBPICK'

	AND usage = 'PCK'

	AND blocked = 'N'

	AND blockedout = 'N'

	GROUP BY artnr
2025-11-06 10:48:37.236 CET [5044] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.237 CET [2700] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.238 CET [4560] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.240 CET [5072] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.241 CET [1096] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.244 CET [4492] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.250 CET [4160] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.252 CET [6244] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.255 CET [6140] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.258 CET [7128] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.265 CET [2980] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:48:37.270 CET [4648] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.731 CET [5488] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.733 CET [7088] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.734 CET [236] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.734 CET [2372] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.739 CET [6468] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.741 CET [4196] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.752 CET [5932] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.753 CET [216] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.754 CET [5472] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.755 CET [4860] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.755 CET [2056] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.756 CET [4580] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.760 CET [1216] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 10:51:48.766 CET [2488] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 11:03:18.654 CET [7100] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 11:05:25.825 CET [2300] ERROR:  column "destloc" does not exist at character 36
2025-11-06 11:05:25.825 CET [2300] STATEMENT:  SELECT *
	FROM wms.TaskGVW  
	WHERE  destloc = 'WEBSHOP'
	--AND usage = 'PCK'
	--AND blocked = 'N'
	--AND blockedout = 'N'
	--GROUP BY artnr;
2025-11-06 11:07:00.846 CET [2300] ERROR:  syntax error at or near "TaskInrInfoGvw" at character 1
2025-11-06 11:07:00.846 CET [2300] STATEMENT:  TaskInrInfoGvw
2025-11-06 11:09:20.643 CET [2300] ERROR:  column "quantity" does not exist at character 19
2025-11-06 11:09:20.643 CET [2300] STATEMENT:  SELECT artnr, SUM(quantity)
	FROM wms.TaskInrInfoGvw  
	WHERE  pickzone = 'XWEBPICK'
	AND usage = 'PCK'
	AND blocked = 'N'
	AND blockedout = 'N'
	GROUP BY artnr;
2025-11-06 11:09:46.340 CET [2300] ERROR:  column "stockregulardvw.locname" must appear in the GROUP BY clause or be used in an aggregate function at character 8
2025-11-06 11:09:46.340 CET [2300] STATEMENT:  SELECT locname, artnr, SUM(quantity)
	FROM wms.StockRegularDVW  
	WHERE  pickzone = 'XWEBPICK'
	AND usage = 'PCK'
	AND blocked = 'N'
	AND blockedout = 'N'
	GROUP BY artnr;
2025-11-06 11:12:00.674 CET [2300] ERROR:  syntax error at or near "GROUP" at character 186
2025-11-06 11:12:00.674 CET [2300] STATEMENT:  SELECT locname, artnr, SUM(quantity)
	FROM wms.StockRegularDVW  
	WHERE  --pickzone = 'XWEBPICK'
	--AND usage = 'PCK'
	--AND blocked = 'N'
	--AND blockedout = 'N'
	--AND locname = 'XWEB-PND'
	GROUP BY artnr, locname
	ORDER BY locname DESC
2025-11-06 11:12:24.202 CET [2300] ERROR:  column "stockregulardvw.palid" must appear in the GROUP BY clause or be used in an aggregate function at character 8
2025-11-06 11:12:24.202 CET [2300] STATEMENT:  SELECT *, locname, artnr, SUM(quantity)
	FROM wms.StockRegularDVW  
	WHERE  --pickzone = 'XWEBPICK'
	--AND usage = 'PCK'
	--AND blocked = 'N'
	--AND blockedout = 'N'
	locname = 'XWEB-PND'
	GROUP BY artnr, locname
	ORDER BY locname DESC
2025-11-06 11:12:28.818 CET [2300] ERROR:  column "stockregulardvw.palid" must appear in the GROUP BY clause or be used in an aggregate function at character 8
2025-11-06 11:12:28.818 CET [2300] STATEMENT:  SELECT * --, locname, artnr, SUM(quantity)
	FROM wms.StockRegularDVW  
	WHERE  --pickzone = 'XWEBPICK'
	--AND usage = 'PCK'
	--AND blocked = 'N'
	--AND blockedout = 'N'
	locname = 'XWEB-PND'
	GROUP BY artnr, locname
	ORDER BY locname DESC
2025-11-06 11:15:13.412 CET [2300] ERROR:  relation "taskinrinfogvw" does not exist at character 15
2025-11-06 11:15:13.412 CET [2300] STATEMENT:  SELECT *
	FROM TaskInrInfoGvw
2025-11-06 11:25:06.813 CET [6660] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 11:33:21.573 CET [2300] ERROR:  column "taskinrinfogvw.artnr" must appear in the GROUP BY clause or be used in an aggregate function at character 8
2025-11-06 11:33:21.573 CET [2300] STATEMENT:  SELECT artnr, SUM(qty)
	FROM wms.TaskInrInfoGvw
	WHERE destloc IN ('WEBSHOP', 'PZPICK-TMP-ITM-VIR')
	   OR destloc LIKE 'XW%A%'
	ORDER BY artnr;
2025-11-06 11:46:49.075 CET [5716] LOG:  checkpoint starting: time
2025-11-06 11:46:49.699 CET [5716] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.547 s, sync=0.033 s, total=0.624 s; sync files=5, longest=0.009 s, average=0.007 s; distance=24 kB, estimate=55 kB; lsn=7/A4233860, redo lsn=7/A4233808
2025-11-06 12:00:53.732 CET [4880] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:01:51.432 CET [5196] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:20:25.537 CET [6652] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:20:25.538 CET [4864] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:20:25.540 CET [696] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:20:25.540 CET [7032] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:20:25.542 CET [6232] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:20:25.560 CET [2864] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:20:25.560 CET [5352] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:20:25.560 CET [6116] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:20:25.570 CET [3288] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:20:25.611 CET [2028] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.635 CET [3584] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.636 CET [3428] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.647 CET [4872] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.648 CET [2476] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.648 CET [5144] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.649 CET [5620] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.655 CET [4224] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.655 CET [2352] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.655 CET [3600] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.656 CET [5868] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:21:52.658 CET [3904] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.120 CET [580] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.121 CET [4576] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.121 CET [5488] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.122 CET [6624] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.124 CET [444] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.129 CET [6524] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.132 CET [3712] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.133 CET [4064] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.134 CET [6796] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.134 CET [5432] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.137 CET [7072] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 12:25:24.149 CET [4484] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:00:27.935 CET [4916] ERROR:  syntax error at or near ")" at character 340
2025-11-06 13:00:27.935 CET [4916] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ( ROA.wavestatus < 5 OR ()

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC;
2025-11-06 13:00:47.102 CET [6588] ERROR:  syntax error at or near ")" at character 340
2025-11-06 13:00:47.102 CET [6588] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ( ROA.wavestatus < 5 OR ()

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC;
2025-11-06 13:01:29.852 CET [4916] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:01:29.853 CET [5768] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:01:29.854 CET [5208] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:01:29.855 CET [6632] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:01:29.860 CET [5200] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:01:29.863 CET [4136] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:01:29.872 CET [6588] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:01:29.876 CET [3508] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:01:29.880 CET [424] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:01:29.887 CET [944] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:01:49.757 CET [5716] LOG:  checkpoint starting: time
2025-11-06 13:01:50.487 CET [5716] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.656 s, sync=0.025 s, total=0.730 s; sync files=5, longest=0.007 s, average=0.005 s; distance=16 kB, estimate=51 kB; lsn=7/A42378A0, redo lsn=7/A4237848
2025-11-06 13:01:56.164 CET [6548] ERROR:  syntax error at or near "GROUP" at character 338
2025-11-06 13:01:56.164 CET [6548] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ( ROA.wavestatus < 5 

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC;
2025-11-06 13:02:12.263 CET [3780] ERROR:  syntax error at or near "GROUP" at character 338
2025-11-06 13:02:12.263 CET [3780] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ( ROA.wavestatus < 5 

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC;
2025-11-06 13:04:39.682 CET [6876] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:04:39.683 CET [1096] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:04:39.685 CET [3424] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:04:39.690 CET [6548] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:04:39.690 CET [6972] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:04:39.692 CET [3112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:04:39.693 CET [5040] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:04:39.694 CET [5572] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:05:15.661 CET [1700] ERROR:  syntax error at or near "GROUP" at character 338
2025-11-06 13:05:15.661 CET [1700] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ( ROA.wavestatus < 5 

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC;
2025-11-06 13:08:34.779 CET [3548] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:08:34.779 CET [6364] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:08:34.780 CET [5888] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:08:34.782 CET [1700] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:08:34.783 CET [3324] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:08:34.786 CET [6996] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:08:34.788 CET [7152] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:11:02.591 CET [2208] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:11:02.592 CET [2684] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:11:02.593 CET [5392] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:11:02.594 CET [6432] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:11:02.596 CET [3040] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:11:02.596 CET [3696] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:11:02.601 CET [6816] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:11:02.613 CET [6756] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:11:02.613 CET [3984] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:14:06.799 CET [3112] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 13:14:06.799 CET [3112] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 13:14:07.122 CET [6736] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 13:14:07.122 CET [6736] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 13:16:49.501 CET [5716] LOG:  checkpoint starting: time
2025-11-06 13:16:50.682 CET [5716] LOG:  checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.091 s, sync=0.038 s, total=1.181 s; sync files=6, longest=0.012 s, average=0.007 s; distance=42 kB, estimate=51 kB; lsn=7/A4242420, redo lsn=7/A42423C8
2025-11-06 13:21:49.690 CET [5716] LOG:  checkpoint starting: time
2025-11-06 13:21:50.189 CET [5716] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.435 s, sync=0.018 s, total=0.500 s; sync files=2, longest=0.013 s, average=0.009 s; distance=20 kB, estimate=47 kB; lsn=7/A4247620, redo lsn=7/A42475C8
2025-11-06 13:31:35.582 CET [5164] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:31:35.583 CET [6516] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:31:35.584 CET [2788] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:31:35.590 CET [5496] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:31:35.590 CET [2696] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:31:35.591 CET [2484] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:31:35.592 CET [2944] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:31:35.597 CET [420] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:31:35.598 CET [6012] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:31:35.629 CET [556] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:31:49.192 CET [5716] LOG:  checkpoint starting: time
2025-11-06 13:31:49.927 CET [5716] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.657 s, sync=0.033 s, total=0.736 s; sync files=4, longest=0.012 s, average=0.009 s; distance=32 kB, estimate=46 kB; lsn=7/A424F8F8, redo lsn=7/A424F868
2025-11-06 13:33:56.110 CET [2300] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:36:49.923 CET [5716] LOG:  checkpoint starting: time
2025-11-06 13:36:50.442 CET [5716] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.431 s, sync=0.042 s, total=0.520 s; sync files=5, longest=0.012 s, average=0.009 s; distance=6 kB, estimate=42 kB; lsn=7/A42511F0, redo lsn=7/A4251198
2025-11-06 13:38:16.893 CET [5476] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.908 CET [2964] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.909 CET [5384] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.912 CET [6656] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.915 CET [5392] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.915 CET [5964] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.923 CET [2512] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.925 CET [3304] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.927 CET [6652] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.932 CET [4840] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.936 CET [6604] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.936 CET [4200] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.937 CET [5800] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.938 CET [2440] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.939 CET [6220] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.948 CET [2400] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.951 CET [4388] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.962 CET [6180] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.970 CET [6936] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.971 CET [5260] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.986 CET [2800] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.988 CET [6432] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.990 CET [4828] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.994 CET [6492] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.996 CET [4320] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:16.997 CET [6392] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:17.001 CET [7012] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:17.003 CET [6176] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:38:17.074 CET [4860] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.602 CET [6076] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.603 CET [6596] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.605 CET [5684] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.606 CET [3308] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.607 CET [5424] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.609 CET [4504] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.619 CET [1964] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.632 CET [7120] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.633 CET [5000] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.645 CET [4252] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.651 CET [5752] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.652 CET [6904] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.652 CET [4456] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.654 CET [2668] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.666 CET [2796] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.675 CET [340] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 13:40:07.678 CET [5872] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.476 CET [4804] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.479 CET [6240] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.479 CET [4756] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.481 CET [5192] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.481 CET [2488] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.487 CET [1112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.500 CET [6468] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.509 CET [2668] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.515 CET [6292] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.515 CET [2772] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.515 CET [2368] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.515 CET [3664] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.515 CET [1056] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.516 CET [4912] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:42.520 CET [4344] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:29:52.656 CET [1616] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 14:29:52.656 CET [1616] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 14:29:52.982 CET [5632] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 14:29:52.982 CET [5632] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 14:31:49.480 CET [5716] LOG:  checkpoint starting: time
2025-11-06 14:31:50.331 CET [5716] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.759 s, sync=0.040 s, total=0.852 s; sync files=6, longest=0.011 s, average=0.007 s; distance=32 kB, estimate=41 kB; lsn=7/A42592C0, redo lsn=7/A4259268
2025-11-06 14:33:16.824 CET [1616] ERROR:  null value in column "password_hash" of relation "app_users" violates not-null constraint
2025-11-06 14:33:16.824 CET [1616] DETAIL:  Failing row contains (7, null, f, Samuel Jendryke, SJ, null, null, null, null, null, null, null, sje, null, null, null, null, null, null, null, 2025-11-06 14:33:16.666806, null, {}).
2025-11-06 14:33:16.824 CET [1616] STATEMENT:  INSERT INTO sonex.app_users (
	password_hash, is_blocked, name, initials, date_of_birth, native_language, other_languages, email, phone_number, department, job_title, account_sonex, account_locus_wms, account_locus_terminal, account_orp, account_bk, account_dpd, account_xenos, tags, notes) VALUES (
	$1::text, $2::boolean, $3::character varying, $4::character varying, $5::timestamp without time zone, $6::character varying, $7::text, $8::character varying, $9::character varying, $10::character varying, $11::character varying, $12::character varying, $13::character varying, $14::character varying, $15::character varying, $16::character varying, $17::character varying, $18::character varying, $19::text[], $20::text)
	 returning guid;
2025-11-06 14:36:49.331 CET [5716] LOG:  checkpoint starting: time
2025-11-06 14:36:50.203 CET [5716] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.763 s, sync=0.062 s, total=0.873 s; sync files=7, longest=0.015 s, average=0.009 s; distance=7 kB, estimate=37 kB; lsn=7/A425AF00, redo lsn=7/A425AEA8
2025-11-06 14:39:43.875 CET [5808] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:39:43.875 CET [2728] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:39:43.879 CET [4064] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:39:43.882 CET [6380] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:39:43.884 CET [2400] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:39:43.886 CET [4032] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:39:43.897 CET [7036] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:44:17.402 CET [3396] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:44:17.403 CET [6076] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:45:48.221 CET [6212] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:45:48.221 CET [5536] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:45:48.223 CET [1040] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:45:48.227 CET [2944] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:45:48.229 CET [3544] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:45:48.230 CET [3712] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:45:48.231 CET [6448] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:45:48.235 CET [2892] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:48:42.931 CET [1216] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:48:42.932 CET [4216] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:48:42.934 CET [6872] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:48:42.935 CET [6652] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:48:42.936 CET [5640] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:48:42.937 CET [5384] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:48:42.937 CET [1700] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:51:06.472 CET [6988] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:51:06.473 CET [6912] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:51:06.474 CET [4916] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:51:06.475 CET [3016] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:51:06.480 CET [4016] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:51:06.482 CET [6880] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:51:06.482 CET [4592] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 14:56:49.197 CET [5716] LOG:  checkpoint starting: time
2025-11-06 14:56:49.362 CET [5716] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.103 s, sync=0.014 s, total=0.166 s; sync files=2, longest=0.008 s, average=0.007 s; distance=5 kB, estimate=34 kB; lsn=7/A425C648, redo lsn=7/A425C5F0
2025-11-06 15:10:22.858 CET [1064] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 15:10:22.859 CET [4340] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 15:11:34.001 CET [6156] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 15:11:34.002 CET [6412] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 15:11:34.004 CET [4984] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 15:11:34.005 CET [2368] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 15:11:34.006 CET [6292] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 15:11:49.354 CET [5716] LOG:  checkpoint starting: time
2025-11-06 15:11:49.873 CET [5716] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.436 s, sync=0.037 s, total=0.520 s; sync files=5, longest=0.009 s, average=0.008 s; distance=17 kB, estimate=33 kB; lsn=7/A4260C38, redo lsn=7/A4260BE0
2025-11-06 15:14:16.941 CET [3112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 15:31:09.372 CET [6736] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:07:42.680 CET [2968] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:07:42.681 CET [3736] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:07:42.683 CET [4484] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:07:42.688 CET [5280] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:07:42.695 CET [3020] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:07:42.698 CET [5112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:07:42.703 CET [5068] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:07:42.703 CET [6156] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:07:42.705 CET [556] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:07:42.706 CET [4416] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:09:49.241 CET [2928] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:09:49.242 CET [5200] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:09:49.242 CET [6284] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:09:49.243 CET [5576] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:09:49.257 CET [6536] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:09:49.264 CET [4448] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:09:49.264 CET [4668] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:09:49.265 CET [5452] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:09:49.265 CET [6820] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.399 CET [6016] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.401 CET [3496] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.405 CET [2812] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.413 CET [6012] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.420 CET [4500] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.422 CET [3456] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.423 CET [4668] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.427 CET [4880] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.428 CET [172] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.429 CET [2868] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.432 CET [6932] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.434 CET [3000] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.437 CET [3032] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.442 CET [5732] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.447 CET [4552] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.448 CET [696] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.450 CET [6680] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.461 CET [4248] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.470 CET [6428] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.472 CET [1112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.484 CET [2244] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.555 CET [4004] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.563 CET [2948] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:22:39.569 CET [576] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:30:03.172 CET [5632] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:35:00.593 CET [1616] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 16:56:49.991 CET [5716] LOG:  checkpoint starting: time
2025-11-06 16:56:52.289 CET [5716] LOG:  checkpoint complete: wrote 21 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.166 s, sync=0.087 s, total=2.299 s; sync files=13, longest=0.013 s, average=0.007 s; distance=50 kB, estimate=50 kB; lsn=7/A426D7E8, redo lsn=7/A426D790
2025-11-06 17:10:33.502 CET [2476] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.503 CET [5452] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.504 CET [1932] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.504 CET [6464] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.508 CET [5664] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.511 CET [4776] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.514 CET [6972] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.544 CET [6476] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.546 CET [5892] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.546 CET [3156] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.547 CET [6048] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.548 CET [6572] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.576 CET [4032] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.597 CET [6596] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.606 CET [5220] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.613 CET [2928] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:10:33.614 CET [2208] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 17:57:41.348 CET [652] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 17:57:41.348 CET [652] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 17:57:41.950 CET [4552] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-06 17:57:41.950 CET [4552] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-06 18:02:27.670 CET [4552] ERROR:  syntax error at end of input at character 516
2025-11-06 18:02:27.670 CET [4552] STATEMENT:  SELECT *
	--    COUNT(ROA.conumber) AS orders,
	--    ROA.artnr,
	--    MAX(ROA.packlistdescr) AS description,
	--    MAX(ROA.classification) AS classification,
	--    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.classification LIKE 'NO_SHIP_UNIT%'
	  AND (ROA.wavestatus < 5  OR (RO.despatchdate <= '06-11-2025' AND RO.datecreated >= '06-11-2025' ) )
	--GROUP BY ROA.artnr
	--ORDER BY ROA.artnr DESC;
	ORDER BY 
2025-11-06 18:02:42.622 CET [4552] ERROR:  syntax error at end of input at character 516
2025-11-06 18:02:42.622 CET [4552] STATEMENT:  SELECT *
	--    COUNT(ROA.conumber) AS orders,
	--    ROA.artnr,
	--    MAX(ROA.packlistdescr) AS description,
	--    MAX(ROA.classification) AS classification,
	--    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.classification LIKE 'NO_SHIP_UNIT%'
	  AND (ROA.wavestatus < 5  OR (RO.despatchdate <= '06-11-2025' AND RO.datecreated >= '06-11-2025' ) )
	--GROUP BY ROA.artnr
	--ORDER BY ROA.artnr DESC;
	ORDER BY 
2025-11-06 18:12:40.911 CET [4552] ERROR:  syntax error at or near "ROA" at character 382
2025-11-06 18:12:40.911 CET [4552] STATEMENT:  SELECT *
	--    COUNT(ROA.conumber) AS orders,
	--    ROA.artnr,
	--    MAX(ROA.packlistdescr) AS description,
	--    MAX(ROA.classification) AS classification,
	--    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.classification LIKE 'NO_SHIP_UNIT%'
	  AND(ROA.wavestatus < 5 ROA.wavestatus  AND dspwaveid in not null OR ( RO.despatchdate <= '2025-11-06' 
	  AND RO.despatchdate >= '2025-11-06'))
	--GROUP BY ROA.artnr
	--ORDER BY ROA.artnr DESC;
	ORDER BY RO.despatchdate
2025-11-06 18:12:49.382 CET [4552] ERROR:  syntax error at or near "ROA" at character 382
2025-11-06 18:12:49.382 CET [4552] STATEMENT:  SELECT *
	--    COUNT(ROA.conumber) AS orders,
	--    ROA.artnr,
	--    MAX(ROA.packlistdescr) AS description,
	--    MAX(ROA.classification) AS classification,
	--    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.classification LIKE 'NO_SHIP_UNIT%'
	  AND(ROA.wavestatus < 5 ROA.wavestatus  AND ROA.dspwaveid in not null OR ( RO.despatchdate <= '2025-11-06' 
	  AND RO.despatchdate >= '2025-11-06'))
	--GROUP BY ROA.artnr
	--ORDER BY ROA.artnr DESC;
	ORDER BY RO.despatchdate
2025-11-06 18:13:00.391 CET [4552] ERROR:  syntax error at or near "ROA" at character 382
2025-11-06 18:13:00.391 CET [4552] STATEMENT:  SELECT *
	--    COUNT(ROA.conumber) AS orders,
	--    ROA.artnr,
	--    MAX(ROA.packlistdescr) AS description,
	--    MAX(ROA.classification) AS classification,
	--    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.classification LIKE 'NO_SHIP_UNIT%'
	  AND(ROA.wavestatus < 5 ROA.wavestatus  AND RO.dspwaveid in not null OR ( RO.despatchdate <= '2025-11-06' 
	  AND RO.despatchdate >= '2025-11-06'))
	--GROUP BY ROA.artnr
	--ORDER BY ROA.artnr DESC;
	ORDER BY RO.despatchdate
2025-11-06 18:13:29.583 CET [4552] ERROR:  syntax error at or near "ROA" at character 382
2025-11-06 18:13:29.583 CET [4552] STATEMENT:  SELECT *
	--    COUNT(ROA.conumber) AS orders,
	--    ROA.artnr,
	--    MAX(ROA.packlistdescr) AS description,
	--    MAX(ROA.classification) AS classification,
	--    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.classification LIKE 'NO_SHIP_UNIT%'
	  AND(ROA.wavestatus < 5 ROA.wavestatus  AND ROA.dspwaveid in not null OR ( RO.despatchdate <= '2025-11-06' 
	  AND RO.despatchdate >= '2025-11-06'))
	--GROUP BY ROA.artnr
	--ORDER BY ROA.artnr DESC;
	ORDER BY RO.despatchdate
2025-11-06 18:13:40.897 CET [4552] ERROR:  syntax error at or near "ROA" at character 383
2025-11-06 18:13:40.897 CET [4552] STATEMENT:  SELECT *
	--    COUNT(ROA.conumber) AS orders,
	--    ROA.artnr,
	--    MAX(ROA.packlistdescr) AS description,
	--    MAX(ROA.classification) AS classification,
	--    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.classification LIKE 'NO_SHIP_UNIT%'
	  AND((ROA.wavestatus < 5 ROA.wavestatus  AND ROA.dspwaveid in not null) OR ( RO.despatchdate <= '2025-11-06' 
	  AND RO.despatchdate >= '2025-11-06'))
	--GROUP BY ROA.artnr
	--ORDER BY ROA.artnr DESC;
	ORDER BY RO.despatchdate
2025-11-06 18:13:50.941 CET [4552] ERROR:  syntax error at or near "not" at character 404
2025-11-06 18:13:50.941 CET [4552] STATEMENT:  SELECT *
	--    COUNT(ROA.conumber) AS orders,
	--    ROA.artnr,
	--    MAX(ROA.packlistdescr) AS description,
	--    MAX(ROA.classification) AS classification,
	--    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.classification LIKE 'NO_SHIP_UNIT%'
	  AND((ROA.wavestatus < 5 AND ROA.dspwaveid in not null) OR ( RO.despatchdate <= '2025-11-06' 
	  AND RO.despatchdate >= '2025-11-06'))
	--GROUP BY ROA.artnr
	--ORDER BY ROA.artnr DESC;
	ORDER BY RO.despatchdate
2025-11-06 18:21:02.134 CET [5156] ERROR:  syntax error at or near "ROA" at character 406
2025-11-06 18:21:02.134 CET [5156] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.wavestatus < 5
	  AND ROA.classification LIKE 'NO_SHIP_UNIT%'
	  AND (ROA.wavestatus < 5 ROA.dspwaveid IS NOT NULL OR (RO.despatchdate >= $1 AND RO.despatchdate <= $2 ) )

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC
2025-11-06 18:21:17.939 CET [6588] ERROR:  syntax error at or near "ROA" at character 406
2025-11-06 18:21:17.939 CET [6588] STATEMENT:  

	SELECT

	    COUNT(ROA.conumber) AS orders,

	    ROA.artnr,

	    MAX(ROA.packlistdescr) AS description,

	    MAX(ROA.classification) AS classification,

	    SUM(ROA.qordered) AS ordered

	FROM wms.RcpOrd RO

	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber

	WHERE RO.OrdType = 'WEB'
	  AND RO.State = 'A'
	  AND ROA.wavestatus < 5
	  AND ROA.classification LIKE 'NO_SHIP_UNIT%'
	  AND (ROA.wavestatus < 5 ROA.dspwaveid IS NOT NULL OR (RO.despatchdate >= $1 AND RO.despatchdate <= $2 ) )

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC
2025-11-06 18:25:14.702 CET [5156] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.703 CET [6100] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.703 CET [3156] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.706 CET [3768] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.715 CET [6052] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.715 CET [6588] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.726 CET [6972] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.726 CET [2796] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.728 CET [6184] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.733 CET [5992] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.734 CET [4596] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.734 CET [5364] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 18:25:14.738 CET [3708] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 19:57:51.580 CET [652] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:14:27.108 CET [4552] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:20:26.133 CET [2684] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:26:55.592 CET [6720] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:26:55.593 CET [2968] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:26:55.595 CET [7004] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:26:55.596 CET [5832] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:26:55.601 CET [7092] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:27:29.981 CET [3280] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:27:30.735 CET [3456] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:27:35.304 CET [1028] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:27:35.429 CET [5128] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:27:36.081 CET [4508] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:27:39.759 CET [7040] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:27:41.020 CET [4556] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:27:42.532 CET [3804] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:27:43.407 CET [4996] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:28:01.867 CET [2368] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:28:03.226 CET [6252] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:28:04.219 CET [6984] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:28:20.295 CET [2668] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:28:21.729 CET [6380] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:28:22.573 CET [6708] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:28:57.428 CET [5924] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:28:58.940 CET [6792] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:28:59.944 CET [420] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:29:10.076 CET [4112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:29:11.495 CET [5792] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:29:12.345 CET [5140] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:29:21.763 CET [4340] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:29:23.154 CET [4388] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:29:24.102 CET [4200] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:29:32.064 CET [1344] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:29:33.606 CET [1872] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:29:34.492 CET [6284] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:30:15.000 CET [6560] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:30:16.526 CET [3020] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:30:17.483 CET [5108] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:30:27.990 CET [2696] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:30:29.454 CET [6376] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:30:30.376 CET [3696] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:31:54.253 CET [6852] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:31:55.764 CET [6572] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:31:56.821 CET [5932] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:34:59.270 CET [1676] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:35:00.796 CET [2852] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:35:01.796 CET [3048] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:36:25.922 CET [444] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:36:27.429 CET [7008] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:36:28.566 CET [4456] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:37:25.561 CET [6864] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:37:27.119 CET [4836] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:37:28.166 CET [6340] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:37:49.201 CET [6916] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:37:49.779 CET [7116] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:37:50.775 CET [5672] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:37:52.270 CET [1884] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:37:53.223 CET [4788] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:38:24.214 CET [1976] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:38:25.756 CET [6856] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:38:26.735 CET [6876] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:38:37.201 CET [4524] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:38:38.732 CET [2056] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:38:39.575 CET [4804] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:38:50.981 CET [7100] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:38:52.375 CET [6804] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:38:53.380 CET [3660] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:39:49.251 CET [1616] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:39:50.731 CET [6516] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:39:51.746 CET [116] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:46:33.971 CET [6448] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:46:33.972 CET [4916] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:46:33.973 CET [6396] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:46:33.975 CET [5364] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:46:33.980 CET [5664] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:46:33.982 CET [5816] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:49:47.130 CET [4644] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:49:47.131 CET [5456] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:49:47.132 CET [4356] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:49:47.134 CET [5296] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:49:47.138 CET [2812] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-06 20:49:47.139 CET [3704] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.