[14:25:35] DB Error Occured. FILE: CDSPrkPlceF.cpp LINE: 1244 FUNC: TPrkPlceManager::MergePrkPlce Title: TPrkPlceManager::MergePrkPlce Class: EOleException Error: TBR-11021 (ERREX): Error occurred during type casting SQL : MERGE INTO TB_PRK_PLCE L USING (SELECT :p01 AS PRK_PLCE_NMBR, :p02 AS PRK_PLCE_MANAGE_NO, :p03 AS PRK_PLCE_STTUS_VER, :p04 AS PRK_PLCE_NM, :p44 AS VMS_DSPL_NM, :p05 AS PRK_PLCE_ADRES, :p06 AS PRK_PLCE_INSTL_DE, :p07 AS PRK_PLCE_ABL_DE, :p08 AS PRK_PLCE_ENTRC_NM, :p09 AS PRK_PLCE_ENTRC_LA, :p10 AS PRK_PLCE_ENTRC_LO, :p11 AS PRK_PLCE_ENTRC_EXTTY, :p12 AS PARKING_TY, :p13 AS PARKING_US, :p14 AS AR_LEVEL_SE, :p15 AS PRK_PLCE_IMAGE_DATA, :p16 AS PRK_PLCE_IMAGE_TYPE, :p17 AS PRK_PLCE_IMAGE_DC, :p18 AS SYS_NE, :p19 AS PARKING_CNTRL_SYS_INSTL_DE, :p20 AS RELATION_LAW_AND_ORDINANCES, :p21 AS PRK_AVAIL_CARTYPE, :p22 AS PRK_CMPRT_CO, :p23 AS COLCT_DEVICE_INSTL_AT, :p24 AS MASTER_CONTROLLER, :p25 AS SLAVE_CONTROLLER, :p26 AS COLCT_DEVICE_QTY, :p27 AS COLCT_DEVICE_KND, :p34 AS COLCT_DEVICE_INSTL_DE, :p35 AS CRM_PRV_CCTV_INSTL_AT, :p36 AS CRM_PRV_CCTV_INSTL_CO, :p37 AS PIS_TYPE, :p38 AS INFO_CREATE_TIME FROM DUAL) M ON (L.PRK_PLCE_NMBR = M.PRK_PLCE_NMBR) WHEN MATCHED THEN UPDATE SET L.PRK_PLCE_MANAGE_NO = M.PRK_PLCE_MANAGE_NO, L.PRK_PLCE_STTUS_VER = M.PRK_PLCE_STTUS_VER, L.PRK_PLCE_NM = M.PRK_PLCE_NM, L.VMS_DSPL_NM = M.VMS_DSPL_NM, L.PRK_PLCE_ADRES = M.PRK_PLCE_ADRES, L.PRK_PLCE_INSTL_DE = M.PRK_PLCE_INSTL_DE, L.PRK_PLCE_ABL_DE = M.PRK_PLCE_ABL_DE, L.PRK_PLCE_ENTRC_NM = M.PRK_PLCE_ENTRC_NM, L.PRK_PLCE_ENTRC_LA = M.PRK_PLCE_ENTRC_LA, L.PRK_PLCE_ENTRC_LO = M.PRK_PLCE_ENTRC_LO, L.PRK_PLCE_ENTRC_EXTTY = M.PRK_PLCE_ENTRC_EXTTY, L.PARKING_TY = M.PARKING_TY, L.PARKING_US = M.PARKING_US, L.AR_LEVEL_SE = M.AR_LEVEL_SE, L.PRK_PLCE_IMAGE_DATA = M.PRK_PLCE_IMAGE_DATA, L.PRK_PLCE_IMAGE_TYPE = M.PRK_PLCE_IMAGE_TYPE, L.PRK_PLCE_IMAGE_DC = M.PRK_PLCE_IMAGE_DC, L.SYS_NE = M.SYS_NE, L.PARKING_CNTRL_SYS_INSTL_DE = M.PARKING_CNTRL_SYS_INSTL_DE, L.RELATION_LAW_AND_ORDINANCES = M.RELATION_LAW_AND_ORDINANCES, L.PRK_AVAIL_CARTYPE = M.PRK_AVAIL_CARTYPE, L.PRK_CMPRT_CO = M.PRK_CMPRT_CO, L.COLCT_DEVICE_INSTL_AT = M.COLCT_DEVICE_INSTL_AT, L.MASTER_CONTROLLER = M.MASTER_CONTROLLER, L.SLAVE_CONTROLLER = M.SLAVE_CONTROLLER, L.COLCT_DEVICE_QTY = M.COLCT_DEVICE_QTY, L.COLCT_DEVICE_KND = M.COLCT_DEVICE_KND, L.COLCT_DEVICE_INSTL_DE = M.COLCT_DEVICE_INSTL_DE, L.CRM_PRV_CCTV_INSTL_AT = M.CRM_PRV_CCTV_INSTL_AT, L.CRM_PRV_CCTV_INSTL_CO = M.CRM_PRV_CCTV_INSTL_CO, L.PIS_TYPE = M.PIS_TYPE, L.INFO_CREATE_TIME = M.INFO_CREATE_TIME WHEN NOT MATCHED THEN INSERT ( PRK_PLCE_NMBR, PRK_PLCE_MANAGE_NO, PRK_PLCE_STTUS_VER, PRK_PLCE_NM, VMS_DSPL_NM, PRK_PLCE_ADRES, PRK_PLCE_INSTL_DE, PRK_PLCE_ABL_DE, PRK_PLCE_ENTRC_NM, PRK_PLCE_ENTRC_LA, PRK_PLCE_ENTRC_LO, PRK_PLCE_ENTRC_EXTTY, PARKING_TY, PARKING_US, AR_LEVEL_SE, PRK_PLCE_IMAGE_DATA, PRK_PLCE_IMAGE_TYPE, PRK_PLCE_IMAGE_DC, SYS_NE, PARKING_CNTRL_SYS_INSTL_DE, RELATION_LAW_AND_ORDINANCES, PRK_AVAIL_CARTYPE, PRK_CMPRT_CO, COLCT_DEVICE_INSTL_AT, MASTER_CONTROLLER, SLAVE_CONTROLLER, COLCT_DEVICE_QTY, COLCT_DEVICE_KND, COLCT_DEVICE_INSTL_DE, CRM_PRV_CCTV_INSTL_AT, CRM_PRV_CCTV_INSTL_CO, PIS_TYPE, INFO_CREATE_TIME ) VALUES ( M.PRK_PLCE_NMBR, M.PRK_PLCE_MANAGE_NO, M.PRK_PLCE_STTUS_VER, M.PRK_PLCE_NM, M.VMS_DSPL_NM, M.PRK_PLCE_ADRES, M.PRK_PLCE_INSTL_DE, M.PRK_PLCE_ABL_DE, M.PRK_PLCE_ENTRC_NM, M.PRK_PLCE_ENTRC_LA, M.PRK_PLCE_ENTRC_LO, M.PRK_PLCE_ENTRC_EXTTY, M.PARKING_TY, M.PARKING_US, M.AR_LEVEL_SE, M.PRK_PLCE_IMAGE_DATA, M.PRK_PLCE_IMAGE_TYPE, M.PRK_PLCE_IMAGE_DC, M.SYS_NE, M.PARKING_CNTRL_SYS_INSTL_DE, M.RELATION_LAW_AND_ORDINANCES, M.PRK_AVAIL_CARTYPE, M.PRK_CMPRT_CO, M.COLCT_DEVICE_INSTL_AT, M.MASTER_CONTROLLER, M.SLAVE_CONTROLLER, M.COLCT_DEVICE_QTY, M.COLCT_DEVICE_KND, M.COLCT_DEVICE_INSTL_DE, M.CRM_PRV_CCTV_INSTL_AT, M.CRM_PRV_CCTV_INSTL_CO, M.PIS_TYPE, M.INFO_CREATE_TIME ) [15:07:20] DB Error Occured. FILE: PRK0010MF.cpp LINE: 1453 FUNC: TPRK0010M::UpdatePrkPlceImage Title: TPRK0010M::UpdatePrkPlceImage Class: EOleException Error: 매개 변수 개체를 잘못 정의했습니다. 제공된 정보가 일치하지 않거나 완전하지 않습니다 SQL : UPDATE TB_PRK_PLCE SET PRK_PLCE_IMAGE_DATA = :p02 WHERE PRK_PLCE_NMBR = :p01 [15:09:58] DB Error Occured. FILE: PRK0010MF.cpp LINE: 1554 FUNC: TPRK0010M::MergePrkPlceFlr Title: TPRK0010M::MergePrkPlceFlr Class: EOleException Error: TBR-05074 (ERRDT): Given string does not represent a number in proper format SQL : DELETE TB_PRK_PLCE_FLR WHERE PRK_PLCE_NMBR = :p01 AND FLR_NO NOT IN (1F, 2F, 3F) [15:12:13] DB Error Occured. FILE: PRK0010MF.cpp LINE: 1554 FUNC: TPRK0010M::MergePrkPlceFlr Title: TPRK0010M::MergePrkPlceFlr Class: EOleException Error: TBR-04008 (23000): Duplicate unique key found during multi insert SQL : MERGE INTO TB_PRK_PLCE_FLR L USING (SELECT :p01 AS PRK_PLCE_NMBR, :p02 AS FLR_NO, :p03 AS FLR_PRK_CMPRT_CO FROM DUAL) M ON (L.PRK_PLCE_NMBR = M.PRK_PLCE_NMBR) WHEN MATCHED THEN UPDATE SET L.FLR_NO = M.FLR_NO, L.FLR_PRK_CMPRT_CO = M.FLR_PRK_CMPRT_CO WHEN NOT MATCHED THEN INSERT (PRK_PLCE_NMBR, FLR_NO, FLR_PRK_CMPRT_CO ) VALUES (M.PRK_PLCE_NMBR, M.FLR_NO, M.FLR_PRK_CMPRT_CO )