
* paths:
 - main: '/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/Resources/Lua/'
 - bin : '/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/Resources/bin/bin_osx_x86/'
 - pref: '/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/Resources/Lua/preference/'
 - git : '/Users/pasi/ma-git/'
 - 4D  : '/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/'
	18/06/2020	18:41:58	lx	(1. Application process)


sqlQueryExecute '', sql: SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'system/ma_server_start.json' AND prf.organization_id = 0.	18/06/2020	18:41:58	lx	(1. Application process)

sqlQueryExecute time: 0 ms, delay from previous: 0 ms, 2020-06-18 18:41:58.154.	18/06/2020	18:41:58	lx	(1. Application process)

query 'SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'system/ma_server_start.json' AND prf.organization_id = 0', postgre result load time: 0.002683 seconds, rows: 1
	18/06/2020	18:41:58	lx	(1. Application process)

nc_server_4d.runServerOnStart run time: 0.0036 s	{"application_type":0, "user":"MG_Admin"}	/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/Resources/Lua/manager/4d/.	18/06/2020	18:41:58	lx	(1. Application process)

Käynnisteään Tcp palvelin 2.	18/06/2020	18:41:58	_lx_SERVER	(4. palvelin)


* paths:
 - main: '/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/Resources/Lua/'
 - bin : '/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/Resources/bin/bin_osx_x86/'
 - pref: '/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/Resources/Lua/preference/'
 - git : '/Users/pasi/ma-git/'
 - 4D  : '/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/'
	18/06/2020	18:42:00	lx	(4. palvelin)

poll.expand_fds: 10, old fds: nil, new fds: cdata<struct pollfd *>: 0x4bf215a0, size: 80.	18/06/2020	18:42:00	lx	(4. palvelin)

********************* /4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/Resources/Lua/ *********************.	18/06/2020	18:42:00	lx	(4. palvelin)

cpu performance: 16 000 000, os: OSX x86, using: rapidjson_sse4.2.	18/06/2020	18:42:00	lx	(4. palvelin)

CPU features: vender:GenuineIntel idmax:13 step:9 model:58 family:6 type:0 fpu:1 mmx:1 sse:1 sse2:1 htt:1 ia64:0 sse3:1 vmx:1 ssse3:1 fma:0 sse4.1:1 sse4.2:1 popcnt:1 aes:1 avx:1 hypervisor:0 bmi1:0 avx2:0 bmi2:0 avx512f:0 avx512dq:0 avx512ifma:0 avx512pf:0 avx512er:0 avx512cd:0 sha:0 avx512bw:0 avx512vl:0 avx512vbmi:0 .	18/06/2020	18:42:00	lx	(4. palvelin)

arguments: '[
	5949
]'.	18/06/2020	18:42:00	lx	(4. palvelin)

ma_server: debugLevel(0):0  port(5958):5949  closeConnection(0):0.	18/06/2020	18:42:00	lx	(4. palvelin)

1. Loading plugin: worker/auth_worker.	18/06/2020	18:42:00	lx	(4. palvelin)

2. Loading plugin: worker/protocol_worker.	18/06/2020	18:42:00	lx	(4. palvelin)

3. Loading plugin: worker/query_worker.	18/06/2020	18:42:00	lx	(4. palvelin)

4. Loading plugin: worker/web_worker.	18/06/2020	18:42:00	lx	(4. palvelin)

5. Loading plugin: custom/sop/warehouse_control.	18/06/2020	18:42:00	lx	(4. palvelin)

All plugins have been loaded.	18/06/2020	18:42:00	lx	(4. palvelin)

--- server started in 0.1285 seconds, 2020-06-18 18:42:00, used memory 2958.3 kb ---.	18/06/2020	18:42:00	lx	(4. palvelin)


