2025-11-22 00:12:26.536 CET [5540] ERROR:  syntax error at or near "userexec" at character 309
2025-11-22 00:12:26.536 CET [5540] STATEMENT:  Select stockeventid, userexec, olddt, newdt, lgstkproc, mainprocess, restypeexec,
	handlingtype, oldlocation, newlocation, newartnr, newqty, resourceexec, collobarcode, picklistid, conr, contid
	From ltt.StockEvents 
	WHERE --oldlocation <> newlocation
	newdt > '2025-11-17'::date
	AND newdt < '2025-11-18'::date
	userexec = 'BHUPINDERM'
	
	-- Web picking
	AND restypeexec = 'HAND' AND mainprocess = 'ORDPICK' AND  lgstkproc = 'ORDPICK' AND handlingtype = 'OP2' AND oldlocation is null
	-- Rivers pikowanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK'  AND handlingtype = 'TS2' AND  newlocation <> oldlocation --newlocation LIKE 'R%'
	-- Rivers odkładanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TU4' AND newlocation LIKE 'X%' AND newlocation NOT LIKE 'XWE%'
	
	
	--AND mainprocess = 'ALGEMEEN'
	--AND restypeexec = 'HAND'
	--AND oldlocation <> newlocation
	--AND handlingtype = 'TU4'
	--AND oldlocation LIKE 'R%'
	--AND newlocation LIKE 'X%'
	ORDER BY userexec ASC, newdt asc
	--LIMIT 1000 718450732
	
	
	-----   lgstkproc   -----
	-- DESPATCH
	-- INVENT
	-- NAVUL
	-- ONTVANG
	-- ORDPICK
	-- REALLOC
	-- REVPCK
	-- STOCKCHG - WERK
	-------------------------
	
	----   mainprocess  -----
	-- ALGEMEEN - WERK
	-- DESPATCH
	-- INRUIM
	-- INVENT
	-- NAVUL
	-- ORDPICK
	-- REALLOC
	--------------------------
	
	----   handlingtype  -----
	-- DL1
	-- DV1
	-- FPE
	-- LC1
	-- LP1
	-- MS1
	-- MV1
	-- OP1
	-- OP2
	-- OP5
	-- RC0
	-- RC1
	-- RS1
	-- SNP
	-- SQL
	-- TI1
	-- TO5
	-- TS2
	-- TU2
	-- TU4 - WERK TO PICK LOC
	-- TU5 - WERK TO STOCK LOC
	-- WV1
	-- XC1
	-- XC2
	-- XC4
	-- XC5
	-- XL2
	-- XL4
	-- XL6
	-- XP2
	-- XP3 - WERK TO STOCK LOC
	-- XP4
	-- XP5
	-----------------------
	
	---- WERK ----
	-- AND lgstkproc = 'STOCKCHG'
	-- AND mainprocess = 'ALGEMEEN'
	-- AND handlingtype = 'TU4'
	-- AND restypeexec = 'HAND'
	-- AND oldlocation LIKE 'R%'
	-- AND newlocation LIKE 'X%'
	
	
