API tools faq
paste
Advertisement
Alex_cooler

Untitled

Alex_cooler
Aug 17th, 2016
103
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 126.75 KB | None | 0 0
raw download clone embed print report
  1. Hibernate:
  2. select
  3. this_.SITE_ID as SITE_ID1_107_0_,
  4. this_.AUTOSTART as AUTOSTART2_107_0_,
  5. this_.DB_SYNC as DB_SYNC3_107_0_,
  6. this_.TP as TP4_107_0_,
  7. this_.GI as GI5_107_0_,
  8. this_.HTNG as HTNG6_107_0_,
  9. this_.INQ_TM as INQ_TM7_107_0_,
  10. this_.IP as IP8_107_0_,
  11. this_.LOCATION as LOCATION9_107_0_,
  12. this_.NAME as NAME10_107_0_,
  13. this_.OPTIONS as OPTIONS11_107_0_,
  14. this_.PMS_PROPERTY as PMS_PROPERTY12_107_0_,
  15. this_.PORT as PORT13_107_0_,
  16. this_.SITE_KEY as SITE_KEY14_107_0_,
  17. this_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_0_,
  18. this_.V8IFC as V15_107_0_
  19. from
  20. club.SITES this_
  21. 17.08.16 15:04:39:405 - INFO - TngLogger - 2016-08-17 15:04:39.405 - INFO - FiasService(627672168).receive: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Receive LS|DA160817|TI140439|
  22. 17.08.16 15:04:39:410 - INFO - TngLogger - 2016-08-17 15:04:39.409 - INFO - FiasService(627672168).receive: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Check timeout. Current: 1471431879409 End time: 1471431893388
  23. 17.08.16 15:04:39:411 - INFO - TngLogger - 2016-08-17 15:04:39.411 - INFO - FiasService(627672168).linkStart: Send Link Start, Link Record, LA
  24. 17.08.16 15:04:39:411 - INFO - FiasService - linkDescription send: LD|DA160817|TI150439|V#1.0|IFVI|RT183|
  25. 17.08.16 15:04:39:412 - INFO - TngLogger - 2016-08-17 15:04:39.412 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LD|DA160817|TI150439|V#1.0|IFVI|RT183|
  26. 17.08.16 15:04:39:414 - INFO - FiasService - linkDescription ret: LD
  27. 17.08.16 15:04:39:414 - INFO - FiasService - strLinkRecord send: LR|RIPR|FLPIWSP#MXSOIDPMDATIG#GNRNTAC#CVD1D2D3D4D5D6D7D8D9S1S2S3S4S5S6S7S8S9SCT1T2T3T4T5T6T7T8T9TPCO|
  28. 17.08.16 15:04:39:414 - INFO - TngLogger - 2016-08-17 15:04:39.414 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIPR|FLPIWSP#MXSOIDPMDATIG#GNRNTAC#CVD1D2D3D4D5D6D7D8D9S1S2S3S4S5S6S7S8S9SCT1T2T3T4T5T6T7T8T9TPCO|
  29. 17.08.16 15:04:39:415 - INFO - FiasService - strLinkRecord send: LR|RIPL|FLRNG#GNWSP#|
  30. 17.08.16 15:04:39:416 - INFO - TngLogger - 2016-08-17 15:04:39.416 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIPL|FLRNG#GNWSP#|
  31. 17.08.16 15:04:39:416 - INFO - FiasService - strLinkRecord send: LR|RIPA|FLASCTWSP#DATI|
  32. 17.08.16 15:04:39:416 - INFO - TngLogger - 2016-08-17 15:04:39.416 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIPA|FLASCTWSP#DATI|
  33. 17.08.16 15:04:39:417 - INFO - FiasService - strLinkRecord send: LR|RIXR|FLRNG#|
  34. 17.08.16 15:04:39:417 - INFO - TngLogger - 2016-08-17 15:04:39.417 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIXR|FLRNG#|
  35. 17.08.16 15:04:39:417 - INFO - FiasService - strLinkRecord send: LR|RIXI|FLBDBIDCG#RNF#FD|
  36. 17.08.16 15:04:39:418 - INFO - TngLogger - 2016-08-17 15:04:39.418 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIXI|FLBDBIDCG#RNF#FD|
  37. 17.08.16 15:04:39:418 - INFO - FiasService - strLinkRecord send: LR|RIXB|FLBAG#RNAS|
  38. 17.08.16 15:04:39:418 - INFO - TngLogger - 2016-08-17 15:04:39.418 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIXB|FLBAG#RNAS|
  39. 17.08.16 15:04:39:419 - INFO - FiasService - strLinkRecord send: LR|RIGI|FLG#GAGDG+GFGNGVRNCSWSA0A1A2A3A4A5A6A7A8A9NPSFDATI|
  40. 17.08.16 15:04:39:419 - INFO - TngLogger - 2016-08-17 15:04:39.419 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIGI|FLG#GAGDG+GFGNGVRNCSWSA0A1A2A3A4A5A6A7A8A9NPSFDATI|
  41. 17.08.16 15:04:39:419 - INFO - FiasService - strLinkRecord send: LR|RIGO|FLG#RNWSSFDATI|
  42. 17.08.16 15:04:39:419 - INFO - TngLogger - 2016-08-17 15:04:39.419 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIGO|FLG#RNWSSFDATI|
  43. 17.08.16 15:04:39:420 - INFO - FiasService - strLinkRecord send: LR|RIGC|FLG#GAGDG+GFGNGVRNCSWSA0A1A2A3A4A5A6A7A8A9NPROSFDATI|
  44. 17.08.16 15:04:39:420 - INFO - TngLogger - 2016-08-17 15:04:39.420 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIGC|FLG#GAGDG+GFGNGVRNCSWSA0A1A2A3A4A5A6A7A8A9NPROSFDATI|
  45. 17.08.16 15:04:39:420 - INFO - FiasService - strLinkRecord send: LR|RIDR|FLDATI|
  46. 17.08.16 15:04:39:420 - INFO - TngLogger - 2016-08-17 15:04:39.420 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIDR|FLDATI|
  47. 17.08.16 15:04:39:420 - INFO - FiasService - strLinkRecord send: LR|RIDS|FLDATI|
  48. 17.08.16 15:04:39:421 - INFO - TngLogger - 2016-08-17 15:04:39.421 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIDS|FLDATI|
  49. 17.08.16 15:04:39:421 - INFO - FiasService - strLinkRecord send: LR|RIDE|FLDATI|
  50. 17.08.16 15:04:39:421 - INFO - TngLogger - 2016-08-17 15:04:39.421 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LR|RIDE|FLDATI|
  51. 17.08.16 15:04:39:422 - INFO - TngLogger - 2016-08-17 15:04:39.421 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LA|DA160817|TI150439|
  52. 17.08.16 15:04:40:422 - INFO - TngLogger - 2016-08-17 15:04:40.422 - INFO - FiasService(627672168).receive: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Check timeout. Current: 1471431880422 End time: 1471431894422
  53. 17.08.16 15:04:41:436 - INFO - TngLogger - 2016-08-17 15:04:41.436 - INFO - FiasService(627672168).receive: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Receive LC|DA160817|TI140441|RPROOM|PH1|A040;16|A18.9.6.10|A28.9.6.10|A35.45|LA|DA160817|TI140441|
  54. 17.08.16 15:04:41:437 - INFO - TngLogger - 2016-08-17 15:04:41.437 - INFO - FiasService(627672168).receive: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Check timeout. Current: 1471431881437 End time: 1471431894422
  55. 17.08.16 15:04:41:438 - INFO - FiasService - strLinkAlive FINISH LinkStart ret: LC|DA160817|TI140441|RPROOM|PH1|A040;16|A18.9.6.10|A28.9.6.10|A35.45|LA|DA160817|TI140441|
  56. Hibernate:
  57. select
  58. site0_.SITE_ID as SITE_ID1_107_,
  59. site0_.AUTOSTART as AUTOSTART2_107_,
  60. site0_.DB_SYNC as DB_SYNC3_107_,
  61. site0_.TP as TP4_107_,
  62. site0_.GI as GI5_107_,
  63. site0_.HTNG as HTNG6_107_,
  64. site0_.INQ_TM as INQ_TM7_107_,
  65. site0_.IP as IP8_107_,
  66. site0_.LOCATION as LOCATION9_107_,
  67. site0_.NAME as NAME10_107_,
  68. site0_.OPTIONS as OPTIONS11_107_,
  69. site0_.PMS_PROPERTY as PMS_PROPERTY12_107_,
  70. site0_.PORT as PORT13_107_,
  71. site0_.SITE_KEY as SITE_KEY14_107_,
  72. site0_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_,
  73. site0_.V8IFC as V15_107_
  74. from
  75. club.SITES site0_
  76. where
  77. (
  78. upper(site0_.SITE_KEY)=?
  79. )
  80. 17.08.16 15:04:42:312 - INFO - TngLogger - 2016-08-17 15:04:42.312 - INFO - FIAS_postings(869457972).FIAS_postings: Set IfcPostingsService: -1111934407
  81. 17.08.16 15:04:42:313 - INFO - TngLogger - 2016-08-17 15:04:42.313 - INFO - FIAS_postings(869457972).FIAS_postings: Complete IfcPostingsService: -1111934407
  82. 17.08.16 15:04:42:313 - INFO - TngLogger - 2016-08-17 15:04:42.313 - INFO - FIAS_postings(869457972).FIAS_postings: Start FIAS_postings
  83. 17.08.16 15:04:42:314 - INFO - FiasService - *** linkStart START FIAS_reader ***
  84. FiasService Run Service Tread
  85. FiasService Run Service Tread ft.isStarted=false
  86. FiasService Runing Service Tread
  87. 17.08.16 15:04:42:317 - INFO - TngLogger - 2016-08-17 15:04:42.317 - INFO - FiasService(627672168).dbSync_onStartIFC: Start DB Swap on Start FIAS for site: 1000
  88. 17.08.16 15:04:44:318 - INFO - TngLogger - 2016-08-17 15:04:44.318 - INFO - FiasService(627672168).checkConnection: Send LS for check socket by 1000
  89. 17.08.16 15:04:44:322 - INFO - TngLogger - 2016-08-17 15:04:44.322 - INFO - FiasService(627672168).send: From:/192.168.170.49:50234 to:/192.168.172.23:5005 Send: LS|DA160817|TI150444|
  90. 17.08.16 15:04:44:576 - INFO - TngLogger - 2016-08-17 15:04:44.576 - INFO - FIAS_reader(1974376518).run: Read message :LA|DA160817|TI140445|
  91. 17.08.16 15:04:44:579 - INFO - TngLogger - 2016-08-17 15:04:44.577 - INFO - FiasService(627672168).checkConnection: Receive LA. Socket checked.
  92. 17.08.16 15:04:52:318 - INFO - TngLogger - 2016-08-17 15:04:52.318 - INFO - FiasService(627672168).sendDR: DB Resync 1000
  93. Hibernate:
  94. select
  95. site0_.SITE_ID as SITE_ID1_107_,
  96. site0_.AUTOSTART as AUTOSTART2_107_,
  97. site0_.DB_SYNC as DB_SYNC3_107_,
  98. site0_.TP as TP4_107_,
  99. site0_.GI as GI5_107_,
  100. site0_.HTNG as HTNG6_107_,
  101. site0_.INQ_TM as INQ_TM7_107_,
  102. site0_.IP as IP8_107_,
  103. site0_.LOCATION as LOCATION9_107_,
  104. site0_.NAME as NAME10_107_,
  105. site0_.OPTIONS as OPTIONS11_107_,
  106. site0_.PMS_PROPERTY as PMS_PROPERTY12_107_,
  107. site0_.PORT as PORT13_107_,
  108. site0_.SITE_KEY as SITE_KEY14_107_,
  109. site0_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_,
  110. site0_.V8IFC as V15_107_
  111. from
  112. club.SITES site0_
  113. where
  114. (
  115. upper(site0_.SITE_KEY)=?
  116. )
  117. Hibernate:
  118. select
  119. jrndbsync0_.ID as ID1_71_,
  120. jrndbsync0_.SITE_ID as SITE_ID4_71_,
  121. jrndbsync0_.SYNC_END as SYNC_END2_71_,
  122. jrndbsync0_.SYNC_START as SYNC_START3_71_
  123. from
  124. club.JRN_DBSYNC jrndbsync0_
  125. where
  126. (
  127. id in(
  128. select
  129. jrndbsync1_.ID
  130. from
  131. club.JRN_DBSYNC jrndbsync1_
  132. where
  133. (
  134. SYNC_START is null
  135. )
  136. AND(
  137. SYNC_END is null
  138. )
  139. AND(
  140. SITE_ID=?
  141. )
  142. )
  143. )
  144. Hibernate:
  145. select
  146. site0_.SITE_ID as SITE_ID1_107_0_,
  147. site0_.AUTOSTART as AUTOSTART2_107_0_,
  148. site0_.DB_SYNC as DB_SYNC3_107_0_,
  149. site0_.TP as TP4_107_0_,
  150. site0_.GI as GI5_107_0_,
  151. site0_.HTNG as HTNG6_107_0_,
  152. site0_.INQ_TM as INQ_TM7_107_0_,
  153. site0_.IP as IP8_107_0_,
  154. site0_.LOCATION as LOCATION9_107_0_,
  155. site0_.NAME as NAME10_107_0_,
  156. site0_.OPTIONS as OPTIONS11_107_0_,
  157. site0_.PMS_PROPERTY as PMS_PROPERTY12_107_0_,
  158. site0_.PORT as PORT13_107_0_,
  159. site0_.SITE_KEY as SITE_KEY14_107_0_,
  160. site0_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_0_,
  161. site0_.V8IFC as V15_107_0_
  162. from
  163. club.SITES site0_
  164. where
  165. site0_.SITE_ID=?
  166. Hibernate:
  167. select
  168. jrndbsync0_.ID as ID1_71_,
  169. jrndbsync0_.SITE_ID as SITE_ID4_71_,
  170. jrndbsync0_.SYNC_END as SYNC_END2_71_,
  171. jrndbsync0_.SYNC_START as SYNC_START3_71_
  172. from
  173. club.JRN_DBSYNC jrndbsync0_
  174. where
  175. (
  176. id=(
  177. select
  178. jrndbsync1_.ID
  179. from
  180. club.JRN_DBSYNC jrndbsync1_
  181. where
  182. (
  183. SYNC_START is not null
  184. )
  185. AND(
  186. SYNC_END is null
  187. )
  188. AND(
  189. SITE_ID=?
  190. )
  191. )
  192. )
  193. 17.08.16 15:04:52:475 - INFO - TngLogger - 2016-08-17 15:04:52.475 - INFO - FiasService(627672168).dbSync_onStartIFC: DB Swap for site: 1000 Return: Resync not started: Previous resync not completed :Sync waiting for service started ...
  194. Hibernate:
  195. select
  196. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  197. system0_.VALUE as VALUE2_114_0_
  198. from
  199. club.SYSTEM system0_
  200. where
  201. system0_.PARAM_NAME=?
  202. Hibernate:
  203. select
  204. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  205. system0_.VALUE as VALUE2_114_0_
  206. from
  207. club.SYSTEM system0_
  208. where
  209. system0_.PARAM_NAME=?
  210. Hibernate:
  211. select
  212. currency0_.CURRENCY_ID as CURRENCY_ID1_39_,
  213. currency0_.BASE as BASE2_39_,
  214. currency0_.DECIMAL_CHAR as DECIMAL_CHAR3_39_,
  215. currency0_.DGT_GROUP_CHAR as DGT_GROUP_CHAR4_39_,
  216. currency0_.ISO_CODE as ISO_CODE5_39_,
  217. currency0_.NAME as NAME6_39_,
  218. currency0_.PRINT_PREFIX as PRINT_PREFIX7_39_,
  219. currency0_.PRINT_SUFFIX as PRINT_SUFFIX8_39_,
  220. currency0_.RATE as RATE9_39_,
  221. currency0_.SCALE as SCALE10_39_
  222. from
  223. club.CURRENCY currency0_
  224. where
  225. (
  226. base=1
  227. )
  228. Hibernate:
  229. select
  230. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  231. system0_.VALUE as VALUE2_114_0_
  232. from
  233. club.SYSTEM system0_
  234. where
  235. system0_.PARAM_NAME=?
  236. Hibernate:
  237. select
  238. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  239. system0_.VALUE as VALUE2_114_0_
  240. from
  241. club.SYSTEM system0_
  242. where
  243. system0_.PARAM_NAME=?
  244. Hibernate:
  245. select
  246. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  247. system0_.VALUE as VALUE2_114_0_
  248. from
  249. club.SYSTEM system0_
  250. where
  251. system0_.PARAM_NAME=?
  252. Hibernate:
  253. select
  254. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  255. system0_.VALUE as VALUE2_114_0_
  256. from
  257. club.SYSTEM system0_
  258. where
  259. system0_.PARAM_NAME=?
  260. Hibernate:
  261. select
  262. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  263. system0_.VALUE as VALUE2_114_0_
  264. from
  265. club.SYSTEM system0_
  266. where
  267. system0_.PARAM_NAME=?
  268. Hibernate:
  269. select
  270. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  271. system0_.VALUE as VALUE2_114_0_
  272. from
  273. club.SYSTEM system0_
  274. where
  275. system0_.PARAM_NAME=?
  276. Hibernate:
  277. select
  278. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  279. system0_.VALUE as VALUE2_114_0_
  280. from
  281. club.SYSTEM system0_
  282. where
  283. system0_.PARAM_NAME=?
  284. Hibernate:
  285. select
  286. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  287. system0_.VALUE as VALUE2_114_0_
  288. from
  289. club.SYSTEM system0_
  290. where
  291. system0_.PARAM_NAME=?
  292. Hibernate:
  293. select
  294. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  295. system0_.VALUE as VALUE2_114_0_
  296. from
  297. club.SYSTEM system0_
  298. where
  299. system0_.PARAM_NAME=?
  300. Hibernate:
  301. select
  302. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  303. system0_.VALUE as VALUE2_114_0_
  304. from
  305. club.SYSTEM system0_
  306. where
  307. system0_.PARAM_NAME=?
  308. Hibernate:
  309. select
  310. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  311. system0_.VALUE as VALUE2_114_0_
  312. from
  313. club.SYSTEM system0_
  314. where
  315. system0_.PARAM_NAME=?
  316. Hibernate:
  317. select
  318. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  319. system0_.VALUE as VALUE2_114_0_
  320. from
  321. club.SYSTEM system0_
  322. where
  323. system0_.PARAM_NAME=?
  324. Hibernate:
  325. select
  326. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  327. system0_.VALUE as VALUE2_114_0_
  328. from
  329. club.SYSTEM system0_
  330. where
  331. system0_.PARAM_NAME=?
  332. Hibernate:
  333. select
  334. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  335. system0_.VALUE as VALUE2_114_0_
  336. from
  337. club.SYSTEM system0_
  338. where
  339. system0_.PARAM_NAME=?
  340. Hibernate:
  341. select
  342. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  343. system0_.VALUE as VALUE2_114_0_
  344. from
  345. club.SYSTEM system0_
  346. where
  347. system0_.PARAM_NAME=?
  348. Hibernate:
  349. select
  350. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  351. system0_.VALUE as VALUE2_114_0_
  352. from
  353. club.SYSTEM system0_
  354. where
  355. system0_.PARAM_NAME=?
  356. Hibernate:
  357. select
  358. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  359. system0_.VALUE as VALUE2_114_0_
  360. from
  361. club.SYSTEM system0_
  362. where
  363. system0_.PARAM_NAME=?
  364. Hibernate:
  365. select
  366. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  367. system0_.VALUE as VALUE2_114_0_
  368. from
  369. club.SYSTEM system0_
  370. where
  371. system0_.PARAM_NAME=?
  372. Hibernate:
  373. select
  374. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  375. system0_.VALUE as VALUE2_114_0_
  376. from
  377. club.SYSTEM system0_
  378. where
  379. system0_.PARAM_NAME=?
  380. Hibernate:
  381. select
  382. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  383. system0_.VALUE as VALUE2_114_0_
  384. from
  385. club.SYSTEM system0_
  386. where
  387. system0_.PARAM_NAME=?
  388. Hibernate:
  389. select
  390. *
  391. from
  392. ( select
  393. this_.DOC_ID as DOC_ID1_42_0_,
  394. this_.BUSSINES_DATE as BUSSINES_DATE2_42_0_,
  395. this_.DEF_CARD_ID as DEF_CARD_ID3_42_0_,
  396. this_.DEF_CARD_TYPE_ID as DEF_CARD_TYPE_ID4_42_0_,
  397. this_.CHCK_ID as CHCK_ID5_42_0_,
  398. this_.CHECK_OPEN as CHECK_OPEN6_42_0_,
  399. this_.CHKNUM as CHKNUM7_42_0_,
  400. this_.COFIRMATION as COFIRMATION8_42_0_,
  401. this_.DOC_TYPE as DOC_TYPE9_42_0_,
  402. this_.GST as GST10_42_0_,
  403. this_.IMAGE as IMAGE11_42_0_,
  404. this_.INVOICE_ID as INVOICE_ID20_42_0_,
  405. this_.DEF_MAGSTRIPE as DEF_MAGSTRIPE12_42_0_,
  406. this_.OPERATOR as OPERATOR13_42_0_,
  407. this_.REGISTRATION_ID as REGISTRATION_ID21_42_0_,
  408. this_.RVC as RVC22_42_0_,
  409. this_.SP as SP14_42_0_,
  410. this_.TAX_EXEMPT as TAX_EXEMPT15_42_0_,
  411. this_.TICKET_ID as TICKET_ID23_42_0_,
  412. this_.TM as TM16_42_0_,
  413. this_.TM_OPEN as TM_OPEN17_42_0_,
  414. this_.TTL as TTL18_42_0_,
  415. this_.VER as VER19_42_0_
  416. from
  417. club.DOCS this_
  418. where
  419. this_.DOC_TYPE=?
  420. order by
  421. this_.BUSSINES_DATE desc )
  422. where
  423. rownum <= ?
  424. 17.08.16 15:04:52:804 - INFO - EndOfDayJob - next exec: Thu Aug 18 06:00:00 GST 2016
  425. 17.08.16 15:04:53:260 - INFO - SaajSoapMessageFactory - Creating SAAJ 1.3 MessageFactory with SOAP 1.1 Protocol
  426. 17.08.16 15:04:53:970 - INFO - SpringViewProvider - Looking up SpringViews
  427. 17.08.16 15:04:54:266 - INFO - SpringViewProvider - 3 SpringViews found
  428. 17.08.16 15:04:54:280 - INFO - ContextLoader - Root WebApplicationContext: initialization completed in 61366 ms
  429. 17.08.16 15:05:01:622 - INFO - ContextLoader - Root WebApplicationContext: initialization started
  430. 17.08.16 15:05:01:785 - INFO - AbstractApplicationContext - Refreshing Root WebApplicationContext: startup date [Wed Aug 17 15:05:01 GST 2016]; root of context hierarchy
  431. 17.08.16 15:05:01:861 - INFO - XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
  432. Hibernate:
  433. select
  434. jrndbsync0_.ID as ID1_71_,
  435. jrndbsync0_.SITE_ID as SITE_ID4_71_,
  436. jrndbsync0_.SYNC_END as SYNC_END2_71_,
  437. jrndbsync0_.SYNC_START as SYNC_START3_71_
  438. from
  439. club.JRN_DBSYNC jrndbsync0_
  440. where
  441. (
  442. SYNC_END is null
  443. )
  444. Hibernate:
  445. select
  446. site0_.SITE_ID as SITE_ID1_107_0_,
  447. site0_.AUTOSTART as AUTOSTART2_107_0_,
  448. site0_.DB_SYNC as DB_SYNC3_107_0_,
  449. site0_.TP as TP4_107_0_,
  450. site0_.GI as GI5_107_0_,
  451. site0_.HTNG as HTNG6_107_0_,
  452. site0_.INQ_TM as INQ_TM7_107_0_,
  453. site0_.IP as IP8_107_0_,
  454. site0_.LOCATION as LOCATION9_107_0_,
  455. site0_.NAME as NAME10_107_0_,
  456. site0_.OPTIONS as OPTIONS11_107_0_,
  457. site0_.PMS_PROPERTY as PMS_PROPERTY12_107_0_,
  458. site0_.PORT as PORT13_107_0_,
  459. site0_.SITE_KEY as SITE_KEY14_107_0_,
  460. site0_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_0_,
  461. site0_.V8IFC as V15_107_0_
  462. from
  463. club.SITES site0_
  464. where
  465. site0_.SITE_ID=?
  466. Hibernate:
  467. select
  468. ifcposting0_.ID as ID1_58_,
  469. ifcposting0_.ADDRESS as ADDRESS2_58_,
  470. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  471. ifcposting0_.COMPLETE as COMPLETE4_58_,
  472. ifcposting0_.DOC_ID as DOC_ID5_58_,
  473. ifcposting0_.ERR as ERR6_58_,
  474. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  475. ifcposting0_.PORT as PORT8_58_,
  476. ifcposting0_.POSTING as POSTING9_58_,
  477. ifcposting0_.SEQ as SEQ10_58_,
  478. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  479. ifcposting0_.TM as TM12_58_,
  480. ifcposting0_.TP as TP13_58_
  481. from
  482. club.IFC_POSTINGS ifcposting0_
  483. where
  484. (
  485. trim(ADDRESS)is not null
  486. )
  487. and(
  488. trim(PORT)is not null
  489. )
  490. and(
  491. COMPLETE is null
  492. )
  493. and(
  494. ATTEMPT<3
  495. )
  496. and(
  497. upper(TP)=?
  498. )
  499. and(
  500. 0<=?
  501. )
  502. order by
  503. id
  504. Hibernate:
  505. select
  506. ifcposting0_.ID as ID1_58_,
  507. ifcposting0_.ADDRESS as ADDRESS2_58_,
  508. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  509. ifcposting0_.COMPLETE as COMPLETE4_58_,
  510. ifcposting0_.DOC_ID as DOC_ID5_58_,
  511. ifcposting0_.ERR as ERR6_58_,
  512. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  513. ifcposting0_.PORT as PORT8_58_,
  514. ifcposting0_.POSTING as POSTING9_58_,
  515. ifcposting0_.SEQ as SEQ10_58_,
  516. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  517. ifcposting0_.TM as TM12_58_,
  518. ifcposting0_.TP as TP13_58_
  519. from
  520. club.IFC_POSTINGS ifcposting0_
  521. where
  522. (
  523. trim(ADDRESS)is not null
  524. )
  525. and(
  526. trim(PORT)is not null
  527. )
  528. and(
  529. COMPLETE is null
  530. )
  531. and(
  532. ATTEMPT<3
  533. )
  534. and(
  535. upper(TP)=?
  536. )
  537. and(
  538. 0<=?
  539. )
  540. order by
  541. id
  542. Hibernate:
  543. select
  544. ifcposting0_.ID as ID1_58_,
  545. ifcposting0_.ADDRESS as ADDRESS2_58_,
  546. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  547. ifcposting0_.COMPLETE as COMPLETE4_58_,
  548. ifcposting0_.DOC_ID as DOC_ID5_58_,
  549. ifcposting0_.ERR as ERR6_58_,
  550. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  551. ifcposting0_.PORT as PORT8_58_,
  552. ifcposting0_.POSTING as POSTING9_58_,
  553. ifcposting0_.SEQ as SEQ10_58_,
  554. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  555. ifcposting0_.TM as TM12_58_,
  556. ifcposting0_.TP as TP13_58_
  557. from
  558. club.IFC_POSTINGS ifcposting0_
  559. where
  560. (
  561. trim(ADDRESS)is not null
  562. )
  563. and(
  564. trim(PORT)is not null
  565. )
  566. and(
  567. COMPLETE is null
  568. )
  569. and(
  570. ATTEMPT<3
  571. )
  572. and(
  573. upper(TP)=?
  574. )
  575. and(
  576. 0<=?
  577. )
  578. order by
  579. id
  580. 17.08.16 15:05:10:170 - INFO - ExecutorConfigurationSupport - Initializing ExecutorService 'scheduler'
  581. 17.08.16 15:05:11:829 - INFO - JavaReflectionManager - HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
  582. 17.08.16 15:05:11:843 - INFO - Version - HHH000412: Hibernate Core {4.3.11.Final}
  583. 17.08.16 15:05:11:846 - INFO - Environment - HHH000206: hibernate.properties not found
  584. 17.08.16 15:05:11:849 - INFO - Environment - HHH000021: Bytecode provider name : javassist
  585. Hibernate:
  586. select
  587. ifcposting0_.ID as ID1_58_,
  588. ifcposting0_.ADDRESS as ADDRESS2_58_,
  589. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  590. ifcposting0_.COMPLETE as COMPLETE4_58_,
  591. ifcposting0_.DOC_ID as DOC_ID5_58_,
  592. ifcposting0_.ERR as ERR6_58_,
  593. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  594. ifcposting0_.PORT as PORT8_58_,
  595. ifcposting0_.POSTING as POSTING9_58_,
  596. ifcposting0_.SEQ as SEQ10_58_,
  597. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  598. ifcposting0_.TM as TM12_58_,
  599. ifcposting0_.TP as TP13_58_
  600. from
  601. club.IFC_POSTINGS ifcposting0_
  602. where
  603. (
  604. trim(ADDRESS)is not null
  605. )
  606. and(
  607. trim(PORT)is not null
  608. )
  609. and(
  610. COMPLETE is null
  611. )
  612. and(
  613. ATTEMPT<3
  614. )
  615. and(
  616. upper(TP)=?
  617. )
  618. and(
  619. 0<=?
  620. )
  621. order by
  622. id
  623. 17.08.16 15:05:13:953 - INFO - Dialect - HHH000400: Using dialect: org.hibernate.dialect.Oracle10gDialect
  624. Hibernate:
  625. select
  626. ifcposting0_.ID as ID1_58_,
  627. ifcposting0_.ADDRESS as ADDRESS2_58_,
  628. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  629. ifcposting0_.COMPLETE as COMPLETE4_58_,
  630. ifcposting0_.DOC_ID as DOC_ID5_58_,
  631. ifcposting0_.ERR as ERR6_58_,
  632. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  633. ifcposting0_.PORT as PORT8_58_,
  634. ifcposting0_.POSTING as POSTING9_58_,
  635. ifcposting0_.SEQ as SEQ10_58_,
  636. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  637. ifcposting0_.TM as TM12_58_,
  638. ifcposting0_.TP as TP13_58_
  639. from
  640. club.IFC_POSTINGS ifcposting0_
  641. where
  642. (
  643. trim(ADDRESS)is not null
  644. )
  645. and(
  646. trim(PORT)is not null
  647. )
  648. and(
  649. COMPLETE is null
  650. )
  651. and(
  652. ATTEMPT<3
  653. )
  654. and(
  655. upper(TP)=?
  656. )
  657. and(
  658. 0<=?
  659. )
  660. order by
  661. id
  662. 17.08.16 15:05:15:299 - WARN - RootClass - HHH000038: Composite-id class does not override equals(): ru.hrs.lassd.club.vo.MemoryValuePK
  663. 17.08.16 15:05:15:300 - WARN - RootClass - HHH000039: Composite-id class does not override hashCode(): ru.hrs.lassd.club.vo.MemoryValuePK
  664. 17.08.16 15:05:15:313 - WARN - RootClass - HHH000038: Composite-id class does not override equals(): ru.hrs.lassd.club.vo.DocDtlPK
  665. 17.08.16 15:05:15:313 - WARN - RootClass - HHH000039: Composite-id class does not override hashCode(): ru.hrs.lassd.club.vo.DocDtlPK
  666. 17.08.16 15:05:15:315 - WARN - RootClass - HHH000038: Composite-id class does not override equals(): ru.hrs.lassd.club.vo.AccountingPK
  667. 17.08.16 15:05:15:315 - WARN - RootClass - HHH000039: Composite-id class does not override hashCode(): ru.hrs.lassd.club.vo.AccountingPK
  668. 17.08.16 15:05:15:319 - WARN - RootClass - HHH000038: Composite-id class does not override equals(): ru.hrs.lassd.club.vo.BookingsHistoryPK
  669. 17.08.16 15:05:15:319 - WARN - RootClass - HHH000039: Composite-id class does not override hashCode(): ru.hrs.lassd.club.vo.BookingsHistoryPK
  670. 17.08.16 15:05:15:325 - WARN - RootClass - HHH000038: Composite-id class does not override equals(): ru.hrs.lassd.club.vo.DscHistoryPK
  671. 17.08.16 15:05:15:325 - WARN - RootClass - HHH000039: Composite-id class does not override hashCode(): ru.hrs.lassd.club.vo.DscHistoryPK
  672. 17.08.16 15:05:15:326 - WARN - RootClass - HHH000038: Composite-id class does not override equals(): ru.hrs.lassd.club.vo.TaxPK
  673. 17.08.16 15:05:15:327 - WARN - RootClass - HHH000039: Composite-id class does not override hashCode(): ru.hrs.lassd.club.vo.TaxPK
  674. Hibernate:
  675. select
  676. ifcposting0_.ID as ID1_58_,
  677. ifcposting0_.ADDRESS as ADDRESS2_58_,
  678. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  679. ifcposting0_.COMPLETE as COMPLETE4_58_,
  680. ifcposting0_.DOC_ID as DOC_ID5_58_,
  681. ifcposting0_.ERR as ERR6_58_,
  682. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  683. ifcposting0_.PORT as PORT8_58_,
  684. ifcposting0_.POSTING as POSTING9_58_,
  685. ifcposting0_.SEQ as SEQ10_58_,
  686. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  687. ifcposting0_.TM as TM12_58_,
  688. ifcposting0_.TP as TP13_58_
  689. from
  690. club.IFC_POSTINGS ifcposting0_
  691. where
  692. (
  693. trim(ADDRESS)is not null
  694. )
  695. and(
  696. trim(PORT)is not null
  697. )
  698. and(
  699. COMPLETE is null
  700. )
  701. and(
  702. ATTEMPT<3
  703. )
  704. and(
  705. upper(TP)=?
  706. )
  707. and(
  708. 0<=?
  709. )
  710. order by
  711. id
  712. Hibernate:
  713. select
  714. ifcposting0_.ID as ID1_58_,
  715. ifcposting0_.ADDRESS as ADDRESS2_58_,
  716. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  717. ifcposting0_.COMPLETE as COMPLETE4_58_,
  718. ifcposting0_.DOC_ID as DOC_ID5_58_,
  719. ifcposting0_.ERR as ERR6_58_,
  720. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  721. ifcposting0_.PORT as PORT8_58_,
  722. ifcposting0_.POSTING as POSTING9_58_,
  723. ifcposting0_.SEQ as SEQ10_58_,
  724. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  725. ifcposting0_.TM as TM12_58_,
  726. ifcposting0_.TP as TP13_58_
  727. from
  728. club.IFC_POSTINGS ifcposting0_
  729. where
  730. (
  731. trim(ADDRESS)is not null
  732. )
  733. and(
  734. trim(PORT)is not null
  735. )
  736. and(
  737. COMPLETE is null
  738. )
  739. and(
  740. ATTEMPT<3
  741. )
  742. and(
  743. upper(TP)=?
  744. )
  745. and(
  746. 0<=?
  747. )
  748. order by
  749. id
  750. 17.08.16 15:05:19:811 - INFO - SchemaUpdate - HHH000228: Running hbm2ddl schema update
  751. 17.08.16 15:05:19:812 - INFO - SchemaUpdate - HHH000102: Fetching database metadata
  752. 17.08.16 15:05:20:091 - INFO - SchemaUpdate - HHH000396: Updating schema
  753. 17.08.16 15:05:20:263 - INFO - TableMetadata - HHH000261: Table found: CLUB.ACCOUNTING
  754. 17.08.16 15:05:20:263 - INFO - TableMetadata - HHH000037: Columns: [account_def_id, amount, immed, loan_flag, expiry_date, tag, doc_id, seq, card_id]
  755. 17.08.16 15:05:20:264 - INFO - TableMetadata - HHH000108: Foreign keys: [accounting_cards_fk1, accounting_docs_fk1, accounting_account_def_fk1]
  756. 17.08.16 15:05:20:264 - INFO - TableMetadata - HHH000126: Indexes: [accounting_pk, accounting_idx1]
  757. 17.08.16 15:05:20:358 - INFO - TableMetadata - HHH000261: Table found: CLUB.ACCOUNTING_BALANCE
  758. 17.08.16 15:05:20:359 - INFO - TableMetadata - HHH000037: Columns: [account_def_id, amount, last_expiry, loan, id, crd_ttl, card_id]
  759. 17.08.16 15:05:20:359 - INFO - TableMetadata - HHH000108: Foreign keys: [accounting_bal_account_def_fk1]
  760. 17.08.16 15:05:20:360 - INFO - TableMetadata - HHH000126: Indexes: [accounting_balance_uk1, accounting_balance_pk]
  761. 17.08.16 15:05:20:450 - INFO - TableMetadata - HHH000261: Table found: CLUB.ACCOUNT_DEF
  762. 17.08.16 15:05:20:450 - INFO - TableMetadata - HHH000037: Columns: [account_def_id, account_type, task_type_id, auto_renew, ordr, points_rate, ruleset_id, name, account_code, expiration, points_rounding, currency_id]
  763. 17.08.16 15:05:20:450 - INFO - TableMetadata - HHH000108: Foreign keys: [account_def_rulesets_fk1, fkb4077eb3b14c07a6, fkb4077eb38df90de2]
  764. 17.08.16 15:05:20:451 - INFO - TableMetadata - HHH000126: Indexes: [account_def_pk, account_def_uk1]
  765. 17.08.16 15:05:20:509 - INFO - TableMetadata - HHH000261: Table found: CLUB.ACTIVITY_SKILLS
  766. 17.08.16 15:05:20:510 - INFO - TableMetadata - HHH000037: Columns: [name, resource_type, skill_id, mi_id]
  767. 17.08.16 15:05:20:510 - INFO - TableMetadata - HHH000108: Foreign keys: [fk_a6lvsyq72pkhwuw0g6yp3255q]
  768. 17.08.16 15:05:20:510 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175569]
  769. 17.08.16 15:05:20:581 - INFO - TableMetadata - HHH000261: Table found: CLUB.ACTIVITY_SKILLS_ASSIGN
  770. 17.08.16 15:05:20:581 - INFO - TableMetadata - HHH000037: Columns: [resource_type, resource_id, skill_id, id]
  771. 17.08.16 15:05:20:582 - INFO - TableMetadata - HHH000108: Foreign keys: [fk8e82be5cbe722e3f]
  772. 17.08.16 15:05:20:582 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175574]
  773. 17.08.16 15:05:20:649 - INFO - TableMetadata - HHH000261: Table found: CLUB.AUDIT_LOG
  774. 17.08.16 15:05:20:650 - INFO - TableMetadata - HHH000037: Columns: [event_type, tm, id, key_value, operator, tbl]
  775. 17.08.16 15:05:20:650 - INFO - TableMetadata - HHH000108: Foreign keys: []
  776. 17.08.16 15:05:20:650 - INFO - TableMetadata - HHH000126: Indexes: [audit_log_idx_tbl, audit_log_idx_tm, audit_log_pk, audit_log_idx_operator]
  777. 17.08.16 15:05:20:712 - INFO - TableMetadata - HHH000261: Table found: CLUB.AUDIT_LOG_DTL
  778. 17.08.16 15:05:20:713 - INFO - TableMetadata - HHH000037: Columns: [old_reference, log_id, new_reference, old_value, id, new_value, fld]
  779. 17.08.16 15:05:20:713 - INFO - TableMetadata - HHH000108: Foreign keys: [audit_log_dtl_audit_log_fk1]
  780. 17.08.16 15:05:20:713 - INFO - TableMetadata - HHH000126: Indexes: [audit_log_dtl_index, audit_log_dtl_pk]
  781. 17.08.16 15:05:20:769 - INFO - TableMetadata - HHH000261: Table found: CLUB.AUDIT_LOG_TBLS
  782. 17.08.16 15:05:20:770 - INFO - TableMetadata - HHH000037: Columns: [flg, fld_name, tbl_name, id]
  783. 17.08.16 15:05:20:770 - INFO - TableMetadata - HHH000108: Foreign keys: []
  784. 17.08.16 15:05:20:770 - INFO - TableMetadata - HHH000126: Indexes: [audit_log_tbls_pk, tbl_name_uniq]
  785. 17.08.16 15:05:20:826 - INFO - TableMetadata - HHH000261: Table found: CLUB.BONUS_TRIGGERS
  786. 17.08.16 15:05:20:827 - INFO - TableMetadata - HHH000037: Columns: [award_extend_validity, trigger_date_delta, ruleset_id, award_deposit_multiply, trigger_date, award_coupon_ruleset_id, trigger_amount_min, deposit_account_def_id, award_subscription_mi_id, task_type_id, runonce_flag, email_template_id, name, award_change_card_type_id, bonus_trigger_id, award_deposit, trigger_amount_max, reset_type]
  787. 17.08.16 15:05:20:827 - INFO - TableMetadata - HHH000108: Foreign keys: [bonus_triggers_rulesets_fk2, bonus_triggers_rulesets_fk1, fk_fldsaochil0e6d4propi65d80, bonus_triggers_menu_items_fk1, bonus_triggers_card_types_fk1, bonus_triggers_account_def_fk1, bonus_triggers_templates_fk1]
  788. 17.08.16 15:05:20:828 - INFO - TableMetadata - HHH000126: Indexes: [bonus_triggers_pk]
  789. 17.08.16 15:05:20:881 - INFO - TableMetadata - HHH000261: Table found: CLUB.BONUS_TRIGGER_HISTORY
  790. 17.08.16 15:05:20:882 - INFO - TableMetadata - HHH000037: Columns: [event_id, bonus_trigger_id, card_id, ts]
  791. 17.08.16 15:05:20:889 - INFO - TableMetadata - HHH000108: Foreign keys: [bonus_trigger_history_bon_fk1, bonus_trigger_history_car_fk1]
  792. 17.08.16 15:05:20:890 - INFO - TableMetadata - HHH000126: Indexes: [bonus_trigger_history_pk]
  793. 17.08.16 15:05:20:956 - INFO - TableMetadata - HHH000261: Table found: CLUB.BOOKINGS
  794. 17.08.16 15:05:20:957 - INFO - TableMetadata - HHH000037: Columns: [class_number, payer_card_id, color, prep_time, time_start, booking_package_id, rvc_id, booking_id, reference, class_level, class_group, mdsc, price, source_code_id, time_end, menu_package_id, market_code_id, doc_id, booking_empl_id, mi_id, parent_booking_id, cleanout_time, dsc, group_id, name, status]
  795. 17.08.16 15:05:20:957 - INFO - TableMetadata - HHH000108: Foreign keys: [fka62bf33ab5daaa5d, fka62bf33ac1d807a, fka62bf33a6d9e924e, fka62bf33a985d7717, fka62bf33a7f4a88c3, fka62bf33a47f9ff3b, fka62bf33aa16d0e5c, fka62bf33a4e38473c, fka62bf33af33b0559, fka62bf33a870b76ea]
  796. 17.08.16 15:05:20:957 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175624]
  797. 17.08.16 15:05:21:034 - INFO - TableMetadata - HHH000261: Table found: CLUB.BOOKINGS_HISTORY
  798. 17.08.16 15:05:21:035 - INFO - TableMetadata - HHH000037: Columns: [old_status, reference, booking_id, operator_empl_id, no_cancel_fee, new_status, details, time]
  799. 17.08.16 15:05:21:035 - INFO - TableMetadata - HHH000108: Foreign keys: [fkc6a5306fa4471c35, fkc6a5306f62d46a0e]
  800. 17.08.16 15:05:21:036 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175629]
  801. 17.08.16 15:05:21:118 - INFO - TableMetadata - HHH000261: Table found: CLUB.BOOKING_PACKAGE
  802. 17.08.16 15:05:21:118 - INFO - TableMetadata - HHH000037: Columns: [pms_reservation_num, acknowledge, booking_package_id, package_mi_id]
  803. 17.08.16 15:05:21:118 - INFO - TableMetadata - HHH000108: Foreign keys: [fk434fb220bb771203]
  804. 17.08.16 15:05:21:119 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175631]
  805. 17.08.16 15:05:21:181 - INFO - TableMetadata - HHH000261: Table found: CLUB.BOOKING_RESOURCES
  806. 17.08.16 15:05:21:187 - INFO - TableMetadata - HHH000037: Columns: [booking_id, resource_type, resource_id, id, resource_name]
  807. 17.08.16 15:05:21:230 - INFO - TableMetadata - HHH000108: Foreign keys: [fkcc8f297f62d46a0e]
  808. 17.08.16 15:05:21:230 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175636]
  809. 17.08.16 15:05:21:292 - INFO - TableMetadata - HHH000261: Table found: CLUB.BOOKING_WAITLIST
  810. 17.08.16 15:05:21:293 - INFO - TableMetadata - HHH000037: Columns: [note, cancel_empl, booked_empl, valid_from, create_empl, booked_tm, hour_to, card_id, rvc_id, mi_id, valid_till, create_tm, cancel_tm, hour_from, booking_waitlist_id]
  811. 17.08.16 15:05:21:293 - INFO - TableMetadata - HHH000108: Foreign keys: [fk88fbcd96d9e924e, fk88fbcd94e38473c, fk88fbcd99af5946]
  812. 17.08.16 15:05:21:293 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175645, booking_waitlist_rvcind, booking_waitlist_crtmind, booking_waitlist_cantmind, booking_waitlist_vtillind, booking_waitlist_btmind, booking_waitlist_vfromind]
  813. 17.08.16 15:05:21:356 - INFO - TableMetadata - HHH000261: Table found: CLUB.BS_TASK
  814. 17.08.16 15:05:21:356 - INFO - TableMetadata - HHH000037: Columns: [update_employee_id, close_tm, parent_task_id, subject, close_empl_id, task_id, priority, doc_id, card_id, result, create_employee_id, task_type_id, create_tm, assign_employee_id, contract_block_id, channel_type, update_tm, schedule_tm]
  815. 17.08.16 15:05:21:356 - INFO - TableMetadata - HHH000108: Foreign keys: [bs_task_reason_text_fk1, fk365f68b39af5946, fk365f68b31c9d6b82, fk365f68b380e05810, fk365f68b38df90de2, fk365f68b325b23d89, fk365f68b331840bc3, fk365f68b38379736]
  816. 17.08.16 15:05:21:357 - INFO - TableMetadata - HHH000126: Indexes: [bs_task_pk]
  817. 17.08.16 15:05:21:411 - INFO - TableMetadata - HHH000261: Table found: CLUB.BS_TASK_MSG
  818. 17.08.16 15:05:21:411 - INFO - TableMetadata - HHH000037: Columns: [create_employee_id, task_msg_id, create_tm, task_id, text]
  819. 17.08.16 15:05:21:411 - INFO - TableMetadata - HHH000108: Foreign keys: [fkb27231d5d790617, fkb27231d531840bc3]
  820. 17.08.16 15:05:21:411 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175655]
  821. 17.08.16 15:05:21:459 - INFO - TableMetadata - HHH000261: Table found: CLUB.BS_TASK_STPL
  822. 17.08.16 15:05:21:459 - INFO - TableMetadata - HHH000037: Columns: [bs_task_stpl_id, name]
  823. 17.08.16 15:05:21:459 - INFO - TableMetadata - HHH000108: Foreign keys: []
  824. 17.08.16 15:05:21:460 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175658]
  825. 17.08.16 15:05:21:534 - INFO - TableMetadata - HHH000261: Table found: CLUB.BS_TASK_STPL_DTL
  826. 17.08.16 15:05:21:535 - INFO - TableMetadata - HHH000037: Columns: [bs_task_stpl_dtl_id, task_type_id, subject, shift, bs_task_stpl_id]
  827. 17.08.16 15:05:21:535 - INFO - TableMetadata - HHH000108: Foreign keys: [fkc5a0c4a68df90de2, fkc5a0c4a6afcce830]
  828. 17.08.16 15:05:21:536 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175664]
  829. 17.08.16 15:05:21:603 - INFO - TableMetadata - HHH000261: Table found: CLUB.BS_TASK_TYPE
  830. 17.08.16 15:05:21:604 - INFO - TableMetadata - HHH000037: Columns: [popup_mode, template_name, task_type_id, color, assign_employee_id, name, message_mode_empl, message_mode]
  831. 17.08.16 15:05:21:604 - INFO - TableMetadata - HHH000108: Foreign keys: [fk9bd74f468379736]
  832. 17.08.16 15:05:21:605 - INFO - TableMetadata - HHH000126: Indexes: [bs_task_type_pk]
  833. 17.08.16 15:05:21:693 - INFO - TableMetadata - HHH000261: Table found: CLUB.CARDS
  834. 17.08.16 15:05:21:693 - INFO - TableMetadata - HHH000037: Columns: [country, udfs20, udfs9, notes, udfs8, udfs7, occupancy, udfs6, udfs5, birth_date, greeting, udfs4, udfs3, udfs2, udfs1, source, magstripe, zip_code, card_type_id, password, passport, spa_gender_pref, udfs15, udfs16, udfs17, udfs18, udfs19, job_title, udfn9, udfn8, udfn7, card_status_id, card_id, update_date, udfn10, cell_phone, is_archived, udfd10, phone, health_info, second_name, street_address, master_card_id, gender, city, title, mlst_sync_status, valid_till, udfd9, udfd8, rate, udfd7, udfd6, udfd5, udfd4, udfd3, company, udfd2, udfd1, lang, first_name, email, created_person, udfn6, udfn5, udfn4, profile_type, udfn3, udfs10, udfn2, udfs11, udfn1, udfs12, udfs13, udfs14, last_name, last_used_rvc_id, vip_status, created_date, update_person, max_children, mailing_opt]
  835. 17.08.16 15:05:21:694 - INFO - TableMetadata - HHH000108: Foreign keys: [cards_card_status_fk1, fk3ceef437534a869, cards_card_types_fk1]
  836. 17.08.16 15:05:21:694 - INFO - TableMetadata - HHH000126: Indexes: [cards_magstripe_uk1, cards_pk]
  837. Hibernate:
  838. select
  839. ifcposting0_.ID as ID1_58_,
  840. ifcposting0_.ADDRESS as ADDRESS2_58_,
  841. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  842. ifcposting0_.COMPLETE as COMPLETE4_58_,
  843. ifcposting0_.DOC_ID as DOC_ID5_58_,
  844. ifcposting0_.ERR as ERR6_58_,
  845. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  846. ifcposting0_.PORT as PORT8_58_,
  847. ifcposting0_.POSTING as POSTING9_58_,
  848. ifcposting0_.SEQ as SEQ10_58_,
  849. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  850. ifcposting0_.TM as TM12_58_,
  851. ifcposting0_.TP as TP13_58_
  852. from
  853. club.IFC_POSTINGS ifcposting0_
  854. where
  855. (
  856. trim(ADDRESS)is not null
  857. )
  858. and(
  859. trim(PORT)is not null
  860. )
  861. and(
  862. COMPLETE is null
  863. )
  864. and(
  865. ATTEMPT<3
  866. )
  867. and(
  868. upper(TP)=?
  869. )
  870. and(
  871. 0<=?
  872. )
  873. order by
  874. id
  875. 17.08.16 15:05:21:886 - INFO - TableMetadata - HHH000261: Table found: CLUB.CARDS_BLACK_LIST
  876. 17.08.16 15:05:21:886 - INFO - TableMetadata - HHH000037: Columns: [reason, cards_black_id, create_empl, create_date, card_id]
  877. 17.08.16 15:05:21:886 - INFO - TableMetadata - HHH000108: Foreign keys: [fka3a2b7a9af5946]
  878. 17.08.16 15:05:22:040 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175683]
  879. 17.08.16 15:05:22:094 - INFO - TableMetadata - HHH000261: Table found: CLUB.CARDS_EMPL_ASSGN
  880. 17.08.16 15:05:22:097 - INFO - TableMetadata - HHH000037: Columns: [inactive, empl_id, cards_empl_assgn_id, skill_id, preferred, card_id]
  881. 17.08.16 15:05:22:097 - INFO - TableMetadata - HHH000108: Foreign keys: [fk8e222229be722e3f, fk8e2222299af5946, fk8e222229525e30d0]
  882. 17.08.16 15:05:22:098 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175690]
  883. 17.08.16 15:05:22:154 - INFO - TableMetadata - HHH000261: Table found: CLUB.CARDS_MERGE_HISTORY
  884. 17.08.16 15:05:22:155 - INFO - TableMetadata - HHH000037: Columns: [source_card_id, empl_id, target_name, target_card_id, tm, cards_merge_history_id, operator, source_name]
  885. 17.08.16 15:05:22:155 - INFO - TableMetadata - HHH000108: Foreign keys: [fk98327b51525e30d0]
  886. 17.08.16 15:05:22:155 - INFO - TableMetadata - HHH000126: Indexes: [cards_merge_history_pk]
  887. 17.08.16 15:05:22:231 - INFO - TableMetadata - HHH000261: Table found: CLUB.CARD_FOREIGN_IDS
  888. 17.08.16 15:05:22:231 - INFO - TableMetadata - HHH000037: Columns: [card_foreign_id, key_number, interface_id, key_source, card_id]
  889. 17.08.16 15:05:22:232 - INFO - TableMetadata - HHH000108: Foreign keys: [card_foreign_ids_fk1, card_foreign_ids_fk2]
  890. 17.08.16 15:05:22:232 - INFO - TableMetadata - HHH000126: Indexes: [card_foreign_ids_uk, card_foreign_ids_pk]
  891. 17.08.16 15:05:22:287 - INFO - TableMetadata - HHH000261: Table found: CLUB.CARD_STATUS
  892. 17.08.16 15:05:22:287 - INFO - TableMetadata - HHH000037: Columns: [description, id, actived]
  893. 17.08.16 15:05:22:288 - INFO - TableMetadata - HHH000108: Foreign keys: []
  894. 17.08.16 15:05:22:288 - INFO - TableMetadata - HHH000126: Indexes: [card_status_pk]
  895. 17.08.16 15:05:22:356 - INFO - TableMetadata - HHH000261: Table found: CLUB.CARD_TYPES
  896. 17.08.16 15:05:22:356 - INFO - TableMetadata - HHH000037: Columns: [pms_level, type_name, default_validity_period, default_account_def_id, facility_access_ruleset, range_start, active, track1format, default_mask, card_type_id, options, credit_limit, menu_level, pms_type]
  897. 17.08.16 15:05:22:357 - INFO - TableMetadata - HHH000108: Foreign keys: [card_types_facility_acces_fk1, card_types_account_def_fk1]
  898. 17.08.16 15:05:22:385 - INFO - TableMetadata - HHH000126: Indexes: [card_types_pk, card_types_uk, uk_q8ao9u2818oh21ijvy6svxu77]
  899. 17.08.16 15:05:22:458 - INFO - TableMetadata - HHH000261: Table found: CLUB.CARD_TYPES_ACCOUNTS
  900. 17.08.16 15:05:22:459 - INFO - TableMetadata - HHH000037: Columns: [card_types_accounts_id, card_type_id, payment_limit, account_def_id, credit_limit, priority]
  901. 17.08.16 15:05:22:459 - INFO - TableMetadata - HHH000108: Foreign keys: [card_types_accounts_accou_fk1, card_types_accounts_card__fk1]
  902. 17.08.16 15:05:22:459 - INFO - TableMetadata - HHH000126: Indexes: [card_types_accounts_pk, card_types_accounts_uk1]
  903. 17.08.16 15:05:22:509 - INFO - TableMetadata - HHH000261: Table found: CLUB.CARD_TYPES_RULESET_LINK
  904. 17.08.16 15:05:22:510 - INFO - TableMetadata - HHH000037: Columns: [card_type_id, ruleset_id, id]
  905. 17.08.16 15:05:22:510 - INFO - TableMetadata - HHH000108: Foreign keys: [card_types_ruleset_link_c_fk1, card_types_ruleset_link_r_fk1]
  906. 17.08.16 15:05:22:510 - INFO - TableMetadata - HHH000126: Indexes: [card_types_ruleset_link_pk, idx$$_37920001]
  907. 17.08.16 15:05:22:569 - INFO - TableMetadata - HHH000261: Table found: CLUB.CARD_XTRA
  908. 17.08.16 15:05:22:569 - INFO - TableMetadata - HHH000037: Columns: [card_type_id, valid_till, id, magstripe, card_id]
  909. 17.08.16 15:05:22:570 - INFO - TableMetadata - HHH000108: Foreign keys: [fk9941f5fa9af5946, fk9941f5fadd0c4407]
  910. 17.08.16 15:05:22:570 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175738, sys_c00175739]
  911. 17.08.16 15:05:22:615 - INFO - TableMetadata - HHH000261: Table found: CLUB.CASHIERS
  912. 17.08.16 15:05:22:615 - INFO - TableMetadata - HHH000037: Columns: [cashier_id, password, name]
  913. 17.08.16 15:05:22:615 - INFO - TableMetadata - HHH000108: Foreign keys: []
  914. 17.08.16 15:05:22:615 - INFO - TableMetadata - HHH000126: Indexes: [cashiers_pk]
  915. 17.08.16 15:05:22:671 - INFO - TableMetadata - HHH000261: Table found: CLUB.CASHIER_SHIFT
  916. 17.08.16 15:05:22:671 - INFO - TableMetadata - HHH000037: Columns: [tm_open, cashier_id, tm_close, cashier_shift_id]
  917. 17.08.16 15:05:22:671 - INFO - TableMetadata - HHH000108: Foreign keys: []
  918. 17.08.16 15:05:22:672 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175745]
  919. 17.08.16 15:05:22:718 - INFO - TableMetadata - HHH000261: Table found: CLUB.CLIENT_PROFILE_DICTIONARY
  920. 17.08.16 15:05:22:718 - INFO - TableMetadata - HHH000037: Columns: [field_id, text, dictionary_id, card_id]
  921. 17.08.16 15:05:22:718 - INFO - TableMetadata - HHH000108: Foreign keys: []
  922. 17.08.16 15:05:22:718 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176545]
  923. 17.08.16 15:05:22:767 - INFO - TableMetadata - HHH000261: Table found: CLUB.CLIENT_PROFILE_GROUP
  924. 17.08.16 15:05:22:767 - INFO - TableMetadata - HHH000037: Columns: [name_sid, ordr, options, profile_group_id]
  925. 17.08.16 15:05:22:767 - INFO - TableMetadata - HHH000108: Foreign keys: []
  926. 17.08.16 15:05:22:768 - INFO - TableMetadata - HHH000126: Indexes: [client_profile_group_pk, uk_no3i7t951qi5kyp2098t4awlr]
  927. 17.08.16 15:05:22:829 - INFO - TableMetadata - HHH000261: Table found: CLUB.CLIENT_PROFILE_SPEC
  928. 17.08.16 15:05:22:829 - INFO - TableMetadata - HHH000037: Columns: [field_id, label_offset, is_visible, line, field_width, builtin, default_value, display_name_sid, view_priv_lvl, field_name, label_width, master, field_offset, edit_priv_lvl, is_masked, options, profile_group_id, field_type, height]
  929. 17.08.16 15:05:22:830 - INFO - TableMetadata - HHH000108: Foreign keys: [client_profile_spec_clien_fk2, client_profile_spec_clien_fk1]
  930. 17.08.16 15:05:22:830 - INFO - TableMetadata - HHH000126: Indexes: [client_profile_spec_uk1, uk_r3cnyd39xt12mnrr7pudgtjsg, client_profile_spec_pk]
  931. 17.08.16 15:05:22:882 - INFO - TableMetadata - HHH000261: Table found: CLUB.CLIENT_RELATIONS
  932. 17.08.16 15:05:22:882 - INFO - TableMetadata - HHH000037: Columns: [relation_2, card_id_2, relation_1, card_id_1, id, relation_type]
  933. 17.08.16 15:05:22:882 - INFO - TableMetadata - HHH000108: Foreign keys: [fke7ef3663da0ae279, fke7ef3663da0ae278]
  934. 17.08.16 15:05:22:883 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175787]
  935. 17.08.16 15:05:22:932 - INFO - TableMetadata - HHH000261: Table found: CLUB.COUPON
  936. 17.08.16 15:05:22:933 - INFO - TableMetadata - HHH000037: Columns: [reference, coupon_code, coupon_id, ruleset_id, expiry_date, status]
  937. 17.08.16 15:05:22:933 - INFO - TableMetadata - HHH000108: Foreign keys: [fk76d5cc261508a2ee]
  938. 17.08.16 15:05:22:933 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175796]
  939. 17.08.16 15:05:22:983 - INFO - TableMetadata - HHH000261: Table found: CLUB.CRM
  940. 17.08.16 15:05:22:983 - INFO - TableMetadata - HHH000037: Columns: [event_update_empl, event_update_tm, sms_text, task_insert_empl, task_comment, event_color, event_insert_tm, event_result_type_id, task_priority, sms_delivery_result, task_title, task_insert_tm, event_title, task_tm, email_delivery_tm, event_comment, task_update_tm, card_id, email_title, task_color, task_type_id, email_body, crm_id, email_delivery_result, sms_delivery_tm, task_assign_empl, event_insert_empl, task_update_empl]
  941. 17.08.16 15:05:22:983 - INFO - TableMetadata - HHH000108: Foreign keys: [fk_eopmhusuihv5havowloxmggfg, fk_2glqx5q3cswl4bd22478qmq0q, fk_3be8fmfamjccqxyvrkibo3eld, fk_bkni4gah11bgv1g0rq34kbmht, fk_j37qoewa1th8gjx8efoyi9kwe, fk_h6eosybxj0srn2riidy3qfbla, fk_qac5p7dymbu9t8604a3j49hgi, fk_g8vg254oqxprjlvdleec10dty]
  942. 17.08.16 15:05:22:984 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176548]
  943. 17.08.16 15:05:23:034 - INFO - TableMetadata - HHH000261: Table found: CLUB.CRM_TYPE
  944. 17.08.16 15:05:23:035 - INFO - TableMetadata - HHH000037: Columns: [crm_type_id, popup_mode, role, name]
  945. 17.08.16 15:05:23:035 - INFO - TableMetadata - HHH000108: Foreign keys: []
  946. 17.08.16 15:05:23:035 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176551]
  947. 17.08.16 15:05:23:088 - INFO - TableMetadata - HHH000261: Table found: CLUB.CURRENCY
  948. 17.08.16 15:05:23:088 - INFO - TableMetadata - HHH000037: Columns: [print_prefix, dgt_group_char, rate, name, scale, decimal_char, iso_code, currency_id, print_suffix, base]
  949. 17.08.16 15:05:23:088 - INFO - TableMetadata - HHH000108: Foreign keys: []
  950. 17.08.16 15:05:23:089 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175800]
  951. 17.08.16 15:05:23:145 - INFO - TableMetadata - HHH000261: Table found: CLUB.CURRENCY_RATE
  952. 17.08.16 15:05:23:145 - INFO - TableMetadata - HHH000037: Columns: [rate, currency_rate_id, insert_empl, insert_tm, effective_from, currency_id]
  953. 17.08.16 15:05:23:145 - INFO - TableMetadata - HHH000108: Foreign keys: [fkfd9d804eacff14a4, fkfd9d804eb14c07a6]
  954. 17.08.16 15:05:23:145 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175805]
  955. 17.08.16 15:05:23:192 - INFO - TableMetadata - HHH000261: Table found: CLUB.DICTIONARY_HIERARCHY
  956. 17.08.16 15:05:23:192 - INFO - TableMetadata - HHH000037: Columns: [hierarchy_id, parent_id, name]
  957. 17.08.16 15:05:23:193 - INFO - TableMetadata - HHH000108: Foreign keys: [fk8a78b5ac3102f003]
  958. 17.08.16 15:05:23:193 - INFO - TableMetadata - HHH000126: Indexes: [dictionary_hierarchy_pk]
  959. 17.08.16 15:05:23:266 - INFO - TableMetadata - HHH000261: Table found: CLUB.DOCS
  960. 17.08.16 15:05:23:267 - INFO - TableMetadata - HHH000037: Columns: [image, def_card_type_id, ver, bussines_date, tax_exempt, gst, registration_id, chck_id, doc_type, ticket_id, doc_id, ttl, operator, tm_open, cofirmation, def_card_id, def_magstripe, tm, check_open, invoice_id, chknum, sp, rvc]
  961. 17.08.16 15:05:23:267 - INFO - TableMetadata - HHH000108: Foreign keys: [fk_egc0lo866f7hjdpfd8l62wphw, fk201a3bd4c4c0a6, fk_h32b046xahnkih1n25c0if6nu, fk201a3b97b2898e, docs_rvc_fk1]
  962. 17.08.16 15:05:23:267 - INFO - TableMetadata - HHH000126: Indexes: [docs_pk]
  963. 17.08.16 15:05:23:308 - INFO - TableMetadata - HHH000261: Table found: CLUB.DOCS_CHKNUM_SEQ
  964. 17.08.16 15:05:23:309 - INFO - TableMetadata - HHH000037: Columns: [chknum]
  965. 17.08.16 15:05:23:309 - INFO - TableMetadata - HHH000108: Foreign keys: []
  966. 17.08.16 15:05:23:309 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175818]
  967. 17.08.16 15:05:23:443 - INFO - TableMetadata - HHH000261: Table found: CLUB.DOCS_DTL
  968. 17.08.16 15:05:23:444 - INFO - TableMetadata - HHH000037: Columns: [tickets, mi_seq, tax_addon, points, fgrp, booking_id, reference, hide_flag, revenue, pay_ttl_deposit, si, dsc_reason, pay_ttl_subscr, void_flag, count, reason_text, manual_dsc, doc_id, ttl, tax_add, mi_id, void_reason, posting_empl_id, dsc, manual_svc, tax_vat, name, tm, comission_empl_id, dtl_seq, cashier_shift_id]
  969. 17.08.16 15:05:23:444 - INFO - TableMetadata - HHH000108: Foreign keys: [docs_dtl_docs_fk1]
  970. 17.08.16 15:05:23:444 - INFO - TableMetadata - HHH000126: Indexes: [docs_dtl_pk]
  971. 17.08.16 15:05:23:496 - INFO - TableMetadata - HHH000261: Table found: CLUB.DOCS_PAYM
  972. 17.08.16 15:05:23:496 - INFO - TableMetadata - HHH000037: Columns: [paym_seq, amount, cashier_id, currency_amount, posting_tm, doc_id, tm_name, reference, tm_id, void_reference, void_flag, cashier_shift_id, currency_id]
  973. 17.08.16 15:05:23:496 - INFO - TableMetadata - HHH000108: Foreign keys: [docs_paym_docs_fk1, docs_paym_cashiers_fk1, fkdbee2849b14c07a6]
  974. 17.08.16 15:05:23:497 - INFO - TableMetadata - HHH000126: Indexes: [docs_paym_pk]
  975. 17.08.16 15:05:23:554 - INFO - TableMetadata - HHH000261: Table found: CLUB.DOCS_TAX
  976. 17.08.16 15:05:23:554 - INFO - TableMetadata - HHH000037: Columns: [amount, rate, name, type, doc_id, seq, tax_id]
  977. 17.08.16 15:05:23:554 - INFO - TableMetadata - HHH000108: Foreign keys: [fk61eef7875557e3ae]
  978. 17.08.16 15:05:23:555 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175837]
  979. 17.08.16 15:05:23:608 - INFO - TableMetadata - HHH000261: Table found: CLUB.DSC_HISTORY
  980. 17.08.16 15:05:23:609 - INFO - TableMetadata - HHH000037: Columns: [coupon_id, tag, dsc_ttl, doc_id, seq, card_id]
  981. 17.08.16 15:05:23:609 - INFO - TableMetadata - HHH000108: Foreign keys: [fk7d134cc9be660686, fk7d134cc99af5946, fk7d134cc95557e3ae]
  982. 17.08.16 15:05:23:609 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175841]
  983. 17.08.16 15:05:23:675 - INFO - TableMetadata - HHH000261: Table found: CLUB.EMPLOYEES
  984. 17.08.16 15:05:23:676 - INFO - TableMetadata - HHH000037: Columns: [hierarchy_id, gender, logon, booking_priority, magstripe, text_sid, manager_empl_id, password, role_id, target_amnt, password_change_tm, email, name_sid, empl_id, current_rvc_id, active, photo, priority, card_id, external, position_sid, allowed_rvc_group_id, phone, name2, name1, inv_store_id, salary_class_id, target_cnt]
  985. 17.08.16 15:05:23:677 - INFO - TableMetadata - HHH000108: Foreign keys: [employees_users_roles_fk1, employees_cards_fk1, employees_salary_class_fk1, employees_dictionary_hier_fk1, employees_rvc_group_fk1, fk4351ff656c76ea3e, employees_rvc_fk1, fk4351ff65b83054c3]
  986. 17.08.16 15:05:23:677 - INFO - TableMetadata - HHH000126: Indexes: [employees_uk1, employees_pk]
  987. 17.08.16 15:05:23:719 - INFO - TableMetadata - HHH000261: Table found: CLUB.EMPLOYEES_PASSWD
  988. 17.08.16 15:05:23:719 - INFO - TableMetadata - HHH000037: Columns: [empl_id, passwd, tm, id]
  989. 17.08.16 15:05:23:719 - INFO - TableMetadata - HHH000108: Foreign keys: [fk4c678b8525e30d0]
  990. 17.08.16 15:05:23:720 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175859]
  991. 17.08.16 15:05:23:771 - INFO - TableMetadata - HHH000261: Table found: CLUB.EOD_HISTORY
  992. 17.08.16 15:05:23:772 - INFO - TableMetadata - HHH000037: Columns: [eod_history_id, site_id, tm, operator]
  993. 17.08.16 15:05:23:772 - INFO - TableMetadata - HHH000108: Foreign keys: [fkd516aa0f65ddd9e6]
  994. 17.08.16 15:05:23:772 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175861]
  995. 17.08.16 15:05:23:822 - INFO - TableMetadata - HHH000261: Table found: CLUB.EOD_REPORTS
  996. 17.08.16 15:05:23:823 - INFO - TableMetadata - HHH000037: Columns: [rep_name, rep_url, eod_reports_id]
  997. 17.08.16 15:05:23:823 - INFO - TableMetadata - HHH000108: Foreign keys: []
  998. 17.08.16 15:05:23:823 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175863]
  999. 17.08.16 15:05:23:885 - INFO - TableMetadata - HHH000261: Table found: CLUB.EQUIPMENT
  1000. 17.08.16 15:05:23:886 - INFO - TableMetadata - HHH000037: Columns: [hierarchy_id, amount, allowed_rvc_group_id, name, active, equipment_id]
  1001. 17.08.16 15:05:23:886 - INFO - TableMetadata - HHH000108: Foreign keys: [fke63ff56efa1405e, fke63ff56ee8c1f698]
  1002. 17.08.16 15:05:23:886 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175867]
  1003. 17.08.16 15:05:23:936 - INFO - TableMetadata - HHH000261: Table found: CLUB.FACILITIES
  1004. 17.08.16 15:05:23:937 - INFO - TableMetadata - HHH000037: Columns: [hierarchy_id, confirm_overbook, name, active, facilities_id, priority, rvc_id, capacity]
  1005. 17.08.16 15:05:23:937 - INFO - TableMetadata - HHH000108: Foreign keys: [fk3ce70e816d9e924e, fk3ce70e81e8c1f698]
  1006. 17.08.16 15:05:23:938 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175874]
  1007. Hibernate:
  1008. select
  1009. ifcposting0_.ID as ID1_58_,
  1010. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1011. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1012. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1013. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1014. ifcposting0_.ERR as ERR6_58_,
  1015. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1016. ifcposting0_.PORT as PORT8_58_,
  1017. ifcposting0_.POSTING as POSTING9_58_,
  1018. ifcposting0_.SEQ as SEQ10_58_,
  1019. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1020. ifcposting0_.TM as TM12_58_,
  1021. ifcposting0_.TP as TP13_58_
  1022. from
  1023. club.IFC_POSTINGS ifcposting0_
  1024. where
  1025. (
  1026. trim(ADDRESS)is not null
  1027. )
  1028. and(
  1029. trim(PORT)is not null
  1030. )
  1031. and(
  1032. COMPLETE is null
  1033. )
  1034. and(
  1035. ATTEMPT<3
  1036. )
  1037. and(
  1038. upper(TP)=?
  1039. )
  1040. and(
  1041. 0<=?
  1042. )
  1043. order by
  1044. id
  1045. 17.08.16 15:05:23:998 - INFO - TableMetadata - HHH000261: Table found: CLUB.FACILITY_ACCESS
  1046. 17.08.16 15:05:23:998 - INFO - TableMetadata - HHH000037: Columns: [facility_access_id, code, name, options]
  1047. 17.08.16 15:05:23:998 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1048. 17.08.16 15:05:23:998 - INFO - TableMetadata - HHH000126: Indexes: [facility_access_pk, facility_access_uk2, facility_access_uk]
  1049. 17.08.16 15:05:24:053 - INFO - TableMetadata - HHH000261: Table found: CLUB.FACILITY_ACCESS_BEGINCHK
  1050. 17.08.16 15:05:24:054 - INFO - TableMetadata - HHH000037: Columns: [facility_access_id, checkedin_rvc_group_id, action, active, id, rvc_group_id, seq]
  1051. 17.08.16 15:05:24:054 - INFO - TableMetadata - HHH000108: Foreign keys: [fka907b23c9499e727, fka907b23c149417ad, fka907b23c2815957a]
  1052. 17.08.16 15:05:24:054 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175884]
  1053. 17.08.16 15:05:24:118 - INFO - TableMetadata - HHH000261: Table found: CLUB.FACILITY_ACCESS_DTL
  1054. 17.08.16 15:05:24:118 - INFO - TableMetadata - HHH000037: Columns: [facility_access_id, day_limit, active, time_profile_id, overtime_trshld, mi_id, checkedin_rvc_group_id, overtime_rvc_id, day_min_regs, options, overtime_mi_id, action, key_opt, id, rvc_group_id, seq]
  1055. 17.08.16 15:05:24:119 - INFO - TableMetadata - HHH000108: Foreign keys: [fk_tga9wku6276fbk8neswstgs2g, facility_access_dtl_fk1, facility_access_dtl_fk2, facility_access_dtl_fk5, facility_access_dtl_fk6, facility_access_dtl_fk3, facility_access_dtl_fk4]
  1056. 17.08.16 15:05:24:119 - INFO - TableMetadata - HHH000126: Indexes: [facility_access_dtl_pk, idx$$_37920004]
  1057. 17.08.16 15:05:24:171 - INFO - TableMetadata - HHH000261: Table found: CLUB.GROUP_CARDS
  1058. 17.08.16 15:05:24:172 - INFO - TableMetadata - HHH000037: Columns: [group_id, create_tm, create_empl, card_id, group_cards_id]
  1059. 17.08.16 15:05:24:172 - INFO - TableMetadata - HHH000108: Foreign keys: [fkf7b3cd63b5daaa5d, fkf7b3cd639af5946]
  1060. 17.08.16 15:05:24:174 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175892]
  1061. 17.08.16 15:05:24:229 - INFO - TableMetadata - HHH000261: Table found: CLUB.IFC_POSTINGS
  1062. 17.08.16 15:05:24:230 - INFO - TableMetadata - HHH000037: Columns: [address, msg_number, err, site_key, posting, attempt, doc_id, port, tm, id, complete, tp, seq]
  1063. 17.08.16 15:05:24:232 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1064. 17.08.16 15:05:24:232 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175901, doc_id_idx]
  1065. 17.08.16 15:05:24:286 - INFO - TableMetadata - HHH000261: Table found: CLUB.INTERFACES
  1066. 17.08.16 15:05:24:287 - INFO - TableMetadata - HHH000037: Columns: [interface_id, site_id, interface_name, config_xml_new_profile, config_xml_update_profile]
  1067. 17.08.16 15:05:24:290 - INFO - TableMetadata - HHH000108: Foreign keys: [interfaces_sites_fk1]
  1068. 17.08.16 15:05:24:291 - INFO - TableMetadata - HHH000126: Indexes: [interfaces_uk, interface_id_pk]
  1069. 17.08.16 15:05:24:378 - INFO - TableMetadata - HHH000261: Table found: CLUB.INVOICE
  1070. 17.08.16 15:05:24:378 - INFO - TableMetadata - HHH000037: Columns: [created_person, print_tm, reference, period_start, payment_status, site_id, invoice_id, created_date, invoice_number, seq_num, ttl, card_id]
  1071. 17.08.16 15:05:24:378 - INFO - TableMetadata - HHH000108: Foreign keys: [fk9fa1cf0d9af5946]
  1072. 17.08.16 15:05:24:379 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175915]
  1073. 17.08.16 15:05:24:433 - INFO - TableMetadata - HHH000261: Table found: CLUB.INV_BALANCE
  1074. 17.08.16 15:05:24:433 - INFO - TableMetadata - HHH000037: Columns: [store_id, amount, id, mi_id]
  1075. 17.08.16 15:05:24:433 - INFO - TableMetadata - HHH000108: Foreign keys: [fk55b85c4e4e38473c, fk55b85c4ef6cf5c35]
  1076. 17.08.16 15:05:24:434 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175920]
  1077. 17.08.16 15:05:24:501 - INFO - TableMetadata - HHH000261: Table found: CLUB.INV_DOCS
  1078. 17.08.16 15:05:24:501 - INFO - TableMetadata - HHH000037: Columns: [amount, notes, inv_docs_id, confirmation, date_tm, mod_operator, doc_id, operator, mi_id, op_code, inv_supplier_id, booking_id, xtra_cost, ext_doc_num, dst_store_id, src_store_id]
  1079. 17.08.16 15:05:24:502 - INFO - TableMetadata - HHH000108: Foreign keys: [inv_docs_docs_fk1, fk557771e937403030, fk557771e9919cb56f, inv_docs_inv_suppliers_fk1, fk557771e94e38473c, fk557771e962d46a0e]
  1080. 17.08.16 15:05:24:502 - INFO - TableMetadata - HHH000126: Indexes: [inv_docs_pk]
  1081. 17.08.16 15:05:24:567 - INFO - TableMetadata - HHH000261: Table found: CLUB.INV_DOCS_DTL
  1082. 17.08.16 15:05:24:568 - INFO - TableMetadata - HHH000037: Columns: [amount, cost, notes, xtra_cost, inv_docs_id, inv_unit_id, dtl_seq, mi_id]
  1083. 17.08.16 15:05:24:568 - INFO - TableMetadata - HHH000108: Foreign keys: [fk7568e66328556e3, fk7568e664e38473c, fk7568e66cf4c9164]
  1084. 17.08.16 15:05:24:568 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175934]
  1085. 17.08.16 15:05:24:616 - INFO - TableMetadata - HHH000261: Table found: CLUB.INV_STORE
  1086. 17.08.16 15:05:24:617 - INFO - TableMetadata - HHH000037: Columns: [is_cental, name, inv_store_id, retail_rvc_id]
  1087. 17.08.16 15:05:24:617 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1088. 17.08.16 15:05:24:618 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175937]
  1089. 17.08.16 15:05:24:683 - INFO - TableMetadata - HHH000261: Table found: CLUB.INV_SUPPLIERS
  1090. 17.08.16 15:05:24:683 - INFO - TableMetadata - HHH000037: Columns: [inv_supplier_id, notes, name]
  1091. 17.08.16 15:05:24:684 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1092. 17.08.16 15:05:24:685 - INFO - TableMetadata - HHH000126: Indexes: [inv_suppliers_pk]
  1093. 17.08.16 15:05:24:739 - INFO - TableMetadata - HHH000261: Table found: CLUB.INV_UNITS
  1094. 17.08.16 15:05:24:740 - INFO - TableMetadata - HHH000037: Columns: [inv_units_base_id, name, inv_unit_id, unit_wgt, unit_vol]
  1095. 17.08.16 15:05:24:740 - INFO - TableMetadata - HHH000108: Foreign keys: [inv_units_inv_units_base_fk1]
  1096. 17.08.16 15:05:24:740 - INFO - TableMetadata - HHH000126: Indexes: [inv_units_pk]
  1097. 17.08.16 15:05:24:790 - INFO - TableMetadata - HHH000261: Table found: CLUB.INV_UNITS_BASE
  1098. 17.08.16 15:05:24:791 - INFO - TableMetadata - HHH000037: Columns: [inv_units_base_id, name]
  1099. 17.08.16 15:05:24:791 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1100. 17.08.16 15:05:24:791 - INFO - TableMetadata - HHH000126: Indexes: [inv_units_base_pk]
  1101. 17.08.16 15:05:24:850 - INFO - TableMetadata - HHH000261: Table found: CLUB.ITEM_ACCOUNTING
  1102. 17.08.16 15:05:24:851 - INFO - TableMetadata - HHH000037: Columns: [subscription_accounting_id, subscription_item_id, doc_id, seq, card_id, mi_count, value_ttl]
  1103. 17.08.16 15:05:24:851 - INFO - TableMetadata - HHH000108: Foreign keys: [item_accounting_subscript_fk1, item_accounting_subscript_fk2, item_accounting_cards_fk1, item_accounting_docs_fk1]
  1104. 17.08.16 15:05:24:851 - INFO - TableMetadata - HHH000126: Indexes: [item_accounting_pk]
  1105. 17.08.16 15:05:24:935 - INFO - TableMetadata - HHH000261: Table found: CLUB.ITEM_BALANCE
  1106. 17.08.16 15:05:24:935 - INFO - TableMetadata - HHH000037: Columns: [cost, valid_till, subscription_accounting_id, subscription_item_id, count, init_count, card_id, value_ttl]
  1107. 17.08.16 15:05:24:936 - INFO - TableMetadata - HHH000108: Foreign keys: [item_balance_subscription_fk1, item_balance_cards_fk1, item_balance_subscription_fk2]
  1108. 17.08.16 15:05:24:936 - INFO - TableMetadata - HHH000126: Indexes: [item_balance_pk]
  1109. 17.08.16 15:05:24:990 - INFO - TableMetadata - HHH000261: Table found: CLUB.ITEM_PERIOD_ACC
  1110. 17.08.16 15:05:24:991 - INFO - TableMetadata - HHH000037: Columns: [subscription_accounting_id, subscription_item_id, count, card_id]
  1111. 17.08.16 15:05:24:991 - INFO - TableMetadata - HHH000108: Foreign keys: [fkcadb158f9af5946, fkcadb158f5c164d81, fkcadb158f65084e01]
  1112. 17.08.16 15:05:24:991 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175961]
  1113. 17.08.16 15:05:25:040 - INFO - TableMetadata - HHH000261: Table found: CLUB.JRN_DBSYNC
  1114. 17.08.16 15:05:25:040 - INFO - TableMetadata - HHH000037: Columns: [site_id, sync_start, sync_end, id]
  1115. 17.08.16 15:05:25:041 - INFO - TableMetadata - HHH000108: Foreign keys: [fkdb04967265ddd9e6]
  1116. 17.08.16 15:05:25:041 - INFO - TableMetadata - HHH000126: Indexes: [jrn_dbsync_pk]
  1117. 17.08.16 15:05:25:087 - INFO - TableMetadata - HHH000261: Table found: CLUB.LANGUAGE
  1118. 17.08.16 15:05:25:088 - INFO - TableMetadata - HHH000037: Columns: [name, lang_id, enabled]
  1119. 17.08.16 15:05:25:088 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1120. 17.08.16 15:05:25:088 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176554]
  1121. 17.08.16 15:05:25:146 - INFO - TableMetadata - HHH000261: Table found: CLUB.LOCKER_ACTION
  1122. 17.08.16 15:05:25:147 - INFO - TableMetadata - HHH000037: Columns: [result, locker_action_id, action, registration_id, tm, key_code, locker_num, rvc]
  1123. 17.08.16 15:05:25:147 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1124. 17.08.16 15:05:25:147 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00175966]
  1125. 17.08.16 15:05:25:196 - INFO - TableMetadata - HHH000261: Table found: CLUB.LOCKER_STATUS
  1126. 17.08.16 15:05:25:197 - INFO - TableMetadata - HHH000037: Columns: [registration_id, key_code, locker_num, locker_status_id, rvc, status]
  1127. 17.08.16 15:05:25:197 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1128. 17.08.16 15:05:25:197 - INFO - TableMetadata - HHH000126: Indexes: [key_code_idx, sys_c00175969, sys_c00175970]
  1129. 17.08.16 15:05:25:245 - INFO - TableMetadata - HHH000261: Table found: CLUB.MENU_COMMISSION_GRP
  1130. 17.08.16 15:05:25:245 - INFO - TableMetadata - HHH000037: Columns: [commission_grp_id, name]
  1131. 17.08.16 15:05:25:245 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1132. 17.08.16 15:05:25:246 - INFO - TableMetadata - HHH000126: Indexes: [menu_commission_grp_pk]
  1133. 17.08.16 15:05:25:295 - INFO - TableMetadata - HHH000261: Table found: CLUB.MENU_FGRP
  1134. 17.08.16 15:05:25:295 - INFO - TableMetadata - HHH000037: Columns: [fgrp_id, name]
  1135. 17.08.16 15:05:25:296 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1136. 17.08.16 15:05:25:297 - INFO - TableMetadata - HHH000126: Indexes: [menu_fgrp_pk]
  1137. 17.08.16 15:05:25:465 - INFO - TableMetadata - HHH000261: Table found: CLUB.MENU_ITEMS
  1138. 17.08.16 15:05:25:466 - INFO - TableMetadata - HHH000037: Columns: [hierarchy_id, description_string_id, initial_status, subscr_period_count, return_charge, complexity, treat_cleanout_time, code, commission_grp_id, color, discount_ruleset_id, pms_code, description, book_step, spa_cancel_cat_id, rsrv_count, fgrp, max_participant_web, max_participant, subscr_frozen_mi, treat_prep_time, subscr_active_mi, si, mi_type, options, barcode, name_string_id, treat_duration, webgrp, optimum_count, cost, tax_class, base_inv_unit_id, favourites_id, active, voucher_campaign_id, extn_group, mi_id, subscr_period_type, name2, name1]
  1139. 17.08.16 15:05:25:466 - INFO - TableMetadata - HHH000108: Foreign keys: [fk4dde9cc04a8018cd, menu_items_inv_units_fk1, menu_items_dictionary_hie_fk2, menu_items_rulesets_fk1, fk4dde9cc06d33236b, menu_items_dictionary_hie_fk1, menu_items_menu_fgrp_fk1, menu_items_menu_si_fk1, fk4dde9cc058f807fd, fk4dde9cc0ff846b72, menu_items_menu_commission_fk1]
  1140. 17.08.16 15:05:25:467 - INFO - TableMetadata - HHH000126: Indexes: [menu_items_index3, menu_items_pk, uk_85u5o0n2fgq4ksf7rjtfuiyq8, uk_aoymucoa5lkchhpnl613ebh13, sys_c00176006, menu_items_index2]
  1141. 17.08.16 15:05:25:521 - INFO - TableMetadata - HHH000261: Table found: CLUB.MENU_ITEM_SKILLS
  1142. 17.08.16 15:05:25:522 - INFO - TableMetadata - HHH000037: Columns: [menu_item_skills_id, skill_id, mi_id]
  1143. 17.08.16 15:05:25:523 - INFO - TableMetadata - HHH000108: Foreign keys: [fkf4d6480ebe722e3f, fkf4d6480e4e38473c]
  1144. 17.08.16 15:05:25:523 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176010]
  1145. 17.08.16 15:05:25:576 - INFO - TableMetadata - HHH000261: Table found: CLUB.MENU_PACKAGE
  1146. 17.08.16 15:05:25:576 - INFO - TableMetadata - HHH000037: Columns: [break, value_rate, dtl_mi_id, package_mi_id, menu_package_id, day, seq]
  1147. 17.08.16 15:05:25:577 - INFO - TableMetadata - HHH000108: Foreign keys: [fka26ca546bb771203, fka26ca5463e395b19]
  1148. 17.08.16 15:05:25:577 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176012]
  1149. 17.08.16 15:05:25:638 - INFO - TableMetadata - HHH000261: Table found: CLUB.MENU_PRICE
  1150. 17.08.16 15:05:25:639 - INFO - TableMetadata - HHH000037: Columns: [allowed_rvcs, valid_till, redeem_bonus, ordr, price, price_id, valid_from, allowed_time_profile_id, mi_id]
  1151. 17.08.16 15:05:25:639 - INFO - TableMetadata - HHH000108: Foreign keys: [menu_price_menu_items_fk1, menu_price_rvc_group_fk1, menu_price_time_profiles_fk1]
  1152. 17.08.16 15:05:25:639 - INFO - TableMetadata - HHH000126: Indexes: [menu_price_pk, menu_price_uk1]
  1153. 17.08.16 15:05:25:718 - INFO - TableMetadata - HHH000261: Table found: CLUB.MENU_SI
  1154. 17.08.16 15:05:25:718 - INFO - TableMetadata - HHH000037: Columns: [si_id, name, dep_code]
  1155. 17.08.16 15:05:25:718 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1156. 17.08.16 15:05:25:719 - INFO - TableMetadata - HHH000126: Indexes: [menu_si_pk]
  1157. 17.08.16 15:05:25:771 - INFO - TableMetadata - HHH000261: Table found: CLUB.MENU_WEBGRP
  1158. 17.08.16 15:05:25:771 - INFO - TableMetadata - HHH000037: Columns: [name, name_string_id, webgrp_id]
  1159. 17.08.16 15:05:25:772 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1160. 17.08.16 15:05:25:773 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176023, sys_c00176024]
  1161. 17.08.16 15:05:25:825 - INFO - TableMetadata - HHH000261: Table found: CLUB.MI_CALC
  1162. 17.08.16 15:05:25:825 - INFO - TableMetadata - HHH000037: Columns: [amount, dtl_mi_id, inv_unit_id, dtl_seq, mi_id]
  1163. 17.08.16 15:05:25:825 - INFO - TableMetadata - HHH000108: Foreign keys: [fk6b2bc3184e38473c, fk6b2bc318328556e3, fk6b2bc3183e395b19]
  1164. 17.08.16 15:05:25:825 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176030]
  1165. 17.08.16 15:05:25:935 - INFO - TableMetadata - HHH000261: Table found: CLUB.PMS_PACKAGE
  1166. 17.08.16 15:05:25:936 - INFO - TableMetadata - HHH000037: Columns: [pms_package_id, end_date, ackn_empl, menu_item_id, cancel_empl, pms_code, booking_package_id, card_id, ackn_tm, reservation_id, book_empl, book_tm, create_tm, site_id, cancel_tm, start_date]
  1167. 17.08.16 15:05:25:936 - INFO - TableMetadata - HHH000108: Foreign keys: [fk9aff46dd126cbf85, fk9aff46dd9af5946]
  1168. 17.08.16 15:05:25:936 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176038]
  1169. 17.08.16 15:05:26:015 - INFO - TableMetadata - HHH000261: Table found: CLUB.PMS_RATE_MAP
  1170. 17.08.16 15:05:26:015 - INFO - TableMetadata - HHH000037: Columns: [pms_rate_map_id, card_type_id, account_def_id, def_val, master_multiplier, multiplier, master_account_def_id, site_id, rate_code, subscription_mi_id]
  1171. 17.08.16 15:05:26:015 - INFO - TableMetadata - HHH000108: Foreign keys: [fkb1677d86ac409c88, fkb1677d86dd0c4407, fkb1677d8665ddd9e6, fkb1677d86f4d8f99a, fkb1677d8676c3a90b]
  1172. 17.08.16 15:05:26:016 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176041, sys_c00176042]
  1173. 17.08.16 15:05:26:071 - INFO - TableMetadata - HHH000261: Table found: CLUB.REASON_TEXT
  1174. 17.08.16 15:05:26:072 - INFO - TableMetadata - HHH000037: Columns: [text, reason_text_id, type]
  1175. 17.08.16 15:05:26:072 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1176. 17.08.16 15:05:26:073 - INFO - TableMetadata - HHH000126: Indexes: [reason_text_pk]
  1177. Hibernate:
  1178. select
  1179. ifcposting0_.ID as ID1_58_,
  1180. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1181. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1182. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1183. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1184. ifcposting0_.ERR as ERR6_58_,
  1185. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1186. ifcposting0_.PORT as PORT8_58_,
  1187. ifcposting0_.POSTING as POSTING9_58_,
  1188. ifcposting0_.SEQ as SEQ10_58_,
  1189. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1190. ifcposting0_.TM as TM12_58_,
  1191. ifcposting0_.TP as TP13_58_
  1192. from
  1193. club.IFC_POSTINGS ifcposting0_
  1194. where
  1195. (
  1196. trim(ADDRESS)is not null
  1197. )
  1198. and(
  1199. trim(PORT)is not null
  1200. )
  1201. and(
  1202. COMPLETE is null
  1203. )
  1204. and(
  1205. ATTEMPT<3
  1206. )
  1207. and(
  1208. upper(TP)=?
  1209. )
  1210. and(
  1211. 0<=?
  1212. )
  1213. order by
  1214. id
  1215. 17.08.16 15:05:26:170 - INFO - TableMetadata - HHH000261: Table found: CLUB.REGISTRATION
  1216. 17.08.16 15:05:26:170 - INFO - TableMetadata - HHH000037: Columns: [clockout, bussines_date, subscription_item_id, facility_access_dtl_id, clockin, rate_code, reg_id, card_id, rvc_id, booking_id, exp_dep_hour, pms_status, void_flag]
  1217. 17.08.16 15:05:26:171 - INFO - TableMetadata - HHH000108: Foreign keys: [fk39a2d0b96ee2ed66, fk39a2d0b965084e01, registration_cards_fk1]
  1218. 17.08.16 15:05:26:171 - INFO - TableMetadata - HHH000126: Indexes: [registration_pk, reg_index2, reg_index1]
  1219. 17.08.16 15:05:26:227 - INFO - TableMetadata - HHH000261: Table found: CLUB.REGISTRATION_KEYS
  1220. 17.08.16 15:05:26:227 - INFO - TableMetadata - HHH000037: Columns: [key_number, key_id, key_code, reg_id]
  1221. 17.08.16 15:05:26:227 - INFO - TableMetadata - HHH000108: Foreign keys: [reg_keys_registration_fk1]
  1222. 17.08.16 15:05:26:227 - INFO - TableMetadata - HHH000126: Indexes: [reg_keys_pk, idx$$_37920003]
  1223. 17.08.16 15:05:26:273 - INFO - TableMetadata - HHH000261: Table found: CLUB.RESMAN_PRESET
  1224. 17.08.16 15:05:26:273 - INFO - TableMetadata - HHH000037: Columns: [resman_preset_id, clockout, name, clockin, rvc_id]
  1225. 17.08.16 15:05:26:274 - INFO - TableMetadata - HHH000108: Foreign keys: [fkb3aa52046d9e924e]
  1226. 17.08.16 15:05:26:279 - INFO - TableMetadata - HHH000126: Indexes: [resman_preset_pk]
  1227. 17.08.16 15:05:26:322 - INFO - TableMetadata - HHH000261: Table found: CLUB.RESMAN_PRESET_DTL
  1228. 17.08.16 15:05:26:322 - INFO - TableMetadata - HHH000037: Columns: [resman_preset_dtl_id, resman_preset_id, resource_type, resource_id]
  1229. 17.08.16 15:05:26:323 - INFO - TableMetadata - HHH000108: Foreign keys: [fk5295e90160d0044f]
  1230. 17.08.16 15:05:26:323 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176063]
  1231. 17.08.16 15:05:26:380 - INFO - TableMetadata - HHH000261: Table found: CLUB.RESOURCE_SCHEDULE
  1232. 17.08.16 15:05:26:380 - INFO - TableMetadata - HHH000037: Columns: [reference, booking_id, event_id, event_type, color, time_start, resource_type, resource_id, time_end]
  1233. 17.08.16 15:05:26:381 - INFO - TableMetadata - HHH000108: Foreign keys: [fkfaceafa862d46a0e]
  1234. 17.08.16 15:05:26:381 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176070]
  1235. 17.08.16 15:05:26:428 - INFO - TableMetadata - HHH000261: Table found: CLUB.RINV_ACCOUNTING
  1236. 17.08.16 15:05:26:428 - INFO - TableMetadata - HHH000037: Columns: [reference, start_empl, cnt, start_tm, end_empl, end_tm, rinv_accounting_id, card_id, rvc_id, mi_id]
  1237. 17.08.16 15:05:26:429 - INFO - TableMetadata - HHH000108: Foreign keys: [fka00694956d9e924e, fka00694959af5946, fka00694954e38473c]
  1238. 17.08.16 15:05:26:443 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176075]
  1239. 17.08.16 15:05:26:488 - INFO - TableMetadata - HHH000261: Table found: CLUB.RINV_BALANCE
  1240. 17.08.16 15:05:26:488 - INFO - TableMetadata - HHH000037: Columns: [use_cnt, rinv_balance_id, stock_cnt, rvc_id, mi_id]
  1241. 17.08.16 15:05:26:489 - INFO - TableMetadata - HHH000108: Foreign keys: [fkcc9f54bc6d9e924e, fkcc9f54bc4e38473c]
  1242. 17.08.16 15:05:26:489 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176080]
  1243. 17.08.16 15:05:26:573 - INFO - TableMetadata - HHH000261: Table found: CLUB.RULESETS
  1244. 17.08.16 15:05:26:574 - INFO - TableMetadata - HHH000037: Columns: [bonus_activation_delay, ruleset_code, limit_amount, limit_period, ruleset_id, name, options, bonus_account_def_id, weight, limit_count, limit_period_count, type]
  1245. 17.08.16 15:05:26:574 - INFO - TableMetadata - HHH000108: Foreign keys: [rulesets_account_def_fk1]
  1246. 17.08.16 15:05:26:574 - INFO - TableMetadata - HHH000126: Indexes: [rulesets_pk, rulesets_uk_nameacode, rulesets_index1, rulesets_index2]
  1247. 17.08.16 15:05:26:650 - INFO - TableMetadata - HHH000261: Table found: CLUB.RULESETS_DTL
  1248. 17.08.16 15:05:26:650 - INFO - TableMetadata - HHH000037: Columns: [miid, ruleset_id, serv_period, gst, active, counter, limit_period_count, rule_id, fgrp, res_prcnt, res_base, res_amount, limit_amount, limit_period, rvclist, si, chktotal, name, options, action, limit_count, idx, timeprofile_id]
  1249. 17.08.16 15:05:26:650 - INFO - TableMetadata - HHH000108: Foreign keys: [rulesets_dtl_time_profile_fk1, rulesets_dtl_rvc_group_fk1, rulesets_dtl_rulesets_fk1]
  1250. 17.08.16 15:05:26:651 - INFO - TableMetadata - HHH000126: Indexes: [rulesets_dtl_pk]
  1251. 17.08.16 15:05:26:722 - INFO - TableMetadata - HHH000261: Table found: CLUB.RULESET_PERIOD_ACC
  1252. 17.08.16 15:05:26:722 - INFO - TableMetadata - HHH000037: Columns: [rule_id, amount, ruleset_id, id, doc_id, card_id]
  1253. 17.08.16 15:05:26:722 - INFO - TableMetadata - HHH000108: Foreign keys: [fk6dda2afc5557e3ae, fk6dda2afc1508a2ee, fk6dda2afc9af5946]
  1254. 17.08.16 15:05:26:722 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176107]
  1255. 17.08.16 15:05:26:820 - INFO - TableMetadata - HHH000261: Table found: CLUB.RVC
  1256. 17.08.16 15:05:26:820 - INFO - TableMetadata - HHH000037: Columns: [fias_cfg_ig, treat_store_id, reg_rvc_group_id, facebook, web_paym_key, web_book_enable, last_check_num, lon, instagram, time_zone, bussines_date_start, web_paym_driver, rvc_id, sale_store_id, pos_rvc, twitter, phone, vk, site_id, name, options, web_paym_url, email, lat]
  1257. 17.08.16 15:05:26:820 - INFO - TableMetadata - HHH000108: Foreign keys: [fk13e7f3cd52d2d, rvc_rvc_group_fk1, rvc_time_zone_fk1, fk13e7fb0120aba, rvc_sites_fk1]
  1258. 17.08.16 15:05:26:821 - INFO - TableMetadata - HHH000126: Indexes: [rvc_index1, rvc_pk]
  1259. 17.08.16 15:05:26:873 - INFO - TableMetadata - HHH000261: Table found: CLUB.RVC_GROUP
  1260. 17.08.16 15:05:26:873 - INFO - TableMetadata - HHH000037: Columns: [name, rvc_group_id]
  1261. 17.08.16 15:05:26:875 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1262. 17.08.16 15:05:26:876 - INFO - TableMetadata - HHH000126: Indexes: [rvc_group_pk]
  1263. 17.08.16 15:05:26:931 - INFO - TableMetadata - HHH000261: Table found: CLUB.RVC_GROUP_LINK
  1264. 17.08.16 15:05:26:931 - INFO - TableMetadata - HHH000037: Columns: [rvc_group_link_id, rvc_group_id, rvc_id]
  1265. 17.08.16 15:05:26:932 - INFO - TableMetadata - HHH000108: Foreign keys: [rvc_group_link_rvc_group_fk1, rvc_group_link_rvc_fk1]
  1266. 17.08.16 15:05:26:932 - INFO - TableMetadata - HHH000126: Indexes: [rvc_group_link_pk, rvc_group_link_uk1]
  1267. 17.08.16 15:05:26:986 - INFO - TableMetadata - HHH000261: Table found: CLUB.SALARY_CALC
  1268. 17.08.16 15:05:26:987 - INFO - TableMetadata - HHH000037: Columns: [tagret_amnt_min, charge_type, tagret_amnt_max, commission_grp_id, prcnt, tagret_cnt_max, tagret_cnt_min, salary_calc_id, salary_class_id, amnt]
  1269. 17.08.16 15:05:26:987 - INFO - TableMetadata - HHH000108: Foreign keys: [fk40417baa67d18b58, fk40417baa46d2e6d9]
  1270. 17.08.16 15:05:26:987 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176125]
  1271. 17.08.16 15:05:27:071 - INFO - TableMetadata - HHH000261: Table found: CLUB.SALARY_CLASS
  1272. 17.08.16 15:05:27:072 - INFO - TableMetadata - HHH000037: Columns: [absence_penalty, month_plan, late_treshold, month_plan_cnt, late_penalty, month_plan_cond, month_plan_hi, month_plan_cnt_hi, name, penalty_period_amnt, penalty_period_time, hour_rate, salary_class_id, monthly_wage]
  1273. 17.08.16 15:05:27:072 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1274. 17.08.16 15:05:27:073 - INFO - TableMetadata - HHH000126: Indexes: [salary_class_pk]
  1275. 17.08.16 15:05:27:135 - INFO - TableMetadata - HHH000261: Table found: CLUB.SALARY_COMMISSION
  1276. 17.08.16 15:05:27:135 - INFO - TableMetadata - HHH000037: Columns: [overplan_comm_prcnt, commission_amnt, plan_comm_amnt, plan_comm_prcnt, commission_grp_id, plan_factor_prcnt, id, commission_prcnt, salary_class_id, overplan_comm_amnt]
  1277. 17.08.16 15:05:27:135 - INFO - TableMetadata - HHH000108: Foreign keys: [fk20c45e8067d18b58, fk20c45e8046d2e6d9]
  1278. 17.08.16 15:05:27:136 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176141]
  1279. 17.08.16 15:05:27:198 - INFO - TableMetadata - HHH000261: Table found: CLUB.SA_HISTORY
  1280. 17.08.16 15:05:27:199 - INFO - TableMetadata - HHH000037: Columns: [reference, sa_history_id, subscription_accounting_id, empl_id, tm, expiration_date, operator, status]
  1281. 17.08.16 15:05:27:199 - INFO - TableMetadata - HHH000108: Foreign keys: [fkc7caf3835c164d81, fkc7caf383525e30d0]
  1282. 17.08.16 15:05:27:200 - INFO - TableMetadata - HHH000126: Indexes: [sa_history_pk]
  1283. 17.08.16 15:05:27:249 - INFO - TableMetadata - HHH000261: Table found: CLUB.SA_HOLDS
  1284. 17.08.16 15:05:27:249 - INFO - TableMetadata - HHH000037: Columns: [reference, date_start, delete_empl, sa_hold_id, subscription_accounting_id, post_date, delete_date, date_end, post_empl]
  1285. 17.08.16 15:05:27:249 - INFO - TableMetadata - HHH000108: Foreign keys: [fkc2aea6435c164d81]
  1286. 17.08.16 15:05:27:249 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176153]
  1287. 17.08.16 15:05:27:307 - INFO - TableMetadata - HHH000261: Table found: CLUB.SA_SCHEDULER
  1288. 17.08.16 15:05:27:308 - INFO - TableMetadata - HHH000037: Columns: [reference, subscription_accounting_id, business_date, sa_shceduler_id, status]
  1289. 17.08.16 15:05:27:308 - INFO - TableMetadata - HHH000108: Foreign keys: [fk906ecbea5c164d81]
  1290. 17.08.16 15:05:27:308 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176158]
  1291. 17.08.16 15:05:27:356 - INFO - TableMetadata - HHH000261: Table found: CLUB.SE_PRESETS
  1292. 17.08.16 15:05:27:356 - INFO - TableMetadata - HHH000037: Columns: [query, name, se_preset_id]
  1293. 17.08.16 15:05:27:357 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1294. 17.08.16 15:05:27:357 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176558]
  1295. 17.08.16 15:05:27:485 - INFO - TableMetadata - HHH000261: Table found: CLUB.SITES
  1296. 17.08.16 15:05:27:485 - INFO - TableMetadata - HHH000037: Columns: [gi, inq_tm, site_key, db_sync, ip, autostart, htng, port, pms_property, name, options, site_id, svc_tax_class_id, location, tp, v8ifc]
  1297. 17.08.16 15:05:27:485 - INFO - TableMetadata - HHH000108: Foreign keys: [sites_tax_classes_fk1]
  1298. 17.08.16 15:05:27:486 - INFO - TableMetadata - HHH000126: Indexes: [sites_pk, sites_uk1]
  1299. 17.08.16 15:05:27:552 - INFO - TableMetadata - HHH000261: Table found: CLUB.SPA_CANCEL_CAT
  1300. 17.08.16 15:05:27:552 - INFO - TableMetadata - HHH000037: Columns: [name, spa_cancel_cat_id, mi_id]
  1301. 17.08.16 15:05:27:553 - INFO - TableMetadata - HHH000108: Foreign keys: [fk8663420c4e38473c]
  1302. 17.08.16 15:05:27:553 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176167]
  1303. 17.08.16 15:05:27:607 - INFO - TableMetadata - HHH000261: Table found: CLUB.SPA_CANCEL_DTL
  1304. 17.08.16 15:05:27:608 - INFO - TableMetadata - HHH000037: Columns: [charge_amnt, minutes, spa_cancel_dtl_id, spa_cancel_cat_id, charge_prcnt]
  1305. 17.08.16 15:05:27:609 - INFO - TableMetadata - HHH000108: Foreign keys: [fk86634812ff846b72]
  1306. 17.08.16 15:05:27:609 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176169]
  1307. 17.08.16 15:05:27:663 - INFO - TableMetadata - HHH000261: Table found: CLUB.SPA_GROUPS
  1308. 17.08.16 15:05:27:663 - INFO - TableMetadata - HHH000037: Columns: [update_empl, payer_card_id, clockout, group_id, create_tm, pms_code, name, create_empl, clockin, update_tm]
  1309. 17.08.16 15:05:27:663 - INFO - TableMetadata - HHH000108: Foreign keys: [fk89f8cefa16d0e5c]
  1310. 17.08.16 15:05:27:664 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176171]
  1311. 17.08.16 15:05:27:719 - INFO - TableMetadata - HHH000261: Table found: CLUB.STRINGS
  1312. 17.08.16 15:05:27:720 - INFO - TableMetadata - HHH000037: Columns: [lang_id, text, string_id]
  1313. 17.08.16 15:05:27:720 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1314. 17.08.16 15:05:27:720 - INFO - TableMetadata - HHH000126: Indexes: [strings_pk]
  1315. 17.08.16 15:05:27:777 - INFO - TableMetadata - HHH000261: Table found: CLUB.SUBSCRIPTION_ACCOUNTING
  1316. 17.08.16 15:05:27:777 - INFO - TableMetadata - HHH000037: Columns: [extn_flag, mmshp_start_date, note, empl_id, expiration_date, cancellation_reason, subscription_mi_id, is_membership, doc_id, card_id, ref_num, mmshp_end_date, subscription_accounting_id, issue_date, price, dsc_valid_till, dsc_ruleset_id, status, value_ttl]
  1317. 17.08.16 15:05:27:778 - INFO - TableMetadata - HHH000108: Foreign keys: [subscription_accounting_c_fk1, subscription_accounting_m_fk1, subscription_accounting_r_fk1, subscription_accounting_d_fk1]
  1318. 17.08.16 15:05:27:778 - INFO - TableMetadata - HHH000126: Indexes: [subscription_accounting_pk]
  1319. 17.08.16 15:05:27:843 - INFO - TableMetadata - HHH000261: Table found: CLUB.SUBSCRIPTION_ITEMS
  1320. 17.08.16 15:05:27:844 - INFO - TableMetadata - HHH000037: Columns: [cancel_refund, allowed_rvcs, subscription_item_id, value_rate, count, dtl_mi_id, limit_period_count, subscription_mi_id, charge_policy, limit_period, auto_renew, extn_count, limit_count, allowed_time_profile_id]
  1321. 17.08.16 15:05:27:844 - INFO - TableMetadata - HHH000108: Foreign keys: [subscription_items_time_p_fk1, subscription_items_menu_i_fk2, subscription_items_menu_i_fk1, subscription_items_rvc_gr_fk1]
  1322. 17.08.16 15:05:27:845 - INFO - TableMetadata - HHH000126: Indexes: [subscription_items_pk]
  1323. 17.08.16 15:05:27:894 - INFO - TableMetadata - HHH000261: Table found: CLUB.SYSTEM
  1324. 17.08.16 15:05:27:894 - INFO - TableMetadata - HHH000037: Columns: [param_name, value]
  1325. 17.08.16 15:05:27:895 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1326. 17.08.16 15:05:27:895 - INFO - TableMetadata - HHH000126: Indexes: []
  1327. 17.08.16 15:05:27:950 - INFO - TableMetadata - HHH000261: Table found: CLUB.TAXES
  1328. 17.08.16 15:05:27:950 - INFO - TableMetadata - HHH000037: Columns: [rate, name, site_id, type, tax_id]
  1329. 17.08.16 15:05:27:950 - INFO - TableMetadata - HHH000108: Foreign keys: [taxes_sites_fk1]
  1330. 17.08.16 15:05:27:950 - INFO - TableMetadata - HHH000126: Indexes: [taxes_pk]
  1331. 17.08.16 15:05:27:994 - INFO - TableMetadata - HHH000261: Table found: CLUB.TAX_CLASSES
  1332. 17.08.16 15:05:27:995 - INFO - TableMetadata - HHH000037: Columns: [tax_class_id, name, tax_rates]
  1333. 17.08.16 15:05:27:995 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1334. 17.08.16 15:05:27:995 - INFO - TableMetadata - HHH000126: Indexes: [tax_classes_pk]
  1335. 17.08.16 15:05:28:042 - INFO - TableMetadata - HHH000261: Table found: CLUB.TCMENU_ITEMS_CLASSES
  1336. 17.08.16 15:05:28:043 - INFO - TableMetadata - HHH000037: Columns: [menuitem_id, class_id]
  1337. 17.08.16 15:05:28:043 - INFO - TableMetadata - HHH000108: Foreign keys: [fk35c4343648b77c9f, fk35c43436bbd4c426]
  1338. 17.08.16 15:05:28:043 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176205]
  1339. 17.08.16 15:05:28:087 - INFO - TableMetadata - HHH000261: Table found: CLUB.TCQUESTION_CLASSES
  1340. 17.08.16 15:05:28:087 - INFO - TableMetadata - HHH000037: Columns: [class_id, question_id]
  1341. 17.08.16 15:05:28:087 - INFO - TableMetadata - HHH000108: Foreign keys: [fk7bd89d1c48b77c9f, fk7bd89d1cc84fc8c6]
  1342. 17.08.16 15:05:28:087 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176208]
  1343. 17.08.16 15:05:28:135 - INFO - TableMetadata - HHH000261: Table found: CLUB.TC_ANSWER
  1344. 17.08.16 15:05:28:135 - INFO - TableMetadata - HHH000037: Columns: [valid_till, answer, cancelled_tm, tc_qstns_id, posted_by, tm, tc_answer_id, card_id, is_qualified]
  1345. 17.08.16 15:05:28:136 - INFO - TableMetadata - HHH000108: Foreign keys: [fkeb305b8e9af5946, fkeb305b8eee4a3b05]
  1346. 17.08.16 15:05:28:136 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176212]
  1347. 17.08.16 15:05:28:186 - INFO - TableMetadata - HHH000261: Table found: CLUB.TC_CLASS
  1348. 17.08.16 15:05:28:187 - INFO - TableMetadata - HHH000037: Columns: [tc_class_id, name]
  1349. 17.08.16 15:05:28:187 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1350. 17.08.16 15:05:28:188 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176215]
  1351. 17.08.16 15:05:28:239 - INFO - TableMetadata - HHH000261: Table found: CLUB.TC_CLASS_QSTNS
  1352. 17.08.16 15:05:28:240 - INFO - TableMetadata - HHH000037: Columns: [tc_class_id, tc_questions_id, tc_class_qstns_id]
  1353. 17.08.16 15:05:28:240 - INFO - TableMetadata - HHH000108: Foreign keys: [fk2655c401771fdcf, fk2655c403e246c6f]
  1354. 17.08.16 15:05:28:241 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176219]
  1355. Hibernate:
  1356. select
  1357. ifcposting0_.ID as ID1_58_,
  1358. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1359. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1360. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1361. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1362. ifcposting0_.ERR as ERR6_58_,
  1363. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1364. ifcposting0_.PORT as PORT8_58_,
  1365. ifcposting0_.POSTING as POSTING9_58_,
  1366. ifcposting0_.SEQ as SEQ10_58_,
  1367. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1368. ifcposting0_.TM as TM12_58_,
  1369. ifcposting0_.TP as TP13_58_
  1370. from
  1371. club.IFC_POSTINGS ifcposting0_
  1372. where
  1373. (
  1374. trim(ADDRESS)is not null
  1375. )
  1376. and(
  1377. trim(PORT)is not null
  1378. )
  1379. and(
  1380. COMPLETE is null
  1381. )
  1382. and(
  1383. ATTEMPT<3
  1384. )
  1385. and(
  1386. upper(TP)=?
  1387. )
  1388. and(
  1389. 0<=?
  1390. )
  1391. order by
  1392. id
  1393. 17.08.16 15:05:28:291 - INFO - TableMetadata - HHH000261: Table found: CLUB.TC_QSTNS
  1394. 17.08.16 15:05:28:291 - INFO - TableMetadata - HHH000037: Columns: [ql_max, code, question, tc_qstns_id, ql_choices, valid_days, choices, q_type, ql_min]
  1395. 17.08.16 15:05:28:291 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1396. 17.08.16 15:05:28:292 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176225]
  1397. 17.08.16 15:05:28:346 - INFO - TableMetadata - HHH000261: Table found: CLUB.TEMPLATES
  1398. 17.08.16 15:05:28:346 - INFO - TableMetadata - HHH000037: Columns: [system, data, rtf, name, template_id, type, title]
  1399. 17.08.16 15:05:28:346 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1400. 17.08.16 15:05:28:347 - INFO - TableMetadata - HHH000126: Indexes: [templates_pk, templates_uk1]
  1401. 17.08.16 15:05:28:423 - INFO - TableMetadata - HHH000261: Table found: CLUB.TENDERMEDIA
  1402. 17.08.16 15:05:28:424 - INFO - TableMetadata - HHH000037: Columns: [pms_stat, ifc, htng_unit, f_service, pms_paym_svc, f_nosale, privileged, f_closecheck, tm_id, fiscal, allowed_rvc_group_id, name, f_closeshift, id, autobalance_pm]
  1403. 17.08.16 15:05:28:424 - INFO - TableMetadata - HHH000108: Foreign keys: [fk_cb1x0y1le98v9le3gknqcqpks]
  1404. 17.08.16 15:05:28:424 - INFO - TableMetadata - HHH000126: Indexes: [tendermedia_pk, tendermedia_uk1, tendermedia_uk2]
  1405. 17.08.16 15:05:28:481 - INFO - TableMetadata - HHH000261: Table found: CLUB.TICKETS
  1406. 17.08.16 15:05:28:481 - INFO - TableMetadata - HHH000037: Columns: [code, release_tm, ticket_id, reg_tm, doc_id, card_id, mi_id]
  1407. 17.08.16 15:05:28:482 - INFO - TableMetadata - HHH000108: Foreign keys: [fk_aaxjqfoxoxme259vrpcf8l2wn, fk_16ijhlwhlemy4f493wpxra9no, fk_834vufy4u0xghk67pvhtahvsa]
  1408. 17.08.16 15:05:28:482 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00177604]
  1409. 17.08.16 15:05:28:525 - INFO - TableMetadata - HHH000261: Table found: CLUB.TICKET_EVENTS
  1410. 17.08.16 15:05:28:526 - INFO - TableMetadata - HHH000037: Columns: [reference, success, ticket_event_id, tm, ticket_id, rvc_id, direction]
  1411. 17.08.16 15:05:28:526 - INFO - TableMetadata - HHH000108: Foreign keys: [fk_s1vtnjotrxkc58rjg4c80csit, fk_ac2wocf9l2g1floralvfums7s]
  1412. 17.08.16 15:05:28:526 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176565]
  1413. 17.08.16 15:05:28:593 - INFO - TableMetadata - HHH000261: Table found: CLUB.TICKET_RULES
  1414. 17.08.16 15:05:28:593 - INFO - TableMetadata - HHH000037: Columns: [included_mins, charge_mi_id, checkout_policy, active, overtime_mi_id, ticket_rule_id, rvc_id, mi_id]
  1415. 17.08.16 15:05:28:594 - INFO - TableMetadata - HHH000108: Foreign keys: [fk_ivf0esoq7uu8hmkw93ihd4oey, fk_m297kx14i7dufn2r75aomby4q, fk_mqybig5a3upc90dyg8vy7mdjc, fk_bbaxg3d39vsbbshl1dyk6p36v]
  1416. 17.08.16 15:05:28:594 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176568]
  1417. 17.08.16 15:05:28:649 - INFO - TableMetadata - HHH000261: Table found: CLUB.TIMER
  1418. 17.08.16 15:05:28:649 - INFO - TableMetadata - HHH000037: Columns: [reference, act_count, tm_start, tm_stop, timer_id, card_id, rvc_id, mi_id]
  1419. 17.08.16 15:05:28:650 - INFO - TableMetadata - HHH000108: Foreign keys: [fk4c20f259af5946, fk_ti4fsayj36cwwiqt21pe4o6e5, fk4c20f254e38473c]
  1420. 17.08.16 15:05:28:650 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176244]
  1421. 17.08.16 15:05:28:710 - INFO - TableMetadata - HHH000261: Table found: CLUB.TIME_PROFILES
  1422. 17.08.16 15:05:28:710 - INFO - TableMetadata - HHH000037: Columns: [time_profile_code, name, time_profile_id]
  1423. 17.08.16 15:05:28:711 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1424. 17.08.16 15:05:28:711 - INFO - TableMetadata - HHH000126: Indexes: [time_profiles_uk1, time_profiles_uk2, time_profiles_pk]
  1425. 17.08.16 15:05:28:769 - INFO - TableMetadata - HHH000261: Table found: CLUB.TIME_PROFILE_DTLS
  1426. 17.08.16 15:05:28:770 - INFO - TableMetadata - HHH000037: Columns: [wday, min, hour, year, dtl_id, dtl_type, time_profile_id, day, mon]
  1427. 17.08.16 15:05:28:770 - INFO - TableMetadata - HHH000108: Foreign keys: [fk988b33f23afb333]
  1428. 17.08.16 15:05:28:770 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176254]
  1429. 17.08.16 15:05:28:817 - INFO - TableMetadata - HHH000261: Table found: CLUB.TIME_ZONE
  1430. 17.08.16 15:05:28:817 - INFO - TableMetadata - HHH000037: Columns: [name, id]
  1431. 17.08.16 15:05:28:818 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1432. 17.08.16 15:05:28:818 - INFO - TableMetadata - HHH000126: Indexes: [time_zone_pk]
  1433. 17.08.16 15:05:28:870 - INFO - TableMetadata - HHH000261: Table found: CLUB.USERENTRY_HISTORY
  1434. 17.08.16 15:05:28:871 - INFO - TableMetadata - HHH000037: Columns: [client_spec_id, text, counter]
  1435. 17.08.16 15:05:28:871 - INFO - TableMetadata - HHH000108: Foreign keys: [memory_values_client_prof_fk1]
  1436. 17.08.16 15:05:28:872 - INFO - TableMetadata - HHH000126: Indexes: [userentry_history_pk]
  1437. 17.08.16 15:05:28:920 - INFO - TableMetadata - HHH000261: Table found: CLUB.USERS_BI
  1438. 17.08.16 15:05:28:920 - INFO - TableMetadata - HHH000037: Columns: [password, login, reports_priv_lvl]
  1439. 17.08.16 15:05:28:920 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1440. 17.08.16 15:05:28:921 - INFO - TableMetadata - HHH000126: Indexes: [users_bi_pk]
  1441. 17.08.16 15:05:28:983 - INFO - TableMetadata - HHH000261: Table found: CLUB.USERS_ROLES
  1442. 17.08.16 15:05:28:983 - INFO - TableMetadata - HHH000037: Columns: [prv_activity, prv_setup, role_id, profile_priv_lvl, prv_pos, name, prv_ops_ext, prv_ops, dashboard_url, reports_priv_lvl, prv_reports]
  1443. 17.08.16 15:05:28:983 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1444. 17.08.16 15:05:28:984 - INFO - TableMetadata - HHH000126: Indexes: [users_roles_pk, users_roles_uk1]
  1445. 17.08.16 15:05:29:041 - INFO - TableMetadata - HHH000261: Table found: CLUB.VOUCHER
  1446. 17.08.16 15:05:29:042 - INFO - TableMetadata - HHH000037: Columns: [created_person, link_empl, code, lock_reason, valid_from, voucher_campaign_id, use_count, lock_person, created_tm, valid_till, link_date, subscription_accounting_id, dsc, value_balance, voucher_id, link_card_id, items, lock_tm]
  1447. 17.08.16 15:05:29:042 - INFO - TableMetadata - HHH000108: Foreign keys: [fk50f41a8ed7271601, fk50f41a8e6d33236b, fk50f41a8e5c164d81]
  1448. 17.08.16 15:05:29:043 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176285]
  1449. 17.08.16 15:05:29:093 - INFO - TableMetadata - HHH000261: Table found: CLUB.VOUCHER_ACCOUNTING
  1450. 17.08.16 15:05:29:094 - INFO - TableMetadata - HHH000037: Columns: [dsc, voucher_id, voucher_accounting_id, value, doc_id]
  1451. 17.08.16 15:05:29:094 - INFO - TableMetadata - HHH000108: Foreign keys: [fkcbc7e4e660c54dee, fkcbc7e4e65557e3ae]
  1452. 17.08.16 15:05:29:094 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176291]
  1453. 17.08.16 15:05:29:153 - INFO - TableMetadata - HHH000261: Table found: CLUB.VOUCHER_CAMPAIGN
  1454. 17.08.16 15:05:29:153 - INFO - TableMetadata - HHH000037: Columns: [created_person, hierarchy_id, default_validity, dsc_rulset_id, range_from, bonus, prefix, range_till, bonus_type, max_use_count, voucher_campaign_id, code_len, type, created_tm, name, update_person, items, value, update_tm, code_type]
  1455. 17.08.16 15:05:29:154 - INFO - TableMetadata - HHH000108: Foreign keys: [fka37a07a1e8c1f698, fka37a07a1846b17f0]
  1456. 17.08.16 15:05:29:154 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176300]
  1457. 17.08.16 15:05:29:205 - INFO - TableMetadata - HHH000261: Table found: CLUB.WS_TRANS_LOG
  1458. 17.08.16 15:05:29:206 - INFO - TableMetadata - HHH000037: Columns: [request, amount, response, success, client, created_at, id, error, card_id, rvc_id]
  1459. 17.08.16 15:05:29:206 - INFO - TableMetadata - HHH000108: Foreign keys: []
  1460. 17.08.16 15:05:29:207 - INFO - TableMetadata - HHH000126: Indexes: [sys_c00176306]
  1461. 17.08.16 15:05:29:351 - ERROR - SchemaUpdate - HHH000388: Unsuccessful: alter table club.REGISTRATION add constraint FK_enwys1vn3cdk17c1kyj2tw5f3 foreign key (RVC_ID) references club.RVC
  1462. 17.08.16 15:05:29:351 - ERROR - SchemaUpdate - ORA-02267: column type incompatible with referenced column type
  1463.  
  1464. 17.08.16 15:05:29:351 - INFO - SchemaUpdate - HHH000232: Schema update complete
  1465. 17.08.16 15:05:29:368 - INFO - TransactionFactoryInitiator - HHH000399: Using default transaction strategy (direct JDBC transactions)
  1466. Hibernate:
  1467. select
  1468. system0_.PARAM_NAME as PARAM_NAME1_114_0_,
  1469. system0_.VALUE as VALUE2_114_0_
  1470. from
  1471. club.SYSTEM system0_
  1472. where
  1473. system0_.PARAM_NAME=?
  1474. Hibernate:
  1475. select
  1476. this_.REPORTS_PRIV_LVL as REPORTS_PRIV_LVL1_133_0_,
  1477. this_.LOGIN as LOGIN2_133_0_,
  1478. this_.PASSWORD as PASSWORD3_133_0_
  1479. from
  1480. club.USERS_BI this_
  1481. Hibernate:
  1482. select
  1483. ifcposting0_.ID as ID1_58_,
  1484. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1485. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1486. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1487. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1488. ifcposting0_.ERR as ERR6_58_,
  1489. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1490. ifcposting0_.PORT as PORT8_58_,
  1491. ifcposting0_.POSTING as POSTING9_58_,
  1492. ifcposting0_.SEQ as SEQ10_58_,
  1493. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1494. ifcposting0_.TM as TM12_58_,
  1495. ifcposting0_.TP as TP13_58_
  1496. from
  1497. club.IFC_POSTINGS ifcposting0_
  1498. where
  1499. (
  1500. trim(ADDRESS)is not null
  1501. )
  1502. and(
  1503. trim(PORT)is not null
  1504. )
  1505. and(
  1506. COMPLETE is null
  1507. )
  1508. and(
  1509. ATTEMPT<3
  1510. )
  1511. and(
  1512. upper(TP)=?
  1513. )
  1514. and(
  1515. 0<=?
  1516. )
  1517. order by
  1518. id
  1519. Hibernate:
  1520. select
  1521. ifcposting0_.ID as ID1_58_,
  1522. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1523. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1524. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1525. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1526. ifcposting0_.ERR as ERR6_58_,
  1527. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1528. ifcposting0_.PORT as PORT8_58_,
  1529. ifcposting0_.POSTING as POSTING9_58_,
  1530. ifcposting0_.SEQ as SEQ10_58_,
  1531. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1532. ifcposting0_.TM as TM12_58_,
  1533. ifcposting0_.TP as TP13_58_
  1534. from
  1535. club.IFC_POSTINGS ifcposting0_
  1536. where
  1537. (
  1538. trim(ADDRESS)is not null
  1539. )
  1540. and(
  1541. trim(PORT)is not null
  1542. )
  1543. and(
  1544. COMPLETE is null
  1545. )
  1546. and(
  1547. ATTEMPT<3
  1548. )
  1549. and(
  1550. upper(TP)=?
  1551. )
  1552. and(
  1553. 0<=?
  1554. )
  1555. order by
  1556. id
  1557. 17.08.16 15:05:34:260 - INFO - SaajSoapMessageFactory - Creating SAAJ 1.3 MessageFactory with SOAP 1.1 Protocol
  1558. 17.08.16 15:05:34:312 - INFO - Jaxb2Marshaller - Creating JAXBContext with context path [ru.hrs.lassd.club.ws.schema]
  1559. 17.08.16 15:05:36:379 - INFO - HibernateTransactionManager - Using DataSource [org.apache.commons.dbcp2.BasicDataSource@59ea9781] of Hibernate SessionFactory for HibernateTransactionManager
  1560. Hibernate:
  1561. select
  1562. ifcposting0_.ID as ID1_58_,
  1563. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1564. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1565. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1566. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1567. ifcposting0_.ERR as ERR6_58_,
  1568. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1569. ifcposting0_.PORT as PORT8_58_,
  1570. ifcposting0_.POSTING as POSTING9_58_,
  1571. ifcposting0_.SEQ as SEQ10_58_,
  1572. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1573. ifcposting0_.TM as TM12_58_,
  1574. ifcposting0_.TP as TP13_58_
  1575. from
  1576. club.IFC_POSTINGS ifcposting0_
  1577. where
  1578. (
  1579. trim(ADDRESS)is not null
  1580. )
  1581. and(
  1582. trim(PORT)is not null
  1583. )
  1584. and(
  1585. COMPLETE is null
  1586. )
  1587. and(
  1588. ATTEMPT<3
  1589. )
  1590. and(
  1591. upper(TP)=?
  1592. )
  1593. and(
  1594. 0<=?
  1595. )
  1596. order by
  1597. id
  1598. Hibernate:
  1599. select
  1600. this_.SITE_ID as SITE_ID1_107_0_,
  1601. this_.AUTOSTART as AUTOSTART2_107_0_,
  1602. this_.DB_SYNC as DB_SYNC3_107_0_,
  1603. this_.TP as TP4_107_0_,
  1604. this_.GI as GI5_107_0_,
  1605. this_.HTNG as HTNG6_107_0_,
  1606. this_.INQ_TM as INQ_TM7_107_0_,
  1607. this_.IP as IP8_107_0_,
  1608. this_.LOCATION as LOCATION9_107_0_,
  1609. this_.NAME as NAME10_107_0_,
  1610. this_.OPTIONS as OPTIONS11_107_0_,
  1611. this_.PMS_PROPERTY as PMS_PROPERTY12_107_0_,
  1612. this_.PORT as PORT13_107_0_,
  1613. this_.SITE_KEY as SITE_KEY14_107_0_,
  1614. this_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_0_,
  1615. this_.V8IFC as V15_107_0_
  1616. from
  1617. club.SITES this_
  1618. Hibernate:
  1619. select
  1620. this_.SITE_ID as SITE_ID1_107_0_,
  1621. this_.AUTOSTART as AUTOSTART2_107_0_,
  1622. this_.DB_SYNC as DB_SYNC3_107_0_,
  1623. this_.TP as TP4_107_0_,
  1624. this_.GI as GI5_107_0_,
  1625. this_.HTNG as HTNG6_107_0_,
  1626. this_.INQ_TM as INQ_TM7_107_0_,
  1627. this_.IP as IP8_107_0_,
  1628. this_.LOCATION as LOCATION9_107_0_,
  1629. this_.NAME as NAME10_107_0_,
  1630. this_.OPTIONS as OPTIONS11_107_0_,
  1631. this_.PMS_PROPERTY as PMS_PROPERTY12_107_0_,
  1632. this_.PORT as PORT13_107_0_,
  1633. this_.SITE_KEY as SITE_KEY14_107_0_,
  1634. this_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_0_,
  1635. this_.V8IFC as V15_107_0_
  1636. from
  1637. club.SITES this_
  1638. Hibernate:
  1639. select
  1640. ifcposting0_.ID as ID1_58_,
  1641. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1642. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1643. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1644. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1645. ifcposting0_.ERR as ERR6_58_,
  1646. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1647. ifcposting0_.PORT as PORT8_58_,
  1648. ifcposting0_.POSTING as POSTING9_58_,
  1649. ifcposting0_.SEQ as SEQ10_58_,
  1650. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1651. ifcposting0_.TM as TM12_58_,
  1652. ifcposting0_.TP as TP13_58_
  1653. from
  1654. club.IFC_POSTINGS ifcposting0_
  1655. where
  1656. (
  1657. trim(ADDRESS)is not null
  1658. )
  1659. and(
  1660. trim(PORT)is not null
  1661. )
  1662. and(
  1663. COMPLETE is null
  1664. )
  1665. and(
  1666. ATTEMPT<3
  1667. )
  1668. and(
  1669. upper(TP)=?
  1670. )
  1671. and(
  1672. 0<=?
  1673. )
  1674. order by
  1675. id
  1676. 17.08.16 15:05:39:252 - INFO - TngLogger - 2016-08-17 15:05:39.252 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431939252 End time: 1471431953252
  1677. 17.08.16 15:05:40:254 - INFO - TngLogger - 2016-08-17 15:05:40.254 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431940254 End time: 1471431953252
  1678. Hibernate:
  1679. select
  1680. ifcposting0_.ID as ID1_58_,
  1681. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1682. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1683. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1684. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1685. ifcposting0_.ERR as ERR6_58_,
  1686. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1687. ifcposting0_.PORT as PORT8_58_,
  1688. ifcposting0_.POSTING as POSTING9_58_,
  1689. ifcposting0_.SEQ as SEQ10_58_,
  1690. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1691. ifcposting0_.TM as TM12_58_,
  1692. ifcposting0_.TP as TP13_58_
  1693. from
  1694. club.IFC_POSTINGS ifcposting0_
  1695. where
  1696. (
  1697. trim(ADDRESS)is not null
  1698. )
  1699. and(
  1700. trim(PORT)is not null
  1701. )
  1702. and(
  1703. COMPLETE is null
  1704. )
  1705. and(
  1706. ATTEMPT<3
  1707. )
  1708. and(
  1709. upper(TP)=?
  1710. )
  1711. and(
  1712. 0<=?
  1713. )
  1714. order by
  1715. id
  1716. 17.08.16 15:05:41:257 - INFO - TngLogger - 2016-08-17 15:05:41.257 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431941257 End time: 1471431953252
  1717. 17.08.16 15:05:42:264 - INFO - TngLogger - 2016-08-17 15:05:42.264 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431942264 End time: 1471431953252
  1718. Hibernate:
  1719. select
  1720. ifcposting0_.ID as ID1_58_,
  1721. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1722. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1723. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1724. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1725. ifcposting0_.ERR as ERR6_58_,
  1726. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1727. ifcposting0_.PORT as PORT8_58_,
  1728. ifcposting0_.POSTING as POSTING9_58_,
  1729. ifcposting0_.SEQ as SEQ10_58_,
  1730. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1731. ifcposting0_.TM as TM12_58_,
  1732. ifcposting0_.TP as TP13_58_
  1733. from
  1734. club.IFC_POSTINGS ifcposting0_
  1735. where
  1736. (
  1737. trim(ADDRESS)is not null
  1738. )
  1739. and(
  1740. trim(PORT)is not null
  1741. )
  1742. and(
  1743. COMPLETE is null
  1744. )
  1745. and(
  1746. ATTEMPT<3
  1747. )
  1748. and(
  1749. upper(TP)=?
  1750. )
  1751. and(
  1752. 0<=?
  1753. )
  1754. order by
  1755. id
  1756. 17.08.16 15:05:43:265 - INFO - TngLogger - 2016-08-17 15:05:43.265 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431943265 End time: 1471431953252
  1757. 17.08.16 15:05:44:266 - INFO - TngLogger - 2016-08-17 15:05:44.266 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431944266 End time: 1471431953252
  1758. Hibernate:
  1759. select
  1760. ifcposting0_.ID as ID1_58_,
  1761. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1762. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1763. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1764. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1765. ifcposting0_.ERR as ERR6_58_,
  1766. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1767. ifcposting0_.PORT as PORT8_58_,
  1768. ifcposting0_.POSTING as POSTING9_58_,
  1769. ifcposting0_.SEQ as SEQ10_58_,
  1770. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1771. ifcposting0_.TM as TM12_58_,
  1772. ifcposting0_.TP as TP13_58_
  1773. from
  1774. club.IFC_POSTINGS ifcposting0_
  1775. where
  1776. (
  1777. trim(ADDRESS)is not null
  1778. )
  1779. and(
  1780. trim(PORT)is not null
  1781. )
  1782. and(
  1783. COMPLETE is null
  1784. )
  1785. and(
  1786. ATTEMPT<3
  1787. )
  1788. and(
  1789. upper(TP)=?
  1790. )
  1791. and(
  1792. 0<=?
  1793. )
  1794. order by
  1795. id
  1796. 17.08.16 15:05:45:266 - INFO - TngLogger - 2016-08-17 15:05:45.266 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431945266 End time: 1471431953252
  1797. 17.08.16 15:05:46:268 - INFO - TngLogger - 2016-08-17 15:05:46.267 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431946267 End time: 1471431953252
  1798. Hibernate:
  1799. select
  1800. ifcposting0_.ID as ID1_58_,
  1801. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1802. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1803. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1804. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1805. ifcposting0_.ERR as ERR6_58_,
  1806. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1807. ifcposting0_.PORT as PORT8_58_,
  1808. ifcposting0_.POSTING as POSTING9_58_,
  1809. ifcposting0_.SEQ as SEQ10_58_,
  1810. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1811. ifcposting0_.TM as TM12_58_,
  1812. ifcposting0_.TP as TP13_58_
  1813. from
  1814. club.IFC_POSTINGS ifcposting0_
  1815. where
  1816. (
  1817. trim(ADDRESS)is not null
  1818. )
  1819. and(
  1820. trim(PORT)is not null
  1821. )
  1822. and(
  1823. COMPLETE is null
  1824. )
  1825. and(
  1826. ATTEMPT<3
  1827. )
  1828. and(
  1829. upper(TP)=?
  1830. )
  1831. and(
  1832. 0<=?
  1833. )
  1834. order by
  1835. id
  1836. 17.08.16 15:05:47:268 - INFO - TngLogger - 2016-08-17 15:05:47.268 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431947268 End time: 1471431953252
  1837. 17.08.16 15:05:48:270 - INFO - TngLogger - 2016-08-17 15:05:48.270 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431948270 End time: 1471431953252
  1838. Hibernate:
  1839. select
  1840. ifcposting0_.ID as ID1_58_,
  1841. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1842. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1843. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1844. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1845. ifcposting0_.ERR as ERR6_58_,
  1846. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1847. ifcposting0_.PORT as PORT8_58_,
  1848. ifcposting0_.POSTING as POSTING9_58_,
  1849. ifcposting0_.SEQ as SEQ10_58_,
  1850. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1851. ifcposting0_.TM as TM12_58_,
  1852. ifcposting0_.TP as TP13_58_
  1853. from
  1854. club.IFC_POSTINGS ifcposting0_
  1855. where
  1856. (
  1857. trim(ADDRESS)is not null
  1858. )
  1859. and(
  1860. trim(PORT)is not null
  1861. )
  1862. and(
  1863. COMPLETE is null
  1864. )
  1865. and(
  1866. ATTEMPT<3
  1867. )
  1868. and(
  1869. upper(TP)=?
  1870. )
  1871. and(
  1872. 0<=?
  1873. )
  1874. order by
  1875. id
  1876. 17.08.16 15:05:49:271 - INFO - TngLogger - 2016-08-17 15:05:49.271 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431949271 End time: 1471431953252
  1877. 17.08.16 15:05:50:274 - INFO - TngLogger - 2016-08-17 15:05:50.274 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431950274 End time: 1471431953252
  1878. Hibernate:
  1879. select
  1880. ifcposting0_.ID as ID1_58_,
  1881. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1882. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1883. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1884. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1885. ifcposting0_.ERR as ERR6_58_,
  1886. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1887. ifcposting0_.PORT as PORT8_58_,
  1888. ifcposting0_.POSTING as POSTING9_58_,
  1889. ifcposting0_.SEQ as SEQ10_58_,
  1890. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1891. ifcposting0_.TM as TM12_58_,
  1892. ifcposting0_.TP as TP13_58_
  1893. from
  1894. club.IFC_POSTINGS ifcposting0_
  1895. where
  1896. (
  1897. trim(ADDRESS)is not null
  1898. )
  1899. and(
  1900. trim(PORT)is not null
  1901. )
  1902. and(
  1903. COMPLETE is null
  1904. )
  1905. and(
  1906. ATTEMPT<3
  1907. )
  1908. and(
  1909. upper(TP)=?
  1910. )
  1911. and(
  1912. 0<=?
  1913. )
  1914. order by
  1915. id
  1916. 17.08.16 15:05:51:276 - INFO - TngLogger - 2016-08-17 15:05:51.274 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431951274 End time: 1471431953252
  1917. 17.08.16 15:05:52:277 - INFO - TngLogger - 2016-08-17 15:05:52.277 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431952277 End time: 1471431953252
  1918. Hibernate:
  1919. select
  1920. ifcposting0_.ID as ID1_58_,
  1921. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1922. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1923. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1924. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1925. ifcposting0_.ERR as ERR6_58_,
  1926. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1927. ifcposting0_.PORT as PORT8_58_,
  1928. ifcposting0_.POSTING as POSTING9_58_,
  1929. ifcposting0_.SEQ as SEQ10_58_,
  1930. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1931. ifcposting0_.TM as TM12_58_,
  1932. ifcposting0_.TP as TP13_58_
  1933. from
  1934. club.IFC_POSTINGS ifcposting0_
  1935. where
  1936. (
  1937. trim(ADDRESS)is not null
  1938. )
  1939. and(
  1940. trim(PORT)is not null
  1941. )
  1942. and(
  1943. COMPLETE is null
  1944. )
  1945. and(
  1946. ATTEMPT<3
  1947. )
  1948. and(
  1949. upper(TP)=?
  1950. )
  1951. and(
  1952. 0<=?
  1953. )
  1954. order by
  1955. id
  1956. 17.08.16 15:05:53:277 - INFO - TngLogger - 2016-08-17 15:05:53.277 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431953277 End time: 1471431953252
  1957. 17.08.16 15:05:53:278 - INFO - TngLogger - 2016-08-17 15:05:53.277 - INFO - FiasService(552635328).receive: TimeOut close receive:
  1958. 17.08.16 15:05:53:284 - INFO - TngLogger - 2016-08-17 15:05:53.278 - INFO - FiasService(552635328).linkStart: Send Link Start, Link Record, LA
  1959. 17.08.16 15:05:53:286 - INFO - TngLogger - 2016-08-17 15:05:53.286 - INFO - FiasService(552635328).send: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Send: LS|DA160817|TI150553|
  1960. 17.08.16 15:05:54:290 - INFO - TngLogger - 2016-08-17 15:05:54.289 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Receive LA|DA160817|TI140553|
  1961. 17.08.16 15:05:54:293 - INFO - TngLogger - 2016-08-17 15:05:54.293 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431954293 End time: 1471431968287
  1962. Hibernate:
  1963. select
  1964. ifcposting0_.ID as ID1_58_,
  1965. ifcposting0_.ADDRESS as ADDRESS2_58_,
  1966. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  1967. ifcposting0_.COMPLETE as COMPLETE4_58_,
  1968. ifcposting0_.DOC_ID as DOC_ID5_58_,
  1969. ifcposting0_.ERR as ERR6_58_,
  1970. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  1971. ifcposting0_.PORT as PORT8_58_,
  1972. ifcposting0_.POSTING as POSTING9_58_,
  1973. ifcposting0_.SEQ as SEQ10_58_,
  1974. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  1975. ifcposting0_.TM as TM12_58_,
  1976. ifcposting0_.TP as TP13_58_
  1977. from
  1978. club.IFC_POSTINGS ifcposting0_
  1979. where
  1980. (
  1981. trim(ADDRESS)is not null
  1982. )
  1983. and(
  1984. trim(PORT)is not null
  1985. )
  1986. and(
  1987. COMPLETE is null
  1988. )
  1989. and(
  1990. ATTEMPT<3
  1991. )
  1992. and(
  1993. upper(TP)=?
  1994. )
  1995. and(
  1996. 0<=?
  1997. )
  1998. order by
  1999. id
  2000. 17.08.16 15:05:55:293 - INFO - TngLogger - 2016-08-17 15:05:55.293 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431955293 End time: 1471431968287
  2001. 17.08.16 15:05:56:293 - INFO - TngLogger - 2016-08-17 15:05:56.293 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431956293 End time: 1471431968287
  2002. Hibernate:
  2003. select
  2004. ifcposting0_.ID as ID1_58_,
  2005. ifcposting0_.ADDRESS as ADDRESS2_58_,
  2006. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  2007. ifcposting0_.COMPLETE as COMPLETE4_58_,
  2008. ifcposting0_.DOC_ID as DOC_ID5_58_,
  2009. ifcposting0_.ERR as ERR6_58_,
  2010. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  2011. ifcposting0_.PORT as PORT8_58_,
  2012. ifcposting0_.POSTING as POSTING9_58_,
  2013. ifcposting0_.SEQ as SEQ10_58_,
  2014. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  2015. ifcposting0_.TM as TM12_58_,
  2016. ifcposting0_.TP as TP13_58_
  2017. from
  2018. club.IFC_POSTINGS ifcposting0_
  2019. where
  2020. (
  2021. trim(ADDRESS)is not null
  2022. )
  2023. and(
  2024. trim(PORT)is not null
  2025. )
  2026. and(
  2027. COMPLETE is null
  2028. )
  2029. and(
  2030. ATTEMPT<3
  2031. )
  2032. and(
  2033. upper(TP)=?
  2034. )
  2035. and(
  2036. 0<=?
  2037. )
  2038. order by
  2039. id
  2040. 17.08.16 15:05:57:293 - INFO - TngLogger - 2016-08-17 15:05:57.293 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431957293 End time: 1471431968287
  2041. 17.08.16 15:05:58:295 - INFO - TngLogger - 2016-08-17 15:05:58.295 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431958295 End time: 1471431968287
  2042. Hibernate:
  2043. select
  2044. ifcposting0_.ID as ID1_58_,
  2045. ifcposting0_.ADDRESS as ADDRESS2_58_,
  2046. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  2047. ifcposting0_.COMPLETE as COMPLETE4_58_,
  2048. ifcposting0_.DOC_ID as DOC_ID5_58_,
  2049. ifcposting0_.ERR as ERR6_58_,
  2050. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  2051. ifcposting0_.PORT as PORT8_58_,
  2052. ifcposting0_.POSTING as POSTING9_58_,
  2053. ifcposting0_.SEQ as SEQ10_58_,
  2054. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  2055. ifcposting0_.TM as TM12_58_,
  2056. ifcposting0_.TP as TP13_58_
  2057. from
  2058. club.IFC_POSTINGS ifcposting0_
  2059. where
  2060. (
  2061. trim(ADDRESS)is not null
  2062. )
  2063. and(
  2064. trim(PORT)is not null
  2065. )
  2066. and(
  2067. COMPLETE is null
  2068. )
  2069. and(
  2070. ATTEMPT<3
  2071. )
  2072. and(
  2073. upper(TP)=?
  2074. )
  2075. and(
  2076. 0<=?
  2077. )
  2078. order by
  2079. id
  2080. 17.08.16 15:05:59:301 - INFO - TngLogger - 2016-08-17 15:05:59.301 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431959301 End time: 1471431968287
  2081. 17.08.16 15:06:00:302 - INFO - TngLogger - 2016-08-17 15:06:00.302 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431960302 End time: 1471431968287
  2082. Hibernate:
  2083. select
  2084. ifcposting0_.ID as ID1_58_,
  2085. ifcposting0_.ADDRESS as ADDRESS2_58_,
  2086. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  2087. ifcposting0_.COMPLETE as COMPLETE4_58_,
  2088. ifcposting0_.DOC_ID as DOC_ID5_58_,
  2089. ifcposting0_.ERR as ERR6_58_,
  2090. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  2091. ifcposting0_.PORT as PORT8_58_,
  2092. ifcposting0_.POSTING as POSTING9_58_,
  2093. ifcposting0_.SEQ as SEQ10_58_,
  2094. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  2095. ifcposting0_.TM as TM12_58_,
  2096. ifcposting0_.TP as TP13_58_
  2097. from
  2098. club.IFC_POSTINGS ifcposting0_
  2099. where
  2100. (
  2101. trim(ADDRESS)is not null
  2102. )
  2103. and(
  2104. trim(PORT)is not null
  2105. )
  2106. and(
  2107. COMPLETE is null
  2108. )
  2109. and(
  2110. ATTEMPT<3
  2111. )
  2112. and(
  2113. upper(TP)=?
  2114. )
  2115. and(
  2116. 0<=?
  2117. )
  2118. order by
  2119. id
  2120. 17.08.16 15:06:01:302 - INFO - TngLogger - 2016-08-17 15:06:01.302 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431961302 End time: 1471431968287
  2121. 17.08.16 15:06:02:303 - INFO - TngLogger - 2016-08-17 15:06:02.303 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431962303 End time: 1471431968287
  2122. Hibernate:
  2123. select
  2124. ifcposting0_.ID as ID1_58_,
  2125. ifcposting0_.ADDRESS as ADDRESS2_58_,
  2126. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  2127. ifcposting0_.COMPLETE as COMPLETE4_58_,
  2128. ifcposting0_.DOC_ID as DOC_ID5_58_,
  2129. ifcposting0_.ERR as ERR6_58_,
  2130. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  2131. ifcposting0_.PORT as PORT8_58_,
  2132. ifcposting0_.POSTING as POSTING9_58_,
  2133. ifcposting0_.SEQ as SEQ10_58_,
  2134. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  2135. ifcposting0_.TM as TM12_58_,
  2136. ifcposting0_.TP as TP13_58_
  2137. from
  2138. club.IFC_POSTINGS ifcposting0_
  2139. where
  2140. (
  2141. trim(ADDRESS)is not null
  2142. )
  2143. and(
  2144. trim(PORT)is not null
  2145. )
  2146. and(
  2147. COMPLETE is null
  2148. )
  2149. and(
  2150. ATTEMPT<3
  2151. )
  2152. and(
  2153. upper(TP)=?
  2154. )
  2155. and(
  2156. 0<=?
  2157. )
  2158. order by
  2159. id
  2160. 17.08.16 15:06:03:303 - INFO - TngLogger - 2016-08-17 15:06:03.303 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431963303 End time: 1471431968287
  2161. 17.08.16 15:06:04:304 - INFO - TngLogger - 2016-08-17 15:06:04.304 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431964304 End time: 1471431968287
  2162. Hibernate:
  2163. select
  2164. ifcposting0_.ID as ID1_58_,
  2165. ifcposting0_.ADDRESS as ADDRESS2_58_,
  2166. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  2167. ifcposting0_.COMPLETE as COMPLETE4_58_,
  2168. ifcposting0_.DOC_ID as DOC_ID5_58_,
  2169. ifcposting0_.ERR as ERR6_58_,
  2170. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  2171. ifcposting0_.PORT as PORT8_58_,
  2172. ifcposting0_.POSTING as POSTING9_58_,
  2173. ifcposting0_.SEQ as SEQ10_58_,
  2174. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  2175. ifcposting0_.TM as TM12_58_,
  2176. ifcposting0_.TP as TP13_58_
  2177. from
  2178. club.IFC_POSTINGS ifcposting0_
  2179. where
  2180. (
  2181. trim(ADDRESS)is not null
  2182. )
  2183. and(
  2184. trim(PORT)is not null
  2185. )
  2186. and(
  2187. COMPLETE is null
  2188. )
  2189. and(
  2190. ATTEMPT<3
  2191. )
  2192. and(
  2193. upper(TP)=?
  2194. )
  2195. and(
  2196. 0<=?
  2197. )
  2198. order by
  2199. id
  2200. 17.08.16 15:06:05:304 - INFO - TngLogger - 2016-08-17 15:06:05.304 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431965304 End time: 1471431968287
  2201. 17.08.16 15:06:06:306 - INFO - TngLogger - 2016-08-17 15:06:06.305 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431966305 End time: 1471431968287
  2202. Hibernate:
  2203. select
  2204. ifcposting0_.ID as ID1_58_,
  2205. ifcposting0_.ADDRESS as ADDRESS2_58_,
  2206. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  2207. ifcposting0_.COMPLETE as COMPLETE4_58_,
  2208. ifcposting0_.DOC_ID as DOC_ID5_58_,
  2209. ifcposting0_.ERR as ERR6_58_,
  2210. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  2211. ifcposting0_.PORT as PORT8_58_,
  2212. ifcposting0_.POSTING as POSTING9_58_,
  2213. ifcposting0_.SEQ as SEQ10_58_,
  2214. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  2215. ifcposting0_.TM as TM12_58_,
  2216. ifcposting0_.TP as TP13_58_
  2217. from
  2218. club.IFC_POSTINGS ifcposting0_
  2219. where
  2220. (
  2221. trim(ADDRESS)is not null
  2222. )
  2223. and(
  2224. trim(PORT)is not null
  2225. )
  2226. and(
  2227. COMPLETE is null
  2228. )
  2229. and(
  2230. ATTEMPT<3
  2231. )
  2232. and(
  2233. upper(TP)=?
  2234. )
  2235. and(
  2236. 0<=?
  2237. )
  2238. order by
  2239. id
  2240. 17.08.16 15:06:07:307 - INFO - TngLogger - 2016-08-17 15:06:07.307 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431967307 End time: 1471431968287
  2241. 17.08.16 15:06:08:308 - INFO - TngLogger - 2016-08-17 15:06:08.308 - INFO - FiasService(552635328).receive: From:/192.168.170.49:50241 to:/192.168.172.23:5005 Check timeout. Current: 1471431968308 End time: 1471431968287
  2242. 17.08.16 15:06:08:309 - INFO - TngLogger - 2016-08-17 15:06:08.309 - INFO - FiasService(552635328).receive: TimeOut close receive: LA|DA160817|TI140553|
  2243. FiasService Run Service Tread
  2244. FiasService Run Service Tread ft.isStarted=false
  2245. FiasService Runing Service Tread
  2246. 17.08.16 15:06:08:313 - INFO - TngLogger - 2016-08-17 15:06:08.313 - INFO - FiasService(552635328).dbSync_onStartIFC: Start DB Swap on Start FIAS for site: 1000
  2247. Hibernate:
  2248. select
  2249. ifcposting0_.ID as ID1_58_,
  2250. ifcposting0_.ADDRESS as ADDRESS2_58_,
  2251. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  2252. ifcposting0_.COMPLETE as COMPLETE4_58_,
  2253. ifcposting0_.DOC_ID as DOC_ID5_58_,
  2254. ifcposting0_.ERR as ERR6_58_,
  2255. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  2256. ifcposting0_.PORT as PORT8_58_,
  2257. ifcposting0_.POSTING as POSTING9_58_,
  2258. ifcposting0_.SEQ as SEQ10_58_,
  2259. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  2260. ifcposting0_.TM as TM12_58_,
  2261. ifcposting0_.TP as TP13_58_
  2262. from
  2263. club.IFC_POSTINGS ifcposting0_
  2264. where
  2265. (
  2266. trim(ADDRESS)is not null
  2267. )
  2268. and(
  2269. trim(PORT)is not null
  2270. )
  2271. and(
  2272. COMPLETE is null
  2273. )
  2274. and(
  2275. ATTEMPT<3
  2276. )
  2277. and(
  2278. upper(TP)=?
  2279. )
  2280. and(
  2281. 0<=?
  2282. )
  2283. order by
  2284. id
  2285. Hibernate:
  2286. select
  2287. ifcposting0_.ID as ID1_58_,
  2288. ifcposting0_.ADDRESS as ADDRESS2_58_,
  2289. ifcposting0_.ATTEMPT as ATTEMPT3_58_,
  2290. ifcposting0_.COMPLETE as COMPLETE4_58_,
  2291. ifcposting0_.DOC_ID as DOC_ID5_58_,
  2292. ifcposting0_.ERR as ERR6_58_,
  2293. ifcposting0_.MSG_NUMBER as MSG_NUMBER7_58_,
  2294. ifcposting0_.PORT as PORT8_58_,
  2295. ifcposting0_.POSTING as POSTING9_58_,
  2296. ifcposting0_.SEQ as SEQ10_58_,
  2297. ifcposting0_.SITE_KEY as SITE_KEY11_58_,
  2298. ifcposting0_.TM as TM12_58_,
  2299. ifcposting0_.TP as TP13_58_
  2300. from
  2301. club.IFC_POSTINGS ifcposting0_
  2302. where
  2303. (
  2304. trim(ADDRESS)is not null
  2305. )
  2306. and(
  2307. trim(PORT)is not null
  2308. )
  2309. and(
  2310. COMPLETE is null
  2311. )
  2312. and(
  2313. ATTEMPT<3
  2314. )
  2315. and(
  2316. upper(TP)=?
  2317. )
  2318. and(
  2319. 0<=?
  2320. )
  2321. order by
  2322. id
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!