API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 19th, 2018
136
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 96.13 KB | None | 0 0
raw download clone embed print report
  1. # MicroStrategy Log version 2.0
  2. 2018-07-19 17:09:34.477 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5162][THR:140220044617472][Report Server][Info] Cache backup thread exits.
  3. 2018-07-19 17:09:34.512 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5162][THR:140220090279680][Report Server][Info] Cache backup thread exits.
  4. 2018-07-19 17:09:34.526 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5162][THR:140219722622720][Report Server][Info] Cache backup thread exits.
  5. 2018-07-19 17:09:34.533 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5162][THR:140219655382784][Report Server][Info] Cache backup thread exits.
  6. 2018-07-19 17:09:34.541 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5162][THR:140219595220736][Report Server][Info] Cache backup thread exits.
  7. 2018-07-19 17:09:34.549 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5162][THR:140219509630720][Report Server][Info] Cache backup thread exits.
  8. 2018-07-19 17:09:34.557 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5162][THR:140219483875072][Report Server][Info] Cache backup thread exits.
  9. 2018-07-19 17:09:34.575 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5162][THR:140219394549504][Report Server][Info] Cache backup thread exits.
  10. 2018-07-19 17:09:34.588 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5162][THR:140218940253952][Report Server][Info] Cache backup thread exits.
  11. 2018-07-19 17:11:56.908 [HOST:env-92950laiouse1][SERVER:][PID:5651][THR:140313146604800][RefineProcess][Info] Failed to read refine server port config from registry, trying to start refine server with port 3333.
  12. 2018-07-19 17:11:58.625 [HOST:env-92950laiouse1][SERVER:][PID:5651][THR:140313146604800][RefineProcess][Info] OpenRefine Server is starting
  13. 2018-07-19 17:12:24.121 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558237820672][Report Server][Info] Report Cache Manager: I-Server sets max cache count to 10000.
  14. 2018-07-19 17:12:24.121 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558237820672][Report Server][Info] Report Cache Manager: I-Server sets max memory cache size to 25600 MB.
  15. 2018-07-19 17:12:24.121 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558237820672][Report Server][Info] Report Cache Manager: Max LKUP memory size of 0x7FD643D5D61C MB is invalid.
  16. 2018-07-19 17:12:24.121 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558237820672][Report Server][Info] Report Cache Manager: I-Server sets max LKUP memory size to 8737792 MB.
  17. 2018-07-19 17:12:24.121 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558237820672][Report Server][Info] Report Cache Manager: I-Server sets bucket count to 5.
  18. 2018-07-19 17:12:24.121 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558237820672][Report Server][Info] Report Cache Manager: I-Server sets bucket per lock to 1.
  19. 2018-07-19 17:12:24.264 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558237820672][Report Server][Info] 0 Report Cache Info Loaded.
  20. 2018-07-19 17:12:24.264 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558237820672][Report Server][Info] Report Cache File Path: /opt/mstr/MicroStrategy/IntelligenceServer/Caches/cloud_10s
  21. 2018-07-19 17:12:24.264 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558237820672][Report Server][Info] Report Cache Version: 8.0.0.1
  22. 2018-07-19 17:12:24.801 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558239921920][Report Server][Info] Report Cache Manager: I-Server sets max cache count to 10000.
  23. 2018-07-19 17:12:24.801 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558239921920][Report Server][Info] Report Cache Manager: I-Server sets max memory cache size to 51200 MB.
  24. 2018-07-19 17:12:24.801 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558239921920][Report Server][Info] Report Cache Manager: Max LKUP memory size of 0x7FD643F5E61C MB is invalid.
  25. 2018-07-19 17:12:24.802 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558239921920][Report Server][Info] Report Cache Manager: I-Server sets max LKUP memory size to 17475584 MB.
  26. 2018-07-19 17:12:24.802 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558239921920][Report Server][Info] Report Cache Manager: I-Server sets bucket count to 5.
  27. 2018-07-19 17:12:24.802 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558239921920][Report Server][Info] Report Cache Manager: I-Server sets bucket per lock to 1.
  28. 2018-07-19 17:12:24.843 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558239921920][Report Server][Info] 0 Report Cache Info Loaded.
  29. 2018-07-19 17:12:24.843 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558239921920][Report Server][Info] Report Cache File Path: /opt/mstr/MicroStrategy/IntelligenceServer/Caches/cloud_10s
  30. 2018-07-19 17:12:24.843 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558239921920][Report Server][Info] Report Cache Version: 8.0.0.1
  31. 2018-07-19 17:12:46.187 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557875672832][Report Server][Info] Report Cache Manager: I-Server sets max cache count to 10000.
  32. 2018-07-19 17:12:46.187 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557875672832][Report Server][Info] Report Cache Manager: I-Server sets max memory cache size to 25600 MB.
  33. 2018-07-19 17:12:46.187 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557875672832][Report Server][Info] Report Cache Manager: Max LKUP memory size of 0x7FD62E3FE61C MB is invalid.
  34. 2018-07-19 17:12:46.187 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557875672832][Report Server][Info] Report Cache Manager: I-Server sets max LKUP memory size to 8737792 MB.
  35. 2018-07-19 17:12:46.187 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557875672832][Report Server][Info] Report Cache Manager: I-Server sets bucket count to 5.
  36. 2018-07-19 17:12:46.187 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557875672832][Report Server][Info] Report Cache Manager: I-Server sets bucket per lock to 1.
  37. 2018-07-19 17:12:46.301 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557875672832][Report Server][Info] 0 Report Cache Info Loaded.
  38. 2018-07-19 17:12:46.301 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557875672832][Report Server][Info] Report Cache File Path: /opt/mstr/MicroStrategy/IntelligenceServer/Caches/cloud_10s
  39. 2018-07-19 17:12:46.301 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557875672832][Report Server][Info] Report Cache Version: 8.0.0.1
  40. 2018-07-19 17:12:51.814 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557788518144][Report Server][Info] Report Cache Manager: I-Server sets max cache count to 10000.
  41. 2018-07-19 17:12:51.814 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557788518144][Report Server][Info] Report Cache Manager: I-Server sets max memory cache size to 25600 MB.
  42. 2018-07-19 17:12:51.814 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557788518144][Report Server][Info] Report Cache Manager: Max LKUP memory size of 0x7FD6290E061C MB is invalid.
  43. 2018-07-19 17:12:51.814 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557788518144][Report Server][Info] Report Cache Manager: I-Server sets max LKUP memory size to 8737792 MB.
  44. 2018-07-19 17:12:51.814 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557788518144][Report Server][Info] Report Cache Manager: I-Server sets bucket count to 5.
  45. 2018-07-19 17:12:51.814 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557788518144][Report Server][Info] Report Cache Manager: I-Server sets bucket per lock to 1.
  46. 2018-07-19 17:12:51.843 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557788518144][Report Server][Info] 0 Report Cache Info Loaded.
  47. 2018-07-19 17:12:51.843 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557788518144][Report Server][Info] Report Cache File Path: /opt/mstr/MicroStrategy/IntelligenceServer/Caches/cloud_10s
  48. 2018-07-19 17:12:51.843 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557788518144][Report Server][Info] Report Cache Version: 8.0.0.1
  49. 2018-07-19 17:12:56.479 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557770094336][Report Server][Info] Report Cache Manager: I-Server sets max cache count to 10000.
  50. 2018-07-19 17:12:56.479 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557770094336][Report Server][Info] Report Cache Manager: I-Server sets max memory cache size to 25600 MB.
  51. 2018-07-19 17:12:56.479 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557770094336][Report Server][Info] Report Cache Manager: Max LKUP memory size of 0x7FD627F4E61C MB is invalid.
  52. 2018-07-19 17:12:56.479 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557770094336][Report Server][Info] Report Cache Manager: I-Server sets max LKUP memory size to 8737792 MB.
  53. 2018-07-19 17:12:56.479 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557770094336][Report Server][Info] Report Cache Manager: I-Server sets bucket count to 5.
  54. 2018-07-19 17:12:56.479 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557770094336][Report Server][Info] Report Cache Manager: I-Server sets bucket per lock to 1.
  55. 2018-07-19 17:12:56.650 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557770094336][Report Server][Info] 0 Report Cache Info Loaded.
  56. 2018-07-19 17:12:56.650 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557770094336][Report Server][Info] Report Cache File Path: /opt/mstr/MicroStrategy/IntelligenceServer/Caches/cloud_10s
  57. 2018-07-19 17:12:56.650 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557770094336][Report Server][Info] Report Cache Version: 8.0.0.1
  58. 2018-07-19 17:13:02.740 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557641193216][Report Server][Info] Report Cache Manager: I-Server sets max cache count to 10000.
  59. 2018-07-19 17:13:02.740 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557641193216][Report Server][Info] Report Cache Manager: I-Server sets max memory cache size to 25600 MB.
  60. 2018-07-19 17:13:02.740 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557641193216][Report Server][Info] Report Cache Manager: Max LKUP memory size of 0x7FD62046061C MB is invalid.
  61. 2018-07-19 17:13:02.740 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557641193216][Report Server][Info] Report Cache Manager: I-Server sets max LKUP memory size to 8737792 MB.
  62. 2018-07-19 17:13:02.740 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557641193216][Report Server][Info] Report Cache Manager: I-Server sets bucket count to 5.
  63. 2018-07-19 17:13:02.740 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557641193216][Report Server][Info] Report Cache Manager: I-Server sets bucket per lock to 1.
  64. 2018-07-19 17:13:02.811 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557641193216][Report Server][Info] 0 Report Cache Info Loaded.
  65. 2018-07-19 17:13:02.811 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557641193216][Report Server][Info] Report Cache File Path: /opt/mstr/MicroStrategy/IntelligenceServer/Caches/cloud_10s
  66. 2018-07-19 17:13:02.811 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557641193216][Report Server][Info] Report Cache Version: 8.0.0.1
  67. 2018-07-19 17:13:08.524 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557618501376][Report Server][Info] Report Cache Manager: I-Server sets max cache count to 10000.
  68. 2018-07-19 17:13:08.524 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557618501376][Report Server][Info] Report Cache Manager: I-Server sets max memory cache size to 25600 MB.
  69. 2018-07-19 17:13:08.524 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557618501376][Report Server][Info] Report Cache Manager: Max LKUP memory size of 0x7FD61EEBC61C MB is invalid.
  70. 2018-07-19 17:13:08.524 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557618501376][Report Server][Info] Report Cache Manager: I-Server sets max LKUP memory size to 8737792 MB.
  71. 2018-07-19 17:13:08.524 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557618501376][Report Server][Info] Report Cache Manager: I-Server sets bucket count to 5.
  72. 2018-07-19 17:13:08.524 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557618501376][Report Server][Info] Report Cache Manager: I-Server sets bucket per lock to 1.
  73. 2018-07-19 17:13:08.613 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557618501376][Report Server][Info] 0 Report Cache Info Loaded.
  74. 2018-07-19 17:13:08.613 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557618501376][Report Server][Info] Report Cache File Path: /opt/mstr/MicroStrategy/IntelligenceServer/Caches/cloud_10s
  75. 2018-07-19 17:13:08.613 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557618501376][Report Server][Info] Report Cache Version: 8.0.0.1
  76. 2018-07-19 17:13:12.621 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557569226496][Report Server][Info] Report Cache Manager: I-Server sets max cache count to 10000.
  77. 2018-07-19 17:13:12.621 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557569226496][Report Server][Info] Report Cache Manager: I-Server sets max memory cache size to 25600 MB.
  78. 2018-07-19 17:13:12.621 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557569226496][Report Server][Info] Report Cache Manager: Max LKUP memory size of 0x7FD61BFBE61C MB is invalid.
  79. 2018-07-19 17:13:12.621 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557569226496][Report Server][Info] Report Cache Manager: I-Server sets max LKUP memory size to 8737792 MB.
  80. 2018-07-19 17:13:12.621 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557569226496][Report Server][Info] Report Cache Manager: I-Server sets bucket count to 5.
  81. 2018-07-19 17:13:12.621 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557569226496][Report Server][Info] Report Cache Manager: I-Server sets bucket per lock to 1.
  82. 2018-07-19 17:13:12.719 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557569226496][Report Server][Info] 2 Report Cache Info Loaded.
  83. 2018-07-19 17:13:12.719 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557569226496][Report Server][Info] Report Cache File Path: /opt/mstr/MicroStrategy/IntelligenceServer/Caches/cloud_10s
  84. 2018-07-19 17:13:12.719 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557569226496][Report Server][Info] Report Cache Version: 8.0.0.1
  85. 2018-07-19 17:13:20.968 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557140686592][Report Server][Info] Report Cache Manager: I-Server sets max cache count to 10000.
  86. 2018-07-19 17:13:20.968 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557140686592][Report Server][Info] Report Cache Manager: I-Server sets max memory cache size to 25600 MB.
  87. 2018-07-19 17:13:20.968 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557140686592][Report Server][Info] Report Cache Manager: Max LKUP memory size of 0x7FD60270E61C MB is invalid.
  88. 2018-07-19 17:13:20.968 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557140686592][Report Server][Info] Report Cache Manager: I-Server sets max LKUP memory size to 8737792 MB.
  89. 2018-07-19 17:13:20.968 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557140686592][Report Server][Info] Report Cache Manager: I-Server sets bucket count to 5.
  90. 2018-07-19 17:13:20.968 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557140686592][Report Server][Info] Report Cache Manager: I-Server sets bucket per lock to 1.
  91. 2018-07-19 17:13:21.181 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557140686592][Report Server][Info] 32 Report Cache Info Loaded.
  92. 2018-07-19 17:13:21.181 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557140686592][Report Server][Info] Report Cache File Path: /opt/mstr/MicroStrategy/IntelligenceServer/Caches/cloud_10s
  93. 2018-07-19 17:13:21.181 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557140686592][Report Server][Info] Report Cache Version: 8.0.0.1
  94. 2018-07-19 17:13:25.832 [HOST:env-92950laiouse1][SERVER:][PID:6785][THR:140226045881600][HGoSManager][Info] HGoS Manager is starting
  95. 2018-07-19 17:13:35.666 [HOST:env-92950laiouse1][SERVER:][PID:6785][THR:140225363150592][HGoSManager][Info] HGoS Manager port is 5688
  96. 2018-07-19 17:37:04.229 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557974824704][Database Classes][SQL Trace] Executing Parameterized SQL: insert into STG_IS_SESSION_STATS (SESSIONID,SERVERID,SERVERMACHINE,WEBMACHINE,USERID,CLIENTMACHINE,CONNECTTIME,DISCONNECTTIME,EVENTSOURCE,DAY_ID,HOUR_ID,MINUTE_ID,REPOSITORYID,RECORDTIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
  97. 2018-07-19 17:37:24.235 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557974824704][Database Classes][SQL Trace] Executing Parameterized SQL: insert into STG_IS_SESSION_STATS (SESSIONID,SERVERID,SERVERMACHINE,WEBMACHINE,USERID,CLIENTMACHINE,CONNECTTIME,DISCONNECTTIME,EVENTSOURCE,DAY_ID,HOUR_ID,MINUTE_ID,REPOSITORYID,RECORDTIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
  98. 2018-07-19 17:38:54.252 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557974824704][Database Classes][SQL Trace] Executing Parameterized SQL: insert into STG_IS_SESSION_STATS (SESSIONID,SERVERID,SERVERMACHINE,WEBMACHINE,USERID,CLIENTMACHINE,CONNECTTIME,DISCONNECTTIME,EVENTSOURCE,DAY_ID,HOUR_ID,MINUTE_ID,REPOSITORYID,RECORDTIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
  99. 2018-07-19 17:40:00.213 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  100. 2018-07-19 17:40:00.215 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  101. 2018-07-19 17:40:00.216 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SET @@SESSION.SQL_MODE = 'NO_ENGINE_SUBSTITUTION,NO_BACKSLASH_ESCAPES'
  102. 2018-07-19 17:40:00.217 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
  103. 2018-07-19 17:40:00.218 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SET @@SESSION.SQL_MODE = 'NO_ENGINE_SUBSTITUTION,NO_BACKSLASH_ESCAPES'
  104. 2018-07-19 17:40:00.220 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='1E6460C94E9DEC452E29D6A1D3F9E365') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='B7CA92F04B9FAE8D941C3E9B7E0CD754')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  105. 2018-07-19 17:40:00.226 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  106. 2018-07-19 17:40:00.229 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='1E6460C94E9DEC452E29D6A1D3F9E365') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='163613BB4B34BD0B08CE8AB4828EBE97')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  107. 2018-07-19 17:40:00.235 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  108. 2018-07-19 17:40:00.236 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  109. 2018-07-19 17:40:00.237 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='1E6460C94E9DEC452E29D6A1D3F9E365') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='CE52831411E696C8BD2F0080EFD5AF44')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  110. 2018-07-19 17:40:00.238 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
  111. 2018-07-19 17:40:00.248 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  112. 2018-07-19 17:40:00.250 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='1E6460C94E9DEC452E29D6A1D3F9E365') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='B3FEE61A11E696C8BD0F0080EFC58F44')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  113. 2018-07-19 17:40:00.251 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  114. 2018-07-19 17:40:00.255 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  115. 2018-07-19 17:40:00.255 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
  116. 2018-07-19 17:40:00.257 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='1E6460C94E9DEC452E29D6A1D3F9E365') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='4BAE16A340B995CAD24193AA3AC15D29')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  117. 2018-07-19 17:40:00.261 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  118. 2018-07-19 17:40:00.263 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='1E6460C94E9DEC452E29D6A1D3F9E365') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='4C09350211E69712BAEE0080EFB56D41')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  119. 2018-07-19 17:40:00.267 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  120. 2018-07-19 17:40:00.270 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='1E6460C94E9DEC452E29D6A1D3F9E365') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='85C3FE7E11E7028A06660080EFB5E5D4')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  121. 2018-07-19 17:40:00.282 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  122. 2018-07-19 17:40:00.284 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='1E6460C94E9DEC452E29D6A1D3F9E365') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='19E3120C11E847D125D60080EFF5FD36')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  123. 2018-07-19 17:40:00.289 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  124. 2018-07-19 17:40:00.291 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558382176000][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='1E6460C94E9DEC452E29D6A1D3F9E365') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='04B3BD3C11E873FF1E810080EFF5A4D1')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  125. 2018-07-19 17:40:00.308 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  126. 2018-07-19 17:40:00.311 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
  127. 2018-07-19 17:40:00.325 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  128. 2018-07-19 17:40:00.327 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
  129. 2018-07-19 17:40:00.342 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  130. 2018-07-19 17:40:00.344 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
  131. 2018-07-19 17:40:00.358 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  132. 2018-07-19 17:40:00.360 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
  133. 2018-07-19 17:40:00.374 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  134. 2018-07-19 17:40:00.376 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
  135. 2018-07-19 17:40:00.390 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  136. 2018-07-19 17:40:00.393 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
  137. 2018-07-19 17:40:00.407 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  138. 2018-07-19 17:40:00.409 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556994926336][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT DISTINCT info.OBJECT_ID, info.PROJECT_ID, info.OBJECT_TYPE, COALESCE(otrns.TRANSLATION, info.OBJECT_UNAME) FROM DSSMDOBJINFO info LEFT JOIN DSSMDOBJTRNS otrns ON otrns.PROPERTY=1 AND otrns.LOCALE=1033 AND info.OBJECT_ID=otrns.OBJECT_ID AND info.PROJECT_ID=otrns.PROJECT_ID WHERE info.PROJECT_ID='38A062302D4411D28E71006008960167' AND info.OBJECT_TYPE=51 AND info.OBJECT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') AND info.PARENT_ID NOT IN ('EE9BD70043F0F571B38E43BF19B9301A', '027B542144A77860ACD37BB3ED40AA07') ORDER BY 4, 1
  139. 2018-07-19 17:40:00.425 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  140. 2018-07-19 17:40:00.428 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='3678B0B547176DAB8478E38DBD7F7305') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='B7CA92F04B9FAE8D941C3E9B7E0CD754')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  141. 2018-07-19 17:40:00.433 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  142. 2018-07-19 17:40:00.435 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='3678B0B547176DAB8478E38DBD7F7305') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='163613BB4B34BD0B08CE8AB4828EBE97')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  143. 2018-07-19 17:40:00.443 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  144. 2018-07-19 17:40:00.445 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='3678B0B547176DAB8478E38DBD7F7305') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='CE52831411E696C8BD2F0080EFD5AF44')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  145. 2018-07-19 17:40:00.451 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  146. 2018-07-19 17:40:00.452 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  147. 2018-07-19 17:40:00.456 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST WHERE (DSSCSSUBINST.INST_ID='74933D9E11E740A20CD40080EF95EF9E')
  148. 2018-07-19 17:40:00.462 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='3678B0B547176DAB8478E38DBD7F7305') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='B3FEE61A11E696C8BD0F0080EFC58F44')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  149. 2018-07-19 17:40:00.463 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  150. 2018-07-19 17:40:00.466 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT DSSCSPSNLZTN.SUB_ID, DSSCSPSNLZTN.VAL_SEQ, DSSCSPSNLZTN.P_VALUE FROM DSSCSPSNLZTN WHERE (DSSCSPSNLZTN.INST_ID='74933D9E11E740A20CD40080EF95EF9E') ORDER BY DSSCSPSNLZTN.SUB_ID ASC , DSSCSPSNLZTN.VAL_SEQ ASC
  151. 2018-07-19 17:40:00.473 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  152. 2018-07-19 17:40:00.475 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSCONTACT WHERE (DSSCSCONTACT.CONTACT_ID='7FC05A65473CE2FD845CE6A1D3F13233')
  153. 2018-07-19 17:40:00.480 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  154. 2018-07-19 17:40:00.480 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  155. 2018-07-19 17:40:00.482 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT DSSCSPSNLZTN.SUB_ID, DSSCSPSNLZTN.VAL_SEQ, DSSCSPSNLZTN.P_VALUE FROM DSSCSPSNLZTN WHERE (DSSCSPSNLZTN.INST_ID='7495B42B11E740A20CD40080EF95EF9E') ORDER BY DSSCSPSNLZTN.SUB_ID ASC , DSSCSPSNLZTN.VAL_SEQ ASC
  156. 2018-07-19 17:40:00.489 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  157. 2018-07-19 17:40:00.492 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='3678B0B547176DAB8478E38DBD7F7305') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='4BAE16A340B995CAD24193AA3AC15D29')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  158. 2018-07-19 17:40:00.493 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSCONTACT WHERE (DSSCSCONTACT.CONTACT_ID='7FC05A65473CE2FD845CE6A1D3F13233')
  159. 2018-07-19 17:40:00.536 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  160. 2018-07-19 17:40:00.539 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='3678B0B547176DAB8478E38DBD7F7305') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='4C09350211E69712BAEE0080EFB56D41')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  161. 2018-07-19 17:40:00.544 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  162. 2018-07-19 17:40:00.546 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='3678B0B547176DAB8478E38DBD7F7305') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='85C3FE7E11E7028A06660080EFB5E5D4')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  163. 2018-07-19 17:40:00.550 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  164. 2018-07-19 17:40:00.552 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='3678B0B547176DAB8478E38DBD7F7305') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='19E3120C11E847D125D60080EFF5FD36')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  165. 2018-07-19 17:40:00.556 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  166. 2018-07-19 17:40:00.559 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558377973504][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSSUBINST INNER JOIN DSSCSCONTACT ON DSSCSSUBINST.RECIPIENT_ID=DSSCSCONTACT.CONTACT_ID WHERE ((((DSSCSSUBINST.TRIGGER_ID='3678B0B547176DAB8478E38DBD7F7305') AND (DSSCSSUBINST.PARENT_ID<>'00000000000000000000000000000000')) AND (DSSCSSUBINST.STATUS=1)) AND (DSSCSSUBINST.PROJECT_ID='04B3BD3C11E873FF1E810080EFF5A4D1')) ORDER BY DSSCSCONTACT.MSTRUSER_ID ASC , DSSCSSUBINST.CREATION_TIME ASC , DSSCSSUBINST.INST_ID ASC
  167. 2018-07-19 17:40:00.619 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  168. 2018-07-19 17:40:00.622 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT * FROM DSSCSCONTACT WHERE (DSSCSCONTACT.CONTACT_ID='7FC05A65473CE2FD845CE6A1D3F13233')
  169. 2018-07-19 17:40:00.627 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  170. 2018-07-19 17:40:00.629 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558327543552][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSADDRESS WHERE ((DSSCSADDRESS.DELIVERY_TYPE IN (1, 2, 4, 8, 16, 32, 64, 128, 256, 512, 1024, 2048, 8192, 16384)) AND (DSSCSADDRESS.CONTACT_ID IN ('7FC05A65473CE2FD845CE6A1D3F13233'))) ORDER BY DSSCSADDRESS.CONTACT_ID ASC , DSSCSADDRESS.DISP_NAME ASC
  171. 2018-07-19 17:40:00.771 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557962217216][Database Classes][SQL Trace][UID:7FC05A65473CE2FD845CE6A1D3F13233][SID:F3D52FA7F87CBB6708C342ECD17F5D9E][OID:7C5CD53E11E529671FB700802FF7BD86] Executing SQL. Connection ID: 8. SQL: start transaction;
  172. 2018-07-19 17:40:00.780 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select day_of_week.day_of_week_id day_of_week_id,
  173. day_of_week.day_of_week_desc day_of_week_desc
  174. from `idm_intel`.`day_of_week` day_of_week
  175. 2018-07-19 17:40:00.784 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select device.device_id device_id,
  176. device.device_desc device_desc
  177. from `idm_intel`.`device` device
  178. 2018-07-19 17:40:00.787 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_date_range.date_range_id date_range_id,
  179. lu_date_range.date_range_desc date_range_desc
  180. from `idm_intel`.`lu_date_range` lu_date_range
  181. 2018-07-19 17:40:00.791 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select month_of_year.month_of_year_id month_of_year_id,
  182. month_of_year.month_of_year_desc month_of_year_desc
  183. from `idm_intel`.`month_of_year` month_of_year
  184. 2018-07-19 17:40:00.794 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select v_ul_lu_state.state_id state_id,
  185. v_ul_lu_state.state_desc state_desc,
  186. v_ul_lu_state.country_id country_id
  187. from `idm_intel`.`v_ul_lu_state` v_ul_lu_state
  188. 2018-07-19 17:40:00.798 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select week_desc,
  189. week_id
  190. from week
  191. 2018-07-19 17:40:00.879 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_user_device.user_device_id user_device_id,
  192. lu_user_device.user_device_name user_device_name,
  193. lu_user_device.user_device_type_id user_device_type_id
  194. from `idm_intel`.`lu_user_device` lu_user_device
  195. 2018-07-19 17:40:00.883 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_week_range.week_range_id week_range_id,
  196. lu_week_range.week_range_desc week_range_desc
  197. from `idm_intel`.`lu_week_range` lu_week_range
  198. 2018-07-19 17:40:00.887 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select day_of_week_desc,
  199. day_of_week_id,
  200. weekpart_id
  201. from day_of_week
  202. 2018-07-19 17:40:00.891 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select minute.minute_id minute_id,
  203. minute.hour_id hour_id
  204. from `idm_intel`.`minute` minute
  205. 2018-07-19 17:40:00.899 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select os.os_id os_id,
  206. os.os_desc os_desc,
  207. os.os_category_id os_category_id
  208. from `idm_intel`.`os` os
  209. 2018-07-19 17:40:00.903 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select rel_date_range_days_view.date_range_id date_range_id,
  210. rel_date_range_days_view.day_id day_id
  211. from `idm_intel`.`rel_date_range_days_view` rel_date_range_days_view
  212. 2018-07-19 17:40:00.907 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select rel_week_range_days.week_range_id week_range_id,
  213. rel_week_range_days.day_id day_id
  214. from `idm_intel`.`rel_week_range_days` rel_week_range_days
  215. 2018-07-19 17:40:00.913 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select transaction_type.tran_type_id tran_type_id,
  216. transaction_type.tran_type_desc tran_type_desc,
  217. transaction_type.tran_type_category_id tran_type_category_id
  218. from `idm_intel`.`transaction_type` transaction_type
  219. 2018-07-19 17:40:00.933 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select badge_type.badge_type_id badge_type_id,
  220. badge_type.badge_type_desc badge_type_desc,
  221. badge_type.status status,
  222. badge_type.updated_ts updated_ts,
  223. badge_type.created_ts created_ts
  224. from `idm_intel`.`badge_type` badge_type
  225. 2018-07-19 17:40:00.941 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select week.week_id week_id,
  226. week.week_end_date week_end_date,
  227. week.week_begin_date week_begin_date,
  228. week.week_desc week_desc
  229. from `idm_intel`.`week` week
  230. 2018-07-19 17:40:00.953 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: Select day_id,
  231. day_of_week_id,
  232. month_desc,
  233. month_id,
  234. week_id,
  235. year_id,
  236. Month(Day_id) month_of_year_id
  237. from day
  238. 2018-07-19 17:40:00.986 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select badge_email,
  239. badge_id,
  240. badge_name,
  241. badge_picture,
  242. org_id,
  243. status,
  244. badge_role_category_id
  245. from badge
  246. 2018-07-19 17:40:00.991 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select daypart.daypart_id daypart_id,
  247. daypart.daypart_desc daypart_desc
  248. from `idm_intel`.`daypart` daypart
  249. 2018-07-19 17:40:00.996 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select badge_role_category_desc,
  250. badge_role_category_id
  251. from lu_badge_role_category
  252. 2018-07-19 17:40:01.001 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select org_desc,
  253. org_id
  254. from organization
  255. 2018-07-19 17:40:01.006 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select badge_status_desc,
  256. badge_status_id
  257. from lu_badge_status
  258. 2018-07-19 17:40:01.011 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select day_id,
  259. day_of_week_id,
  260. month_desc,
  261. month_id,
  262. week_id,
  263. year_id,
  264. Month(day_id) month_of_year_id
  265. from day
  266. 2018-07-19 17:40:01.015 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select application.app_id app_id,
  267. application.app_desc app_desc,
  268. application.app_category_id app_category_id
  269. from `idm_intel`.`application` application
  270. 2018-07-19 17:40:01.018 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 5. SQL: SELECT @@SESSION.SQL_MODE
  271. 2018-07-19 17:40:01.021 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 5. SQL: SET @@SESSION.SQL_MODE = 'NO_ENGINE_SUBSTITUTION,NO_BACKSLASH_ESCAPES'
  272. 2018-07-19 17:40:01.022 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 5. SQL: SELECT * FROM DSSCSSUBINST WHERE (DSSCSSUBINST.INST_ID='75386A3A11E740A20CD40080EF75B0A0')
  273. 2018-07-19 17:40:01.027 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  274. 2018-07-19 17:40:01.030 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT DSSCSPSNLZTN.SUB_ID, DSSCSPSNLZTN.VAL_SEQ, DSSCSPSNLZTN.P_VALUE FROM DSSCSPSNLZTN WHERE (DSSCSPSNLZTN.INST_ID='75386A3A11E740A20CD40080EF75B0A0') ORDER BY DSSCSPSNLZTN.SUB_ID ASC , DSSCSPSNLZTN.VAL_SEQ ASC
  275. 2018-07-19 17:40:01.034 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select day_of_week_desc,
  276. day_of_week_id
  277. from day_of_week
  278. 2018-07-19 17:40:01.039 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select date(badge_creation) badge_creation,
  279. badge_email as user_email_attr,
  280. badge_email,
  281. badge_id,
  282. badge_name,
  283. badge_phone,
  284. badge_picture ,
  285. concat("<img src=", badge_picture," height = 72>") badge_picture72,
  286. concat("<img src=", badge_picture," width = 635>") badge_picture635,
  287. badge_role_category_id,
  288. badge_title,
  289. badge_type_id,
  290. org_id,
  291. status,
  292. ((Year(Badge_Creation) * 100) + Week(Badge_Creation)) user_week_id,
  293. DayOfWeek(Badge_Creation) day_of_week_id,
  294. badge_creation badge_creation_timestamp,
  295. Month(badge_creation) month_of_year_id,
  296. ((Year(Badge_Creation) * 100) + Month(Badge_Creation)) user_month_id,
  297. latitude user_latitude,
  298. longitude user_longitude,
  299. last_action_timestamp
  300. from badge
  301. 2018-07-19 17:40:01.046 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  302. 2018-07-19 17:40:01.048 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSCONTACT WHERE (DSSCSCONTACT.CONTACT_ID='7FC05A65473CE2FD845CE6A1D3F13233')
  303. 2018-07-19 17:40:01.052 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select hour_id,
  304. minute_id
  305. from minute
  306. 2018-07-19 17:40:01.058 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 5. SQL: SELECT @@SESSION.SQL_MODE
  307. 2018-07-19 17:40:01.059 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select hour_desc,
  308. hour_id
  309. from hour
  310. 2018-07-19 17:40:01.065 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select v_ul_lu_city.city_id city_id,
  311. v_ul_lu_city.city_desc city_desc,
  312. v_ul_lu_city.state_id state_id,
  313. v_ul_lu_city.country_id country_id
  314. from `idm_intel`.`v_ul_lu_city` v_ul_lu_city
  315. 2018-07-19 17:40:01.069 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_badge_status.badge_status_id badge_status_id,
  316. lu_badge_status.badge_status_desc badge_status_desc
  317. from `idm_intel`.`lu_badge_status` lu_badge_status
  318. 2018-07-19 17:40:01.070 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 5. SQL: SELECT DSSCSPSNLZTN.SUB_ID, DSSCSPSNLZTN.VAL_SEQ, DSSCSPSNLZTN.P_VALUE FROM DSSCSPSNLZTN WHERE (DSSCSPSNLZTN.INST_ID='753ACE6A11E740A20CD40080EF75B0A0') ORDER BY DSSCSPSNLZTN.SUB_ID ASC , DSSCSPSNLZTN.VAL_SEQ ASC
  319. 2018-07-19 17:40:01.075 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select month_of_year_desc,
  320. month_of_year_id
  321. from month_of_year
  322. 2018-07-19 17:40:01.079 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_os_category.os_category_id os_category_id,
  323. lu_os_category.os_category_desc os_category_desc
  324. from `idm_intel`.`lu_os_category` lu_os_category
  325. 2018-07-19 17:40:01.083 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select v_ul_lu_country.country_id country_id,
  326. v_ul_lu_country.country_desc country_desc
  327. from `idm_intel`.`v_ul_lu_country` v_ul_lu_country
  328. 2018-07-19 17:40:01.089 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_application_category.app_category_id app_category_id,
  329. lu_application_category.app_category_desc app_category_desc
  330. from `idm_intel`.`lu_application_category` lu_application_category
  331. 2018-07-19 17:40:01.092 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select hour.hour_id hour_id,
  332. hour.daypart_id daypart_id,
  333. hour.hour_desc hour_desc
  334. from `idm_intel`.`hour` hour
  335. 2018-07-19 17:40:01.096 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_admin_role.name name,
  336. lu_admin_role.badge_role_category_id badge_role_category_id
  337. from `idm_intel`.`lu_admin_role` lu_admin_role
  338. 2018-07-19 17:40:01.100 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_access_status.access_status_id access_status_id,
  339. lu_access_status.access_status_desc access_status_desc
  340. from `idm_intel`.`lu_access_status` lu_access_status
  341. 2018-07-19 17:40:01.103 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_gateway_category.gateway_category_id gateway_category_id,
  342. lu_gateway_category.gateway_category_desc gateway_category_desc
  343. from `idm_intel`.`lu_gateway_category` lu_gateway_category
  344. 2018-07-19 17:40:01.107 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select DAYOFWEEK(a11.created_ts) day_of_week_id,
  345. ((YEAR(a11.created_ts) * 100) + MONTH(a11.created_ts)) network_creation_month_id,
  346. MONTH(a11.created_ts) month_of_year_id,
  347. a11.created_ts network_creation_timestamp,
  348. ((YEAR(a11.created_ts) * 100) + WEEK(a11.created_ts,
  349. 6)) network_creation_week_id,
  350. a11.organization_group_id org_group_id,
  351. a11.org_id org_id,
  352. a11.Org_Desc Org_Desc,
  353. a11.created_ts created_ts,
  354. a11.updated_ts updated_ts,
  355. a11.status status,
  356. DATE(a11.created_ts) network_creation_date
  357. from organization a11
  358. 2018-07-19 17:40:01.111 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select badge_id,
  359. week_range_id,
  360. 1 dummy
  361. from badge cross
  362. join lu_week_range
  363. 2018-07-19 17:40:01.115 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select gateway_id,
  364. org_id
  365. from lu_gateway
  366. 2018-07-19 17:40:01.118 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select week_id,
  367. week_begin_date,
  368. week_end_date
  369. from week
  370. 2018-07-19 17:40:01.119 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  371. 2018-07-19 17:40:01.120 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select day_of_week.day_of_week_id day_of_week_id,
  372. day_of_week.day_of_week_desc day_of_week_desc
  373. from `idm_intel`.`day_of_week` day_of_week
  374. 2018-07-19 17:40:01.123 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select month_of_year.month_of_year_id month_of_year_id,
  375. month_of_year.month_of_year_desc month_of_year_desc
  376. from `idm_intel`.`month_of_year` month_of_year
  377. 2018-07-19 17:40:01.124 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select LU_MANAGER.manager_id manager_id,
  378. LU_MANAGER.manager_desc manager_desc
  379. from `idm_intel`.`LU_MANAGER` LU_MANAGER
  380. 2018-07-19 17:40:01.125 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT * FROM DSSCSCONTACT WHERE (DSSCSCONTACT.CONTACT_ID='7FC05A65473CE2FD845CE6A1D3F13233')
  381. 2018-07-19 17:40:01.129 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select FACT_Access_Transactions_view.access_status_id access_status_id,
  382. FACT_Access_Transactions_view.app_id app_id,
  383. FACT_Access_Transactions_view.badge_id badge_id,
  384. FACT_Access_Transactions_view.elapsed_time elapsed_time,
  385. FACT_Access_Transactions_view.est_minute_id est_minute_id,
  386. FACT_Access_Transactions_view.gateway_id gateway_id,
  387. FACT_Access_Transactions_view.local_minute_id local_minute_id,
  388. FACT_Access_Transactions_view.local_time local_time,
  389. FACT_Access_Transactions_view.org_id org_id,
  390. FACT_Access_Transactions_view.os_id os_id,
  391. FACT_Access_Transactions_view.tran_date_est tran_date_est,
  392. FACT_Access_Transactions_view.tran_id tran_id,
  393. FACT_Access_Transactions_view.tran_lat tran_lat,
  394. FACT_Access_Transactions_view.tran_long tran_long,
  395. FACT_Access_Transactions_view.tran_timestamp tran_timestamp,
  396. FACT_Access_Transactions_view.tran_timestamp_est tran_timestamp_est,
  397. FACT_Access_Transactions_view.tran_type_id tran_type_id,
  398. FACT_Access_Transactions_view.user_device_id user_device_id,
  399. FACT_Access_Transactions_view.validating_badge_id validating_badge_id,
  400. FACT_Access_Transactions_view.day_of_week_id day_of_week_id,
  401. FACT_Access_Transactions_view.day_join_id day_join_id,
  402. FACT_Access_Transactions_view.local_day_id local_day_id,
  403. FACT_Access_Transactions_view.ActionID ActionID,
  404. FACT_Access_Transactions_view.beacon_id beacon_id,
  405. FACT_Access_Transactions_view.space_id space_id,
  406. FACT_Access_Transactions_view.sysapplication_id sysapplication_id,
  407. FACT_Access_Transactions_view.address_id address_id,
  408. FACT_Access_Transactions_view.facility_address_id facility_address_id,
  409. FACT_Access_Transactions_view.desktop_unlock_setting_id desktop_unlock_setting_id,
  410. FACT_Access_Transactions_view.bar_code_id bar_code_id,
  411. FACT_Access_Transactions_view.desktop_id desktop_id
  412. from `idm_intel`.`FACT_Access_Transactions_view` FACT_Access_Transactions_view
  413. 2018-07-19 17:40:01.134 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select REL_BADGE_BDHISTORY.badge_id badge_id,
  414. REL_BADGE_BDHISTORY.bd_history_id bd_history_id
  415. from `idm_intel`.`REL_BADGE_BDHISTORY` REL_BADGE_BDHISTORY
  416. 2018-07-19 17:40:01.139 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select lu_weekpart.weekpart_id weekpart_id,
  417. lu_weekpart.weekpart_desc weekpart_desc
  418. from `idm_intel`.`lu_weekpart` lu_weekpart
  419. 2018-07-19 17:40:01.142 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select lu_bar_code_type.bar_code_type_id bar_code_type_id,
  420. lu_bar_code_type.bar_code_type_desc bar_code_type_desc
  421. from `idm_intel`.`lu_bar_code_type` lu_bar_code_type
  422. 2018-07-19 17:40:01.145 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select lu_transaction_type_category.tran_type_category_id tran_type_category_id,
  423. lu_transaction_type_category.tran_type_category_desc tran_type_category_desc
  424. from `idm_intel`.`lu_transaction_type_category` lu_transaction_type_category
  425. 2018-07-19 17:40:01.149 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select lu_bar_code.bar_code_id bar_code_id,
  426. lu_bar_code.bar_code bar_code,
  427. lu_bar_code.bar_code_type_id bar_code_type_id
  428. from `idm_intel`.`lu_bar_code` lu_bar_code
  429. 2018-07-19 17:40:01.159 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select week.Week_ID Week_ID,
  430. week.Week_End_Date Week_End_Date,
  431. week.Week_Begin_Date Week_Begin_Date
  432. from `idm_intel`.`week` week
  433. 2018-07-19 17:40:01.165 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select v_lu_facility_address.facility_address_id facility_address_id,
  434. v_lu_facility_address.facility_address_desc facility_address_desc,
  435. v_lu_facility_address.facility_street_address facility_street_address,
  436. v_lu_facility_address.facility_latitude facility_latitude,
  437. v_lu_facility_address.facility_longitude facility_longitude,
  438. v_lu_facility_address.org_id org_id
  439. from `idm_intel`.`v_lu_facility_address` v_lu_facility_address
  440. 2018-07-19 17:40:01.169 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select 2 stddev, '2 Dev',2
  441. union
  442. select 3 stddev, '3 Dev',3
  443. union
  444. select 4 stddev, '4 Dev',4
  445. union
  446. select 5 stddev, '5 Dev',5
  447. union
  448. select 6 stddev, '6 Dev',6
  449. 2018-07-19 17:40:01.172 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select week_range_id,
  450. sysapplication_id,
  451. 1 dummym
  452. from v_lu_sysapplication cross
  453. join lu_week_range
  454. 2018-07-19 17:40:01.175 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select week_range_id,
  455. space_id,
  456. 1 dummym
  457. from v_sp_lu_space
  458. join lu_week_range
  459. 2018-07-19 17:40:01.179 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select v_lu_subdomain.subdomain_id subdomain_id,
  460. v_lu_subdomain.subdomain_desc subdomain_desc,
  461. v_lu_subdomain.org_id org_id
  462. from `idm_intel`.`v_lu_subdomain` v_lu_subdomain
  463. 2018-07-19 17:40:01.182 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select v_sp_lu_floor.floor_id floor_id,
  464. v_sp_lu_floor.floor_desc floor_desc,
  465. v_sp_lu_floor.floor_status floor_status,
  466. v_sp_lu_floor.creation_timestamp creation_timestamp,
  467. v_sp_lu_floor.modification_timestamp modification_timestamp,
  468. v_sp_lu_floor.facility_id facility_id
  469. from `idm_intel`.`v_sp_lu_floor` v_sp_lu_floor
  470. 2018-07-19 17:40:01.191 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT @@SESSION.SQL_MODE
  471. 2018-07-19 17:40:01.193 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 0. SQL: SELECT * FROM DSSCSCONTACT WHERE (DSSCSCONTACT.CONTACT_ID='7FC05A65473CE2FD845CE6A1D3F13233')
  472. 2018-07-19 17:40:01.197 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select LU_COMP_BUDGET_RVP_DIRECTORY.budget_directory_rvp_id budget_directory_rvp_id,
  473. LU_COMP_BUDGET_RVP_DIRECTORY.budget_directory_rvp_desc budget_directory_rvp_desc
  474. from `idm_intel`.`LU_COMP_BUDGET_RVP_DIRECTORY` LU_COMP_BUDGET_RVP_DIRECTORY
  475. 2018-07-19 17:40:01.199 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select V_LU_COMP_BUDGET_RVP_OWNER.budget_directory_rvp_owner_id budget_directory_rvp_owner_id,
  476. V_LU_COMP_BUDGET_RVP_OWNER.budget_directory_rvp_owner_desc budget_directory_rvp_owner_desc,
  477. V_LU_COMP_BUDGET_RVP_OWNER.budget_directory_rvp_owner_login_id budget_directory_rvp_owner_login_id
  478. from `idm_intel`.`V_LU_COMP_BUDGET_RVP_OWNER` V_LU_COMP_BUDGET_RVP_OWNER
  479. 2018-07-19 17:40:01.200 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 5. SQL: SELECT @@SESSION.SQL_MODE
  480. 2018-07-19 17:40:01.204 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select LU_BD_HISTORY.bd_history_id bd_history_id,
  481. LU_BD_HISTORY.budget_directory_rvp_owner_id budget_directory_rvp_owner_id,
  482. LU_BD_HISTORY.budget_directory_rvp_id budget_directory_rvp_id,
  483. LU_BD_HISTORY.budget_directory_id budget_directory_id,
  484. LU_BD_HISTORY.budget_directory_owner_id budget_directory_owner_id,
  485. LU_BD_HISTORY.budget_directory_vp_id budget_directory_vp_id,
  486. LU_BD_HISTORY.budget_directory_vp_owner_id budget_directory_vp_owner_id,
  487. LU_BD_HISTORY.directorate_id directorate_id,
  488. LU_BD_HISTORY.employee_id employee_id
  489. from `idm_intel`.`LU_BD_HISTORY` LU_BD_HISTORY
  490. 2018-07-19 17:40:01.207 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select v_lu_domain.domain_id domain_id,
  491. v_lu_domain.domain_desc domain_desc,
  492. v_lu_domain.org_id org_id
  493. from `idm_intel`.`v_lu_domain` v_lu_domain
  494. 2018-07-19 17:40:01.211 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select LU_COMP_BUDGET_DIRECTORY.budget_directory_id budget_directory_id,
  495. LU_COMP_BUDGET_DIRECTORY.budget_directory_desc budget_directory_desc
  496. from `idm_intel`.`LU_COMP_BUDGET_DIRECTORY` LU_COMP_BUDGET_DIRECTORY
  497. 2018-07-19 17:40:01.214 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select v_ul_lu_address.address_id address_id,
  498. v_ul_lu_address.street_address street_address,
  499. v_ul_lu_address.city_id city_id,
  500. v_ul_lu_address.state_id state_id,
  501. v_ul_lu_address.country_id country_id,
  502. v_ul_lu_address.tran_lat tran_lat,
  503. v_ul_lu_address.tran_long tran_long
  504. from `idm_intel`.`v_ul_lu_address` v_ul_lu_address
  505. 2018-07-19 17:40:01.217 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 3. SQL: select v_sp_lu_campus.campus_id campus_id,
  506. v_sp_lu_campus.campus_desc campus_desc,
  507. v_sp_lu_campus.campus_status campus_status,
  508. v_sp_lu_campus.creation_timestamp creation_timestamp,
  509. v_sp_lu_campus.modification_timestamp modification_timestamp,
  510. v_sp_lu_campus.org_id org_id
  511. from `idm_intel`.`v_sp_lu_campus` v_sp_lu_campus
  512. 2018-07-19 17:40:01.222 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558350657280][Database Classes][SQL Trace] Executing SQL. Connection ID: 5. SQL: SELECT * FROM DSSCSADDRESS WHERE ((DSSCSADDRESS.DELIVERY_TYPE IN (1, 2, 4, 8, 16, 32, 64, 128, 256, 512, 1024, 2048, 8192, 16384)) AND (DSSCSADDRESS.CONTACT_ID IN ('7FC05A65473CE2FD845CE6A1D3F13233'))) ORDER BY DSSCSADDRESS.CONTACT_ID ASC , DSSCSADDRESS.DISP_NAME ASC
  513. 2018-07-19 17:40:01.238 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557960115968][Database Classes][SQL Trace][UID:7FC05A65473CE2FD845CE6A1D3F13233][SID:F3D52FA7F87CBB6708C342ECD17F5D9E][OID:D989DE1D49DBA50F1B2288B38CB7778A] Executing SQL. Connection ID: 3. SQL: start transaction;
  514. 2018-07-19 17:40:01.240 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557960115968][Database Classes][SQL Trace][UID:7FC05A65473CE2FD845CE6A1D3F13233][SID:F3D52FA7F87CBB6708C342ECD17F5D9E][OID:D989DE1D49DBA50F1B2288B38CB7778A] Executing SQL. Connection ID: 3. SQL: select distinct a11.tran_id Transaction_ID,
  515. a11.tran_type_id tran_type_id,
  516. a18.Tran_Type_desc Tran_Type_desc,
  517. a11.org_id org_id,
  518. a11.beacon_id beacon_id,
  519. a12.beacon_desc beacon_desc,
  520. a16.floor_id floor_id,
  521. a17.floor_desc floor_desc,
  522. a11.space_id space_id,
  523. a16.space_desc space_desc,
  524. a11.sysapplication_id sysapplication_id,
  525. a110.sysapplication_desc sysapplication_desc,
  526. a11.address_id address_id,
  527. a19.tran_lat tran_lat,
  528. a19.tran_long tran_long,
  529. a19.street_address street_address,
  530. a11.tran_timestamp_est tran_timestamp,
  531. a11.tran_timestamp tran_timestamp_est,
  532. a11.tran_lat tran_lat0,
  533. a11.tran_long tran_long0,
  534. a11.badge_id badge_id_bigint,
  535. a113.Badge_Name Badge_Name,
  536. a11.est_minute_id minute_id,
  537. a14.Minute_desc Minute_desc,
  538. a14.Hour_ID Hour_ID,
  539. a112.hour_desc hour_desc,
  540. a17.facility_id facility_id,
  541. a114.facility_desc facility_desc,
  542. a11.facility_address_id facility_address_id,
  543. a13.facility_address_desc facility_address_desc,
  544. a13.facility_street_address facility_street_address,
  545. a15.gateway_category_id gateway_category_id,
  546. a111.gateway_category_desc gateway_category_desc
  547. from `idm_intel`.`access_transactions_view` a11
  548. join `idm_intel`.`lu_beacon` a12
  549. on (a11.beacon_id = a12.beacon_id)
  550. join `v_lu_facility_address` a13
  551. on (a11.facility_address_id = a13.facility_address_id)
  552. join `minute` a14
  553. on (a11.est_minute_id = a14.minute_id)
  554. join `idm_intel`.`lu_gateway` a15
  555. on (a11.gateway_id = a15.gateway_id)
  556. join `v_sp_lu_space` a16
  557. on (a11.space_id = a16.space_id)
  558. join `v_sp_lu_floor` a17
  559. on (a16.floor_id = a17.floor_id)
  560. join `transaction_type` a18
  561. on (a11.tran_type_id = a18.tran_type_id)
  562. join `v_ul_lu_address` a19
  563. on (a11.address_id = a19.address_id)
  564. join `idm_intel`.`v_lu_sysapplication` a110
  565. on (a11.sysapplication_id = a110.sysapplication_id)
  566. join `lu_gateway_category` a111
  567. on (a15.gateway_category_id = a111.gateway_category_id)
  568. join `hour` a112
  569. on (a14.Hour_ID = a112.Hour_ID)
  570. join `badge` a113
  571. on (a11.badge_id = a113.badge_id)
  572. join `idm_intel`.`v_sp_lu_facility` a114
  573. on (a17.facility_id = a114.facility_id)
  574. where (a11.tran_timestamp >= '2018-07-18 17:41:01'
  575. and a11.tran_lat is not null
  576. and a11.tran_long is not null
  577. and a11.access_status_id in (1))
  578. 2018-07-19 17:40:01.250 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_beacon.beacon_id beacon_id,
  579. lu_beacon.beacon_desc beacon_desc,
  580. lu_beacon.org_id org_id,
  581. lu_beacon.beacon_status beacon_status,
  582. lu_beacon.beacon_uuid beacon_uuid,
  583. lu_beacon.beacon_minor beacon_minor,
  584. lu_beacon.beacon_major beacon_major,
  585. lu_beacon.creation_timestamp creation_timestamp,
  586. lu_beacon.modification_timestamp modification_timestamp
  587. from `idm_intel`.`lu_beacon` lu_beacon
  588. 2018-07-19 17:40:01.254 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557960115968][Database Classes][SQL Trace][UID:7FC05A65473CE2FD845CE6A1D3F13233][SID:F3D52FA7F87CBB6708C342ECD17F5D9E][OID:D989DE1D49DBA50F1B2288B38CB7778A] Executing SQL. Connection ID: 3. SQL: commit
  589. 2018-07-19 17:40:01.257 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select v_sp_lu_facility.facility_id facility_id,
  590. v_sp_lu_facility.facility_desc facility_desc,
  591. v_sp_lu_facility.facility_status facility_status,
  592. v_sp_lu_facility.creation_timestamp creation_timestamp,
  593. v_sp_lu_facility.modification_timestamp modification_timestamp,
  594. v_sp_lu_facility.campus_id campus_id
  595. from `idm_intel`.`v_sp_lu_facility` v_sp_lu_facility
  596. 2018-07-19 17:40:01.261 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_gateway.gateway_id gateway_id,
  597. lu_gateway.gateway_category_id gateway_category_id,
  598. lu_gateway.org_id org_id,
  599. lu_gateway.gateway_desc gateway_desc,
  600. lu_gateway.creation_timestamp creation_timestamp,
  601. lu_gateway.modification_timestamp modification_timestamp,
  602. lu_gateway.gateway_status gateway_status
  603. from `idm_intel`.`lu_gateway` lu_gateway
  604. 2018-07-19 17:40:01.265 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select lu_desktop.desktop_id desktop_id,
  605. lu_desktop.desktop_desc desktop_desc,
  606. lu_desktop.desktop_status desktop_status,
  607. lu_desktop.creation_timestamp creation_timestamp,
  608. lu_desktop.modification_timestamp modification_timestamp
  609. from `idm_intel`.`lu_desktop` lu_desktop
  610. 2018-07-19 17:40:01.268 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select distinct Month_ID as User_Month_ID,
  611. Max(Month_Desc) as User_Month_Desc
  612. from day
  613. group by Month_ID
  614. 2018-07-19 17:40:01.276 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select month_of_year_desc,
  615. month_of_year_id
  616. from month_of_year
  617. 2018-07-19 17:40:01.280 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select v_lu_sysapplication.sysapplication_id sysapplication_id,
  618. v_lu_sysapplication.sysapplication_desc sysapplication_desc,
  619. v_lu_sysapplication.sysapplication_status sysapplication_status,
  620. v_lu_sysapplication.subdomain_id subdomain_id,
  621. v_lu_sysapplication.domain_id domain_id,
  622. v_lu_sysapplication.org_id org_id,
  623. v_lu_sysapplication.creation_timestamp creation_timestamp,
  624. v_lu_sysapplication.modification_timestamp modification_timestamp
  625. from `idm_intel`.`v_lu_sysapplication` v_lu_sysapplication
  626. 2018-07-19 17:40:01.500 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select v_sp_lu_space.space_id space_id,
  627. v_sp_lu_space.space_desc space_desc,
  628. v_sp_lu_space.space_status space_status,
  629. v_sp_lu_space.creation_timestamp creation_timestamp,
  630. v_sp_lu_space.modification_timestamp modification_timestamp,
  631. v_sp_lu_space.floor_id floor_id
  632. from `idm_intel`.`v_sp_lu_space` v_sp_lu_space
  633. 2018-07-19 17:40:01.504 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select a.city_id, at.badge_id, avg(d.tran_lat) city_lat, avg(d.tran_long) city_long
  634. from lu_city a join lu_state b on a.state_id = b.state_id
  635. join lu_address d on a.city_id=d.city_id
  636. join access_transactions at on d.address_id=at.address_id
  637. where at.tran_timestamp > TimestampAdd(day, -30, Now())
  638. group by a.city_id, at.badge_id
  639. 2018-07-19 17:40:01.508 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select REL_BDHISTORY_MANAGER.bd_history_id bd_history_id,
  640. REL_BDHISTORY_MANAGER.manager_id manager_id
  641. from `idm_intel`.`REL_BDHISTORY_MANAGER` REL_BDHISTORY_MANAGER
  642. 2018-07-19 17:40:01.511 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select date_range_id,
  643. count(distinct day_id) count_of_days
  644. from rel_date_range_days_view
  645. group by date_range_id
  646. 2018-07-19 17:40:01.528 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select LU_JDE_EMP_DIRECTORY.jde_emp_directory_id jde_emp_directory_id,
  647. LU_JDE_EMP_DIRECTORY.jde_emp_directory_desc jde_emp_directory_desc
  648. from `idm_intel`.`LU_JDE_EMP_DIRECTORY` LU_JDE_EMP_DIRECTORY
  649. 2018-07-19 17:40:01.531 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select LU_EMPLOYEE_ACTIVE_FLAG.employee_active_flag_id employee_active_flag_id,
  650. LU_EMPLOYEE_ACTIVE_FLAG.employee_active_flag_desc employee_active_flag_desc
  651. from `idm_intel`.`LU_EMPLOYEE_ACTIVE_FLAG` LU_EMPLOYEE_ACTIVE_FLAG
  652. 2018-07-19 17:40:01.535 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select LU_JDE_EMP_DIRECTORY_OWNER.directorate_owner_id directorate_owner_id,
  653. LU_JDE_EMP_DIRECTORY_OWNER.directorate_owner_desc directorate_owner_desc
  654. from `idm_intel`.`LU_JDE_EMP_DIRECTORY_OWNER` LU_JDE_EMP_DIRECTORY_OWNER
  655. 2018-07-19 17:40:01.558 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select REL_BDHISTORY_DIRECTORATE_OWNER.bd_history_id bd_history_id,
  656. REL_BDHISTORY_DIRECTORATE_OWNER.directorate_owner_id directorate_owner_id
  657. from `idm_intel`.`REL_BDHISTORY_DIRECTORATE_OWNER` REL_BDHISTORY_DIRECTORATE_OWNER
  658. 2018-07-19 17:40:01.563 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select V_LU_EMPLOYEE_LOGIN.employee_login_id employee_login_id,
  659. V_LU_EMPLOYEE_LOGIN.employee_login_desc employee_login_desc
  660. from `idm_intel`.`V_LU_EMPLOYEE_LOGIN` V_LU_EMPLOYEE_LOGIN
  661. 2018-07-19 17:40:01.567 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select V_LU_COMP_BUDGET_VP_OWNER_LOGIN.budget_directory_vp_owner_login_id budget_directory_vp_owner_login_id,
  662. V_LU_COMP_BUDGET_VP_OWNER_LOGIN.budget_directory_vp_owner_login_desc budget_directory_vp_owner_login_desc
  663. from `idm_intel`.`V_LU_COMP_BUDGET_VP_OWNER_LOGIN` V_LU_COMP_BUDGET_VP_OWNER_LOGIN
  664. 2018-07-19 17:40:01.571 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select V_LU_COMP_BUDGET_OWNER_LOGIN.budget_directory_owner_login_id budget_directory_owner_login_id,
  665. V_LU_COMP_BUDGET_OWNER_LOGIN.budget_directory_owner_login_desc budget_directory_owner_login_desc
  666. from `idm_intel`.`V_LU_COMP_BUDGET_OWNER_LOGIN` V_LU_COMP_BUDGET_OWNER_LOGIN
  667. 2018-07-19 17:40:01.575 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select V_LU_COMP_BUDGET_RVP_OWNER_LOGIN.budget_directory_rvp_owner_login_id budget_directory_rvp_owner_login_id,
  668. V_LU_COMP_BUDGET_RVP_OWNER_LOGIN.budget_directory_rvp_owner_login_desc budget_directory_rvp_owner_login_desc
  669. from `idm_intel`.`V_LU_COMP_BUDGET_RVP_OWNER_LOGIN` V_LU_COMP_BUDGET_RVP_OWNER_LOGIN
  670. 2018-07-19 17:40:01.585 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select LU_COMP_BUDGET_VP_DIRECTORY.budget_directory_vp_id budget_directory_vp_id,
  671. LU_COMP_BUDGET_VP_DIRECTORY.budget_directory_vp_desc budget_directory_vp_desc
  672. from `idm_intel`.`LU_COMP_BUDGET_VP_DIRECTORY` LU_COMP_BUDGET_VP_DIRECTORY
  673. 2018-07-19 17:40:01.589 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select V_LU_COMP_BUDGET_VP_OWNER.budget_directory_vp_owner_id budget_directory_vp_owner_id,
  674. V_LU_COMP_BUDGET_VP_OWNER.budget_directory_vp_owner_desc budget_directory_vp_owner_desc,
  675. V_LU_COMP_BUDGET_VP_OWNER.budget_directory_vp_owner_login_id budget_directory_vp_owner_login_id
  676. from `idm_intel`.`V_LU_COMP_BUDGET_VP_OWNER` V_LU_COMP_BUDGET_VP_OWNER
  677. 2018-07-19 17:40:01.593 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 4. SQL: select lu_desktop_unlock_setting.desktop_unlock_setting_id desktop_unlock_setting_id,
  678. lu_desktop_unlock_setting.desktop_unlock_setting_desc desktop_unlock_setting_desc
  679. from `idm_intel`.`lu_desktop_unlock_setting` lu_desktop_unlock_setting
  680. 2018-07-19 17:40:01.594 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140556997027584][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select LU_EMPLOYEE.employee_id employee_id,
  681. LU_EMPLOYEE.employee_desc employee_desc,
  682. LU_EMPLOYEE.employee_first_name employee_first_name,
  683. LU_EMPLOYEE.employee_last_name employee_last_name,
  684. LU_EMPLOYEE.employee_NTlogin employee_NTlogin,
  685. LU_EMPLOYEE.employee_active_flag_id employee_active_flag_id,
  686. LU_EMPLOYEE.employee_login_id employee_login_id
  687. from `idm_intel`.`LU_EMPLOYEE` LU_EMPLOYEE
  688. 2018-07-19 17:40:01.602 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558863120128][Database Classes][SQL Trace] Executing SQL. Connection ID: 2. SQL: select V_LU_COMP_BUDGET_OWNER.budget_directory_owner_id budget_directory_owner_id,
  689. V_LU_COMP_BUDGET_OWNER.budget_directory_owner_desc budget_directory_owner_desc,
  690. V_LU_COMP_BUDGET_OWNER.budget_directory_owner_login_id budget_directory_owner_login_id
  691. from `idm_intel`.`V_LU_COMP_BUDGET_OWNER` V_LU_COMP_BUDGET_OWNER
  692. 2018-07-19 17:40:02.158 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557962217216][Database Classes][SQL Trace][UID:7FC05A65473CE2FD845CE6A1D3F13233][SID:F3D52FA7F87CBB6708C342ECD17F5D9E][OID:7C5CD53E11E529671FB700802FF7BD86] Executing SQL. Connection ID: 8. SQL: commit
  693. 2018-07-19 17:40:04.273 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557974824704][Database Classes][SQL Trace] Executing Parameterized SQL: insert into STG_IS_SCHEDULE_STATS (SCHEDULEID,SESSIONID,SERVERID,SERVERMACHINE,PROJECTID,TRIGGERID,SCHEDULETYPE,HITCACHE,STARTTIME,DAY_ID,HOUR_ID,MINUTE_ID,REPOSITORYID,RECORDTIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
  694. 2018-07-19 17:40:04.281 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557974824704][Database Classes][SQL Trace] Executing Parameterized SQL: insert into STG_IS_REPORT_STATS (JOBID,SESSIONID,SERVERID,SERVERMACHINE,PROJECTID,USERID,REPORTID,FILTERID,EMBEDDEDFILTER,TEMPLATEID,EMBEDDEDTEMPLATE,PARENTJOBID,DBINSTANCEID,DBUSERID,PARENTINDICATOR,REQUESTRECTIME,REQUESTQUEUETIME,EXECSTARTTIME,EXECFINISHTIME,SQLPASSES,JOBERRORCODE,CANCELINDICATOR,ADHOCINDICATOR,PROMPTINDICATOR,DATAMARTINDICATOR,ELEMENTLOADINDIC,DRILLINDICATOR,SCHEDULEINDICATOR,CACHECREATEINDIC,PRIORITYNUMBER,JOBCOST,FINALRESULTSIZE,ERRORMESSAGE,DRILLTEMPLATEUNIT,NEWOBJECT,DRILLTYPE,TOTALTABLEACCESS,SQLLENGTH,EXECDURATION,CPUTIME,STEPCOUNT,EXECACTIONS,EXECFLAGS,PROMPTANSTIME,DBERRORINDIC,CUBEINSTANCEID,CUBESIZE,SQLEXECINDIC,EXPORTINDIC,DAY_ID,HOUR_ID,MINUTE_ID,REPOSITORYID,MESSAGEID,RECORDTIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
  695. 2018-07-19 17:40:04.290 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557974824704][Database Classes][SQL Trace] Executing Parameterized SQL: insert into STG_IS_PROJ_SESS_STATS (SESSIONID,SERVERID,SERVERMACHINE,USERID,PROJECTID,CONNECTTIME,DISCONNECTTIME,DAY_ID,HOUR_ID,MINUTE_ID,REPOSITORYID,RECORDTIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
  696. 2018-07-19 17:40:04.299 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557974824704][Database Classes][SQL Trace] Executing Parameterized SQL: insert into STG_IS_PR_ANS_STATS (JOBID,SESSIONID,PR_ORDER_ID,ANS_SEQ_ID,PR_LOC_TYPE,PR_LOC_ID,PR_LOC_DESC,PR_GUID,PR_NAME,PR_TITLE,PR_ANS_TYPE,PR_ANSWERS,PR_ANS_GUID,IS_REQUIRED,SERVERID,PROJECTID,SERVERMACHINE,STARTTIME,DAY_ID,HOUR_ID,MINUTE_ID,REPOSITORYID,RECORDTIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
  697. 2018-07-19 17:40:04.305 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557974824704][Database Classes][SQL Trace] Executing Parameterized SQL: insert into STG_IS_MESSAGE_STATS (MESSAGEINDEX,SESSIONID,HISTORYLISTMESSAGEID,SCHEDULEJOBID,DATATYPE,RECIPIENTCONTACTID,DELIVERYTYPE,SUBSINSTID,SCHEDULEID,SUBINSTNAME,DATAID,CONTACTTYPE,RECIPIENTGROUPID,RECIPIENTCONTACTNAME,ISDEFAULTADDRESS,ADDRESSID,DEVICEID,ISNOTIFICATIONMESSAGE,NOTIFICATIONADDR,SERVERID,SERVERMACHINE,PROJECTID,EXECSTARTTIME,EXECFINISHTIME,DELIVERYSTATUS,PHYSICALADDRESS,BATCHID,DAY_ID,HOUR_ID,MINUTE_ID,REPOSITORYID,RECORDTIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
  698. 2018-07-19 17:40:04.312 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557974824704][Database Classes][SQL Trace] Executing Parameterized SQL: insert into STG_IS_CUBE_REP_STATS (SESSIONID,JOBID,PROJECTID,CUBEREPORTGUID,CUBEINSTANCEID,CUBEACTIONID,REPORTGUID,CUBEKBSIZE,CUBEROWSIZE,STARTTIME,FINISHTIME,DAY_ID,HOUR_ID,MINUTE_ID,SERVERMACHINE,REPOSITORYID,RECORDTIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
  699. 2018-07-19 17:40:20.710 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558453618432][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT @@SESSION.SQL_MODE
  700. 2018-07-19 17:40:20.712 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140558453618432][Database Classes][SQL Trace] Executing SQL. Connection ID: 1. SQL: SELECT PROP_VAL FROM DSSMDSYSPROP WHERE NAME='SECURITYPOLICY'
  701. 2018-07-19 17:40:21.162 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557024343808][Database Classes][SQL Trace][UID:597D9F064488B185F49611BB7A999480][SID:2315D8D5B543DFCFB609A5DF88F436D4][OID:648D15EE4EFE10EEF823D38C449B2219] Executing SQL. Connection ID: 3. SQL: CREATE UNLOGGED TABLE TXFWJ0TZKMD000(
  702. parent_agency_id VARCHAR(32),
  703. latest CHAR(1),
  704. fiscal_year INTEGER,
  705. status VARCHAR(32),
  706. archived CHAR(1),
  707. WJXBFS1 INTEGER,
  708. WJXBFS2 INTEGER)
  709. 2018-07-19 17:40:21.188 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557024343808][Database Classes][SQL Trace][UID:597D9F064488B185F49611BB7A999480][SID:2315D8D5B543DFCFB609A5DF88F436D4][OID:648D15EE4EFE10EEF823D38C449B2219] Executing SQL. Connection ID: 3. SQL: insert into TXFWJ0TZKMD000
  710. select a11.parent_agency_id AS parent_agency_id,
  711. a11.latest AS latest,
  712. a11.fiscal_year AS fiscal_year,
  713. a11.status AS status,
  714. a11.archived AS archived,
  715. count(a11.program_no) AS WJXBFS1,
  716. CASE WHEN max(CASE WHEN a11.fiscal_year in (2018) THEN 1 ELSE 0 END) = 1 THEN count(CASE WHEN a11.fiscal_year in (2018) THEN a11.program_no ELSE NULL END) ELSE NULL END AS WJXBFS2
  717. from v_fal a11
  718. where (a11.archived in ('0')
  719. and a11.latest in ('1')
  720. and a11.status in ('published'))
  721. group by a11.parent_agency_id,
  722. a11.latest,
  723. a11.fiscal_year,
  724. a11.status,
  725. a11.archived
  726. 2018-07-19 17:40:22.127 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557024343808][Database Classes][SQL Trace][UID:597D9F064488B185F49611BB7A999480][SID:2315D8D5B543DFCFB609A5DF88F436D4][OID:648D15EE4EFE10EEF823D38C449B2219] Executing SQL. Connection ID: 3. SQL: select distinct pa12.parent_agency_id AS parent_agency_id,
  727. a13.parent_agency_name AS parent_agency_name,
  728. pa12.status AS status,
  729. pa12.latest AS latest,
  730. pa12.archived AS archived,
  731. pa12.fiscal_year AS fiscal_year,
  732. pa12.WJXBFS1 AS WJXBFS1,
  733. pa12.WJXBFS2 AS WJXBFS2
  734. from TXFWJ0TZKMD000 pa12
  735. join v_fal a13
  736. on (pa12.archived = a13.archived and
  737. pa12.fiscal_year = a13.fiscal_year and
  738. pa12.latest = a13.latest and
  739. pa12.parent_agency_id = a13.parent_agency_id and
  740. pa12.status = a13.status)
  741. 2018-07-19 17:40:24.320 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557974824704][Database Classes][SQL Trace] Executing Parameterized SQL: insert into STG_IS_SESSION_STATS (SESSIONID,SERVERID,SERVERMACHINE,WEBMACHINE,USERID,CLIENTMACHINE,CONNECTTIME,DISCONNECTTIME,EVENTSOURCE,DAY_ID,HOUR_ID,MINUTE_ID,REPOSITORYID,RECORDTIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
  742. 2018-07-19 17:40:27.126 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557024343808][Database Classes][SQL Trace][UID:597D9F064488B185F49611BB7A999480][SID:2315D8D5B543DFCFB609A5DF88F436D4][OID:648D15EE4EFE10EEF823D38C449B2219] Executing SQL. Connection ID: 3. SQL: drop table TXFWJ0TZKMD000
  743. 2018-07-19 17:40:27.330 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557022242560][Database Classes][SQL Trace][UID:597D9F064488B185F49611BB7A999480][SID:2315D8D5B543DFCFB609A5DF88F436D4][OID:648D15EE4EFE10EEF823D38C449B2219] Executing SQL. Connection ID: 3. SQL: CREATE UNLOGGED TABLE TN7N7CAYQMD000(
  744. parent_agency_id VARCHAR(32),
  745. latest CHAR(1),
  746. fiscal_year INTEGER,
  747. status VARCHAR(32),
  748. archived CHAR(1),
  749. WJXBFS1 INTEGER,
  750. WJXBFS2 INTEGER)
  751. 2018-07-19 17:40:27.358 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557022242560][Database Classes][SQL Trace][UID:597D9F064488B185F49611BB7A999480][SID:2315D8D5B543DFCFB609A5DF88F436D4][OID:648D15EE4EFE10EEF823D38C449B2219] Executing SQL. Connection ID: 3. SQL: insert into TN7N7CAYQMD000
  752. select a11.parent_agency_id AS parent_agency_id,
  753. a11.latest AS latest,
  754. a11.fiscal_year AS fiscal_year,
  755. a11.status AS status,
  756. a11.archived AS archived,
  757. count(a11.program_no) AS WJXBFS1,
  758. CASE WHEN max(CASE WHEN a11.fiscal_year in (2018) THEN 1 ELSE 0 END) = 1 THEN count(CASE WHEN a11.fiscal_year in (2018) THEN a11.program_no ELSE NULL END) ELSE NULL END AS WJXBFS2
  759. from v_fal a11
  760. where (a11.archived in ('0')
  761. and a11.latest in ('1')
  762. and a11.status in ('published'))
  763. group by a11.parent_agency_id,
  764. a11.latest,
  765. a11.fiscal_year,
  766. a11.status,
  767. a11.archived
  768. 2018-07-19 17:40:28.412 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557022242560][Database Classes][SQL Trace][UID:597D9F064488B185F49611BB7A999480][SID:2315D8D5B543DFCFB609A5DF88F436D4][OID:648D15EE4EFE10EEF823D38C449B2219] Executing SQL. Connection ID: 3. SQL: select distinct pa12.parent_agency_id AS parent_agency_id,
  769. a13.parent_agency_name AS parent_agency_name,
  770. pa12.status AS status,
  771. pa12.latest AS latest,
  772. pa12.archived AS archived,
  773. pa12.fiscal_year AS fiscal_year,
  774. pa12.WJXBFS1 AS WJXBFS1,
  775. pa12.WJXBFS2 AS WJXBFS2
  776. from TN7N7CAYQMD000 pa12
  777. join v_fal a13
  778. on (pa12.archived = a13.archived and
  779. pa12.fiscal_year = a13.fiscal_year and
  780. pa12.latest = a13.latest and
  781. pa12.parent_agency_id = a13.parent_agency_id and
  782. pa12.status = a13.status)
  783. 2018-07-19 17:40:33.381 [HOST:env-92950laiouse1][SERVER:CastorServer][PID:5247][THR:140557022242560][Database Classes][SQL Trace][UID:597D9F064488B185F49611BB7A999480][SID:2315D8D5B543DFCFB609A5DF88F436D4][OID:648D15EE4EFE10EEF823D38C449B2219] Executing SQL. Connection ID: 3. SQL: drop table TN7N7CAYQMD000
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!