2025-11-22 00:16:15.281 CET [5540] ERROR:  syntax error at or near "userexec" at character 309
2025-11-22 00:16:15.281 CET [5540] STATEMENT:  Select stockeventid, userexec, olddt, newdt, lgstkproc, mainprocess, restypeexec,
	handlingtype, oldlocation, newlocation, newartnr, newqty, resourceexec, collobarcode, picklistid, conr, contid
	From ltt.StockEvents 
	WHERE --oldlocation <> newlocation
	newdt > '2025-11-17'::date
	AND newdt < '2025-11-18'::date
	userexec = 'BHUPINDERM'
	
	-- Web picking
	AND restypeexec = 'HAND' AND mainprocess = 'ORDPICK' AND  lgstkproc = 'ORDPICK' AND handlingtype = 'OP2' AND oldlocation is null
	-- Rivers pikowanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK'  AND handlingtype = 'TS2' AND  newlocation <> oldlocation --newlocation LIKE 'R%'
	-- Rivers odkładanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TU4' AND newlocation LIKE 'X%' AND newlocation NOT LIKE 'XWE%'
	
	
	--AND mainprocess = 'ALGEMEEN'
	--AND restypeexec = 'HAND'
	--AND oldlocation <> newlocation
	--AND handlingtype = 'TU4'
	--AND oldlocation LIKE 'R%'
	--AND newlocation LIKE 'X%'
	ORDER BY userexec ASC, newdt asc
	--LIMIT 1000 718450732
	
	
	-----   lgstkproc   -----
	-- DESPATCH
	-- INVENT
	-- NAVUL
	-- ONTVANG
	-- ORDPICK
	-- REALLOC
	-- REVPCK
	-- STOCKCHG - WERK
	-------------------------
	
	----   mainprocess  -----
	-- ALGEMEEN - WERK
	-- DESPATCH
	-- INRUIM
	-- INVENT
	-- NAVUL
	-- ORDPICK
	-- REALLOC
	--------------------------
	
	----   handlingtype  -----
	-- DL1
	-- DV1
	-- FPE
	-- LC1
	-- LP1
	-- MS1
	-- MV1
	-- OP1
	-- OP2
	-- OP5
	-- RC0
	-- RC1
	-- RS1
	-- SNP
	-- SQL
	-- TI1
	-- TO5
	-- TS2
	-- TU2
	-- TU4 - WERK TO PICK LOC
	-- TU5 - WERK TO STOCK LOC
	-- WV1
	-- XC1
	-- XC2
	-- XC4
	-- XC5
	-- XL2
	-- XL4
	-- XL6
	-- XP2
	-- XP3 - WERK TO STOCK LOC
	-- XP4
	-- XP5
	-----------------------
	
	---- WERK ----
	-- AND lgstkproc = 'STOCKCHG'
	-- AND mainprocess = 'ALGEMEEN'
	-- AND handlingtype = 'TU4'
	-- AND restypeexec = 'HAND'
	-- AND oldlocation LIKE 'R%'
	-- AND newlocation LIKE 'X%'
	
	
2025-11-22 00:17:35.146 CET [5540] ERROR:  column "stockevents.userexec" must appear in the GROUP BY clause or be used in an aggregate function at character 1044
2025-11-22 00:17:35.146 CET [5540] STATEMENT:  Select SUM(newqty) -- stockeventid, userexec, olddt, newdt, lgstkproc, mainprocess, restypeexec,
	--handlingtype, oldlocation, newlocation, newartnr, newqty, resourceexec, collobarcode, picklistid, conr, contid
	From ltt.StockEvents 
	WHERE --oldlocation <> newlocation
	newdt > '2025-11-17'::date
	AND newdt < '2025-11-18'::date
	AND userexec = 'ANWARW'
	
	-- Web picking
	AND restypeexec = 'HAND' AND mainprocess = 'ORDPICK' AND  lgstkproc = 'ORDPICK' AND handlingtype = 'OP2' AND oldlocation is null
	-- Rivers pikowanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK'  AND handlingtype = 'TS2' AND  newlocation <> oldlocation --newlocation LIKE 'R%'
	-- Rivers odkładanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TU4' AND newlocation LIKE 'X%' AND newlocation NOT LIKE 'XWE%'
	
	
	--AND mainprocess = 'ALGEMEEN'
	--AND restypeexec = 'HAND'
	--AND oldlocation <> newlocation
	--AND handlingtype = 'TU4'
	--AND oldlocation LIKE 'R%'
	--AND newlocation LIKE 'X%'
	ORDER BY userexec ASC, newdt asc
	--LIMIT 1000 718450732
	
	
	-----   lgstkproc   -----
	-- DESPATCH
	-- INVENT
	-- NAVUL
	-- ONTVANG
	-- ORDPICK
	-- REALLOC
	-- REVPCK
	-- STOCKCHG - WERK
	-------------------------
	
	----   mainprocess  -----
	-- ALGEMEEN - WERK
	-- DESPATCH
	-- INRUIM
	-- INVENT
	-- NAVUL
	-- ORDPICK
	-- REALLOC
	--------------------------
	
	----   handlingtype  -----
	-- DL1
	-- DV1
	-- FPE
	-- LC1
	-- LP1
	-- MS1
	-- MV1
	-- OP1
	-- OP2
	-- OP5
	-- RC0
	-- RC1
	-- RS1
	-- SNP
	-- SQL
	-- TI1
	-- TO5
	-- TS2
	-- TU2
	-- TU4 - WERK TO PICK LOC
	-- TU5 - WERK TO STOCK LOC
	-- WV1
	-- XC1
	-- XC2
	-- XC4
	-- XC5
	-- XL2
	-- XL4
	-- XL6
	-- XP2
	-- XP3 - WERK TO STOCK LOC
	-- XP4
	-- XP5
	-----------------------
	
	---- WERK ----
	-- AND lgstkproc = 'STOCKCHG'
	-- AND mainprocess = 'ALGEMEEN'
	-- AND handlingtype = 'TU4'
	-- AND restypeexec = 'HAND'
	-- AND oldlocation LIKE 'R%'
	-- AND newlocation LIKE 'X%'
	
	
