ITS_OP_08.err 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196
  1. [14:25:35] DB Error Occured. FILE: CDSPrkPlceF.cpp LINE: 1244 FUNC: TPrkPlceManager::MergePrkPlce
  2. Title: TPrkPlceManager::MergePrkPlce
  3. Class: EOleException
  4. Error:
  5. TBR-11021 (ERREX): Error occurred during type casting
  6. SQL :
  7. MERGE INTO TB_PRK_PLCE L
  8. USING (SELECT
  9. :p01 AS PRK_PLCE_NMBR,
  10. :p02 AS PRK_PLCE_MANAGE_NO,
  11. :p03 AS PRK_PLCE_STTUS_VER,
  12. :p04 AS PRK_PLCE_NM,
  13. :p44 AS VMS_DSPL_NM,
  14. :p05 AS PRK_PLCE_ADRES,
  15. :p06 AS PRK_PLCE_INSTL_DE,
  16. :p07 AS PRK_PLCE_ABL_DE,
  17. :p08 AS PRK_PLCE_ENTRC_NM,
  18. :p09 AS PRK_PLCE_ENTRC_LA,
  19. :p10 AS PRK_PLCE_ENTRC_LO,
  20. :p11 AS PRK_PLCE_ENTRC_EXTTY,
  21. :p12 AS PARKING_TY,
  22. :p13 AS PARKING_US,
  23. :p14 AS AR_LEVEL_SE,
  24. :p15 AS PRK_PLCE_IMAGE_DATA,
  25. :p16 AS PRK_PLCE_IMAGE_TYPE,
  26. :p17 AS PRK_PLCE_IMAGE_DC,
  27. :p18 AS SYS_NE,
  28. :p19 AS PARKING_CNTRL_SYS_INSTL_DE,
  29. :p20 AS RELATION_LAW_AND_ORDINANCES,
  30. :p21 AS PRK_AVAIL_CARTYPE,
  31. :p22 AS PRK_CMPRT_CO,
  32. :p23 AS COLCT_DEVICE_INSTL_AT,
  33. :p24 AS MASTER_CONTROLLER,
  34. :p25 AS SLAVE_CONTROLLER,
  35. :p26 AS COLCT_DEVICE_QTY,
  36. :p27 AS COLCT_DEVICE_KND,
  37. :p34 AS COLCT_DEVICE_INSTL_DE,
  38. :p35 AS CRM_PRV_CCTV_INSTL_AT,
  39. :p36 AS CRM_PRV_CCTV_INSTL_CO,
  40. :p37 AS PIS_TYPE,
  41. :p38 AS INFO_CREATE_TIME
  42. FROM DUAL) M
  43. ON (L.PRK_PLCE_NMBR = M.PRK_PLCE_NMBR)
  44. WHEN MATCHED THEN
  45. UPDATE SET
  46. L.PRK_PLCE_MANAGE_NO = M.PRK_PLCE_MANAGE_NO,
  47. L.PRK_PLCE_STTUS_VER = M.PRK_PLCE_STTUS_VER,
  48. L.PRK_PLCE_NM = M.PRK_PLCE_NM,
  49. L.VMS_DSPL_NM = M.VMS_DSPL_NM,
  50. L.PRK_PLCE_ADRES = M.PRK_PLCE_ADRES,
  51. L.PRK_PLCE_INSTL_DE = M.PRK_PLCE_INSTL_DE,
  52. L.PRK_PLCE_ABL_DE = M.PRK_PLCE_ABL_DE,
  53. L.PRK_PLCE_ENTRC_NM = M.PRK_PLCE_ENTRC_NM,
  54. L.PRK_PLCE_ENTRC_LA = M.PRK_PLCE_ENTRC_LA,
  55. L.PRK_PLCE_ENTRC_LO = M.PRK_PLCE_ENTRC_LO,
  56. L.PRK_PLCE_ENTRC_EXTTY = M.PRK_PLCE_ENTRC_EXTTY,
  57. L.PARKING_TY = M.PARKING_TY,
  58. L.PARKING_US = M.PARKING_US,
  59. L.AR_LEVEL_SE = M.AR_LEVEL_SE,
  60. L.PRK_PLCE_IMAGE_DATA = M.PRK_PLCE_IMAGE_DATA,
  61. L.PRK_PLCE_IMAGE_TYPE = M.PRK_PLCE_IMAGE_TYPE,
  62. L.PRK_PLCE_IMAGE_DC = M.PRK_PLCE_IMAGE_DC,
  63. L.SYS_NE = M.SYS_NE,
  64. L.PARKING_CNTRL_SYS_INSTL_DE = M.PARKING_CNTRL_SYS_INSTL_DE,
  65. L.RELATION_LAW_AND_ORDINANCES = M.RELATION_LAW_AND_ORDINANCES,
  66. L.PRK_AVAIL_CARTYPE = M.PRK_AVAIL_CARTYPE,
  67. L.PRK_CMPRT_CO = M.PRK_CMPRT_CO,
  68. L.COLCT_DEVICE_INSTL_AT = M.COLCT_DEVICE_INSTL_AT,
  69. L.MASTER_CONTROLLER = M.MASTER_CONTROLLER,
  70. L.SLAVE_CONTROLLER = M.SLAVE_CONTROLLER,
  71. L.COLCT_DEVICE_QTY = M.COLCT_DEVICE_QTY,
  72. L.COLCT_DEVICE_KND = M.COLCT_DEVICE_KND,
  73. L.COLCT_DEVICE_INSTL_DE = M.COLCT_DEVICE_INSTL_DE,
  74. L.CRM_PRV_CCTV_INSTL_AT = M.CRM_PRV_CCTV_INSTL_AT,
  75. L.CRM_PRV_CCTV_INSTL_CO = M.CRM_PRV_CCTV_INSTL_CO,
  76. L.PIS_TYPE = M.PIS_TYPE,
  77. L.INFO_CREATE_TIME = M.INFO_CREATE_TIME
  78. WHEN NOT MATCHED THEN
  79. INSERT (
  80. PRK_PLCE_NMBR,
  81. PRK_PLCE_MANAGE_NO,
  82. PRK_PLCE_STTUS_VER,
  83. PRK_PLCE_NM,
  84. VMS_DSPL_NM,
  85. PRK_PLCE_ADRES,
  86. PRK_PLCE_INSTL_DE,
  87. PRK_PLCE_ABL_DE,
  88. PRK_PLCE_ENTRC_NM,
  89. PRK_PLCE_ENTRC_LA,
  90. PRK_PLCE_ENTRC_LO,
  91. PRK_PLCE_ENTRC_EXTTY,
  92. PARKING_TY,
  93. PARKING_US,
  94. AR_LEVEL_SE,
  95. PRK_PLCE_IMAGE_DATA,
  96. PRK_PLCE_IMAGE_TYPE,
  97. PRK_PLCE_IMAGE_DC,
  98. SYS_NE,
  99. PARKING_CNTRL_SYS_INSTL_DE,
  100. RELATION_LAW_AND_ORDINANCES,
  101. PRK_AVAIL_CARTYPE,
  102. PRK_CMPRT_CO,
  103. COLCT_DEVICE_INSTL_AT,
  104. MASTER_CONTROLLER,
  105. SLAVE_CONTROLLER,
  106. COLCT_DEVICE_QTY,
  107. COLCT_DEVICE_KND,
  108. COLCT_DEVICE_INSTL_DE,
  109. CRM_PRV_CCTV_INSTL_AT,
  110. CRM_PRV_CCTV_INSTL_CO,
  111. PIS_TYPE,
  112. INFO_CREATE_TIME )
  113. VALUES (
  114. M.PRK_PLCE_NMBR,
  115. M.PRK_PLCE_MANAGE_NO,
  116. M.PRK_PLCE_STTUS_VER,
  117. M.PRK_PLCE_NM,
  118. M.VMS_DSPL_NM,
  119. M.PRK_PLCE_ADRES,
  120. M.PRK_PLCE_INSTL_DE,
  121. M.PRK_PLCE_ABL_DE,
  122. M.PRK_PLCE_ENTRC_NM,
  123. M.PRK_PLCE_ENTRC_LA,
  124. M.PRK_PLCE_ENTRC_LO,
  125. M.PRK_PLCE_ENTRC_EXTTY,
  126. M.PARKING_TY,
  127. M.PARKING_US,
  128. M.AR_LEVEL_SE,
  129. M.PRK_PLCE_IMAGE_DATA,
  130. M.PRK_PLCE_IMAGE_TYPE,
  131. M.PRK_PLCE_IMAGE_DC,
  132. M.SYS_NE,
  133. M.PARKING_CNTRL_SYS_INSTL_DE,
  134. M.RELATION_LAW_AND_ORDINANCES,
  135. M.PRK_AVAIL_CARTYPE,
  136. M.PRK_CMPRT_CO,
  137. M.COLCT_DEVICE_INSTL_AT,
  138. M.MASTER_CONTROLLER,
  139. M.SLAVE_CONTROLLER,
  140. M.COLCT_DEVICE_QTY,
  141. M.COLCT_DEVICE_KND,
  142. M.COLCT_DEVICE_INSTL_DE,
  143. M.CRM_PRV_CCTV_INSTL_AT,
  144. M.CRM_PRV_CCTV_INSTL_CO,
  145. M.PIS_TYPE,
  146. M.INFO_CREATE_TIME )
  147. [15:07:20] DB Error Occured. FILE: PRK0010MF.cpp LINE: 1453 FUNC: TPRK0010M::UpdatePrkPlceImage
  148. Title: TPRK0010M::UpdatePrkPlceImage
  149. Class: EOleException
  150. Error: 매개 변수 개체를 잘못 정의했습니다. 제공된 정보가 일치하지 않거나 완전하지 않습니다
  151. SQL :
  152. UPDATE TB_PRK_PLCE
  153. SET PRK_PLCE_IMAGE_DATA = :p02
  154. WHERE PRK_PLCE_NMBR = :p01
  155. [15:09:58] DB Error Occured. FILE: PRK0010MF.cpp LINE: 1554 FUNC: TPRK0010M::MergePrkPlceFlr
  156. Title: TPRK0010M::MergePrkPlceFlr
  157. Class: EOleException
  158. Error:
  159. TBR-05074 (ERRDT): Given string does not represent a number in proper format
  160. SQL :
  161. DELETE TB_PRK_PLCE_FLR
  162. WHERE PRK_PLCE_NMBR = :p01
  163. AND FLR_NO NOT IN (1F, 2F, 3F)
  164. [15:12:13] DB Error Occured. FILE: PRK0010MF.cpp LINE: 1554 FUNC: TPRK0010M::MergePrkPlceFlr
  165. Title: TPRK0010M::MergePrkPlceFlr
  166. Class: EOleException
  167. Error:
  168. TBR-04008 (23000): Duplicate unique key found during multi insert
  169. SQL :
  170. MERGE INTO TB_PRK_PLCE_FLR L
  171. USING (SELECT :p01 AS PRK_PLCE_NMBR,
  172. :p02 AS FLR_NO,
  173. :p03 AS FLR_PRK_CMPRT_CO
  174. FROM DUAL) M
  175. ON (L.PRK_PLCE_NMBR = M.PRK_PLCE_NMBR)
  176. WHEN MATCHED THEN
  177. UPDATE SET L.FLR_NO = M.FLR_NO,
  178. L.FLR_PRK_CMPRT_CO = M.FLR_PRK_CMPRT_CO
  179. WHEN NOT MATCHED THEN
  180. INSERT (PRK_PLCE_NMBR,
  181. FLR_NO,
  182. FLR_PRK_CMPRT_CO )
  183. VALUES (M.PRK_PLCE_NMBR,
  184. M.FLR_NO,
  185. M.FLR_PRK_CMPRT_CO )