2025-11-14 19:40:39.497 CET [5156] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:39.497 CET [5156] 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-14 19:40:39.583 CET [6124] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:39.583 CET [6124] 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-14 19:40:39.654 CET [2800] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:39.654 CET [2800] 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-14 19:40:39.800 CET [6888] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:39.800 CET [6888] 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-14 19:40:39.902 CET [3856] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:39.902 CET [3856] 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-14 19:40:39.968 CET [6460] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:39.968 CET [6460] 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-14 19:40:39.990 CET [1620] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:39.990 CET [1620] 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-14 19:40:40.016 CET [6440] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:40.016 CET [6440] 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-14 19:40:40.028 CET [6044] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:40.028 CET [6044] 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-14 19:40:40.165 CET [1360] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:40.165 CET [1360] 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-14 19:40:52.540 CET [216] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:52.540 CET [216] 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-14 19:40:53.260 CET [6292] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:53.260 CET [6292] 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-14 19:40:53.285 CET [3956] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:40:53.285 CET [3956] 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-14 19:41:12.582 CET [2068] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 19:41:12.582 CET [2068] 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-14 19:41:58.569 CET [5716] LOG: checkpoint starting: time 2025-11-14 19:42:01.413 CET [5716] LOG: checkpoint complete: wrote 26 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.722 s, sync=0.070 s, total=2.844 s; sync files=12, longest=0.012 s, average=0.006 s; distance=109 kB, estimate=390 kB; lsn=7/A9152150, redo lsn=7/A91520F8 2025-11-14 19:46:58.412 CET [5716] LOG: checkpoint starting: time 2025-11-14 19:47:01.706 CET [5716] LOG: checkpoint complete: wrote 30 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.161 s, sync=0.084 s, total=3.294 s; sync files=10, longest=0.021 s, average=0.009 s; distance=191 kB, estimate=370 kB; lsn=7/A9181E28, redo lsn=7/A9181DD0 2025-11-14 20:07:14.571 CET [5772] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 20:07:14.571 CET [5772] 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-14 20:08:51.727 CET [6708] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 20:08:51.727 CET [6708] 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-14 20:11:58.710 CET [5716] LOG: checkpoint starting: time 2025-11-14 20:11:59.331 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.547 s, sync=0.015 s, total=0.622 s; sync files=2, longest=0.010 s, average=0.008 s; distance=35 kB, estimate=336 kB; lsn=7/A918AAE8, redo lsn=7/A918AA90 2025-11-14 21:40:20.713 CET [3544] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 21:40:21.338 CET [1316] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 21:40:25.996 CET [7140] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 21:40:26.105 CET [404] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 21:40:26.480 CET [2920] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 21:42:07.417 CET [4668] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 21:42:11.251 CET [5264] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 21:42:22.879 CET [5248] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 21:42:32.369 CET [2412] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 22:00:38.192 CET [4476] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 22:00:38.192 CET [4476] 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-14 22:00:44.568 CET [4476] ERROR: syntax error at or near ":" at character 1284 2025-11-14 22:00:44.568 CET [4476] STATEMENT: SELECT SUBSTR(A1,1,1) COLLOOUTPUT, SUBSTR(A2,1,9) COLLOID, N1 ROWNR, SUBSTR(A3,1,40) PAYMENTTERMREADABLECODE, SUBSTR(A4,1,60) STOCKOWNNAME, SUBSTR(A5,1,4000) STOCKOWNSTREET, SUBSTR(A6,1,4000) STOCKOWNHOUSENR, SUBSTR(A7,1,9) STOCKOWNCOUNTRY, SUBSTR(A8,1,60) STOCKOWNZIPCODE, SUBSTR(A9,1,60) STOCKOWNTOWN, SUBSTR(A10,1,10) STOCKOWNDPDDEPOT, SUBSTR(A11,1,60) RECIPNAME, SUBSTR(A12,1,4000) RECIPSTREET, SUBSTR(A13,1,4000) RECIPHOUSENR, SUBSTR(A14,1,9) RECIPCOUNTRY, SUBSTR(A15,1,60) RECIPZIPCODE, SUBSTR(A16,1,60) RECIPTOWN, SUBSTR(A17,1,60) RECIPATT, SUBSTR(A18,1,30) RECIPTELNR, SUBSTR(A19,1,100) RECIPEMAIL, SUBSTR(A20,1,60) INVOICENAME, SUBSTR(A21,1,4000) INVOICESTREET, SUBSTR(A22,1,4000) INVOICEHOUSENR, SUBSTR(A23,1,9) INVOICECOUNTRY, SUBSTR(A24,1,60) INVOICEZIPCODE, SUBSTR(A25,1,60) INVOICETOWN, SUBSTR(A26,1,60) INVOICEATT, SUBSTR(A27,1,18) CONUMBER, SUBSTR(A28,1,18) PALNUMBER, SUBSTR(A29,1,20) BKPALNUMBER, SUBSTR(A30,1,4000) EXPDAYDOCK, SUBSTR(A31,1,20) SHIPMENT, SUBSTR(A32,1,9) PALID, SUBSTR(A33,1,20) GTCODE, N2 WEIGHT, SUBSTR(A34,1,40) ORDERDESCR, SUBSTR(A35,1,86) CONTENTDESCR, SUBSTR(A36,1,9) ROACLASSIFICATION, SUBSTR(A37,1,3) PRINTERTYPE, SUBSTR(A38,1,6) REPORTNAME, N3 SEQ, SUBSTR(A39,1,20) COLLOBARCODE, SUBSTR(A40,1,20) PAGEBREAK FROM PQueueSQLData WHERE JobId = :JobId ORDER BY JobId, Line 2025-11-14 22:03:48.015 CET [4476] ERROR: relation "pqueuesqldata" does not exist at character 1219 2025-11-14 22:03:48.015 CET [4476] STATEMENT: SELECT A1 COLLOOUTPUT, A2 COLLOID, N1 ROWNR, A3 PAYMENTTERMREADABLECODE, SUBSTR(A4,1,60) STOCKOWNNAME, SUBSTR(A5,1,4000) STOCKOWNSTREET, SUBSTR(A6,1,4000) STOCKOWNHOUSENR, SUBSTR(A7,1,9) STOCKOWNCOUNTRY, SUBSTR(A8,1,60) STOCKOWNZIPCODE, SUBSTR(A9,1,60) STOCKOWNTOWN, SUBSTR(A10,1,10) STOCKOWNDPDDEPOT, SUBSTR(A11,1,60) RECIPNAME, SUBSTR(A12,1,4000) RECIPSTREET, SUBSTR(A13,1,4000) RECIPHOUSENR, SUBSTR(A14,1,9) RECIPCOUNTRY, SUBSTR(A15,1,60) RECIPZIPCODE, SUBSTR(A16,1,60) RECIPTOWN, SUBSTR(A17,1,60) RECIPATT, SUBSTR(A18,1,30) RECIPTELNR, SUBSTR(A19,1,100) RECIPEMAIL, SUBSTR(A20,1,60) INVOICENAME, SUBSTR(A21,1,4000) INVOICESTREET, SUBSTR(A22,1,4000) INVOICEHOUSENR, SUBSTR(A23,1,9) INVOICECOUNTRY, SUBSTR(A24,1,60) INVOICEZIPCODE, SUBSTR(A25,1,60) INVOICETOWN, SUBSTR(A26,1,60) INVOICEATT, SUBSTR(A27,1,18) CONUMBER, SUBSTR(A28,1,18) PALNUMBER, SUBSTR(A29,1,20) BKPALNUMBER, SUBSTR(A30,1,4000) EXPDAYDOCK, SUBSTR(A31,1,20) SHIPMENT, SUBSTR(A32,1,9) PALID, SUBSTR(A33,1,20) GTCODE, N2 WEIGHT, SUBSTR(A34,1,40) ORDERDESCR, SUBSTR(A35,1,86) CONTENTDESCR, SUBSTR(A36,1,9) ROACLASSIFICATION, SUBSTR(A37,1,3) PRINTERTYPE, SUBSTR(A38,1,6) REPORTNAME, N3 SEQ, SUBSTR(A39,1,20) COLLOBARCODE, SUBSTR(A40,1,20) PAGEBREAK FROM PQueueSQLData WHERE 1 = 1 LIMIT 5 2025-11-14 22:07:25.189 CET [5772] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 22:08:03.691 CET [216] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 22:09:01.881 CET [3956] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 22:21:28.654 CET [6708] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-14 22:30:33.463 CET [4476] ERROR: syntax error at or near "FROM" at character 1048 2025-11-14 22:30:33.463 CET [4476] STATEMENT: SELECT jobid, A1 AS COLLOOUTPUT, A2 AS COLLOID, N1 AS ROWNR, -- A3 AS PAYMENTTERMREADABLECODE, A4 AS STOCKOWNNAME, A5 AS STOCKOWNSTREET, A6 AS STOCKOWNHOUSENR, A7 AS STOCKOWNCOUNTRY, A8 AS STOCKOWNZIPCODE, A9 AS STOCKOWNTOWN, A10 AS STOCKOWNDPDDEPOT, A11 AS RECIPNAME, A12 AS RECIPSTREET, A13 AS RECIPHOUSENR, A14 AS RECIPCOUNTRY, A15 AS RECIPZIPCODE, A16 AS RECIPTOWN, A17 AS RECIPATT, A18 AS RECIPTELNR, A19 AS RECIPEMAIL, A20 AS INVOICENAME, A21 AS INVOICESTREET, A22 AS INVOICEHOUSENR, A23 AS INVOICECOUNTRY, A24 AS INVOICEZIPCODE, A25 AS INVOICETOWN, A26 AS INVOICEATT, A27 AS CONUMBER, A28 AS PALNUMBER, A29 AS BKPALNUMBER, A30 AS EXPDAYDOCK, -- A31 AS SHIPMENT, A32 AS PALID, A33 AS GTCODE, -- N2 AS WEIGHT, A34 AS ORDERDESCR, -- A35 AS CONTENTDESCR, A36 AS ROACLASSIFICATION, -- A37 AS PRINTERTYPE, -- A38 AS REPORTNAME, N3 AS SEQ, A39 AS COLLOBARCODE, -- A40 AS PAGEBREAK FROM wms.PQueueSQLData --WHERE jobid='88449602' LIMIT 1000; 2025-11-14 22:35:44.010 CET [4476] ERROR: syntax error at or near "A30" at character 841 2025-11-14 22:35:44.010 CET [4476] STATEMENT: SELECT jobid, -- A1 AS COLLOOUTPUT, -- A2 AS COLLOID, N1 AS ROWNR, N3 AS SEQ, -- A3 AS PAYMENTTERMREADABLECODE, -- A4 AS STOCKOWNNAME, -- A5 AS STOCKOWNSTREET, -- A6 AS STOCKOWNHOUSENR, -- A7 AS STOCKOWNCOUNTRY, -- A8 AS STOCKOWNZIPCODE, -- A9 AS STOCKOWNTOWN, -- A10 AS STOCKOWNDPDDEPOT, A11 AS RECIPNAME, A12 AS RECIPSTREET, A13 AS RECIPHOUSENR, A14 AS RECIPCOUNTRY, A15 AS RECIPZIPCODE, A16 AS RECIPTOWN, A17 AS RECIPATT, A18 AS RECIPTELNR, A19 AS RECIPEMAIL, A20 AS INVOICENAME, A21 AS INVOICESTREET, A22 AS INVOICEHOUSENR, A23 AS INVOICECOUNTRY, A24 AS INVOICEZIPCODE, A25 AS INVOICETOWN, A26 AS INVOICEATT, A27 AS CONUMBER, A34 AS ORDERDESCR, A28 AS PALNUMBER, A32 AS PALID, A29 AS BKPALNUMBER, A39 AS COLLOBARCODE A30 AS EXPDAYDOCK, -- A31 AS SHIPMENT, A33 AS GTCODE, -- N2 AS WEIGHT, -- A35 AS CONTENTDESCR, A36 AS ROACLASSIFICATION, -- A37 AS PRINTERTYPE, -- A38 AS REPORTNAME, -- A40 AS PAGEBREAK FROM wms.PQueueSQLData WHERE jobid='88449602' LIMIT 1000; 2025-11-14 22:37:50.689 CET [4476] ERROR: syntax error at or near "A38" at character 1010 2025-11-14 22:37:50.689 CET [4476] STATEMENT: SELECT jobid, -- A1 AS COLLOOUTPUT, -- A2 AS COLLOID, N1 AS ROWNR, N3 AS SEQ, -- A3 AS PAYMENTTERMREADABLECODE, -- A4 AS STOCKOWNNAME, -- A5 AS STOCKOWNSTREET, -- A6 AS STOCKOWNHOUSENR, -- A7 AS STOCKOWNCOUNTRY, -- A8 AS STOCKOWNZIPCODE, -- A9 AS STOCKOWNTOWN, -- A10 AS STOCKOWNDPDDEPOT, A11 AS RECIPNAME, A12 AS RECIPSTREET, A13 AS RECIPHOUSENR, A14 AS RECIPCOUNTRY, A15 AS RECIPZIPCODE, A16 AS RECIPTOWN, A17 AS RECIPATT, A18 AS RECIPTELNR, A19 AS RECIPEMAIL, A20 AS INVOICENAME, A21 AS INVOICESTREET, A22 AS INVOICEHOUSENR, A23 AS INVOICECOUNTRY, A24 AS INVOICEZIPCODE, A25 AS INVOICETOWN, A26 AS INVOICEATT, A27 AS CONUMBER, A34 AS ORDERDESCR, A28 AS PALNUMBER, A32 AS PALID, A29 AS BKPALNUMBER, A39 AS COLLOBARCODE, A30 AS EXPDAYDOCK, -- A31 AS SHIPMENT, A33 AS GTCODE, -- N2 AS WEIGHT, -- A35 AS CONTENTDESCR, A36 AS ROACLASSIFICATION -- A37 AS PRINTERTYPE, A38 AS REPORTNAME, -- A40 AS PAGEBREAK FROM wms.PQueueSQLData WHERE jobid='88449602' LIMIT 1000; 2025-11-14 22:37:58.502 CET [4476] ERROR: syntax error at or near "A38" at character 1010 2025-11-14 22:37:58.502 CET [4476] STATEMENT: SELECT jobid, -- A1 AS COLLOOUTPUT, -- A2 AS COLLOID, N1 AS ROWNR, N3 AS SEQ, -- A3 AS PAYMENTTERMREADABLECODE, -- A4 AS STOCKOWNNAME, -- A5 AS STOCKOWNSTREET, -- A6 AS STOCKOWNHOUSENR, -- A7 AS STOCKOWNCOUNTRY, -- A8 AS STOCKOWNZIPCODE, -- A9 AS STOCKOWNTOWN, -- A10 AS STOCKOWNDPDDEPOT, A11 AS RECIPNAME, A12 AS RECIPSTREET, A13 AS RECIPHOUSENR, A14 AS RECIPCOUNTRY, A15 AS RECIPZIPCODE, A16 AS RECIPTOWN, A17 AS RECIPATT, A18 AS RECIPTELNR, A19 AS RECIPEMAIL, A20 AS INVOICENAME, A21 AS INVOICESTREET, A22 AS INVOICEHOUSENR, A23 AS INVOICECOUNTRY, A24 AS INVOICEZIPCODE, A25 AS INVOICETOWN, A26 AS INVOICEATT, A27 AS CONUMBER, A34 AS ORDERDESCR, A28 AS PALNUMBER, A32 AS PALID, A29 AS BKPALNUMBER, A39 AS COLLOBARCODE, A30 AS EXPDAYDOCK, -- A31 AS SHIPMENT, A33 AS GTCODE, -- N2 AS WEIGHT, -- A35 AS CONTENTDESCR, A36 AS ROACLASSIFICATION -- A37 AS PRINTERTYPE, A38 AS REPORTNAME -- A40 AS PAGEBREAK FROM wms.PQueueSQLData WHERE jobid='88449602' LIMIT 1000; 2025-11-14 22:38:30.868 CET [4476] ERROR: column "reportname" does not exist at character 1083 2025-11-14 22:38:30.868 CET [4476] STATEMENT: SELECT jobid, -- A1 AS COLLOOUTPUT, -- A2 AS COLLOID, N1 AS ROWNR, N3 AS SEQ, -- A3 AS PAYMENTTERMREADABLECODE, -- A4 AS STOCKOWNNAME, -- A5 AS STOCKOWNSTREET, -- A6 AS STOCKOWNHOUSENR, -- A7 AS STOCKOWNCOUNTRY, -- A8 AS STOCKOWNZIPCODE, -- A9 AS STOCKOWNTOWN, -- A10 AS STOCKOWNDPDDEPOT, A11 AS RECIPNAME, A12 AS RECIPSTREET, A13 AS RECIPHOUSENR, A14 AS RECIPCOUNTRY, A15 AS RECIPZIPCODE, A16 AS RECIPTOWN, A17 AS RECIPATT, A18 AS RECIPTELNR, A19 AS RECIPEMAIL, A20 AS INVOICENAME, A21 AS INVOICESTREET, A22 AS INVOICEHOUSENR, A23 AS INVOICECOUNTRY, A24 AS INVOICEZIPCODE, A25 AS INVOICETOWN, A26 AS INVOICEATT, A27 AS CONUMBER, A34 AS ORDERDESCR, A28 AS PALNUMBER, A32 AS PALID, A29 AS BKPALNUMBER, A39 AS COLLOBARCODE, A30 AS EXPDAYDOCK, -- A31 AS SHIPMENT, A33 AS GTCODE, -- N2 AS WEIGHT, -- A35 AS CONTENTDESCR, A36 AS ROACLASSIFICATION, -- A37 AS PRINTERTYPE, A38 AS REPORTNAME -- A40 AS PAGEBREAK FROM wms.PQueueSQLData WHERE REPORTNAME='SHIPBK' LIMIT 1000; 2025-11-14 22:45:21.994 CET [4476] ERROR: syntax error at or near "EXPDAYDOCK" at character 1 2025-11-14 22:45:21.994 CET [4476] STATEMENT: EXPDAYDOCK 2025-11-14 23:04:20.987 CET [4476] ERROR: column "88447100" does not exist at character 965 2025-11-14 23:04:20.987 CET [4476] STATEMENT: SELECT jobid, N1 AS ROWNR, N3 AS SEQ, A27 AS CONUMBER, -- "BK817520673R1" A28 AS PALNUMBER, -- "0071493614" A32 AS PALID, -- "71572495" A29 AS BKPALNUMBER, -- "XE0071493614" / "XE0071493614_2" / "XE0071493614_3" A39 AS COLLOBARCODE,-- "XE0071493614" A30 AS EXPDAYDOCK, -- "MA" / "DI" / "WO" / "DO" / "VR" / "ZA" / "ZO" A36 AS ROACLASSIFICATION, -- "SHIP_UNIT" / "NO_SHIP_U" A20 AS RECIPIENTNAME, -- "Ton Schmitz" A21 AS RECIPIENTSTREET, -- "Helvoirtsestraat" A22 AS RECIPIENTHOUSENR, -- "29" A26 AS RECIPIENTATT, -- "1a" ?????? A25 AS RECIPIENTTOWN, -- "Helvoirt" A24 AS RECIPIENTZIPCODE, -- "5268BA" A23 AS RECIPIENTCOUNTRY, -- "NL" A11 AS SENDERNAME, -- "Webshop Xenos NL" A12 AS SENDERSTREET, -- "Schutweg" A13 AS SENDERHOUSENR, --"8" A16 AS SENDEROWN, -- "Waalwijk" A15 AS SENDERZIPCODE, --"5145 NP" A14 AS SENDERCOUNTRY -- "NL" FROM wms.PQueueSQLData WHERE A38 = 'SHIPBK' AND jobid > "88447100" LIMIT 1000; 2025-11-14 23:04:50.980 CET [4476] ERROR: syntax error at or near "88447100" at character 1 2025-11-14 23:04:50.980 CET [4476] STATEMENT: 88447100 2025-11-14 23:44:17.937 CET [5128] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 23:44:17.937 CET [5128] 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-14 23:48:23.707 CET [404] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-14 23:48:23.707 CET [404] 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-14 23:48:25.147 CET [5128] ERROR: syntax error at or near "sonex" at character 1 2025-11-14 23:48:25.147 CET [5128] STATEMENT: sonex 2025-11-14 23:48:32.936 CET [5128] ERROR: relation "pk_shipbk_import" already exists 2025-11-14 23:48:32.936 CET [5128] STATEMENT: CREATE TABLE sonex.shipbk_print_jobs ( job_id INTEGER NOT NULL, row_nr INTEGER NOT NULL, seq INTEGER NOT NULL, co_number VARCHAR(4000), pal_number VARCHAR(4000), pal_id VARCHAR(4000), bk_pal_number VARCHAR(4000), collo_barcode VARCHAR(4000), exp_day_dock VARCHAR(4000), roa_classification VARCHAR(4000), recipient_name VARCHAR(4000), recipient_street VARCHAR(4000), recipient_house_nr VARCHAR(4000), recipient_att VARCHAR(4000), recipient_town VARCHAR(4000), recipient_zip_code VARCHAR(4000), recipient_country VARCHAR(4000), sender_name VARCHAR(4000), sender_street VARCHAR(4000), sender_house_nr VARCHAR(4000), sender_own VARCHAR(4000), sender_zip_code VARCHAR(4000), sender_country VARCHAR(4000), status TEXT, errors TEXT[], width NUMERIC(18,3), height NUMERIC(18,3), length NUMERIC(18,3), volume NUMERIC(18,3), weight NUMERIC(18,3), bk_order_id VARCHAR(100), description TEXT, created_at TIMESTAMPTZ, imported_at TIMESTAMPTZ, updated_at TIMESTAMPTZ, CONSTRAINT pk_shipbk_import PRIMARY KEY (job_id, row_nr, seq) ); 2025-11-14 23:50:47.484 CET [5128] ERROR: syntax error at or near "pk_shipbk_import" at character 1 2025-11-14 23:50:47.484 CET [5128] STATEMENT: pk_shipbk_import 2025-11-14 23:51:58.526 CET [5716] LOG: checkpoint starting: time 2025-11-14 23:52:16.995 CET [5716] LOG: checkpoint complete: wrote 168 buffers (1.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=18.213 s, sync=0.203 s, total=18.470 s; sync files=44, longest=0.011 s, average=0.005 s; distance=1217 kB, estimate=1217 kB; lsn=7/A92BB200, redo lsn=7/A92BB170