error:    SOCKET ERROR: listen_socket:bind for port 5949 failed with error: (-1) Unknown error
  [stack traceback:
	/Users/pasi/ma-git/nc-server/source/lib/util.lua:491: in function 'printError'
	/Users/pasi/ma-git/nc-server/source/lib/net_socket.lua:172: in function 'cleanup'
	/Users/pasi/ma-git/nc-server/source/lib/lib_tcp.lua:749: in function 'listen'
	/Users/pasi/ma-git/nc-server/source/lib/server.lua:423: in function 'serverRun'
	/Users/pasi/ma-git/nc-server/source/manager/ma_server.lua:163: in function 'server'
	...pasi/ma-git/nc-server/source/manager/4d/nc_server_4d.lua:159: in function 'method'
	.../pasi/ma-git/nc-server/source/manager/4d/run_from_4d.lua:59: in function <.../pasi/ma-git/nc-server/source/manager/4d/run_from_4d.lua:18>]
	18/06/2020	18:42:00	lx	(4. palvelin)


  ***  there is another instance of this program or some other program using the port  ***  .	18/06/2020	18:42:00	lx	(4. palvelin)

error: server has not been started - quit-lx-server.	18/06/2020	18:42:00	lx	(4. palvelin)

error:    SOCKET ERROR: listen_socket:bind for port 5949 failed with error: (-1) Unknown error
  [stack traceback:
	/Users/pasi/ma-git/nc-server/source/lib/util.lua:491: in function 'printError'
	/Users/pasi/ma-git/nc-server/source/lib/net_socket.lua:172: in function 'cleanup'
	/Users/pasi/ma-git/nc-server/source/lib/lib_tcp.lua:749: in function 'listen'
	/Users/pasi/ma-git/nc-server/source/lib/server.lua:423: in function 'serverRun'
	/Users/pasi/ma-git/nc-server/source/manager/ma_server.lua:163: in function 'server'
	...pasi/ma-git/nc-server/source/manager/4d/nc_server_4d.lua:159: in function 'method'
	.../pasi/ma-git/nc-server/source/manager/4d/run_from_4d.lua:59: in function <.../pasi/ma-git/nc-server/source/manager/4d/run_from_4d.lua:18>].	18/06/2020	18:42:00	_lx_SERVER	(4. palvelin)

error: server has not been started - quit-lx-server.	18/06/2020	18:42:00	lx	(4. palvelin)

error: server has not been started - quit-lx-server.	18/06/2020	18:42:00	_lx_SERVER	(4. palvelin)


warning: -*-ERR: close socket is nil
	18/06/2020	18:42:00	lx	(4. palvelin)


warning: -*-ERR: close socket is nil
	18/06/2020	18:42:00	lx	(4. palvelin)


 -- Server statistics --
answerCount:          0
poll.fd_count:        0
pollCount:            0
pollInCount:          0
pollOutCount:         0
pollCloseCount:       0
pollErrCount:         0
fd add/remove count:  0/0
totalBytesReceived:   0
totalBytesSent:       0.	18/06/2020	18:42:00	lx	(4. palvelin)

--- server stopped ---.	18/06/2020	18:42:00	lx	(4. palvelin)

finalizer: free p1	cdata<void *>: 0x4bf215a0.	18/06/2020	18:42:02	lx	(4. palvelin)

Tcp palvelin 2 sammutettu.	18/06/2020	18:42:02	_lx_SERVER	(4. palvelin)

Valmistuserän toimituspäivä on nolla: 16281/01.	18/06/2020	18:42:07	ld_ALL_ARR_CALCULATE	(4. Työpiste)


sqlQueryExecute '', sql: SELECT 1 FROM "preference" WHERE 1=0.	18/06/2020	18:42:07	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 0 ms, 2020-06-18 18:42:07.591.	18/06/2020	18:42:07	lx	(4. Työpiste)


sqlQueryExecute '', sql: SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'relation/relation.json'.	18/06/2020	18:42:07	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 1 ms, 2020-06-18 18:42:07.592.	18/06/2020	18:42:07	lx	(4. Työpiste)

query 'SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'relation/relation.json'', postgre result load time: 0.001104 seconds, rows: 0
	18/06/2020	18:42:07	lx	(4. Työpiste)