2025-11-22 00:17:42.917 CET [5540] ERROR:  column "stockevents.userexec" must appear in the GROUP BY clause or be used in an aggregate function at character 1044
2025-11-22 00:17:42.917 CET [5540] STATEMENT:  Select SUM(newqty) -- stockeventid, userexec, olddt, newdt, lgstkproc, mainprocess, restypeexec,
	--handlingtype, oldlocation, newlocation, newartnr, newqty, resourceexec, collobarcode, picklistid, conr, contid
	From ltt.StockEvents 
	WHERE --oldlocation <> newlocation
	newdt > '2025-11-17'::date
	AND newdt < '2025-11-18'::date
	AND userexec = 'ANWARW'
	
	-- Web picking
	AND restypeexec = 'HAND' AND mainprocess = 'ORDPICK' AND  lgstkproc = 'ORDPICK' AND handlingtype = 'OP2' AND oldlocation is null
	-- Rivers pikowanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK'  AND handlingtype = 'TS2' AND  newlocation <> oldlocation --newlocation LIKE 'R%'
	-- Rivers odkładanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TU4' AND newlocation LIKE 'X%' AND newlocation NOT LIKE 'XWE%'
	
	
	--AND mainprocess = 'ALGEMEEN'
	--AND restypeexec = 'HAND'
	--AND oldlocation <> newlocation
	--AND handlingtype = 'TU4'
	--AND oldlocation LIKE 'R%'
	--AND newlocation LIKE 'X%'
	ORDER BY userexec ASC, newdt asc
	--LIMIT 1000 718450732
	
	
	-----   lgstkproc   -----
	-- DESPATCH
	-- INVENT
	-- NAVUL
	-- ONTVANG
	-- ORDPICK
	-- REALLOC
	-- REVPCK
	-- STOCKCHG - WERK
	-------------------------
	
	----   mainprocess  -----
	-- ALGEMEEN - WERK
	-- DESPATCH
	-- INRUIM
	-- INVENT
	-- NAVUL
	-- ORDPICK
	-- REALLOC
	--------------------------
	
	----   handlingtype  -----
	-- DL1
	-- DV1
	-- FPE
	-- LC1
	-- LP1
	-- MS1
	-- MV1
	-- OP1
	-- OP2
	-- OP5
	-- RC0
	-- RC1
	-- RS1
	-- SNP
	-- SQL
	-- TI1
	-- TO5
	-- TS2
	-- TU2
	-- TU4 - WERK TO PICK LOC
	-- TU5 - WERK TO STOCK LOC
	-- WV1
	-- XC1
	-- XC2
	-- XC4
	-- XC5
	-- XL2
	-- XL4
	-- XL6
	-- XP2
	-- XP3 - WERK TO STOCK LOC
	-- XP4
	-- XP5
	-----------------------
	
	---- WERK ----
	-- AND lgstkproc = 'STOCKCHG'
	-- AND mainprocess = 'ALGEMEEN'
	-- AND handlingtype = 'TU4'
	-- AND restypeexec = 'HAND'
	-- AND oldlocation LIKE 'R%'
	-- AND newlocation LIKE 'X%'
	
	
