08-04-2024 10:50:46 ## Exception ## Incorrect datetime value: '' for column 'RFS_Date' at row 1 ## DataAccess.SetData ## ## Exception in query: SaveUpdate_SiteLogicalMaster Incorrect datetime value: '' for column 'RFS_Date' at row 1 INSERT INTO mst_site_logical(updated_at, name, site_P_PK, gen2, gen3, lTE, l_latitude, l_longitude, gID, dPAS_Code, sub_Area, l_Address, l_Road_Access, pAT_Date, Building_Name, floor_Number, room_Type, site_Boundary, shared, eTC_Site_ID, l_Access_Procedure, site_Priority, entry_Key, eKMS, hONEYWELL, mANUAL_KEY, ACCESS_CARD, pRIORITY, cabinet_Location, power_Source, Account_Number, meter_Number, counter, room_Maintenance_Scope, rFS_Date, gPON_Migration_Date, gPON_Migration_Planned, pERMIT, sECURITY, rOOM_DIMENSION, rAISED_FLOOR, sTANDBY_OULET, cONTACT_DETAILS, pROJECT_TYPE, rEMARKS_CANCELLED_SITES, store_Manager, mobile_Number, email, store_Timing, fM_Company_Name, fM_Company_Contact, security_Number_Email, remarks, inactive, ring_number, moc_id, owner_access_ring_id, candidate_status_pk, l_Site_Type, site_l_created_by_user,Safety_wire_brand_Ladder,Safety_wire_brand_Tower,Brand_saftey_wires_poles,Ladder_height_to_Antenna,Number_of_wire_poles,ladder_height_to_BTS,Number_of_poles,Access_to_BTS) VALUES('2024-04-08 10:50:46', '1', 664, '', '', '', 29.38877, 47.99015, '', '', 'CAP', 'Sharq, Blk-3, Bin Misbah St (131)', '', '', '', '', '', '', '', '', 'Sharq, Blk-3, Bin Misbah St (131)', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', 0, 'Self Supported', 'Mehboob L Mohmed Maniyar', '', '', '', '', '', '', '', '') Inner Exception: NULL Source: MySql.Data Platform: Web 08-04-2024 10:50:46 ## Exception ## Incorrect datetime value: '' for column 'RFS_Date' at row 1 ## DataAccess.SetData ## ## Exception in query: SaveUpdate_SiteLogicalMaster Incorrect datetime value: '' for column 'RFS_Date' at row 1 INSERT INTO mst_site_logical(updated_at, name, site_P_PK, gen2, gen3, lTE, l_latitude, l_longitude, gID, dPAS_Code, sub_Area, l_Address, l_Road_Access, pAT_Date, Building_Name, floor_Number, room_Type, site_Boundary, shared, eTC_Site_ID, l_Access_Procedure, site_Priority, entry_Key, eKMS, hONEYWELL, mANUAL_KEY, ACCESS_CARD, pRIORITY, cabinet_Location, power_Source, Account_Number, meter_Number, counter, room_Maintenance_Scope, rFS_Date, gPON_Migration_Date, gPON_Migration_Planned, pERMIT, sECURITY, rOOM_DIMENSION, rAISED_FLOOR, sTANDBY_OULET, cONTACT_DETAILS, pROJECT_TYPE, rEMARKS_CANCELLED_SITES, store_Manager, mobile_Number, email, store_Timing, fM_Company_Name, fM_Company_Contact, security_Number_Email, remarks, inactive, ring_number, moc_id, owner_access_ring_id, candidate_status_pk, l_Site_Type, site_l_created_by_user,Safety_wire_brand_Ladder,Safety_wire_brand_Tower,Brand_saftey_wires_poles,Ladder_height_to_Antenna,Number_of_wire_poles,ladder_height_to_BTS,Number_of_poles,Access_to_BTS) VALUES('2024-04-08 10:50:46', '3', 666, '', '', '', 29.33467, 48.0158, '', '', 'HAW', 'HAWALLY MOC', '', '', '', '', '', '', '', '', 'HAWALLY MOC', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', 0, 'MOC Tower', 'Mehboob L Mohmed Maniyar', '', '', '', '', '', '', '', '') Inner Exception: NULL Source: MySql.Data Platform: Web 08-04-2024 10:50:46 ## Exception ## Incorrect datetime value: '' for column 'RFS_Date' at row 1 ## DataAccess.SetData ## ## Exception in query: SaveUpdate_SiteLogicalMaster Incorrect datetime value: '' for column 'RFS_Date' at row 1 INSERT INTO mst_site_logical(updated_at, name, site_P_PK, gen2, gen3, lTE, l_latitude, l_longitude, gID, dPAS_Code, sub_Area, l_Address, l_Road_Access, pAT_Date, Building_Name, floor_Number, room_Type, site_Boundary, shared, eTC_Site_ID, l_Access_Procedure, site_Priority, entry_Key, eKMS, hONEYWELL, mANUAL_KEY, ACCESS_CARD, pRIORITY, cabinet_Location, power_Source, Account_Number, meter_Number, counter, room_Maintenance_Scope, rFS_Date, gPON_Migration_Date, gPON_Migration_Planned, pERMIT, sECURITY, rOOM_DIMENSION, rAISED_FLOOR, sTANDBY_OULET, cONTACT_DETAILS, pROJECT_TYPE, rEMARKS_CANCELLED_SITES, store_Manager, mobile_Number, email, store_Timing, fM_Company_Name, fM_Company_Contact, security_Number_Email, remarks, inactive, ring_number, moc_id, owner_access_ring_id, candidate_status_pk, l_Site_Type, site_l_created_by_user,Safety_wire_brand_Ladder,Safety_wire_brand_Tower,Brand_saftey_wires_poles,Ladder_height_to_Antenna,Number_of_wire_poles,ladder_height_to_BTS,Number_of_poles,Access_to_BTS) VALUES('2024-04-08 10:50:46', '2', 665, '', '', '', 29.340277, 47.94694, '', '', 'CAP', 'SHUWAIKH SKB, KIFAN MOC', '', '', '', '', '', '', '', '', 'SHUWAIKH SKB, KIFAN MOC', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', 0, 'MOC Tower', 'Mehboob L Mohmed Maniyar', '', '', '', '', '', '', '', '') Inner Exception: NULL Source: MySql.Data Platform: Web 08-04-2024 10:50:46 ## Exception ## Incorrect datetime value: '' for column 'RFS_Date' at row 1 ## DataAccess.SetData ## ## Exception in query: SaveUpdate_SiteLogicalMaster Incorrect datetime value: '' for column 'RFS_Date' at row 1 INSERT INTO mst_site_logical(updated_at, name, site_P_PK, gen2, gen3, lTE, l_latitude, l_longitude, gID, dPAS_Code, sub_Area, l_Address, l_Road_Access, pAT_Date, Building_Name, floor_Number, room_Type, site_Boundary, shared, eTC_Site_ID, l_Access_Procedure, site_Priority, entry_Key, eKMS, hONEYWELL, mANUAL_KEY, ACCESS_CARD, pRIORITY, cabinet_Location, power_Source, Account_Number, meter_Number, counter, room_Maintenance_Scope, rFS_Date, gPON_Migration_Date, gPON_Migration_Planned, pERMIT, sECURITY, rOOM_DIMENSION, rAISED_FLOOR, sTANDBY_OULET, cONTACT_DETAILS, pROJECT_TYPE, rEMARKS_CANCELLED_SITES, store_Manager, mobile_Number, email, store_Timing, fM_Company_Name, fM_Company_Contact, security_Number_Email, remarks, inactive, ring_number, moc_id, owner_access_ring_id, candidate_status_pk, l_Site_Type, site_l_created_by_user,Safety_wire_brand_Ladder,Safety_wire_brand_Tower,Brand_saftey_wires_poles,Ladder_height_to_Antenna,Number_of_wire_poles,ladder_height_to_BTS,Number_of_poles,Access_to_BTS) VALUES('2024-04-08 10:50:46', '4', 667, '', '', '', 29.33833, 48.08305, '', '', 'HAW', 'RAS SALMIYA MOC', '', '', '', '', '', '', '', '', 'RAS SALMIYA MOC', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', 0, 'MOC Tower', 'Mehboob L Mohmed Maniyar', '', '', '', '', '', '', '', '') Inner Exception: NULL Source: MySql.Data Platform: Web 08-04-2024 10:50:46 ## Exception ## Incorrect datetime value: '' for column 'RFS_Date' at row 1 ## DataAccess.SetData ## ## Exception in query: SaveUpdate_SiteLogicalMaster Incorrect datetime value: '' for column 'RFS_Date' at row 1 INSERT INTO mst_site_logical(updated_at, name, site_P_PK, gen2, gen3, lTE, l_latitude, l_longitude, gID, dPAS_Code, sub_Area, l_Address, l_Road_Access, pAT_Date, Building_Name, floor_Number, room_Type, site_Boundary, shared, eTC_Site_ID, l_Access_Procedure, site_Priority, entry_Key, eKMS, hONEYWELL, mANUAL_KEY, ACCESS_CARD, pRIORITY, cabinet_Location, power_Source, Account_Number, meter_Number, counter, room_Maintenance_Scope, rFS_Date, gPON_Migration_Date, gPON_Migration_Planned, pERMIT, sECURITY, rOOM_DIMENSION, rAISED_FLOOR, sTANDBY_OULET, cONTACT_DETAILS, pROJECT_TYPE, rEMARKS_CANCELLED_SITES, store_Manager, mobile_Number, email, store_Timing, fM_Company_Name, fM_Company_Contact, security_Number_Email, remarks, inactive, ring_number, moc_id, owner_access_ring_id, candidate_status_pk, l_Site_Type, site_l_created_by_user,Safety_wire_brand_Ladder,Safety_wire_brand_Tower,Brand_saftey_wires_poles,Ladder_height_to_Antenna,Number_of_wire_poles,ladder_height_to_BTS,Number_of_poles,Access_to_BTS) VALUES('2024-04-08 10:50:46', '5', 668, '', '', '', 29.3654, 48.0127, '', '', 'CAP', 'SHAAB MAIN TOWER', '', '', '', '', '', '', '', '', 'SHAAB MAIN TOWER', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', 0, 'Self Supported', 'Mehboob L Mohmed Maniyar', '', '', '', '', '', '', '', '') Inner Exception: NULL Source: MySql.Data Platform: Web 08-04-2024 01:24:41 ## Exception ## Duplicate entry 'sprasad' for key 'Userid_UNIQUE' ## DataAccess.SetData ## ## Exception in query: SaveUpdate_UserMaster Duplicate entry 'sprasad' for key 'Userid_UNIQUE' INSERT INTO mst_users(updated_at, userid, name, company, department_id, department_name, subdepartment_id, subdepartment_name, designation_id, designation_name, hayat_email, origin, passport_no, function, main_proficiency_id, alt_proficiency_id, cc_mobile_no_1, mobile_no_1, cc_mobile_no_2, mobile_no_2, visa__no, id_no, car_license_plate_import, car_license_plate, country_fk, location, active_on_shift, assistance_required, inactive, team, apk_version, gcm_registration_id, notification_settings, use_tracking, tracking_timeout, uuid, project_pk, user_group_id, allow_sms, allow_mail, allow_push, shift_id) VALUES('2024-04-08 13:24:41', 'sprasad', 'Sanjeet Kumar Prasad', 1, 22, '', 39, '', 49, '', '', 0, '', '', 0, 0, '', '96770696', '', '', 0, '', '', 0, 2, '', 1, 0, 0, '', '', '', '', 0, 0, '', 13, 2, 0, 0, 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Web