sqlQueryExecute '', sql: SELECT 1 FROM "preference" WHERE 1=0.	18/06/2020	18:42:07	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 2 ms, 2020-06-18 18:42:07.594.	18/06/2020	18:42:07	lx	(4. Työpiste)


sqlQueryExecute '', sql: SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'relation/4d/extra_relation.json'.	18/06/2020	18:42:07	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 1 ms, 2020-06-18 18:42:07.596.	18/06/2020	18:42:07	lx	(4. Työpiste)

query 'SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'relation/4d/extra_relation.json'', postgre result load time: 0.001631 seconds, rows: 0
	18/06/2020	18:42:07	lx	(4. Työpiste)

SELECT wos.phase_critical_start_date, wos.phase_critical_start_time, wos.phase_critical_date, wos.phase_critical_time, wos.phase_cr_start_date_delayed, wos.phase_critical_date_delayed, wos.production_lot__work_ph, wos.work_load_group_id, wos.work_description, wos.work_time, wo.state
 FROM work_order_schedule wos
 INNER JOIN work_order wo ON wo.production_lot = wos.production_lot
 WHERE 
 wos.work_phase_state IN ('EK','KU','AL','TA','PY') AND wo.state IN ('EK','KU','AL','TA','PY')
 INTO :_lx_adExe1,:_lx_arExe1,:_lx_adExe2,:_lx_arExe2,:_lx_adExe3,:_lx_adExe4,:_lx_atExe1,:_lx_atExe2,:_lx_atExe3,:_lx_arExe3,:_lx_atExe4
 - result _lx_atExe1 size: 166
 - query name: .	18/06/2020	18:42:07	_lx_ExecuteSql	(4. Työpiste)


sqlQueryExecute '', sql: SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'capacity/preference.json' AND prf.organization_id = 0.	18/06/2020	18:42:07	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 27 ms, 2020-06-18 18:42:07.624.	18/06/2020	18:42:07	lx	(4. Työpiste)

query 'SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'capacity/preference.json' AND prf.organization_id = 0', postgre result load time: 0.001994 seconds, rows: 0
	18/06/2020	18:42:07	lx	(4. Työpiste)


sqlQueryExecute '', sql: SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'fineload_Preference.json' AND prf.organization_id = 0.	18/06/2020	18:42:07	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 2 ms, 2020-06-18 18:42:07.626.	18/06/2020	18:42:07	lx	(4. Työpiste)

query 'SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'fineload_Preference.json' AND prf.organization_id = 0', postgre result load time: 0.001601 seconds, rows: 0
	18/06/2020	18:42:07	lx	(4. Työpiste)

SELECT resr.link_type, resr.resource_id, resr.start_date, resr.end_date, resr.multiplier, resr.work_load_group_id, resr.employee_id, resr.color, resr.row_order, resr.shift_order, resr.work_capacity_id
 FROM resource_row resr
 WHERE 
 resr.state >= 0
 INTO :_lx_arExe1,:_lx_atExe1,:_lx_adExe1,:_lx_adExe2,:_lx_arExe2,:_lx_atExe2,:_lx_atExe3,:_lx_atExe4,:_lx_arExe3,:_lx_atExe5,:_lx_atExe6
 - result _lx_atExe1 size: 76
 - query name: .	18/06/2020	18:42:07	_lx_ExecuteSql	(4. Työpiste)

SELECT wcr.work_capacity_id, wcr.start_date, wcr.end_date, wcr.start_time, wcr.end_time, wcr.type_, wcr.shift, wcr.work_load_group_id, wcr.employee_id, wcr.color, wcr.name, wcr.repeat_rule
 FROM work_capacity_row wcr
 WHERE 
 wcr.work_capacity_id IN ('ld_Capacity_IV1400-2145','ld_Capacity_AV0600-1400','ld_Capacity_YV2145-2230','ld_Capacity_EM2230-0130','ld_Capacity_Perusviikko','3-VUORO','TT POIS 2013','VUORORAJA 3','KIINNI','VR 2-V TESTI','VUORORAJA 4','IV16','AV08','VUORORAJA (8,16)','2V 80T / 1-5','EM 2T /1-5','VR EM 2T TESTI','VUORORAJA 2','AV_0600-1400/1-5')
 INTO :_lx_atExe1,:_lx_adExe1,:_lx_adExe2,:_lx_arExe1,:_lx_arExe2,:_lx_arExe3,:_lx_arExe4,:_lx_atExe2,:_lx_atExe3,:_lx_atExe4,:_lx_atExe5,:_lx_atExe6
 - result _lx_atExe1 size: 91
 - query name: .	18/06/2020	18:42:07	_lx_ExecuteSql	(4. Työpiste)