2025-11-22 00:24:19.215 CET [5540] ERROR:  syntax error at or near "From" at character 196
2025-11-22 00:24:19.215 CET [5540] STATEMENT:  Select stockeventid, userexec, olddt, newdt, lgstkproc, mainprocess, restypeexec,
	--handlingtype, oldlocation, newlocation, newartnr, newqty, resourceexec, collobarcode, picklistid, conr, contid
	From ltt.StockEvents 
	WHERE --oldlocation <> newlocation
	newdt > '2025-11-17'::date
	AND newdt < '2025-11-18'::date
	--AND userexec = 'SINGHJ'
	
	-- Web picking
	-- AND restypeexec = 'HAND' AND mainprocess = 'ORDPICK' AND  lgstkproc = 'ORDPICK' AND handlingtype = 'OP2' AND oldlocation is null
	-- Rivers pikowanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK'  AND handlingtype = 'TS2' AND  newlocation <> oldlocation --newlocation LIKE 'R%'
	-- Rivers odkładanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TU4' AND newlocation LIKE 'X%' AND newlocation NOT LIKE 'XWE%'
	
	
	--AND mainprocess = 'ALGEMEEN'
	--AND restypeexec = 'HAND'
	--AND oldlocation <> newlocation
	--AND handlingtype = 'TU4'
	--AND oldlocation LIKE 'R%'
	--AND newlocation LIKE 'X%'
	--ORDER BY userexec ASC, newdt asc
	--LIMIT 1000 718450732
	
	
	-----   lgstkproc   -----
	-- DESPATCH
	-- INVENT
	-- NAVUL
	-- ONTVANG
	-- ORDPICK
	-- REALLOC
	-- REVPCK
	-- STOCKCHG - WERK
	-------------------------
	
	----   mainprocess  -----
	-- ALGEMEEN - WERK
	-- DESPATCH
	-- INRUIM
	-- INVENT
	-- NAVUL
	-- ORDPICK
	-- REALLOC
	--------------------------
	
	----   handlingtype  -----
	-- DL1
	-- DV1
	-- FPE
	-- LC1
	-- LP1
	-- MS1
	-- MV1
	-- OP1
	-- OP2
	-- OP5
	-- RC0
	-- RC1
	-- RS1
	-- SNP
	-- SQL
	-- TI1
	-- TO5
	-- TS2
	-- TU2
	-- TU4 - WERK TO PICK LOC
	-- TU5 - WERK TO STOCK LOC
	-- WV1
	-- XC1
	-- XC2
	-- XC4
	-- XC5
	-- XL2
	-- XL4
	-- XL6
	-- XP2
	-- XP3 - WERK TO STOCK LOC
	-- XP4
	-- XP5
	-----------------------
	
	---- WERK ----
	-- AND lgstkproc = 'STOCKCHG'
	-- AND mainprocess = 'ALGEMEEN'
	-- AND handlingtype = 'TU4'
	-- AND restypeexec = 'HAND'
	-- AND oldlocation LIKE 'R%'
	-- AND newlocation LIKE 'X%'
	
	
