123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196 |
- [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 )
|