SELECT weff.work_load_group_id, weff.type_, weff.efficiency, weff.employee_count, weff.employee_id
 FROM work_efficiency weff
 WHERE 
 weff.state >= 0
 INTO :_lx_atExe1,:_lx_arExe1,:_lx_arExe2,:_lx_arExe3,:_lx_atExe2
 - result _lx_atExe1 size: 31
 - query name: .	18/06/2020	18:42:07	_lx_ExecuteSql	(4. Työpiste)

SELECT wlg.rough_load_group, wlg.work_load_group_id
 FROM work_load_group wlg
 WHERE 
 wlg.work_load_group_id IN ('ALIH','EMAG PIENI','TESTI-KRY','TESTI-KRY1','BW1','BW2','CNC-2','DAEWOO','ENGEL','HERBER','HIT','JYR','JÄYSTE','KR3','KR4','KOK','LEIKK','MAAL','MANAGE','PAKK','POR','PUHD','PUTKISOLU','RAAKA-AINE','RAEP','SAH','SINK','SOR','SPIRAALI','SÄRM','TAIV')
 INTO :_lx_atExe1,:_lx_atExe2
 - result _lx_atExe1 size: 28
 - query name: .	18/06/2020	18:42:07	_lx_ExecuteSql	(4. Työpiste)

SELECT em.employee_id
 FROM employee em
 WHERE 
 em.employee_id IN ('','KK','X','UN','EK','AKE')
 INTO :_lx_atExe1
 - result _lx_atExe1 size: 5
 - query name: .	18/06/2020	18:42:07	_lx_ExecuteSql	(4. Työpiste)

workpost_4d.fineloadToWorkpostArr run time: 0.1366 s		/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/Resources/Lua/manager/4d/.	18/06/2020	18:42:07	lx	(4. Työpiste)

Kapasiteettia ei löytynyt, pyydetty päivä on suurempi kuin kapasiteetin loppupäivä, kapasiteetti: LEIKK 18/06/2020 > 17/05/2019, kuorm. ryhmä: LEIKK.	18/06/2020	18:42:07	ldcap_ IndexFirstLoaded	(4. Työpiste)

Kapasiteettia ei löytynyt, pyydetty päivä on suurempi kuin kapasiteetin loppupäivä, kapasiteetti: LEIKK 13/10/2019 > 17/05/2019, kuorm. ryhmä: LEIKK.	18/06/2020	18:42:07	ldcap_ IndexFirstLoaded	(4. Työpiste)

Ei voi hakea taulusta Asetus, asetuksen nimi <>_LNK_LDEFAULTINPUTOPENSTATE.	18/06/2020	18:42:35	_prf_ Qry_OLD	(8. tbl_ 7)

Ei voi hakea taulusta Asetus, asetuksen nimi <>_LNK_LUUIDININFOSHOW.	18/06/2020	18:42:35	_prf_ Qry_OLD	(8. tbl_ 7)

Ei voi hakea taulusta Asetus, asetuksen nimi <>AF_LLOADONACTIVATE.	18/06/2020	18:42:35	_prf_ Qry_OLD	(8. tbl_ 7)

Valmistuserän toimituspäivä on nolla: 16281/01.	18/06/2020	18:42:57	ld_ALL_ARR_CALCULATE	(4. Työpiste)