2025-11-22 00:28:01.747 CET [5540] ERROR:  canceling statement due to user request
2025-11-22 00:28:01.747 CET [5540] STATEMENT:  Select stockeventid, userexec, olddt, newdt, lgstkproc, mainprocess, restypeexec,
	handlingtype, oldlocation, newlocation, newartnr, newqty, resourceexec, collobarcode, picklistid, conr, contid
	From ltt.StockEvents 
	WHERE --oldlocation <> newlocation
	newdt >= '2025-11-17 09:00:00'
	AND newdt < '2025-11-17 10:00:00'
	--AND userexec = 'SINGHJ'
	
	-- Web picking
	-- AND restypeexec = 'HAND' AND mainprocess = 'ORDPICK' AND  lgstkproc = 'ORDPICK' AND handlingtype = 'OP2' AND oldlocation is null
	-- Rivers pikowanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK'  AND handlingtype = 'TS2' AND  newlocation <> oldlocation --newlocation LIKE 'R%'
	-- Rivers odkładanie
	-- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TU4' AND newlocation LIKE 'X%' AND newlocation NOT LIKE 'XWE%'
	
	
	--AND mainprocess = 'ALGEMEEN'
	--AND restypeexec = 'HAND'
	--AND oldlocation <> newlocation
	--AND handlingtype = 'TU4'
	--AND oldlocation LIKE 'R%'
	--AND newlocation LIKE 'X%'
	--ORDER BY userexec ASC, newdt asc
	--LIMIT 1000 718450732
	
	
	-----   lgstkproc   -----
	-- DESPATCH
	-- INVENT
	-- NAVUL
	-- ONTVANG
	-- ORDPICK
	-- REALLOC
	-- REVPCK
	-- STOCKCHG - WERK
	-------------------------
	
	----   mainprocess  -----
	-- ALGEMEEN - WERK
	-- DESPATCH
	-- INRUIM
	-- INVENT
	-- NAVUL
	-- ORDPICK
	-- REALLOC
	--------------------------
	
	----   handlingtype  -----
	-- DL1
	-- DV1
	-- FPE
	-- LC1
	-- LP1
	-- MS1
	-- MV1
	-- OP1
	-- OP2
	-- OP5
	-- RC0
	-- RC1
	-- RS1
	-- SNP
	-- SQL
	-- TI1
	-- TO5
	-- TS2
	-- TU2
	-- TU4 - WERK TO PICK LOC
	-- TU5 - WERK TO STOCK LOC
	-- WV1
	-- XC1
	-- XC2
	-- XC4
	-- XC5
	-- XL2
	-- XL4
	-- XL6
	-- XP2
	-- XP3 - WERK TO STOCK LOC
	-- XP4
	-- XP5
	-----------------------
	
	---- WERK ----
	-- AND lgstkproc = 'STOCKCHG'
	-- AND mainprocess = 'ALGEMEEN'
	-- AND handlingtype = 'TU4'
	-- AND restypeexec = 'HAND'
	-- AND oldlocation LIKE 'R%'
	-- AND newlocation LIKE 'X%'
	
	
2025-11-22 00:30:44.322 CET [6452] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 00:30:44.791 CET [2232] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 00:31:49.305 CET [4836] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-22 00:31:49.305 CET [4836] 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-22 00:32:11.494 CET [2752] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-22 00:32:11.494 CET [2752] 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-22 00:49:04.619 CET [6912] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-22 00:49:04.619 CET [6912] 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-22 00:58:41.669 CET [5800] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-22 00:58:41.669 CET [5800] 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-22 01:04:02.934 CET [4732] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 02:31:08.417 CET [3428] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 02:49:14.300 CET [4836] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

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

	
2025-11-22 02:54:11.020 CET [6912] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 03:00:31.553 CET [5800] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 11:10:27.104 CET [7120] LOG:  checkpoint starting: time
2025-11-22 11:10:27.283 CET [7120] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.105 s, sync=0.024 s, total=0.179 s; sync files=2, longest=0.016 s, average=0.012 s; distance=5 kB, estimate=169 kB; lsn=7/AA2B1F40, redo lsn=7/AA2B1EE8
2025-11-22 11:17:25.783 CET [3584] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-22 11:17:25.783 CET [3584] 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-22 11:17:27.193 CET [5764] WARNING:  PID 2752 is not a PostgreSQL backend process
2025-11-22 11:17:27.540 CET [2964] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-22 11:17:27.540 CET [2964] 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-22 11:18:21.422 CET [6612] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-22 11:18:21.422 CET [6612] 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-22 12:21:18.367 CET [6904] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-22 12:21:18.367 CET [6904] 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-22 12:21:18.851 CET [2792] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-22 12:21:18.851 CET [2792] 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-22 12:21:18.977 CET [2792] ERROR:  relation "locusltt.stockevents" does not exist at character 215
2025-11-22 12:21:18.977 CET [2792] STATEMENT:  SELECT stockeventid, userexec, olddt, newdt, lgstkproc, mainprocess, restypeexec,
	       handlingtype, oldlocation, newlocation, newartnr, newqty,
	       resourceexec, collobarcode, picklistid, conr, contid
	FROM   locusltt.stockevents
	WHERE  handlingtype = 'OP2'
	  AND  newdaydt     = DATE '2025-11-18'   -- parametr dnia
	  AND  restypeexec  = 'HAND'
	  AND  mainprocess  = 'ORDPICK'
	  AND  lgstkproc    = 'ORDPICK'
	  AND  oldlocation IS NULL;
