20240906070211am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW102643',		
						wko_ls8_empl_id='ADMIN : Admin',		
						wko_ls8_craft='HSK  : Housekeeping',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs=0.00,			
						wko_ls8_rate=2.0000,			
						wko_ls8_multiplier=2.0000,		
						wko_ls8_adder=0.0000,			
						wko_ls8_act_cost=0.0000,		  
						wko_ls8_chg_costcenter='0070.ADMIN', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-06 14:07',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 42000
code: 2628
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated in table 'cmms_sunway_1011.dbo.wko_ls8', column 'wko_ls8_hours_type'. Truncated value: 'D '.

20240906070211am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW102643',		
						wko_ls8_empl_id='ADMIN : Admin',		
						wko_ls8_craft='HSK  : Housekeeping',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs=0.00,			
						wko_ls8_rate=2.0000,			
						wko_ls8_multiplier=2.0000,		
						wko_ls8_adder=0.0000,			
						wko_ls8_act_cost=0.0000,		  
						wko_ls8_chg_costcenter='0070.ADMIN', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-06 14:07',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 01000
code: 3621
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.

20240910082705am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 42000
code: 2628
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated in table 'cmms_sunway_1011.dbo.wko_ls8', column 'wko_ls8_empl_id'. Truncated value: '074534 : Arman Shahrin Yu'.

20240910082705am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 01000
code: 3621
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.

20240910082956am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 42000
code: 2628
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated in table 'cmms_sunway_1011.dbo.wko_ls8', column 'wko_ls8_empl_id'. Truncated value: '074534 : Arman Shahrin Yu'.

20240910082956am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 01000
code: 3621
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.

20240910083008am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 42000
code: 2628
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated in table 'cmms_sunway_1011.dbo.wko_ls8', column 'wko_ls8_empl_id'. Truncated value: '074534 : Arman Shahrin Yu'.

20240910083008am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 01000
code: 3621
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.

20240911065737am
INSERT wko_ls8 
				
					(	site_cd ,					mst_RowID,					wko_ls8_assetno,				wko_ls8_empl_id,				
						wko_ls8_craft,				wko_ls8_hours_type ,		wko_ls8_hrs ,					wko_ls8_rate ,
						wko_ls8_multiplier ,		wko_ls8_adder ,				wko_ls8_act_cost ,				wko_ls8_chg_costcenter ,
						wko_ls8_chg_account ,		wko_ls8_crd_costcenter ,	wko_ls8_crd_account ,			wko_ls8_time_card_no ,
						wko_ls8_datetime1 ,			audit_user ,				audit_date ,					wko_ls8_datetime2,
						mbl_audit_user,				mbl_audit_date) 
						
			VALUES 	(	'MSW',				'602709',			'MSW100931',					'000485',		
						'ADM ',				'PL',			0.00,				0.00,							
						1.00,			0.00,					,				'TNTS',						
						'',			Null,						Null,							'',	
						'2024-09-11 14:57',			'000485',			'2024-09-11 14:57',				Null,
						'ADMIN',				'2024-09-11 14:57')
SQLSTATE: 42000
code: 102
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ','.

20240924102251am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141441',		'2024-09-24 18:22',			'000485',			'BWK',				
			'D',			0.05,			5.00,					2.00,			0.00,				
			0.50,				'P112132',		'MSW-1010103',				'TNTS',		'',		
			NULL,						NULL,						'P',						'000485',			GetDate(),					
			'000485',			GetDate(),					'ADMIN',				GetDate(),					'2024-09-24 18:22',
			'2024-09-24 18:25',)
SQLSTATE: 42000
code: 102
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.

20240924102340am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141442',		'2024-09-24 18:23',			'SEKHAR_EMP',			'BWK ',				
			'D',			2.45,			0.00,					2.00,			0.00,				
			0.00,				'C140147',		'MSW102625',				'0070.0083',		'',		
			NULL,						NULL,						'P',						'SEKHAR_EMP',			GetDate(),					
			'SEKHAR_EMP',			GetDate(),					'SEKHAR_LOG',				GetDate(),					'2024-09-24 18:23',
			'2024-09-24 20:50',)
SQLSTATE: 42000
code: 102
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.

20240924102503am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141443',		'2024-09-24 18:23',			'SEKHAR_EMP',			'BWK ',				
			'D',			2.45,			0.00,					2.00,			0.00,				
			0.00,				'C140147',		'MSW102625',				'0070.0083',		'',		
			NULL,						NULL,						'P',						'SEKHAR_EMP',			GetDate(),					
			'SEKHAR_EMP',			GetDate(),					'SEKHAR_LOG',				GetDate(),					'2024-09-24 18:23',
			'2024-09-24 20:50',)
SQLSTATE: 42000
code: 102
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.

20240924102540am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141444',		'2024-09-24 18:23',			'SEKHAR_EMP',			'BWK ',				
			'D',			2.45,			0.00,					2.00,			0.00,				
			0.00,				'C140147',		'MSW102625',				'0070.0083',		'',		
			NULL,						NULL,						'P',						'SEKHAR_EMP',			GetDate(),					
			'SEKHAR_EMP',			GetDate(),					'SEKHAR_LOG',				GetDate(),					'2024-09-24 18:23',
			'2024-09-24 20:50',)
SQLSTATE: 42000
code: 102
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.

20241125041943am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141458',		'2024-09-11 15:54',			'074534',			'ADM',				
			'D',			1,796.42,			0.0000,					2.0000,			0.0000,				
			0.00,				'C140027',		'MSW102643',				'0070.ADMIN',		'',		
			NULL,						NULL,						'P',						'000485',			GetDate(),					
			'000485',			GetDate(),					'ADMIN',				GetDate(),					'2024-09-11 15:54',
			'2024-11-25 12:19')
SQLSTATE: 21S01
code: 110
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

20241125042007am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141459',		'2024-09-11 15:54',			'074534',			'ADM',				
			'D',			1,796.42,			0.0000,					2.0000,			0.0000,				
			0.00,				'C140027',		'MSW102643',				'0070.ADMIN',		'',		
			NULL,						NULL,						'P',						'000485',			GetDate(),					
			'000485',			GetDate(),					'ADMIN',				GetDate(),					'2024-09-11 15:54',
			'2024-11-25 12:19')
SQLSTATE: 21S01
code: 110
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.