sqlQueryExecute '', sql: SELECT 1 FROM "preference" WHERE 1=0.	18/06/2020	18:42:57	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 0 ms, 2020-06-18 18:42:57.985.	18/06/2020	18:42:57	lx	(4. Työpiste)


sqlQueryExecute '', sql: SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'relation/relation.json'.	18/06/2020	18:42:57	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 1 ms, 2020-06-18 18:42:57.987.	18/06/2020	18:42:57	lx	(4. Työpiste)

query 'SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'relation/relation.json'', postgre result load time: 0.001239 seconds, rows: 0
	18/06/2020	18:42:57	lx	(4. Työpiste)


sqlQueryExecute '', sql: SELECT 1 FROM "preference" WHERE 1=0.	18/06/2020	18:42:57	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 2 ms, 2020-06-18 18:42:57.989.	18/06/2020	18:42:57	lx	(4. Työpiste)


sqlQueryExecute '', sql: SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'relation/4d/extra_relation.json'.	18/06/2020	18:42:57	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 1 ms, 2020-06-18 18:42:57.991.	18/06/2020	18:42:57	lx	(4. Työpiste)

query 'SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'relation/4d/extra_relation.json'', postgre result load time: 0.001546 seconds, rows: 0
	18/06/2020	18:42:57	lx	(4. Työpiste)

SELECT wos.phase_critical_start_date, wos.phase_critical_start_time, wos.phase_critical_date, wos.phase_critical_time, wos.phase_cr_start_date_delayed, wos.phase_critical_date_delayed, wos.production_lot__work_ph, wos.work_load_group_id, wos.work_description, wos.work_time, wo.state
 FROM work_order_schedule wos
 INNER JOIN work_order wo ON wo.production_lot = wos.production_lot
 WHERE 
 wos.work_phase_state IN ('EK','KU','AL','TA','PY') AND wo.state IN ('EK','KU','AL','TA','PY')
 INTO :_lx_adExe1,:_lx_arExe1,:_lx_adExe2,:_lx_arExe2,:_lx_adExe3,:_lx_adExe4,:_lx_atExe1,:_lx_atExe2,:_lx_atExe3,:_lx_arExe3,:_lx_atExe4
 - result _lx_atExe1 size: 166
 - query name: .	18/06/2020	18:42:57	_lx_ExecuteSql	(4. Työpiste)


sqlQueryExecute '', sql: SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'capacity/preference.json' AND prf.organization_id = 0.	18/06/2020	18:42:57	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 20 ms, 2020-06-18 18:42:57.011.	18/06/2020	18:42:57	lx	(4. Työpiste)

query 'SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'capacity/preference.json' AND prf.organization_id = 0', postgre result load time: 0.001826 seconds, rows: 0
	18/06/2020	18:42:57	lx	(4. Työpiste)


sqlQueryExecute '', sql: SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'fineload_Preference.json' AND prf.organization_id = 0.	18/06/2020	18:42:57	lx	(4. Työpiste)

sqlQueryExecute time: 0 ms, delay from previous: 2 ms, 2020-06-18 18:42:57.013.	18/06/2020	18:42:57	lx	(4. Työpiste)

query 'SELECT prf.json_data
 FROM preference prf
 WHERE 
 prf.name_id = 'fineload_Preference.json' AND prf.organization_id = 0', postgre result load time: 0.001268 seconds, rows: 0
	18/06/2020	18:42:57	lx	(4. Työpiste)

SELECT resr.link_type, resr.resource_id, resr.start_date, resr.end_date, resr.multiplier, resr.work_load_group_id, resr.employee_id, resr.color, resr.row_order, resr.shift_order, resr.work_capacity_id
 FROM resource_row resr
 WHERE 
 resr.state >= 0
 INTO :_lx_arExe1,:_lx_atExe1,:_lx_adExe1,:_lx_adExe2,:_lx_arExe2,:_lx_atExe2,:_lx_atExe3,:_lx_atExe4,:_lx_arExe3,:_lx_atExe5,:_lx_atExe6
 - result _lx_atExe1 size: 76
 - query name: .	18/06/2020	18:42:57	_lx_ExecuteSql	(4. Työpiste)