2025-11-22 13:17:35.933 CET [3584] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

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

	
2025-11-22 14:21:28.520 CET [6904] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 15:02:39.781 CET [2792] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

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

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

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

	
2025-11-22 17:10:58.864 CET [6536] ERROR:  function nvl(smallint, integer) does not exist at character 315
2025-11-22 17:10:58.864 CET [6536] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2025-11-22 17:10:58.864 CET [6536] 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 NVL(ROA.wavestatus, 0) < 5
	  AND (ROA.dspwaveid IS NOT NULL )

	GROUP BY ROA.artnr

	ORDER BY ROA.artnr DESC
2025-11-22 17:12:22.621 CET [6536] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 17:12:22.621 CET [6216] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 17:21:01.430 CET [3852] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 17:23:12.552 CET [4844] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 17:23:12.553 CET [332] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 17:27:27.726 CET [7020] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 17:27:27.727 CET [7056] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 17:31:07.659 CET [2788] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-22 17:31:07.659 CET [2788] 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-22 17:31:34.651 CET [2788] ERROR:  column "stockregulardvw.palid" must appear in the GROUP BY clause or be used in an aggregate function at character 8
2025-11-22 17:31:34.651 CET [2788] STATEMENT:  SELECT * --artnr as ArticleId, SUM(quantity) as Quantity
	                    FROM wms.StockRegularDVW  
	                    WHERE  pickzone = 'XWEBPICK'
	                    --AND usage = 'PCK'
	                    AND locname LIKE 'XW%'
	                    AND blocked = 'N'
	                    AND blockedout = 'N'
	                    GROUP BY artnr;
2025-11-22 17:32:03.904 CET [2788] ERROR:  syntax error at or near "AND" at character 267
2025-11-22 17:32:03.904 CET [2788] STATEMENT:  SELECT * --artnr as ArticleId, SUM(quantity) as Quantity
	                    FROM wms.StockRegularDVW  
	                    WHERE  
						--pickzone = 'XWEBPICK'
	                    --AND usage = 'PCK'
	                    --AND locname LIKE 'XW%'
	                    AND blocked = 'N'
	                    AND blockedout = 'N'
	                    --GROUP BY artnr;
2025-11-22 17:32:48.626 CET [2788] ERROR:  syntax error at or near "AND" at character 222
2025-11-22 17:32:48.626 CET [2788] STATEMENT:  SELECT * --artnr as ArticleId, SUM(quantity) as Quantity
	                    FROM wms.StockRegularDVW  
	                    WHERE  
						--pickzone = 'XWEBPICK'
	                    --AND usage = 'PCK'
	                    AND locname LIKE 'HL%'
	                    blocked = 'N'
	                    AND blockedout = 'N'
	                    --GROUP BY artnr;
2025-11-22 17:32:56.097 CET [2788] ERROR:  syntax error at or near "blocked" at character 262
2025-11-22 17:32:56.097 CET [2788] STATEMENT:  SELECT * --artnr as ArticleId, SUM(quantity) as Quantity
	                    FROM wms.StockRegularDVW  
	                    WHERE  
						--pickzone = 'XWEBPICK'
	                    --AND usage = 'PCK'
	                     locname LIKE 'HL%'
	                    blocked = 'N'
	                    AND blockedout = 'N'
	                    --GROUP BY artnr;
2025-11-22 17:42:29.743 CET [5464] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 17:42:29.744 CET [3056] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 17:45:27.620 CET [7120] LOG:  checkpoint starting: time
2025-11-22 17:45:28.145 CET [7120] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.438 s, sync=0.033 s, total=0.526 s; sync files=5, longest=0.011 s, average=0.007 s; distance=20 kB, estimate=154 kB; lsn=7/AA2B6F90, redo lsn=7/AA2B6F00
2025-11-22 17:51:35.539 CET [1564] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-22 18:10:27.146 CET [7120] LOG:  checkpoint starting: time
2025-11-22 18:10:27.314 CET [7120] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.107 s, sync=0.015 s, total=0.169 s; sync files=2, longest=0.008 s, average=0.008 s; distance=7 kB, estimate=139 kB; lsn=7/AA2B8C58, redo lsn=7/AA2B8C00
2025-11-22 19:48:10.062 CET [2788] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.