API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 21st, 2020
109
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 83.86 KB | None | 0 0
raw download clone embed print report
  1. 2020-01-21 12:35:06.447 DEBUG 63349 --- [nio-9090-exec-7] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL query
  2. 2020-01-21 12:35:06.447 DEBUG 63349 --- [nio-9090-exec-7] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [select ods_secr.set_user(?, true)]
  3. 2020-01-21 12:35:06.473 DEBUG 63349 --- [nio-9090-exec-7] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL query
  4. 2020-01-21 12:35:06.473 DEBUG 63349 --- [nio-9090-exec-7] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [with args as (
  5. select ? :: bigint as type_id,
  6. ST_SetSRID(ST_CollectionHomogenize(ST_Collect(array[
  7. ST_GeomFromGeoJSON(?) :: geometry
  8. , ST_GeomFromGeoJSON(?) :: geometry
  9. , ST_GeomFromGeoJSON(?)
  10. ])),98343) as geometry,
  11. ? :: bigint as id,
  12. ? :: bigint as parentId,
  13. ? :: jsonb as journal,
  14. ? :: int as cnt,
  15. ? :: jsonb as attribute
  16. )
  17. select
  18. (info.v #>> '{allow}')::boolean as isAllow,
  19. ((info.v #>> '{allow}') is not null)::boolean as intersected,
  20. (
  21. select jsonb_agg(jsonb_build_object(
  22. 'id', (item.value::bigint),
  23. 'points', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  24. from (select ((ST_Dump(geo.geometry)).geom) a
  25. from ods_object.object_geometry_v as geo
  26. where geo.id = (item.value::bigint)) a
  27. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'Point'
  28. ),
  29. 'lines', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  30. from (select ((ST_Dump(geo.geometry)).geom) a
  31. from ods_object.object_geometry_v as geo
  32. where geo.id = (item.value::bigint)) a
  33. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'LineString'
  34. ),
  35. 'polygons', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  36. from (select ((ST_Dump(geo.geometry)).geom) a
  37. from ods_object.object_geometry_v as geo
  38. where geo.id = (item.value::bigint)) a
  39. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'Polygon'
  40. )
  41. , 'hint', hi.value
  42. ))
  43. from
  44. jsonb_array_elements_text(info.v -> 'ids') item
  45. , jsonb_each (info.v -> 'object_attribute_hint') hi
  46. where item.value = hi.key
  47. ) as geometry,
  48. (
  49. select jsonb_build_object(
  50. 'points', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  51. from (select ((ST_Dump(args.geometry)).geom) a from args) a
  52. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'Point'
  53. ),
  54. 'lines', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  55. from (select ((ST_Dump(args.geometry)).geom) a from args) a
  56. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'LineString'
  57. ),
  58. 'polygons', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  59. from (select ((ST_Dump(args.geometry)).geom) a from args) a
  60. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'Polygon'
  61. )
  62. )
  63. ) as target
  64. from
  65. (select ods_object.check_geom_contains
  66. ( (select args.type_id from args) --p_object_type_id in ods_object.object.type_id%type
  67. , (select args.geometry from args) --p_geometry in ods_object.object_geometry.geometry%type
  68. , (select args.attribute from args) --p_attribute
  69. , (select args.journal from args) --p_tree_journal in jsonb default null
  70. , (select args.cnt from args) --p_cnt_action in int default null
  71. , (select args.id from args) --p_object_id in ods_object.object.id%type default null
  72. , (select args.parentId from args) --p_object_parent_id in ods_object.object.id%type default null
  73. ) as v) info
  74. ]
  75. 2020-01-21 12:35:07.213 DEBUG 63349 --- [io-9090-exec-10] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL query
  76. 2020-01-21 12:35:07.214 DEBUG 63349 --- [io-9090-exec-10] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [select ods_secr.set_user(?, true)]
  77. 2020-01-21 12:35:07.240 DEBUG 63349 --- [io-9090-exec-10] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL query
  78. 2020-01-21 12:35:07.240 DEBUG 63349 --- [io-9090-exec-10] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [with args as (
  79. select ST_SetSRID(ST_CollectionHomogenize(ST_Collect(array[
  80. ST_GeomFromGeoJSON(?) :: geometry
  81. , ST_GeomFromGeoJSON(?) :: geometry
  82. , ST_GeomFromGeoJSON(?)
  83. ])),98343) as geometry,
  84. ?::bigint as type_id,
  85. ?::bigint as id,
  86. ?::jsonb as attributes,
  87. ?::bigint as treeParentId,
  88. to_timestamp(?, 'DD.MM.YYYY') as startDate
  89. )
  90. select
  91. (info.intersection #>> '{allow}')::boolean as isAllow,
  92. ((info.intersection #>> '{allow}') is not null)::boolean as intersected,
  93. (
  94. select jsonb_agg(jsonb_build_object(
  95. 'id', (item.value::bigint),
  96. 'points', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  97. from (select ((ST_Dump(geo.geometry)).geom) a
  98. from ods_object.object_geometry_v as geo
  99. where geo.id = (item.value::bigint)) a
  100. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'Point'
  101. ),
  102. 'lines', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  103. from (select ((ST_Dump(geo.geometry)).geom) a
  104. from ods_object.object_geometry_v as geo
  105. where geo.id = (item.value::bigint)) a
  106. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'LineString'
  107. ),
  108. 'polygons', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  109. from (select ((ST_Dump(geo.geometry)).geom) a
  110. from ods_object.object_geometry_v as geo
  111. where geo.id = (item.value::bigint)) a
  112. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'Polygon'
  113. )
  114. , 'hint', hi.value
  115. ))
  116. from
  117. jsonb_array_elements_text(info.intersection -> 'ids') item
  118. , jsonb_each (info.intersection -> 'object_attribute_hint') hi
  119. where item.value = hi.key
  120. ) as geometry,
  121. (
  122. select jsonb_build_object(
  123. 'points', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  124. from (select ((ST_Dump(args.geometry)).geom) a from args) a
  125. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'Point'
  126. ),
  127. 'lines', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  128. from (select ((ST_Dump(args.geometry)).geom) a from args) a
  129. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'LineString'
  130. ),
  131. 'polygons', (select jsonb_agg(ST_AsGeoJSON(a.a)::jsonb)
  132. from (select ((ST_Dump(args.geometry)).geom) a from args) a
  133. where ((ST_AsGeoJSON(a.a))::jsonb ->> 'type') = 'Polygon'
  134. )
  135. )
  136. ) as target
  137. from
  138. (select
  139. ods_object.check_geom_intersect(
  140. (select args.geometry from args),
  141. (select args.type_id from args),
  142. (select args.id from args),
  143. (select args.attributes from args),
  144. (select args.treeParentId from args),
  145. (select args.startDate from args))
  146. as intersection) info
  147. ]
  148. 2020-01-21 12:35:07.939 DEBUG 63349 --- [nio-9090-exec-3] o.s.jdbc.core.JdbcTemplate : Executing SQL query [select distinct t_1.code||', expected: '||(
  149. case
  150. when t_1.code in ('bti_object', 'legal_person') then 'NUMBER'
  151. when t_2.code is null then 'NOTHING'
  152. when t_2.value is not null then 'NUMBER'
  153. else upper(t_2.attribute_type)
  154. end
  155. )||', factual: '||t_1.type
  156. from
  157. (
  158. select 'no code'::text as code, 'no type'::text as type
  159. union
  160. select 'section_num' as code, 'NUMBER' as type
  161. union
  162. select 'total_lawn_area' as code, 'NUMBER' as type
  163. union
  164. select 'state_gardening_id' as code, 'OBJECT' as type
  165. union
  166. select 'lawn_type_id' as code, 'OBJECT' as type
  167. union
  168. select 'no_calc' as code, 'NUMBER' as type
  169. union
  170. select 'file_list' as code, 'ARRAY' as type
  171. union
  172. select 'state_gardening' as code, 'NUMBER' as type
  173. union
  174. select 'lawn_type' as code, 'NUMBER' as type
  175. ) t_1 left join ods_dict.dict_general_attribute t_2
  176. on (t_1.code = t_2.code and current_timestamp between t_2.start_date and t_2.end_date)
  177. where
  178. (upper(t_1.type) <> upper(t_2.attribute_type) and t_2.value is not null and upper(t_1.type) <> 'NUMBER') --dictionary
  179. or (upper(t_1.type) <> upper(t_2.attribute_type) and t_2.value is null) --error
  180. or (t_2.code is null and t_1.code <> 'no code') --first row t_1]
  181. 2020-01-21 12:35:07.985 DEBUG 63349 --- [nio-9090-exec-3] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL query
  182. 2020-01-21 12:35:07.985 DEBUG 63349 --- [nio-9090-exec-3] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [select ods_secr.set_user(?, true)]
  183. 2020-01-21 12:35:08.024 DEBUG 63349 --- [nio-9090-exec-3] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [select ods_object.create_object(?, cast(? as jsonb), ?, ? :: jsonb);
  184.  
  185. ]
  186. 2020-01-21 12:35:08.184 DEBUG 63349 --- [nio-9090-exec-3] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL query
  187. 2020-01-21 12:35:08.184 DEBUG 63349 --- [nio-9090-exec-3] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [select ods_object.add_object_geometry(? :: bigint, ? :: bigint,
  188. ST_SetSRID(
  189. ST_CollectionHomogenize(
  190. ST_Collect(
  191. array[ST_GeomFromGeoJSON(?) :: geometry
  192. , ST_GeomFromGeoJSON(?) :: geometry
  193. , ST_GeomFromGeoJSON(?)]
  194. )),
  195. 98343
  196. )
  197. )]
  198. 2020-01-21 12:35:39.536 ERROR 63349 --- [nio-9090-exec-3] r.a.o.c.PostgresExceptionTranslator : Exception occurred: ERROR: {"ids": [270511338], "allow": false, "object_attribute_hint": {"270511338": {"object_attribute_hint": [{"key": "title", "value": "Дворовые территории"}, {"key": "name", "value": "Наименование: ДТ\\Митинская ул. 55"}, {"key": "customer_name", "value": "Заказчик: Жилищник Митино"}, {"key": "owner_name", "value": "Балансодержатель: Жилищник Митино"}, {"key": "ogh_object_type_name", "value": "Дворовые территории"}, {"key": "id_ogh", "value": "ID ОГХ: 270511337"}], "object_attribute_hint_short": [{"key": "name", "value": "ДТ\\Митинская ул. 55"}]}}}
  199. Где: PL/pgSQL function ods_object.add_object_geometry(bigint,bigint,geometry,boolean) line 39 at RAISE
  200. SQL: [select ods_object.add_object_geometry(? :: bigint, ? :: bigint,
  201. ST_SetSRID(
  202. ST_CollectionHomogenize(
  203. ST_Collect(
  204. array[ST_GeomFromGeoJSON(?) :: geometry
  205. , ST_GeomFromGeoJSON(?) :: geometry
  206. , ST_GeomFromGeoJSON(?)]
  207. )),
  208. 98343
  209. )
  210. )]
  211. 2020-01-21 12:35:39.543 ERROR 63349 --- [nio-9090-exec-3] ru.altarix.ods.aop.LoggingAspect : Exception '{"ids": [270511338], "allow": false, "object_attribute_hint": {"270511338": {"object_attribute_hint": [{"key": "title", "value": "Дворовые территории"}, {"key": "name", "value": "Наименование: ДТ\\Митинская ул. 55"}, {"key": "customer_name", "value": "Заказчик: Жилищник Митино"}, {"key": "owner_name", "value": "Балансодержатель: Жилищник Митино"}, {"key": "ogh_object_type_name", "value": "Дворовые территории"}, {"key": "id_ogh", "value": "ID ОГХ: 270511337"}], "object_attribute_hint_short": [{"key": "name", "value": "ДТ\\Митинская ул. 55"}]}}}' in ru.altarix.ods.repository.GeometryRepo.createGeometry()
  212. Args = '[27314221700031, 31, {polygons={"type":"Polygon","coordinates":[[[-9197.865956071428,20863.488272265084],[-9193.905483841398,20863.816936256007],[-9197.612557557211,20858.150399127633],[-9197.865956071428,20863.488272265084]]]}, lines=null, points=null}]'
  213. Cause = 'NULL'
  214.  
  215. ru.altarix.ods.exceptions.BusinessSqlException: {"ids": [270511338], "allow": false, "object_attribute_hint": {"270511338": {"object_attribute_hint": [{"key": "title", "value": "Дворовые территории"}, {"key": "name", "value": "Наименование: ДТ\\Митинская ул. 55"}, {"key": "customer_name", "value": "Заказчик: Жилищник Митино"}, {"key": "owner_name", "value": "Балансодержатель: Жилищник Митино"}, {"key": "ogh_object_type_name", "value": "Дворовые территории"}, {"key": "id_ogh", "value": "ID ОГХ: 270511337"}], "object_attribute_hint_short": [{"key": "name", "value": "ДТ\\Митинская ул. 55"}]}}}
  216. at ru.altarix.ods.config.PostgresExceptionTranslator.customTranslate(PostgresExceptionTranslator.java:45)
  217. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:179)
  218. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
  219. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
  220. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
  221. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
  222. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726)
  223. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:776)
  224. at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:853)
  225. at ru.altarix.ods.repository.GeometryRepo.createGeometry(GeometryRepo.java:22)
  226. at ru.altarix.ods.repository.GeometryRepo$$FastClassBySpringCGLIB$$c7866e48.invoke(<generated>)
  227. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  228. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  229. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  230. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
  231. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  232. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  233. at ru.altarix.ods.aop.LoggingAspect.logAround(LoggingAspect.java:67)
  234. at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
  235. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  236. at java.lang.reflect.Method.invoke(Method.java:498)
  237. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
  238. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
  239. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  240. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  241. at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
  242. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  243. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  244. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  245. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  246. at ru.altarix.ods.repository.GeometryRepo$$EnhancerBySpringCGLIB$$9a27ced5.createGeometry(<generated>)
  247. at ru.altarix.ods.usecases.cards.ObjectManager.create(ObjectManager.java:68)
  248. at ru.altarix.ods.usecases.cards.ObjectManager$$FastClassBySpringCGLIB$$a60b4631.invoke(<generated>)
  249. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  250. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  251. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  252. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  253. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  254. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  255. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  256. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  257. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  258. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  259. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  260. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  261. at ru.altarix.ods.aop.LoggingAspect.logAround(LoggingAspect.java:67)
  262. at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
  263. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  264. at java.lang.reflect.Method.invoke(Method.java:498)
  265. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
  266. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
  267. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  268. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  269. at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
  270. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  271. at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69)
  272. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  273. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  274. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
  275. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  276. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  277. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  278. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  279. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  280. at ru.altarix.ods.usecases.cards.ObjectManager$$EnhancerBySpringCGLIB$$7b2425aa.create(<generated>)
  281. at ru.altarix.ods.web.rest.object.crud.Create.create(Create.java:18)
  282. at ru.altarix.ods.web.rest.object.crud.Create$$FastClassBySpringCGLIB$$4598d45d.invoke(<generated>)
  283. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  284. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  285. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  286. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  287. at ru.altarix.ods.aop.LoggingAspect.logAround(LoggingAspect.java:67)
  288. at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
  289. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  290. at java.lang.reflect.Method.invoke(Method.java:498)
  291. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
  292. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
  293. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  294. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  295. at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
  296. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  297. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  298. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  299. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  300. at ru.altarix.ods.web.rest.object.crud.Create$$EnhancerBySpringCGLIB$$3d0f634.create(<generated>)
  301. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  302. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  303. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  304. at java.lang.reflect.Method.invoke(Method.java:498)
  305. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  306. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  307. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  308. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  309. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  310. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  311. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  312. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  313. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  314. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
  315. at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  316. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  317. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  318. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  319. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  320. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  321. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  322. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  323. at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
  324. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  325. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  326. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  327. at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:110)
  328. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  329. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  330. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  331. at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
  332. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  333. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  334. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  335. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  336. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  337. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  338. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  339. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
  340. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  341. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  342. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  343. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  344. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  345. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  346. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  347. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  348. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  349. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  350. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  351. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  352. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  353. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  354. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  355. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  356. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  357. at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
  358. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  359. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  360. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
  361. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  362. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  363. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  364. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  365. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  366. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  367. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  368. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  369. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  370. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
  371. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
  372. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  373. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  374. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  375. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  376. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  377. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  378. at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
  379. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  380. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  381. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  382. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
  383. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  384. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  385. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  386. at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:167)
  387. at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
  388. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  389. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  390. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  391. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  392. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  393. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  394. at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
  395. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  396. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  397. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  398. at ru.altarix.ods.config.ExcludeSessionRepositoryFilter.doFilterInternal(ExcludeSessionRepositoryFilter.java:30)
  399. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  400. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  401. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  402. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  403. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  404. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  405. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  406. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
  407. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  408. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  409. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
  410. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  411. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
  412. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  413. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  414. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  415. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  416. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  417. at java.lang.Thread.run(Thread.java:748)
  418. Suppressed: org.postgresql.util.PSQLException: ERROR: {"ids": [270511338], "allow": false, "object_attribute_hint": {"270511338": {"object_attribute_hint": [{"key": "title", "value": "Дворовые территории"}, {"key": "name", "value": "Наименование: ДТ\\Митинская ул. 55"}, {"key": "customer_name", "value": "Заказчик: Жилищник Митино"}, {"key": "owner_name", "value": "Балансодержатель: Жилищник Митино"}, {"key": "ogh_object_type_name", "value": "Дворовые территории"}, {"key": "id_ogh", "value": "ID ОГХ: 270511337"}], "object_attribute_hint_short": [{"key": "name", "value": "ДТ\\Митинская ул. 55"}]}}}
  419. Где: PL/pgSQL function ods_object.add_object_geometry(bigint,bigint,geometry,boolean) line 39 at RAISE
  420. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
  421. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
  422. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
  423. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
  424. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
  425. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
  426. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
  427. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
  428. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
  429. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:692)
  430. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
  431. ... 198 common frames omitted
  432.  
  433. 2020-01-21 12:35:39.545 ERROR 63349 --- [nio-9090-exec-3] ru.altarix.ods.aop.LoggingAspect : Exception '{"ids": [270511338], "allow": false, "object_attribute_hint": {"270511338": {"object_attribute_hint": [{"key": "title", "value": "Дворовые территории"}, {"key": "name", "value": "Наименование: ДТ\\Митинская ул. 55"}, {"key": "customer_name", "value": "Заказчик: Жилищник Митино"}, {"key": "owner_name", "value": "Балансодержатель: Жилищник Митино"}, {"key": "ogh_object_type_name", "value": "Дворовые территории"}, {"key": "id_ogh", "value": "ID ОГХ: 270511337"}], "object_attribute_hint_short": [{"key": "name", "value": "ДТ\\Митинская ул. 55"}]}}}' in ru.altarix.ods.usecases.cards.ObjectManager.create()
  434. Args = '[ModifyObject(id=null, rootId=null, type=31, attribute={"section_num":123,"total_lawn_area":123,"state_gardening_id":{"state_gardening":3},"lawn_type_id":{"lawn_type":3},"no_calc":0,"file_list":[]}, calcAttribute=null, treeActions={}, treeCountActions=0, startDate=2021-01-01, endDate=3000-01-01, comment=null, points=null, lines=null, polygons={"type":"Polygon","coordinates":[[[-9197.865956071428,20863.488272265084],[-9193.905483841398,20863.816936256007],[-9197.612557557211,20858.150399127633],[-9197.865956071428,20863.488272265084]]]}, ignoreIntersection=null, reasonId=null, isChild=true, childObjectTypeId=31, oldChildObjectId=0, pathObjectTypeId=31, pathObjectId=null, rootObjectId=27053629800038, rootObjectTypeId=38)]'
  435. Cause = 'NULL'
  436.  
  437. ru.altarix.ods.exceptions.BusinessSqlException: {"ids": [270511338], "allow": false, "object_attribute_hint": {"270511338": {"object_attribute_hint": [{"key": "title", "value": "Дворовые территории"}, {"key": "name", "value": "Наименование: ДТ\\Митинская ул. 55"}, {"key": "customer_name", "value": "Заказчик: Жилищник Митино"}, {"key": "owner_name", "value": "Балансодержатель: Жилищник Митино"}, {"key": "ogh_object_type_name", "value": "Дворовые территории"}, {"key": "id_ogh", "value": "ID ОГХ: 270511337"}], "object_attribute_hint_short": [{"key": "name", "value": "ДТ\\Митинская ул. 55"}]}}}
  438. at ru.altarix.ods.config.PostgresExceptionTranslator.customTranslate(PostgresExceptionTranslator.java:45)
  439. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:179)
  440. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
  441. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
  442. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
  443. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
  444. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726)
  445. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:776)
  446. at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:853)
  447. at ru.altarix.ods.repository.GeometryRepo.createGeometry(GeometryRepo.java:22)
  448. at ru.altarix.ods.repository.GeometryRepo$$FastClassBySpringCGLIB$$c7866e48.invoke(<generated>)
  449. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  450. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  451. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  452. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
  453. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  454. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  455. at ru.altarix.ods.aop.LoggingAspect.logAround(LoggingAspect.java:67)
  456. at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
  457. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  458. at java.lang.reflect.Method.invoke(Method.java:498)
  459. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
  460. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
  461. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  462. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  463. at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
  464. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  465. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  466. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  467. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  468. at ru.altarix.ods.repository.GeometryRepo$$EnhancerBySpringCGLIB$$9a27ced5.createGeometry(<generated>)
  469. at ru.altarix.ods.usecases.cards.ObjectManager.create(ObjectManager.java:68)
  470. at ru.altarix.ods.usecases.cards.ObjectManager$$FastClassBySpringCGLIB$$a60b4631.invoke(<generated>)
  471. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  472. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  473. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  474. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  475. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  476. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  477. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  478. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  479. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  480. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  481. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  482. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  483. at ru.altarix.ods.aop.LoggingAspect.logAround(LoggingAspect.java:67)
  484. at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
  485. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  486. at java.lang.reflect.Method.invoke(Method.java:498)
  487. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
  488. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
  489. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  490. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  491. at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
  492. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  493. at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69)
  494. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  495. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  496. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
  497. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  498. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  499. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  500. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  501. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  502. at ru.altarix.ods.usecases.cards.ObjectManager$$EnhancerBySpringCGLIB$$7b2425aa.create(<generated>)
  503. at ru.altarix.ods.web.rest.object.crud.Create.create(Create.java:18)
  504. at ru.altarix.ods.web.rest.object.crud.Create$$FastClassBySpringCGLIB$$4598d45d.invoke(<generated>)
  505. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  506. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  507. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  508. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  509. at ru.altarix.ods.aop.LoggingAspect.logAround(LoggingAspect.java:67)
  510. at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
  511. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  512. at java.lang.reflect.Method.invoke(Method.java:498)
  513. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
  514. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
  515. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  516. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  517. at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
  518. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  519. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  520. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  521. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  522. at ru.altarix.ods.web.rest.object.crud.Create$$EnhancerBySpringCGLIB$$3d0f634.create(<generated>)
  523. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  524. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  525. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  526. at java.lang.reflect.Method.invoke(Method.java:498)
  527. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  528. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  529. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  530. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  531. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  532. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  533. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  534. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  535. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  536. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
  537. at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  538. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  539. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  540. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  541. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  542. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  543. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  544. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  545. at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
  546. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  547. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  548. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  549. at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:110)
  550. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  551. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  552. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  553. at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
  554. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  555. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  556. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  557. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  558. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  559. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  560. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  561. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
  562. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  563. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  564. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  565. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  566. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  567. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  568. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  569. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  570. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  571. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  572. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  573. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  574. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  575. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  576. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  577. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  578. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  579. at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
  580. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  581. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  582. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
  583. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  584. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  585. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  586. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  587. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  588. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  589. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  590. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  591. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  592. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
  593. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
  594. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  595. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  596. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  597. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  598. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  599. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  600. at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
  601. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  602. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  603. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  604. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
  605. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  606. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  607. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  608. at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:167)
  609. at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
  610. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  611. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  612. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  613. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  614. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  615. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  616. at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
  617. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  618. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  619. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  620. at ru.altarix.ods.config.ExcludeSessionRepositoryFilter.doFilterInternal(ExcludeSessionRepositoryFilter.java:30)
  621. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  622. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  623. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  624. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  625. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  626. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  627. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  628. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
  629. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  630. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  631. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
  632. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  633. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
  634. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  635. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  636. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  637. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  638. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  639. at java.lang.Thread.run(Thread.java:748)
  640. Suppressed: org.postgresql.util.PSQLException: ERROR: {"ids": [270511338], "allow": false, "object_attribute_hint": {"270511338": {"object_attribute_hint": [{"key": "title", "value": "Дворовые территории"}, {"key": "name", "value": "Наименование: ДТ\\Митинская ул. 55"}, {"key": "customer_name", "value": "Заказчик: Жилищник Митино"}, {"key": "owner_name", "value": "Балансодержатель: Жилищник Митино"}, {"key": "ogh_object_type_name", "value": "Дворовые территории"}, {"key": "id_ogh", "value": "ID ОГХ: 270511337"}], "object_attribute_hint_short": [{"key": "name", "value": "ДТ\\Митинская ул. 55"}]}}}
  641. Где: PL/pgSQL function ods_object.add_object_geometry(bigint,bigint,geometry,boolean) line 39 at RAISE
  642. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
  643. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
  644. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
  645. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
  646. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
  647. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
  648. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
  649. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
  650. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
  651. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:692)
  652. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
  653. ... 198 common frames omitted
  654.  
  655. 2020-01-21 12:35:39.582 ERROR 63349 --- [nio-9090-exec-3] ru.altarix.ods.aop.LoggingAspect : Exception '{"ids": [270511338], "allow": false, "object_attribute_hint": {"270511338": {"object_attribute_hint": [{"key": "title", "value": "Дворовые территории"}, {"key": "name", "value": "Наименование: ДТ\\Митинская ул. 55"}, {"key": "customer_name", "value": "Заказчик: Жилищник Митино"}, {"key": "owner_name", "value": "Балансодержатель: Жилищник Митино"}, {"key": "ogh_object_type_name", "value": "Дворовые территории"}, {"key": "id_ogh", "value": "ID ОГХ: 270511337"}], "object_attribute_hint_short": [{"key": "name", "value": "ДТ\\Митинская ул. 55"}]}}}' in ru.altarix.ods.web.rest.object.crud.Create.create()
  656. Args = '[ModifyObject(id=null, rootId=null, type=31, attribute={"section_num":123,"total_lawn_area":123,"state_gardening_id":{"state_gardening":3},"lawn_type_id":{"lawn_type":3},"no_calc":0,"file_list":[]}, calcAttribute=null, treeActions={}, treeCountActions=0, startDate=2021-01-01, endDate=3000-01-01, comment=null, points=null, lines=null, polygons={"type":"Polygon","coordinates":[[[-9197.865956071428,20863.488272265084],[-9193.905483841398,20863.816936256007],[-9197.612557557211,20858.150399127633],[-9197.865956071428,20863.488272265084]]]}, ignoreIntersection=null, reasonId=null, isChild=true, childObjectTypeId=31, oldChildObjectId=0, pathObjectTypeId=31, pathObjectId=null, rootObjectId=27053629800038, rootObjectTypeId=38)]'
  657. Cause = 'NULL'
  658.  
  659. ru.altarix.ods.exceptions.BusinessSqlException: {"ids": [270511338], "allow": false, "object_attribute_hint": {"270511338": {"object_attribute_hint": [{"key": "title", "value": "Дворовые территории"}, {"key": "name", "value": "Наименование: ДТ\\Митинская ул. 55"}, {"key": "customer_name", "value": "Заказчик: Жилищник Митино"}, {"key": "owner_name", "value": "Балансодержатель: Жилищник Митино"}, {"key": "ogh_object_type_name", "value": "Дворовые территории"}, {"key": "id_ogh", "value": "ID ОГХ: 270511337"}], "object_attribute_hint_short": [{"key": "name", "value": "ДТ\\Митинская ул. 55"}]}}}
  660. at ru.altarix.ods.config.PostgresExceptionTranslator.customTranslate(PostgresExceptionTranslator.java:45)
  661. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:179)
  662. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
  663. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
  664. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
  665. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
  666. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726)
  667. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:776)
  668. at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:853)
  669. at ru.altarix.ods.repository.GeometryRepo.createGeometry(GeometryRepo.java:22)
  670. at ru.altarix.ods.repository.GeometryRepo$$FastClassBySpringCGLIB$$c7866e48.invoke(<generated>)
  671. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  672. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  673. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  674. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
  675. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  676. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  677. at ru.altarix.ods.aop.LoggingAspect.logAround(LoggingAspect.java:67)
  678. at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
  679. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  680. at java.lang.reflect.Method.invoke(Method.java:498)
  681. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
  682. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
  683. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  684. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  685. at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
  686. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  687. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  688. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  689. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  690. at ru.altarix.ods.repository.GeometryRepo$$EnhancerBySpringCGLIB$$9a27ced5.createGeometry(<generated>)
  691. at ru.altarix.ods.usecases.cards.ObjectManager.create(ObjectManager.java:68)
  692. at ru.altarix.ods.usecases.cards.ObjectManager$$FastClassBySpringCGLIB$$a60b4631.invoke(<generated>)
  693. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  694. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  695. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  696. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  697. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  698. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  699. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  700. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  701. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  702. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  703. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  704. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  705. at ru.altarix.ods.aop.LoggingAspect.logAround(LoggingAspect.java:67)
  706. at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
  707. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  708. at java.lang.reflect.Method.invoke(Method.java:498)
  709. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
  710. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
  711. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  712. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  713. at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
  714. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  715. at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69)
  716. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  717. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  718. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
  719. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  720. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  721. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  722. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  723. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  724. at ru.altarix.ods.usecases.cards.ObjectManager$$EnhancerBySpringCGLIB$$7b2425aa.create(<generated>)
  725. at ru.altarix.ods.web.rest.object.crud.Create.create(Create.java:18)
  726. at ru.altarix.ods.web.rest.object.crud.Create$$FastClassBySpringCGLIB$$4598d45d.invoke(<generated>)
  727. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  728. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  729. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  730. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  731. at ru.altarix.ods.aop.LoggingAspect.logAround(LoggingAspect.java:67)
  732. at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source)
  733. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  734. at java.lang.reflect.Method.invoke(Method.java:498)
  735. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
  736. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
  737. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  738. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  739. at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
  740. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  741. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  742. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  743. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  744. at ru.altarix.ods.web.rest.object.crud.Create$$EnhancerBySpringCGLIB$$3d0f634.create(<generated>)
  745. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  746. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  747. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  748. at java.lang.reflect.Method.invoke(Method.java:498)
  749. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  750. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  751. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  752. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  753. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  754. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  755. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  756. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  757. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  758. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
  759. at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  760. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  761. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  762. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  763. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  764. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  765. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  766. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  767. at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
  768. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  769. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  770. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  771. at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:110)
  772. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  773. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  774. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  775. at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
  776. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  777. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  778. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  779. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  780. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  781. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  782. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  783. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
  784. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  785. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  786. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  787. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  788. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  789. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  790. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  791. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  792. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  793. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  794. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  795. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  796. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  797. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  798. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  799. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  800. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  801. at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
  802. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  803. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  804. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
  805. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  806. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  807. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  808. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  809. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  810. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  811. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  812. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  813. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  814. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
  815. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
  816. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  817. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  818. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  819. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  820. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  821. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  822. at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
  823. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  824. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  825. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  826. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
  827. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  828. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  829. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  830. at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:167)
  831. at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
  832. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  833. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  834. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  835. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  836. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  837. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  838. at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
  839. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  840. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  841. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  842. at ru.altarix.ods.config.ExcludeSessionRepositoryFilter.doFilterInternal(ExcludeSessionRepositoryFilter.java:30)
  843. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  844. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  845. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  846. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  847. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  848. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  849. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  850. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
  851. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  852. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  853. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
  854. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  855. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
  856. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  857. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  858. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  859. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  860. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  861. at java.lang.Thread.run(Thread.java:748)
  862. Suppressed: org.postgresql.util.PSQLException: ERROR: {"ids": [270511338], "allow": false, "object_attribute_hint": {"270511338": {"object_attribute_hint": [{"key": "title", "value": "Дворовые территории"}, {"key": "name", "value": "Наименование: ДТ\\Митинская ул. 55"}, {"key": "customer_name", "value": "Заказчик: Жилищник Митино"}, {"key": "owner_name", "value": "Балансодержатель: Жилищник Митино"}, {"key": "ogh_object_type_name", "value": "Дворовые территории"}, {"key": "id_ogh", "value": "ID ОГХ: 270511337"}], "object_attribute_hint_short": [{"key": "name", "value": "ДТ\\Митинская ул. 55"}]}}}
  863. Где: PL/pgSQL function ods_object.add_object_geometry(bigint,bigint,geometry,boolean) line 39 at RAISE
  864. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
  865. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
  866. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
  867. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
  868. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
  869. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
  870. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
  871. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
  872. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
  873. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:692)
  874. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
  875. ... 198 common frames omitted
  876.  
  877. 2020-01-21 12:35:42.278 DEBUG 63349 --- [nio-9090-exec-2] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL query
  878. 2020-01-21 12:35:42.279 DEBUG 63349 --- [nio-9090-exec-2] o.s.jdbc.core.JdbcTemplate : Executing prepared SQL statement [select ods_secr.set_user(?, true)]
  879. 2020-01-21 12:35:42.307 DEBUG 63349 --- [nio-9090-exec-2] o.s.jdbc.core.JdbcTemplate : Executing SQL query [select
  880. a.delay_request_count,
  881. b.all_request_count
  882. from
  883. (select
  884. sum(COALESCE(match_entity.get_matching_role(match_entity.get_last_matching(r.matching)) && match_entity.get_user_organization_role(), false)::int) --Те которые я должен согласовать
  885. as delay_request_count
  886. from
  887. ods_req_car.technic_request_v as r
  888. where
  889. now() >= (r.create_date + interval '4 hour')
  890. and
  891. r.state_id = const.technic_req_processed() --На согласовании
  892. ) a,
  893. (select
  894. sum(COALESCE(match_entity.get_matching_role(match_entity.get_last_matching(r.matching)) && match_entity.get_user_organization_role(), false)::int) --Те которые я должен согласовать
  895. as all_request_count
  896. from
  897. ods_req_car.technic_request_v as r
  898. where
  899. r.state_id = const.technic_req_processed() --На согласовании
  900. ) b
  901. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!