SELECT wcr.work_capacity_id, wcr.start_date, wcr.end_date, wcr.start_time, wcr.end_time, wcr.type_, wcr.shift, wcr.work_load_group_id, wcr.employee_id, wcr.color, wcr.name, wcr.repeat_rule
 FROM work_capacity_row wcr
 WHERE 
 wcr.work_capacity_id IN ('ld_Capacity_IV1400-2145','ld_Capacity_AV0600-1400','ld_Capacity_YV2145-2230','ld_Capacity_EM2230-0130','ld_Capacity_Perusviikko','3-VUORO','TT POIS 2013','VUORORAJA 3','KIINNI','VR 2-V TESTI','VUORORAJA 4','IV16','AV08','VUORORAJA (8,16)','2V 80T / 1-5','EM 2T /1-5','VR EM 2T TESTI','VUORORAJA 2','AV_0600-1400/1-5')
 INTO :_lx_atExe1,:_lx_adExe1,:_lx_adExe2,:_lx_arExe1,:_lx_arExe2,:_lx_arExe3,:_lx_arExe4,:_lx_atExe2,:_lx_atExe3,:_lx_atExe4,:_lx_atExe5,:_lx_atExe6
 - result _lx_atExe1 size: 91
 - query name: .	18/06/2020	18:42:57	_lx_ExecuteSql	(4. Työpiste)

SELECT weff.work_load_group_id, weff.type_, weff.efficiency, weff.employee_count, weff.employee_id
 FROM work_efficiency weff
 WHERE 
 weff.state >= 0
 INTO :_lx_atExe1,:_lx_arExe1,:_lx_arExe2,:_lx_arExe3,:_lx_atExe2
 - result _lx_atExe1 size: 31
 - query name: .	18/06/2020	18:42:57	_lx_ExecuteSql	(4. Työpiste)

SELECT wlg.rough_load_group, wlg.work_load_group_id
 FROM work_load_group wlg
 WHERE 
 wlg.work_load_group_id IN ('ALIH','EMAG PIENI','TESTI-KRY','TESTI-KRY1','BW1','BW2','CNC-2','DAEWOO','ENGEL','HERBER','HIT','JYR','JÄYSTE','KR3','KR4','KOK','LEIKK','MAAL','MANAGE','PAKK','POR','PUHD','PUTKISOLU','RAAKA-AINE','RAEP','SAH','SINK','SOR','SPIRAALI','SÄRM','TAIV')
 INTO :_lx_atExe1,:_lx_atExe2
 - result _lx_atExe1 size: 28
 - query name: .	18/06/2020	18:42:57	_lx_ExecuteSql	(4. Työpiste)

SELECT em.employee_id
 FROM employee em
 WHERE 
 em.employee_id IN ('','KK','X','UN','EK','AKE')
 INTO :_lx_atExe1
 - result _lx_atExe1 size: 5
 - query name: .	18/06/2020	18:42:57	_lx_ExecuteSql	(4. Työpiste)

workpost_4d.fineloadToWorkpostArr run time: 0.1217 s		/4D/mg_v12/Manageri_v12_Build/Compiled Database/Manageri v12.4dbase/Resources/Lua/manager/4d/.	18/06/2020	18:42:57	lx	(4. Työpiste)

Kapasiteettia ei löytynyt, pyydetty päivä on suurempi kuin kapasiteetin loppupäivä, kapasiteetti: LEIKK 18/06/2020 > 17/05/2019, kuorm. ryhmä: LEIKK.	18/06/2020	18:42:57	ldcap_ IndexFirstLoaded	(4. Työpiste)

Kapasiteettia ei löytynyt, pyydetty päivä on suurempi kuin kapasiteetin loppupäivä, kapasiteetti: LEIKK 13/10/2019 > 17/05/2019, kuorm. ryhmä: LEIKK.	18/06/2020	18:42:57	ldcap_ IndexFirstLoaded	(4. Työpiste)

