2014-10-03 22:29:01,936 [Timer-3] DEBUG org.hibernate.SQL - select top 1000 this_.id as id9_0_, this_.action_instr as action2_9_0_, this_.action_label as action3_9_0_, this_.action_pm as action4_9_0_, this_.action_summary as action5_9_0_, this_.assoc_data as assoc6_9_0_, this_.assoc_group_uuid as assoc7_9_0_, this_.author_id as author20_9_0_, this_.body as body9_0_, this_.comment_count as comment9_9_0_, this_.closed_ts as closed10_9_0_, this_.type as type9_0_, this_.feed_id as feed21_9_0_, this_.icon_doc_uuid as icon12_9_0_, this_.updated_ts as updated13_9_0_, this_.original_recipients as original14_9_0_, this_.created_ts as created15_9_0_, this_.recipient as recipient9_0_, this_.is_rolemap_locked as is16_9_0_, this_.source as source9_0_, this_.is_targeted as is18_9_0_, this_.is_unsecured as is19_9_0_ from tp_feed_entry this_ where this_.updated_ts>? and this_.updated_ts<=? order by this_.updated_ts asc
2014-10-03 22:29:01,938 [Timer-3] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [BIGINT] - 1412375330920
2014-10-03 22:29:01,939 [Timer-3] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [BIGINT] - 1412375341933
2014-10-03 22:29:01,964 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select this_.id as id23_0_, this_.scs_key_h as scs2_23_0_, this_.scs_key_salt as scs3_23_0_, this_.username as username23_0_ from usr this_ where (this_.username in (?))
2014-10-03 22:29:01,966 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - jm28286
2014-10-03 22:29:01,967 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [259] as column [id23_0_]
2014-10-03 22:29:01,967 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Sc8+0zU+mmf7rn5ytnUeoVTyEk4=] as column [scs2_23_0_]
2014-10-03 22:29:01,968 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [scs3_23_0_]
2014-10-03 22:29:01,969 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [jm28286] as column [username23_0_]
2014-10-03 22:29:01,972 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select this_.id as id15_0_, this_.uuid as uuid15_0_ from grp this_ where (this_.uuid in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
2014-10-03 22:29:01,973 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - _e-0000d926-43e0-8000-4593-010000010000_171
2014-10-03 22:29:01,974 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - _e-0000d849-08d9-8000-4593-010000010000_142
2014-10-03 22:29:01,974 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_159
2014-10-03 22:29:01,975 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [VARCHAR] - _e-0000d984-1fb1-8000-4593-010000010000_241
2014-10-03 22:29:01,976 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [VARCHAR] - _e-0000d984-1fb1-8000-4593-010000010000_240
2014-10-03 22:29:01,976 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_157
2014-10-03 22:29:01,977 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [7] as [VARCHAR] - _e-0000d823-af2b-8000-bffc-010000010000_8
2014-10-03 22:29:01,977 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [8] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_158
2014-10-03 22:29:01,978 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [9] as [VARCHAR] - _e-0000d897-bb80-8000-4593-010000010000_148
2014-10-03 22:29:01,978 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [10] as [VARCHAR] - _e-0000d897-bb80-8000-4593-010000010000_147
2014-10-03 22:29:01,979 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [11] as [VARCHAR] - _e-0000d7ef-08cc-8000-4593-010000010000_119
2014-10-03 22:29:01,979 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [12] as [VARCHAR] - _e-0000d7ef-08cc-8000-4593-010000010000_115
2014-10-03 22:29:01,980 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [13] as [VARCHAR] - _e-0000d7ef-08cc-8000-4593-010000010000_116
2014-10-03 22:29:01,980 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [14] as [VARCHAR] - _e-0000d7ef-08cc-8000-4593-010000010000_117
2014-10-03 22:29:01,981 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [15] as [VARCHAR] - SYSTEM_GROUP_PROCESS_MODEL_CREATORS
2014-10-03 22:29:01,981 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [16] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_163
2014-10-03 22:29:01,982 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [17] as [VARCHAR] - _e-0000d95f-30b6-8000-4593-010000010000_214
2014-10-03 22:29:01,982 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [18] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_161
2014-10-03 22:29:01,983 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [19] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_160
2014-10-03 22:29:01,984 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [20] as [VARCHAR] - _e-0000d984-1fb1-8000-4593-010000010000_232
2014-10-03 22:29:01,984 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [21] as [VARCHAR] - _e-0000d419-b9ec-8000-a13e-012a55012a55_466
2014-10-03 22:29:01,984 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [22] as [VARCHAR] - _e-0000d9ac-e06c-8000-4593-010000010000_242
2014-10-03 22:29:01,985 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [23] as [VARCHAR] - _e-0000d940-128e-8000-4593-010000010000_183
2014-10-03 22:29:01,986 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [24] as [VARCHAR] - _e-0000d398-70cf-8000-9aee-01075c01075c_6
2014-10-03 22:29:01,986 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [25] as [VARCHAR] - _e-0000d908-1770-8000-4593-010000010000_168
2014-10-03 22:29:01,987 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [26] as [VARCHAR] - SYSTEM_GROUP_TEMPO_GLOBAL_MESSAGE_AUTHORS
2014-10-03 22:29:01,987 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [27] as [VARCHAR] - _e-0000d8c8-deaf-8000-4593-010000010000_166
2014-10-03 22:29:01,988 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [28] as [VARCHAR] - _e-0000d984-1fb1-8000-4593-010000010000_235
2014-10-03 22:29:01,988 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [29] as [VARCHAR] - _e-0000d984-1fb1-8000-4593-010000010000_238
2014-10-03 22:29:01,989 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [30] as [VARCHAR] - SYSTEM_GROUP_TEMPO_BROADCAST_TARGETS
2014-10-03 22:29:01,989 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [31] as [VARCHAR] - _e-0000d825-43f8-8000-4593-010000010000_131
2014-10-03 22:29:01,990 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [32] as [VARCHAR] - SYSTEM_GROUP_ROLE_DESIGNERS
2014-10-03 22:29:01,991 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [33] as [VARCHAR] - _e-0000d825-43f8-8000-4593-010000010000_130
2014-10-03 22:29:01,991 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [34] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_154
2014-10-03 22:29:01,992 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [35] as [VARCHAR] - _e-0000d7b7-78bb-8000-4593-010000010000_19
2014-10-03 22:29:01,992 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [36] as [VARCHAR] - _e-0000d7ef-08cc-8000-4593-010000010000_120
2014-10-03 22:29:01,993 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [37] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_153
2014-10-03 22:29:01,993 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [38] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_156
2014-10-03 22:29:01,994 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [39] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_155
2014-10-03 22:29:01,994 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [40] as [VARCHAR] - _e-0000d7b7-78bb-8000-4593-010000010000_18
2014-10-03 22:29:01,995 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [41] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_150
2014-10-03 22:29:01,995 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [42] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_152
2014-10-03 22:29:01,996 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [43] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_151
2014-10-03 22:29:01,998 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [5] as column [id15_0_]
2014-10-03 22:29:01,999 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d398-70cf-8000-9aee-01075c01075c_6] as column [uuid15_0_]
2014-10-03 22:29:01,999 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [202] as column [id15_0_]
2014-10-03 22:29:02,000 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d419-b9ec-8000-a13e-012a55012a55_466] as column [uuid15_0_]
2014-10-03 22:29:02,000 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [13] as column [id15_0_]
2014-10-03 22:29:02,001 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7b7-78bb-8000-4593-010000010000_18] as column [uuid15_0_]
2014-10-03 22:29:02,001 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [106] as column [id15_0_]
2014-10-03 22:29:02,002 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7b7-78bb-8000-4593-010000010000_19] as column [uuid15_0_]
2014-10-03 22:29:02,003 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [93] as column [id15_0_]
2014-10-03 22:29:02,003 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7ef-08cc-8000-4593-010000010000_115] as column [uuid15_0_]
2014-10-03 22:29:02,004 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [95] as column [id15_0_]
2014-10-03 22:29:02,004 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7ef-08cc-8000-4593-010000010000_116] as column [uuid15_0_]
2014-10-03 22:29:02,005 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [96] as column [id15_0_]
2014-10-03 22:29:02,005 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7ef-08cc-8000-4593-010000010000_117] as column [uuid15_0_]
2014-10-03 22:29:02,006 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [94] as column [id15_0_]
2014-10-03 22:29:02,006 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7ef-08cc-8000-4593-010000010000_119] as column [uuid15_0_]
2014-10-03 22:29:02,007 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [98] as column [id15_0_]
2014-10-03 22:29:02,007 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7ef-08cc-8000-4593-010000010000_120] as column [uuid15_0_]
2014-10-03 22:29:02,008 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [161] as column [id15_0_]
2014-10-03 22:29:02,009 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d823-af2b-8000-bffc-010000010000_8] as column [uuid15_0_]
2014-10-03 22:29:02,009 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [109] as column [id15_0_]
2014-10-03 22:29:02,010 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d825-43f8-8000-4593-010000010000_130] as column [uuid15_0_]
2014-10-03 22:29:02,010 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [108] as column [id15_0_]
2014-10-03 22:29:02,010 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d825-43f8-8000-4593-010000010000_131] as column [uuid15_0_]
2014-10-03 22:29:02,011 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [119] as column [id15_0_]
2014-10-03 22:29:02,012 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d849-08d9-8000-4593-010000010000_142] as column [uuid15_0_]
2014-10-03 22:29:02,012 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [127] as column [id15_0_]
2014-10-03 22:29:02,013 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d897-bb80-8000-4593-010000010000_147] as column [uuid15_0_]
2014-10-03 22:29:02,013 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [126] as column [id15_0_]
2014-10-03 22:29:02,014 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d897-bb80-8000-4593-010000010000_148] as column [uuid15_0_]
2014-10-03 22:29:02,014 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [131] as column [id15_0_]
2014-10-03 22:29:02,015 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_150] as column [uuid15_0_]
2014-10-03 22:29:02,015 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [133] as column [id15_0_]
2014-10-03 22:29:02,016 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_151] as column [uuid15_0_]
2014-10-03 22:29:02,017 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [132] as column [id15_0_]
2014-10-03 22:29:02,017 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_152] as column [uuid15_0_]
2014-10-03 22:29:02,018 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [129] as column [id15_0_]
2014-10-03 22:29:02,018 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_153] as column [uuid15_0_]
2014-10-03 22:29:02,019 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [143] as column [id15_0_]
2014-10-03 22:29:02,019 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_154] as column [uuid15_0_]
2014-10-03 22:29:02,020 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [134] as column [id15_0_]
2014-10-03 22:29:02,020 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_155] as column [uuid15_0_]
2014-10-03 22:29:02,021 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [130] as column [id15_0_]
2014-10-03 22:29:02,021 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_156] as column [uuid15_0_]
2014-10-03 22:29:02,022 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [128] as column [id15_0_]
2014-10-03 22:29:02,022 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_157] as column [uuid15_0_]
2014-10-03 22:29:02,023 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [138] as column [id15_0_]
2014-10-03 22:29:02,023 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_158] as column [uuid15_0_]
2014-10-03 22:29:02,024 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [137] as column [id15_0_]
2014-10-03 22:29:02,024 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_159] as column [uuid15_0_]
2014-10-03 22:29:02,025 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [140] as column [id15_0_]
2014-10-03 22:29:02,025 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_160] as column [uuid15_0_]
2014-10-03 22:29:02,026 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [139] as column [id15_0_]
2014-10-03 22:29:02,026 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_161] as column [uuid15_0_]
2014-10-03 22:29:02,027 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [135] as column [id15_0_]
2014-10-03 22:29:02,027 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_163] as column [uuid15_0_]
2014-10-03 22:29:02,028 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [142] as column [id15_0_]
2014-10-03 22:29:02,029 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d8c8-deaf-8000-4593-010000010000_166] as column [uuid15_0_]
2014-10-03 22:29:02,029 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [145] as column [id15_0_]
2014-10-03 22:29:02,030 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d908-1770-8000-4593-010000010000_168] as column [uuid15_0_]
2014-10-03 22:29:02,030 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [147] as column [id15_0_]
2014-10-03 22:29:02,031 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d926-43e0-8000-4593-010000010000_171] as column [uuid15_0_]
2014-10-03 22:29:02,031 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [158] as column [id15_0_]
2014-10-03 22:29:02,032 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d940-128e-8000-4593-010000010000_183] as column [uuid15_0_]
2014-10-03 22:29:02,032 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [184] as column [id15_0_]
2014-10-03 22:29:02,033 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d95f-30b6-8000-4593-010000010000_214] as column [uuid15_0_]
2014-10-03 22:29:02,033 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [203] as column [id15_0_]
2014-10-03 22:29:02,034 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d984-1fb1-8000-4593-010000010000_232] as column [uuid15_0_]
2014-10-03 22:29:02,034 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [205] as column [id15_0_]
2014-10-03 22:29:02,035 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d984-1fb1-8000-4593-010000010000_235] as column [uuid15_0_]
2014-10-03 22:29:02,036 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [208] as column [id15_0_]
2014-10-03 22:29:02,036 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d984-1fb1-8000-4593-010000010000_238] as column [uuid15_0_]
2014-10-03 22:29:02,037 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [210] as column [id15_0_]
2014-10-03 22:29:02,037 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d984-1fb1-8000-4593-010000010000_240] as column [uuid15_0_]
2014-10-03 22:29:02,038 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [211] as column [id15_0_]
2014-10-03 22:29:02,038 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d984-1fb1-8000-4593-010000010000_241] as column [uuid15_0_]
2014-10-03 22:29:02,039 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [212] as column [id15_0_]
2014-10-03 22:29:02,039 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d9ac-e06c-8000-4593-010000010000_242] as column [uuid15_0_]
2014-10-03 22:29:02,040 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [11] as column [id15_0_]
2014-10-03 22:29:02,040 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [SYSTEM_GROUP_PROCESS_MODEL_CREATORS] as column [uuid15_0_]
2014-10-03 22:29:02,041 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [4] as column [id15_0_]
2014-10-03 22:29:02,042 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [SYSTEM_GROUP_ROLE_DESIGNERS] as column [uuid15_0_]
2014-10-03 22:29:02,042 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [21] as column [id15_0_]
2014-10-03 22:29:02,043 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [SYSTEM_GROUP_TEMPO_BROADCAST_TARGETS] as column [uuid15_0_]
2014-10-03 22:29:02,044 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [121] as column [id15_0_]
2014-10-03 22:29:02,044 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [SYSTEM_GROUP_TEMPO_GLOBAL_MESSAGE_AUTHORS] as column [uuid15_0_]
2014-10-03 22:29:02,049 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select this_.id as id10_5_, this_.created_by as created16_10_5_, this_.created_ts as created2_10_5_, this_.updated_by as updated17_10_5_, this_.updated_ts as updated3_10_5_, this_.data_src_expr as data4_10_5_, this_.default_filters_expr as default5_10_5_, this_.default_sort_info_id as default18_10_5_, this_.description as descript6_10_5_, this_.facets_list_expr as facets7_10_5_, this_.is_system as is8_10_5_, this_.lv_tmpt_expr as lv9_10_5_, this_.name as name10_5_, this_.plural_name as plural11_10_5_, this_.src_type as src12_10_5_, this_.src_uuid as src13_10_5_, this_.url_stub as url14_10_5_, this_.uuid as uuid10_5_, sortinfo3_.id as id18_0_, sortinfo3_.ascending as ascending18_0_, sortinfo3_.field as field18_0_, rolemapent4_.record_type_id as record1_10_7_, rolemap1_.id as rm2_7_, (select a13.role_id from rm_entry a13 where a13.id=rolemapent4_.rm_entry_id) as formula2_7_, rolemap1_.id as id7_1_, rolemap1_.role_id as role2_7_1_, groups6_.rm_entry_id as rm1_7_8_, group7_.id as group2_8_, group7_.id as id15_2_, group7_.uuid as uuid15_2_, role8_.id as id13_3_, role8_.name as name13_3_, users9_.rm_entry_id as rm1_7_9_, user10_.id as usr2_9_, user10_.id as id23_4_, user10_.scs_key_h as scs2_23_4_, user10_.scs_key_salt as scs3_23_4_, user10_.username as username23_4_ from record_type this_ left outer join sort_info sortinfo3_ on this_.default_sort_info_id=sortinfo3_.id left outer join record_type_rm rolemapent4_ on this_.id=rolemapent4_.record_type_id left outer join rm_entry rolemap1_ on rolemapent4_.rm_entry_id=rolemap1_.id left outer join rm_entry_groups groups6_ on rolemap1_.id=groups6_.rm_entry_id left outer join grp group7_ on groups6_.group_id=group7_.id left outer join rm_role role8_ on rolemap1_.role_id=role8_.id left outer join rm_entry_users users9_ on rolemap1_.id=users9_.rm_entry_id left outer join usr user10_ on users9_.usr_id=user10_.id where this_.url_stub=?
2014-10-03 22:29:02,051 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - CorporateActionsAllEvents
2014-10-03 22:29:02,053 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [310] as column [id18_0_]
2014-10-03 22:29:02,053 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7324] as column [id7_1_]
2014-10-03 22:29:02,054 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [125] as column [id15_2_]
2014-10-03 22:29:02,054 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [8] as column [id13_3_]
2014-10-03 22:29:02,055 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [id23_4_]
2014-10-03 22:29:02,055 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [id10_5_]
2014-10-03 22:29:02,056 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [ascending18_0_]
2014-10-03 22:29:02,056 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [estimatedProcessingDate] as column [field18_0_]
2014-10-03 22:29:02,057 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [8] as column [role2_7_1_]
2014-10-03 22:29:02,057 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d897-bb80-8000-4593-010000010000_149] as column [uuid15_2_]
2014-10-03 22:29:02,058 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [record_type_editor] as column [name13_3_]
2014-10-03 22:29:02,059 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [257] as column [created16_10_5_]
2014-10-03 22:29:02,059 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1396392986698] as column [created2_10_5_]
2014-10-03 22:29:02,059 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [257] as column [updated17_10_5_]
2014-10-03 22:29:02,060 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1407778535450] as column [updated3_10_5_]
2014-10-03 22:29:02,060 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [data4_10_5_]
2014-10-03 22:29:02,061 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [default5_10_5_]
2014-10-03 22:29:02,061 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [310] as column [default18_10_5_]
2014-10-03 22:29:02,062 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [All Corporate Action Events] as column [descript6_10_5_]
2014-10-03 22:29:02,063 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [facets7_10_5_]
2014-10-03 22:29:02,063 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [is8_10_5_]
2014-10-03 22:29:02,064 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=#"_a-0000d8f3-de2d-8000-4594-010000010000_23394"()] as column [lv9_10_5_]
2014-10-03 22:29:02,064 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [SO_CA_All Events] as column [name10_5_]
2014-10-03 22:29:02,065 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Corporate Actions - All Events] as column [plural11_10_5_]
2014-10-03 22:29:02,065 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}DataStoreEntity] as column [src12_10_5_]
2014-10-03 22:29:02,066 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [72372850-dc88-4a0c-8912-be7b7853047a@_a-0000d897-bb86-8000-4594-010000010000_18482] as column [src13_10_5_]
2014-10-03 22:29:02,066 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [CorporateActionsAllEvents] as column [url14_10_5_]
2014-10-03 22:29:02,067 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [b5e5f582-01c2-4a9c-9f70-16bf19b1d92d] as column [uuid10_5_]
2014-10-03 22:29:02,068 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record1_10_7_]
2014-10-03 22:29:02,068 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7324] as column [rm2_7_]
2014-10-03 22:29:02,069 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [8] as column [formula2_7_]
2014-10-03 22:29:02,069 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7324] as column [rm1_7_8_]
2014-10-03 22:29:02,070 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [125] as column [group2_8_]
2014-10-03 22:29:02,070 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [rm1_7_9_]
2014-10-03 22:29:02,071 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [310] as column [id18_0_]
2014-10-03 22:29:02,071 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7325] as column [id7_1_]
2014-10-03 22:29:02,072 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [127] as column [id15_2_]
2014-10-03 22:29:02,072 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [6] as column [id13_3_]
2014-10-03 22:29:02,073 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [id23_4_]
2014-10-03 22:29:02,073 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [id10_5_]
2014-10-03 22:29:02,074 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [6] as column [role2_7_1_]
2014-10-03 22:29:02,074 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d897-bb80-8000-4593-010000010000_147] as column [uuid15_2_]
2014-10-03 22:29:02,075 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [record_type_viewer] as column [name13_3_]
2014-10-03 22:29:02,075 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record1_10_7_]
2014-10-03 22:29:02,076 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7325] as column [rm2_7_]
2014-10-03 22:29:02,076 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [6] as column [formula2_7_]
2014-10-03 22:29:02,077 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7325] as column [rm1_7_8_]
2014-10-03 22:29:02,078 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [127] as column [group2_8_]
2014-10-03 22:29:02,078 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [rm1_7_9_]
2014-10-03 22:29:02,079 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [310] as column [id18_0_]
2014-10-03 22:29:02,079 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7326] as column [id7_1_]
2014-10-03 22:29:02,080 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [125] as column [id15_2_]
2014-10-03 22:29:02,080 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7] as column [id13_3_]
2014-10-03 22:29:02,080 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [id23_4_]
2014-10-03 22:29:02,081 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [id10_5_]
2014-10-03 22:29:02,081 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7] as column [role2_7_1_]
2014-10-03 22:29:02,082 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [record_type_administrator] as column [name13_3_]
2014-10-03 22:29:02,082 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record1_10_7_]
2014-10-03 22:29:02,083 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7326] as column [rm2_7_]
2014-10-03 22:29:02,083 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7] as column [formula2_7_]
2014-10-03 22:29:02,084 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7326] as column [rm1_7_8_]
2014-10-03 22:29:02,085 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [125] as column [group2_8_]
2014-10-03 22:29:02,085 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [rm1_7_9_]
2014-10-03 22:29:02,087 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select defaultfil0_.record_type_id as record1_10_1_, defaultfil0_.filter_id as filter2_1_, defaultfil0_.order_idx as order3_1_, typedvalue1_.id as id1_0_, typedvalue1_.field as field1_0_, typedvalue1_.operator as operator1_0_, typedvalue1_.value_expr as value4_1_0_ from record_type_filters defaultfil0_ inner join filter typedvalue1_ on defaultfil0_.filter_id=typedvalue1_.id where defaultfil0_.record_type_id=?
2014-10-03 22:29:02,087 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [BIGINT] - 30
2014-10-03 22:29:02,089 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select detailview0_.record_type_id as record6_10_1_, detailview0_.id as id1_, detailview0_.order_idx as order7_1_, detailview0_.id as id0_0_, detailview0_.name_expr as name2_0_0_, detailview0_.ui_expr as ui3_0_0_, detailview0_.url_stub as url4_0_0_, detailview0_.visibility_expr as visibility5_0_0_ from record_detail_view_cfg detailview0_ where detailview0_.record_type_id=?
2014-10-03 22:29:02,090 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [BIGINT] - 30
2014-10-03 22:29:02,091 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [84] as column [id0_0_]
2014-10-03 22:29:02,092 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Summary"] as column [name2_0_0_]
2014-10-03 22:29:02,092 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=#"_a-0000d8f3-de2d-8000-4594-010000010000_23445"()] as column [ui3_0_0_]
2014-10-03 22:29:02,093 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [summary] as column [url4_0_0_]
2014-10-03 22:29:02,093 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,094 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,094 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [84] as column [id1_]
2014-10-03 22:29:02,095 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0] as column [order7_1_]
2014-10-03 22:29:02,096 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [97] as column [id0_0_]
2014-10-03 22:29:02,096 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Terms & Extended Text"] as column [name2_0_0_]
2014-10-03 22:29:02,097 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=rule!SO_CA_TAET_Dashboard()] as column [ui3_0_0_]
2014-10-03 22:29:02,098 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_uj1dlA] as column [url4_0_0_]
2014-10-03 22:29:02,098 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,099 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,099 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [97] as column [id1_]
2014-10-03 22:29:02,100 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1] as column [order7_1_]
2014-10-03 22:29:02,100 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [99] as column [id0_0_]
2014-10-03 22:29:02,101 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="PM Response & Elections"] as column [name2_0_0_]
2014-10-03 22:29:02,101 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=rule!SO_CA_PmResponseAndElectionDetails_Dashboard()] as column [ui3_0_0_]
2014-10-03 22:29:02,102 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_wyKeVw] as column [url4_0_0_]
2014-10-03 22:29:02,102 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,103 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,103 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [99] as column [id1_]
2014-10-03 22:29:02,104 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [2] as column [order7_1_]
2014-10-03 22:29:02,105 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [100] as column [id0_0_]
2014-10-03 22:29:02,105 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Holdings"] as column [name2_0_0_]
2014-10-03 22:29:02,106 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=rule!SO_CA_HoldingsDetails_Dashboard()] as column [ui3_0_0_]
2014-10-03 22:29:02,106 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_u-0Pzg] as column [url4_0_0_]
2014-10-03 22:29:02,107 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,108 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,108 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [100] as column [id1_]
2014-10-03 22:29:02,109 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [3] as column [order7_1_]
2014-10-03 22:29:02,109 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [101] as column [id0_0_]
2014-10-03 22:29:02,110 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Updates"] as column [name2_0_0_]
2014-10-03 22:29:02,110 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=rule!SO_CA_Updates_Dashboard()] as column [ui3_0_0_]
2014-10-03 22:29:02,111 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_d7IuWQ] as column [url4_0_0_]
2014-10-03 22:29:02,111 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,112 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,112 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [101] as column [id1_]
2014-10-03 22:29:02,113 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [4] as column [order7_1_]
2014-10-03 22:29:02,113 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [102] as column [id0_0_]
2014-10-03 22:29:02,114 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Security Ids"] as column [name2_0_0_]
2014-10-03 22:29:02,114 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=rule!SO_CA_SecurityIds_Dashboard()] as column [ui3_0_0_]
2014-10-03 22:29:02,115 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_K7Ikhw] as column [url4_0_0_]
2014-10-03 22:29:02,115 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,116 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,116 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [102] as column [id1_]
2014-10-03 22:29:02,117 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [5] as column [order7_1_]
2014-10-03 22:29:02,117 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [103] as column [id0_0_]
2014-10-03 22:29:02,118 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Unique Documentation"] as column [name2_0_0_]
2014-10-03 22:29:02,118 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=#"_a-0000d984-1fb8-8000-4594-010000010000_47334"()] as column [ui3_0_0_]
2014-10-03 22:29:02,119 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_l1G41A] as column [url4_0_0_]
2014-10-03 22:29:02,119 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,120 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,120 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [103] as column [id1_]
2014-10-03 22:29:02,121 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [6] as column [order7_1_]
2014-10-03 22:29:02,122 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select relatedact0_.record_type_id as record6_10_1_, relatedact0_.id as id1_, relatedact0_.order_idx as order7_1_, relatedact0_.id as id11_0_, relatedact0_.context_expr as context2_11_0_, relatedact0_.target_type as target3_11_0_, relatedact0_.target_uuid as target4_11_0_, relatedact0_.visibility_expr as visibility5_11_0_ from record_related_action_cfg relatedact0_ where relatedact0_.record_type_id=?
2014-10-03 22:29:02,123 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [BIGINT] - 30
2014-10-03 22:29:02,124 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [94] as column [id11_0_]
2014-10-03 22:29:02,124 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [={caEventDetails:rule!SO_CA_GetCAEventDetailsById(rp!id)}] as column [context2_11_0_]
2014-10-03 22:29:02,125 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}ProcessModel] as column [target3_11_0_]
2014-10-03 22:29:02,125 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0005d8ff-e78a-8000-4595-010000010000] as column [target4_11_0_]
2014-10-03 22:29:02,126 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_11_0_]
2014-10-03 22:29:02,126 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,127 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [94] as column [id1_]
2014-10-03 22:29:02,127 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0] as column [order7_1_]
2014-10-03 22:29:02,128 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [95] as column [id11_0_]
2014-10-03 22:29:02,128 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [={caEventDetails:rule!SO_CA_GetCAEventDetailsById(rp!id)}] as column [context2_11_0_]
2014-10-03 22:29:02,129 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}ProcessModel] as column [target3_11_0_]
2014-10-03 22:29:02,129 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0015d901-11d5-8000-4595-010000010000] as column [target4_11_0_]
2014-10-03 22:29:02,130 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_11_0_]
2014-10-03 22:29:02,131 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,131 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [95] as column [id1_]
2014-10-03 22:29:02,132 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1] as column [order7_1_]
2014-10-03 22:29:02,132 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [96] as column [id11_0_]
2014-10-03 22:29:02,133 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [={caEventDetails:rule!SO_CA_GetCAEventDetailsById(rp!id)}] as column [context2_11_0_]
2014-10-03 22:29:02,133 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}ProcessModel] as column [target3_11_0_]
2014-10-03 22:29:02,134 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0006d8ff-f0c3-8000-4595-010000010000] as column [target4_11_0_]
2014-10-03 22:29:02,134 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_11_0_]
2014-10-03 22:29:02,135 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,135 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [96] as column [id1_]
2014-10-03 22:29:02,136 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [4] as column [order7_1_]
2014-10-03 22:29:02,136 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [97] as column [id11_0_]
2014-10-03 22:29:02,137 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [={caEventDetails:rule!SO_CA_GetCAEventDetailsById(rp!id)}] as column [context2_11_0_]
2014-10-03 22:29:02,137 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}ProcessModel] as column [target3_11_0_]
2014-10-03 22:29:02,138 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0019d97a-6cd8-8000-4595-010000010000] as column [target4_11_0_]
2014-10-03 22:29:02,138 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_11_0_]
2014-10-03 22:29:02,139 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,139 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [97] as column [id1_]
2014-10-03 22:29:02,140 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [3] as column [order7_1_]
2014-10-03 22:29:02,140 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [98] as column [id11_0_]
2014-10-03 22:29:02,141 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [={caEventDetails:rule!SO_CA_GetCAEventDetailsById(rp!id)}] as column [context2_11_0_]
2014-10-03 22:29:02,141 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}ProcessModel] as column [target3_11_0_]
2014-10-03 22:29:02,142 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0007d98c-8517-8000-4595-010000010000] as column [target4_11_0_]
2014-10-03 22:29:02,142 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_11_0_]
2014-10-03 22:29:02,143 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,143 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [98] as column [id1_]
2014-10-03 22:29:02,144 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [5] as column [order7_1_]
2014-10-03 22:29:02,144 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [105] as column [id11_0_]
2014-10-03 22:29:02,145 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [={caEventDetails:#"99c23d88-4f76-4e6b-9b19-153a29706310"(rp!id)}] as column [context2_11_0_]
2014-10-03 22:29:02,146 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}ProcessModel] as column [target3_11_0_]
2014-10-03 22:29:02,146 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0008d99c-d2dd-8000-4595-010000010000] as column [target4_11_0_]
2014-10-03 22:29:02,147 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=if(rf!isProcessingComplete=False,true(),false())] as column [visibility5_11_0_]
2014-10-03 22:29:02,147 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,148 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [105] as column [id1_]
2014-10-03 22:29:02,148 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [6] as column [order7_1_]
2014-10-03 22:29:02,149 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [107] as column [id11_0_]
2014-10-03 22:29:02,149 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [={caEventDetails:#"99c23d88-4f76-4e6b-9b19-153a29706310"(rp!id)}] as column [context2_11_0_]
2014-10-03 22:29:02,150 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}ProcessModel] as column [target3_11_0_]
2014-10-03 22:29:02,150 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0003d9a1-e937-8000-4595-010000010000] as column [target4_11_0_]
2014-10-03 22:29:02,151 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=if(rf!isProcessingComplete=True,true(),false())] as column [visibility5_11_0_]
2014-10-03 22:29:02,151 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,152 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [107] as column [id1_]
2014-10-03 22:29:02,153 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7] as column [order7_1_]
2014-10-03 22:29:02,153 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [110] as column [id11_0_]
2014-10-03 22:29:02,154 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [={caEventDetails:#"99c23d88-4f76-4e6b-9b19-153a29706310"(rp!id)}] as column [context2_11_0_]
2014-10-03 22:29:02,154 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}ProcessModel] as column [target3_11_0_]
2014-10-03 22:29:02,155 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [000cd9a0-a4f7-8000-4595-010000010000] as column [target4_11_0_]
2014-10-03 22:29:02,155 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_11_0_]
2014-10-03 22:29:02,156 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,156 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [110] as column [id1_]
2014-10-03 22:29:02,157 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [8] as column [order7_1_]
2014-10-03 22:29:02,157 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [112] as column [id11_0_]
2014-10-03 22:29:02,158 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [={caEventDetails:#"99c23d88-4f76-4e6b-9b19-153a29706310"(rp!id)}] as column [context2_11_0_]
2014-10-03 22:29:02,158 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}ProcessModel] as column [target3_11_0_]
2014-10-03 22:29:02,159 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0007d9a5-c58a-8000-4595-010000010000] as column [target4_11_0_]
2014-10-03 22:29:02,159 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_11_0_]
2014-10-03 22:29:02,160 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,160 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [112] as column [id1_]
2014-10-03 22:29:02,161 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [2] as column [order7_1_]
2014-10-03 22:29:02,187 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select this_.id as id23_0_, this_.scs_key_h as scs2_23_0_, this_.scs_key_salt as scs3_23_0_, this_.username as username23_0_ from usr this_ where (this_.username in (?))
2014-10-03 22:29:02,188 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - jm28286
2014-10-03 22:29:02,189 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [259] as column [id23_0_]
2014-10-03 22:29:02,190 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Sc8+0zU+mmf7rn5ytnUeoVTyEk4=] as column [scs2_23_0_]
2014-10-03 22:29:02,190 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [scs3_23_0_]
2014-10-03 22:29:02,191 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [jm28286] as column [username23_0_]
2014-10-03 22:29:02,194 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select this_.id as id15_0_, this_.uuid as uuid15_0_ from grp this_ where (this_.uuid in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
2014-10-03 22:29:02,194 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - _e-0000d926-43e0-8000-4593-010000010000_171
2014-10-03 22:29:02,195 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - _e-0000d849-08d9-8000-4593-010000010000_142
2014-10-03 22:29:02,195 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_159
2014-10-03 22:29:02,196 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [VARCHAR] - _e-0000d984-1fb1-8000-4593-010000010000_241
2014-10-03 22:29:02,197 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [VARCHAR] - _e-0000d984-1fb1-8000-4593-010000010000_240
2014-10-03 22:29:02,197 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_157
2014-10-03 22:29:02,197 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [7] as [VARCHAR] - _e-0000d823-af2b-8000-bffc-010000010000_8
2014-10-03 22:29:02,198 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [8] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_158
2014-10-03 22:29:02,199 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [9] as [VARCHAR] - _e-0000d897-bb80-8000-4593-010000010000_148
2014-10-03 22:29:02,199 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [10] as [VARCHAR] - _e-0000d897-bb80-8000-4593-010000010000_147
2014-10-03 22:29:02,200 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [11] as [VARCHAR] - _e-0000d7ef-08cc-8000-4593-010000010000_119
2014-10-03 22:29:02,200 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [12] as [VARCHAR] - _e-0000d7ef-08cc-8000-4593-010000010000_115
2014-10-03 22:29:02,201 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [13] as [VARCHAR] - _e-0000d7ef-08cc-8000-4593-010000010000_116
2014-10-03 22:29:02,201 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [14] as [VARCHAR] - _e-0000d7ef-08cc-8000-4593-010000010000_117
2014-10-03 22:29:02,202 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [15] as [VARCHAR] - SYSTEM_GROUP_PROCESS_MODEL_CREATORS
2014-10-03 22:29:02,202 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [16] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_163
2014-10-03 22:29:02,203 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [17] as [VARCHAR] - _e-0000d95f-30b6-8000-4593-010000010000_214
2014-10-03 22:29:02,203 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [18] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_161
2014-10-03 22:29:02,204 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [19] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_160
2014-10-03 22:29:02,204 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [20] as [VARCHAR] - _e-0000d984-1fb1-8000-4593-010000010000_232
2014-10-03 22:29:02,205 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [21] as [VARCHAR] - _e-0000d419-b9ec-8000-a13e-012a55012a55_466
2014-10-03 22:29:02,206 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [22] as [VARCHAR] - _e-0000d9ac-e06c-8000-4593-010000010000_242
2014-10-03 22:29:02,206 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [23] as [VARCHAR] - _e-0000d940-128e-8000-4593-010000010000_183
2014-10-03 22:29:02,207 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [24] as [VARCHAR] - _e-0000d398-70cf-8000-9aee-01075c01075c_6
2014-10-03 22:29:02,207 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [25] as [VARCHAR] - _e-0000d908-1770-8000-4593-010000010000_168
2014-10-03 22:29:02,208 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [26] as [VARCHAR] - SYSTEM_GROUP_TEMPO_GLOBAL_MESSAGE_AUTHORS
2014-10-03 22:29:02,208 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [27] as [VARCHAR] - _e-0000d8c8-deaf-8000-4593-010000010000_166
2014-10-03 22:29:02,209 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [28] as [VARCHAR] - _e-0000d984-1fb1-8000-4593-010000010000_235
2014-10-03 22:29:02,209 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [29] as [VARCHAR] - _e-0000d984-1fb1-8000-4593-010000010000_238
2014-10-03 22:29:02,210 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [30] as [VARCHAR] - SYSTEM_GROUP_TEMPO_BROADCAST_TARGETS
2014-10-03 22:29:02,210 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [31] as [VARCHAR] - _e-0000d825-43f8-8000-4593-010000010000_131
2014-10-03 22:29:02,211 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [32] as [VARCHAR] - SYSTEM_GROUP_ROLE_DESIGNERS
2014-10-03 22:29:02,211 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [33] as [VARCHAR] - _e-0000d825-43f8-8000-4593-010000010000_130
2014-10-03 22:29:02,212 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [34] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_154
2014-10-03 22:29:02,212 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [35] as [VARCHAR] - _e-0000d7b7-78bb-8000-4593-010000010000_19
2014-10-03 22:29:02,213 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [36] as [VARCHAR] - _e-0000d7ef-08cc-8000-4593-010000010000_120
2014-10-03 22:29:02,214 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [37] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_153
2014-10-03 22:29:02,214 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [38] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_156
2014-10-03 22:29:02,215 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [39] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_155
2014-10-03 22:29:02,215 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [40] as [VARCHAR] - _e-0000d7b7-78bb-8000-4593-010000010000_18
2014-10-03 22:29:02,216 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [41] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_150
2014-10-03 22:29:02,216 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [42] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_152
2014-10-03 22:29:02,217 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [43] as [VARCHAR] - _e-0000d89c-c957-8000-4593-010000010000_151
2014-10-03 22:29:02,220 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [5] as column [id15_0_]
2014-10-03 22:29:02,221 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d398-70cf-8000-9aee-01075c01075c_6] as column [uuid15_0_]
2014-10-03 22:29:02,221 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [202] as column [id15_0_]
2014-10-03 22:29:02,221 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d419-b9ec-8000-a13e-012a55012a55_466] as column [uuid15_0_]
2014-10-03 22:29:02,222 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [13] as column [id15_0_]
2014-10-03 22:29:02,223 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7b7-78bb-8000-4593-010000010000_18] as column [uuid15_0_]
2014-10-03 22:29:02,223 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [106] as column [id15_0_]
2014-10-03 22:29:02,224 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7b7-78bb-8000-4593-010000010000_19] as column [uuid15_0_]
2014-10-03 22:29:02,224 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [93] as column [id15_0_]
2014-10-03 22:29:02,225 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7ef-08cc-8000-4593-010000010000_115] as column [uuid15_0_]
2014-10-03 22:29:02,225 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [95] as column [id15_0_]
2014-10-03 22:29:02,226 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7ef-08cc-8000-4593-010000010000_116] as column [uuid15_0_]
2014-10-03 22:29:02,226 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [96] as column [id15_0_]
2014-10-03 22:29:02,227 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7ef-08cc-8000-4593-010000010000_117] as column [uuid15_0_]
2014-10-03 22:29:02,227 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [94] as column [id15_0_]
2014-10-03 22:29:02,228 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7ef-08cc-8000-4593-010000010000_119] as column [uuid15_0_]
2014-10-03 22:29:02,228 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [98] as column [id15_0_]
2014-10-03 22:29:02,228 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d7ef-08cc-8000-4593-010000010000_120] as column [uuid15_0_]
2014-10-03 22:29:02,229 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [161] as column [id15_0_]
2014-10-03 22:29:02,230 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d823-af2b-8000-bffc-010000010000_8] as column [uuid15_0_]
2014-10-03 22:29:02,230 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [109] as column [id15_0_]
2014-10-03 22:29:02,231 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d825-43f8-8000-4593-010000010000_130] as column [uuid15_0_]
2014-10-03 22:29:02,231 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [108] as column [id15_0_]
2014-10-03 22:29:02,232 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d825-43f8-8000-4593-010000010000_131] as column [uuid15_0_]
2014-10-03 22:29:02,232 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [119] as column [id15_0_]
2014-10-03 22:29:02,233 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d849-08d9-8000-4593-010000010000_142] as column [uuid15_0_]
2014-10-03 22:29:02,234 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [127] as column [id15_0_]
2014-10-03 22:29:02,234 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d897-bb80-8000-4593-010000010000_147] as column [uuid15_0_]
2014-10-03 22:29:02,235 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [126] as column [id15_0_]
2014-10-03 22:29:02,235 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d897-bb80-8000-4593-010000010000_148] as column [uuid15_0_]
2014-10-03 22:29:02,236 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [131] as column [id15_0_]
2014-10-03 22:29:02,236 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_150] as column [uuid15_0_]
2014-10-03 22:29:02,237 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [133] as column [id15_0_]
2014-10-03 22:29:02,237 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_151] as column [uuid15_0_]
2014-10-03 22:29:02,238 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [132] as column [id15_0_]
2014-10-03 22:29:02,238 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_152] as column [uuid15_0_]
2014-10-03 22:29:02,239 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [129] as column [id15_0_]
2014-10-03 22:29:02,239 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_153] as column [uuid15_0_]
2014-10-03 22:29:02,240 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [143] as column [id15_0_]
2014-10-03 22:29:02,240 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_154] as column [uuid15_0_]
2014-10-03 22:29:02,241 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [134] as column [id15_0_]
2014-10-03 22:29:02,241 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_155] as column [uuid15_0_]
2014-10-03 22:29:02,242 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [130] as column [id15_0_]
2014-10-03 22:29:02,242 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_156] as column [uuid15_0_]
2014-10-03 22:29:02,243 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [128] as column [id15_0_]
2014-10-03 22:29:02,243 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_157] as column [uuid15_0_]
2014-10-03 22:29:02,244 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [138] as column [id15_0_]
2014-10-03 22:29:02,244 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_158] as column [uuid15_0_]
2014-10-03 22:29:02,245 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [137] as column [id15_0_]
2014-10-03 22:29:02,245 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_159] as column [uuid15_0_]
2014-10-03 22:29:02,246 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [140] as column [id15_0_]
2014-10-03 22:29:02,246 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_160] as column [uuid15_0_]
2014-10-03 22:29:02,247 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [139] as column [id15_0_]
2014-10-03 22:29:02,247 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_161] as column [uuid15_0_]
2014-10-03 22:29:02,248 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [135] as column [id15_0_]
2014-10-03 22:29:02,248 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d89c-c957-8000-4593-010000010000_163] as column [uuid15_0_]
2014-10-03 22:29:02,249 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [142] as column [id15_0_]
2014-10-03 22:29:02,249 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d8c8-deaf-8000-4593-010000010000_166] as column [uuid15_0_]
2014-10-03 22:29:02,250 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [145] as column [id15_0_]
2014-10-03 22:29:02,251 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d908-1770-8000-4593-010000010000_168] as column [uuid15_0_]
2014-10-03 22:29:02,251 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [147] as column [id15_0_]
2014-10-03 22:29:02,251 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d926-43e0-8000-4593-010000010000_171] as column [uuid15_0_]
2014-10-03 22:29:02,252 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [158] as column [id15_0_]
2014-10-03 22:29:02,252 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d940-128e-8000-4593-010000010000_183] as column [uuid15_0_]
2014-10-03 22:29:02,253 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [184] as column [id15_0_]
2014-10-03 22:29:02,254 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d95f-30b6-8000-4593-010000010000_214] as column [uuid15_0_]
2014-10-03 22:29:02,254 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [203] as column [id15_0_]
2014-10-03 22:29:02,255 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d984-1fb1-8000-4593-010000010000_232] as column [uuid15_0_]
2014-10-03 22:29:02,255 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [205] as column [id15_0_]
2014-10-03 22:29:02,256 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d984-1fb1-8000-4593-010000010000_235] as column [uuid15_0_]
2014-10-03 22:29:02,257 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [208] as column [id15_0_]
2014-10-03 22:29:02,257 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d984-1fb1-8000-4593-010000010000_238] as column [uuid15_0_]
2014-10-03 22:29:02,258 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [210] as column [id15_0_]
2014-10-03 22:29:02,258 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d984-1fb1-8000-4593-010000010000_240] as column [uuid15_0_]
2014-10-03 22:29:02,259 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [211] as column [id15_0_]
2014-10-03 22:29:02,259 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d984-1fb1-8000-4593-010000010000_241] as column [uuid15_0_]
2014-10-03 22:29:02,260 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [212] as column [id15_0_]
2014-10-03 22:29:02,260 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d9ac-e06c-8000-4593-010000010000_242] as column [uuid15_0_]
2014-10-03 22:29:02,261 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [11] as column [id15_0_]
2014-10-03 22:29:02,261 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [SYSTEM_GROUP_PROCESS_MODEL_CREATORS] as column [uuid15_0_]
2014-10-03 22:29:02,262 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [4] as column [id15_0_]
2014-10-03 22:29:02,262 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [SYSTEM_GROUP_ROLE_DESIGNERS] as column [uuid15_0_]
2014-10-03 22:29:02,263 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [21] as column [id15_0_]
2014-10-03 22:29:02,263 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [SYSTEM_GROUP_TEMPO_BROADCAST_TARGETS] as column [uuid15_0_]
2014-10-03 22:29:02,264 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [121] as column [id15_0_]
2014-10-03 22:29:02,264 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [SYSTEM_GROUP_TEMPO_GLOBAL_MESSAGE_AUTHORS] as column [uuid15_0_]
2014-10-03 22:29:02,269 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select this_.id as id10_5_, this_.created_by as created16_10_5_, this_.created_ts as created2_10_5_, this_.updated_by as updated17_10_5_, this_.updated_ts as updated3_10_5_, this_.data_src_expr as data4_10_5_, this_.default_filters_expr as default5_10_5_, this_.default_sort_info_id as default18_10_5_, this_.description as descript6_10_5_, this_.facets_list_expr as facets7_10_5_, this_.is_system as is8_10_5_, this_.lv_tmpt_expr as lv9_10_5_, this_.name as name10_5_, this_.plural_name as plural11_10_5_, this_.src_type as src12_10_5_, this_.src_uuid as src13_10_5_, this_.url_stub as url14_10_5_, this_.uuid as uuid10_5_, sortinfo3_.id as id18_0_, sortinfo3_.ascending as ascending18_0_, sortinfo3_.field as field18_0_, rolemapent4_.record_type_id as record1_10_7_, rolemap1_.id as rm2_7_, (select a13.role_id from rm_entry a13 where a13.id=rolemapent4_.rm_entry_id) as formula2_7_, rolemap1_.id as id7_1_, rolemap1_.role_id as role2_7_1_, groups6_.rm_entry_id as rm1_7_8_, group7_.id as group2_8_, group7_.id as id15_2_, group7_.uuid as uuid15_2_, role8_.id as id13_3_, role8_.name as name13_3_, users9_.rm_entry_id as rm1_7_9_, user10_.id as usr2_9_, user10_.id as id23_4_, user10_.scs_key_h as scs2_23_4_, user10_.scs_key_salt as scs3_23_4_, user10_.username as username23_4_ from record_type this_ left outer join sort_info sortinfo3_ on this_.default_sort_info_id=sortinfo3_.id left outer join record_type_rm rolemapent4_ on this_.id=rolemapent4_.record_type_id left outer join rm_entry rolemap1_ on rolemapent4_.rm_entry_id=rolemap1_.id left outer join rm_entry_groups groups6_ on rolemap1_.id=groups6_.rm_entry_id left outer join grp group7_ on groups6_.group_id=group7_.id left outer join rm_role role8_ on rolemap1_.role_id=role8_.id left outer join rm_entry_users users9_ on rolemap1_.id=users9_.rm_entry_id left outer join usr user10_ on users9_.usr_id=user10_.id where this_.url_stub=?
2014-10-03 22:29:02,271 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - CorporateActionsAllEvents
2014-10-03 22:29:02,273 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [310] as column [id18_0_]
2014-10-03 22:29:02,274 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7324] as column [id7_1_]
2014-10-03 22:29:02,274 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [125] as column [id15_2_]
2014-10-03 22:29:02,275 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [8] as column [id13_3_]
2014-10-03 22:29:02,275 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [id23_4_]
2014-10-03 22:29:02,276 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [id10_5_]
2014-10-03 22:29:02,276 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [ascending18_0_]
2014-10-03 22:29:02,277 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [estimatedProcessingDate] as column [field18_0_]
2014-10-03 22:29:02,277 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [8] as column [role2_7_1_]
2014-10-03 22:29:02,278 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d897-bb80-8000-4593-010000010000_149] as column [uuid15_2_]
2014-10-03 22:29:02,278 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [record_type_editor] as column [name13_3_]
2014-10-03 22:29:02,279 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [257] as column [created16_10_5_]
2014-10-03 22:29:02,279 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1396392986698] as column [created2_10_5_]
2014-10-03 22:29:02,280 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [257] as column [updated17_10_5_]
2014-10-03 22:29:02,280 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1407778535450] as column [updated3_10_5_]
2014-10-03 22:29:02,281 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [data4_10_5_]
2014-10-03 22:29:02,281 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [default5_10_5_]
2014-10-03 22:29:02,282 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [310] as column [default18_10_5_]
2014-10-03 22:29:02,282 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [All Corporate Action Events] as column [descript6_10_5_]
2014-10-03 22:29:02,283 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [facets7_10_5_]
2014-10-03 22:29:02,283 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [is8_10_5_]
2014-10-03 22:29:02,284 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=#"_a-0000d8f3-de2d-8000-4594-010000010000_23394"()] as column [lv9_10_5_]
2014-10-03 22:29:02,284 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [SO_CA_All Events] as column [name10_5_]
2014-10-03 22:29:02,285 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Corporate Actions - All Events] as column [plural11_10_5_]
2014-10-03 22:29:02,285 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [{http://www.appian.com/ae/types/2009}DataStoreEntity] as column [src12_10_5_]
2014-10-03 22:29:02,286 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [72372850-dc88-4a0c-8912-be7b7853047a@_a-0000d897-bb86-8000-4594-010000010000_18482] as column [src13_10_5_]
2014-10-03 22:29:02,286 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [CorporateActionsAllEvents] as column [url14_10_5_]
2014-10-03 22:29:02,287 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [b5e5f582-01c2-4a9c-9f70-16bf19b1d92d] as column [uuid10_5_]
2014-10-03 22:29:02,287 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record1_10_7_]
2014-10-03 22:29:02,288 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7324] as column [rm2_7_]
2014-10-03 22:29:02,288 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [8] as column [formula2_7_]
2014-10-03 22:29:02,289 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7324] as column [rm1_7_8_]
2014-10-03 22:29:02,290 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [125] as column [group2_8_]
2014-10-03 22:29:02,290 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [rm1_7_9_]
2014-10-03 22:29:02,291 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [310] as column [id18_0_]
2014-10-03 22:29:02,291 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7325] as column [id7_1_]
2014-10-03 22:29:02,292 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [127] as column [id15_2_]
2014-10-03 22:29:02,292 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [6] as column [id13_3_]
2014-10-03 22:29:02,293 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [id23_4_]
2014-10-03 22:29:02,293 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [id10_5_]
2014-10-03 22:29:02,294 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [6] as column [role2_7_1_]
2014-10-03 22:29:02,294 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_e-0000d897-bb80-8000-4593-010000010000_147] as column [uuid15_2_]
2014-10-03 22:29:02,295 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [record_type_viewer] as column [name13_3_]
2014-10-03 22:29:02,295 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record1_10_7_]
2014-10-03 22:29:02,296 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7325] as column [rm2_7_]
2014-10-03 22:29:02,296 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [6] as column [formula2_7_]
2014-10-03 22:29:02,297 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7325] as column [rm1_7_8_]
2014-10-03 22:29:02,297 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [127] as column [group2_8_]
2014-10-03 22:29:02,298 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [rm1_7_9_]
2014-10-03 22:29:02,298 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [310] as column [id18_0_]
2014-10-03 22:29:02,299 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7326] as column [id7_1_]
2014-10-03 22:29:02,299 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [125] as column [id15_2_]
2014-10-03 22:29:02,300 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7] as column [id13_3_]
2014-10-03 22:29:02,301 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [id23_4_]
2014-10-03 22:29:02,301 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [id10_5_]
2014-10-03 22:29:02,302 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7] as column [role2_7_1_]
2014-10-03 22:29:02,302 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [record_type_administrator] as column [name13_3_]
2014-10-03 22:29:02,303 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record1_10_7_]
2014-10-03 22:29:02,303 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7326] as column [rm2_7_]
2014-10-03 22:29:02,304 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7] as column [formula2_7_]
2014-10-03 22:29:02,304 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [7326] as column [rm1_7_8_]
2014-10-03 22:29:02,305 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [125] as column [group2_8_]
2014-10-03 22:29:02,305 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [rm1_7_9_]
2014-10-03 22:29:02,307 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select defaultfil0_.record_type_id as record1_10_1_, defaultfil0_.filter_id as filter2_1_, defaultfil0_.order_idx as order3_1_, typedvalue1_.id as id1_0_, typedvalue1_.field as field1_0_, typedvalue1_.operator as operator1_0_, typedvalue1_.value_expr as value4_1_0_ from record_type_filters defaultfil0_ inner join filter typedvalue1_ on defaultfil0_.filter_id=typedvalue1_.id where defaultfil0_.record_type_id=?
2014-10-03 22:29:02,307 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [BIGINT] - 30
2014-10-03 22:29:02,309 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select detailview0_.record_type_id as record6_10_1_, detailview0_.id as id1_, detailview0_.order_idx as order7_1_, detailview0_.id as id0_0_, detailview0_.name_expr as name2_0_0_, detailview0_.ui_expr as ui3_0_0_, detailview0_.url_stub as url4_0_0_, detailview0_.visibility_expr as visibility5_0_0_ from record_detail_view_cfg detailview0_ where detailview0_.record_type_id=?
2014-10-03 22:29:02,310 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [BIGINT] - 30
2014-10-03 22:29:02,311 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [84] as column [id0_0_]
2014-10-03 22:29:02,311 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Summary"] as column [name2_0_0_]
2014-10-03 22:29:02,312 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=#"_a-0000d8f3-de2d-8000-4594-010000010000_23445"()] as column [ui3_0_0_]
2014-10-03 22:29:02,313 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [summary] as column [url4_0_0_]
2014-10-03 22:29:02,313 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,314 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,314 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [84] as column [id1_]
2014-10-03 22:29:02,315 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0] as column [order7_1_]
2014-10-03 22:29:02,315 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [97] as column [id0_0_]
2014-10-03 22:29:02,316 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Terms & Extended Text"] as column [name2_0_0_]
2014-10-03 22:29:02,317 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=rule!SO_CA_TAET_Dashboard()] as column [ui3_0_0_]
2014-10-03 22:29:02,317 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_uj1dlA] as column [url4_0_0_]
2014-10-03 22:29:02,318 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,318 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,319 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [97] as column [id1_]
2014-10-03 22:29:02,319 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1] as column [order7_1_]
2014-10-03 22:29:02,320 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [99] as column [id0_0_]
2014-10-03 22:29:02,320 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="PM Response & Elections"] as column [name2_0_0_]
2014-10-03 22:29:02,321 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=rule!SO_CA_PmResponseAndElectionDetails_Dashboard()] as column [ui3_0_0_]
2014-10-03 22:29:02,322 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_wyKeVw] as column [url4_0_0_]
2014-10-03 22:29:02,322 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,322 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,323 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [99] as column [id1_]
2014-10-03 22:29:02,324 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [2] as column [order7_1_]
2014-10-03 22:29:02,324 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [100] as column [id0_0_]
2014-10-03 22:29:02,325 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Holdings"] as column [name2_0_0_]
2014-10-03 22:29:02,325 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=rule!SO_CA_HoldingsDetails_Dashboard()] as column [ui3_0_0_]
2014-10-03 22:29:02,325 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_u-0Pzg] as column [url4_0_0_]
2014-10-03 22:29:02,326 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,326 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,327 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [100] as column [id1_]
2014-10-03 22:29:02,328 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [3] as column [order7_1_]
2014-10-03 22:29:02,328 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [101] as column [id0_0_]
2014-10-03 22:29:02,329 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Updates"] as column [name2_0_0_]
2014-10-03 22:29:02,329 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=rule!SO_CA_Updates_Dashboard()] as column [ui3_0_0_]
2014-10-03 22:29:02,329 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_d7IuWQ] as column [url4_0_0_]
2014-10-03 22:29:02,330 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,330 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,331 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [101] as column [id1_]
2014-10-03 22:29:02,331 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [4] as column [order7_1_]
2014-10-03 22:29:02,332 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [102] as column [id0_0_]
2014-10-03 22:29:02,332 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Security Ids"] as column [name2_0_0_]
2014-10-03 22:29:02,333 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=rule!SO_CA_SecurityIds_Dashboard()] as column [ui3_0_0_]
2014-10-03 22:29:02,333 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_K7Ikhw] as column [url4_0_0_]
2014-10-03 22:29:02,334 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,334 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,335 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [102] as column [id1_]
2014-10-03 22:29:02,335 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [5] as column [order7_1_]
2014-10-03 22:29:02,336 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [103] as column [id0_0_]
2014-10-03 22:29:02,336 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [="Unique Documentation"] as column [name2_0_0_]
2014-10-03 22:29:02,337 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=#"_a-0000d984-1fb8-8000-4594-010000010000_47334"()] as column [ui3_0_0_]
2014-10-03 22:29:02,338 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [_l1G41A] as column [url4_0_0_]
2014-10-03 22:29:02,338 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [=true()] as column [visibility5_0_0_]
2014-10-03 22:29:02,339 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [record6_10_1_]
2014-10-03 22:29:02,339 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [103] as column [id1_]
2014-10-03 22:29:02,340 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [6] as column [order7_1_]
2014-10-03 22:29:02,458 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select count(distinct this_.[cadetailsid]) as y0_ from [socaeventdetails] this_ where this_.[cadetailsid]=?
2014-10-03 22:29:02,460 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 15941
2014-10-03 22:29:02,461 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1] as column [y0_]
2014-10-03 22:29:02,465 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select top 1 this_.[caeventid] as y0_, this_.[cadetailsid] as y1_, this_.[actiontypedescription] as y2_, this_.[electiontypedescription] as y3_, this_.[currentstatus] as y4_, this_.[newsecurityid] as y5_, this_.[securityid] as y6_, this_.[receiveddate] as y7_, this_.[responserequireddate] as y8_, this_.[custodianelectiondate] as y9_, this_.[estimatedprocessingdate] as y10_, this_.[expirationdate] as y11_, this_.[effectivedate] as y12_, this_.[exdate] as y13_, this_.[recorddate] as y14_, this_.[is144a] as y15_, this_.[legalrestrictions] as y16_, this_.[uniquedocumentationrequired] as y17_, this_.[blockshares] as y18_, this_.[istaxable] as y19_, this_.[fxtraderequired] as y20_, this_.[numberfundaccounts] as y21_, this_.[numberportfolioaccounts] as y22_, this_.[securityname] as y23_ from [socaeventdetails] this_ where this_.[cadetailsid]=? order by y10_ asc
2014-10-03 22:29:02,466 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 15941
2014-10-03 22:29:02,467 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [JTRAC224] as column [y0_]
2014-10-03 22:29:02,467 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [y1_]
2014-10-03 22:29:02,468 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Conversion - Voluntary] as column [y2_]
2014-10-03 22:29:02,468 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Voluntary] as column [y3_]
2014-10-03 22:29:02,469 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Election - PM and Analyst] as column [y4_]
2014-10-03 22:29:02,469 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [y5_]
2014-10-03 22:29:02,470 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [989701BC0] as column [y6_]
2014-10-03 22:29:02,470 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [y15_]
2014-10-03 22:29:02,471 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [y16_]
2014-10-03 22:29:02,471 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [y17_]
2014-10-03 22:29:02,472 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [y18_]
2014-10-03 22:29:02,472 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [y19_]
2014-10-03 22:29:02,472 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [y20_]
2014-10-03 22:29:02,473 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [2] as column [y21_]
2014-10-03 22:29:02,473 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [5] as column [y22_]
2014-10-03 22:29:02,474 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [ZIONS BANCORP|4|06/20/2016] as column [y23_]
2014-10-03 22:29:02,533 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select count(distinct this_.[cadetailsid]) as y0_ from [socaeventdetails] this_ where this_.[cadetailsid]=?
2014-10-03 22:29:02,535 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 15941
2014-10-03 22:29:02,536 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1] as column [y0_]
2014-10-03 22:29:02,538 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select top 1 this_.[isprocessingcomplete] as y0_, this_.[securityid] as y1_, this_.[securityname] as y2_, this_.[caeventid] as y3_, this_.[actiontypedescription] as y4_, this_.[electiontypedescription] as y5_, this_.[receiveddate] as y6_, this_.[estimatedprocessingdate] as y7_, this_.[currentstatus] as y8_, this_.[cadetailsid] as y9_ from [socaeventdetails] this_ where this_.[cadetailsid]=? order by y7_ asc
2014-10-03 22:29:02,539 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 15941
2014-10-03 22:29:02,540 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [y0_]
2014-10-03 22:29:02,541 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [989701BC0] as column [y1_]
2014-10-03 22:29:02,541 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [ZIONS BANCORP|4|06/20/2016] as column [y2_]
2014-10-03 22:29:02,542 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [JTRAC224] as column [y3_]
2014-10-03 22:29:02,542 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Conversion - Voluntary] as column [y4_]
2014-10-03 22:29:02,543 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Voluntary] as column [y5_]
2014-10-03 22:29:02,543 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Election - PM and Analyst] as column [y8_]
2014-10-03 22:29:02,544 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [y9_]
2014-10-03 22:29:02,575 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select this_.id as id23_0_, this_.scs_key_h as scs2_23_0_, this_.scs_key_salt as scs3_23_0_, this_.username as username23_0_ from usr this_ where (this_.username in (?))
2014-10-03 22:29:02,576 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - jm28286
2014-10-03 22:29:02,577 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [259] as column [id23_0_]
2014-10-03 22:29:02,578 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Sc8+0zU+mmf7rn5ytnUeoVTyEk4=] as column [scs2_23_0_]
2014-10-03 22:29:02,579 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [scs3_23_0_]
2014-10-03 22:29:02,579 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [jm28286] as column [username23_0_]
2014-10-03 22:29:02,582 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select user0_.id as id23_, user0_.scs_key_h as scs2_23_, user0_.scs_key_salt as scs3_23_, user0_.username as username23_ from usr user0_ where user0_.username=?
2014-10-03 22:29:02,583 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - jm28286
2014-10-03 22:29:02,584 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [259] as column [id23_]
2014-10-03 22:29:02,585 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Sc8+0zU+mmf7rn5ytnUeoVTyEk4=] as column [scs2_23_]
2014-10-03 22:29:02,585 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [scs3_23_]
2014-10-03 22:29:02,586 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [jm28286] as column [username23_]
2014-10-03 22:29:02,587 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select count(*) as y0_ from tp_feed_entry this_ where this_.recipient=? and this_.type=? and this_.closed_ts is null
2014-10-03 22:29:02,588 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [BIGINT] - 259
2014-10-03 22:29:02,588 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TINYINT] - 9
2014-10-03 22:29:02,589 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0] as column [y0_]
2014-10-03 22:29:02,603 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select count(distinct this_.[cadetailsid]) as y0_ from [socaeventdetails] this_ where this_.[cadetailsid]=?
2014-10-03 22:29:02,604 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 15941
2014-10-03 22:29:02,605 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1] as column [y0_]
2014-10-03 22:29:02,608 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select top 1 this_.[cadetailsid] as y0_, this_.[estimatedprocessingdate] as y1_ from [socaeventdetails] this_ where this_.[cadetailsid]=? order by y1_ asc
2014-10-03 22:29:02,608 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 15941
2014-10-03 22:29:02,609 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [y0_]
2014-10-03 22:29:02,798 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select this_.id as id23_0_, this_.scs_key_h as scs2_23_0_, this_.scs_key_salt as scs3_23_0_, this_.username as username23_0_ from usr this_ where (this_.username in (?))
2014-10-03 22:29:02,800 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - jm28286
2014-10-03 22:29:02,801 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [259] as column [id23_0_]
2014-10-03 22:29:02,802 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Sc8+0zU+mmf7rn5ytnUeoVTyEk4=] as column [scs2_23_0_]
2014-10-03 22:29:02,802 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [scs3_23_0_]
2014-10-03 22:29:02,803 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [jm28286] as column [username23_0_]
2014-10-03 22:29:02,805 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select user0_.id as id23_, user0_.scs_key_h as scs2_23_, user0_.scs_key_salt as scs3_23_, user0_.username as username23_ from usr user0_ where user0_.username=?
2014-10-03 22:29:02,806 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - jm28286
2014-10-03 22:29:02,808 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [259] as column [id23_]
2014-10-03 22:29:02,808 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Sc8+0zU+mmf7rn5ytnUeoVTyEk4=] as column [scs2_23_]
2014-10-03 22:29:02,808 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [scs3_23_]
2014-10-03 22:29:02,809 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [jm28286] as column [username23_]
2014-10-03 22:29:02,810 [ajp-/0.0.0.0:8009-8] DEBUG org.hibernate.SQL - select count(*) as y0_ from tp_feed_entry this_ where this_.recipient=? and this_.type=? and this_.closed_ts is null
2014-10-03 22:29:02,811 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [BIGINT] - 259
2014-10-03 22:29:02,812 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TINYINT] - 9
2014-10-03 22:29:02,813 [ajp-/0.0.0.0:8009-8] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [0] as column [y0_]
2014-10-03 22:29:03,365 [default-threads - 29] DEBUG org.hibernate.SQL - select socasuspen0_.[suspendid] as suspendid1_160_0_, socasuspen0_.[cadetailsid] as cadetail2_160_0_, socasuspen0_.[suspendedprocessid] as suspende3_160_0_, socasuspen0_.[suspenddescription] as suspendd4_160_0_, socasuspen0_.[suspendedby] as suspende5_160_0_, socasuspen0_.[suspendeddatetime] as suspende6_160_0_, socasuspen0_.[resumedate] as resumedate7_160_0_, socasuspen0_.[isactive] as isactive8_160_0_ from [socasuspendedtasks] socasuspen0_ where socasuspen0_.[suspendid]=?
2014-10-03 22:29:03,365 [default-threads - 21] DEBUG org.hibernate.SQL - select socasuspen0_.[suspendid] as suspendid1_160_0_, socasuspen0_.[cadetailsid] as cadetail2_160_0_, socasuspen0_.[suspendedprocessid] as suspende3_160_0_, socasuspen0_.[suspenddescription] as suspendd4_160_0_, socasuspen0_.[suspendedby] as suspende5_160_0_, socasuspen0_.[suspendeddatetime] as suspende6_160_0_, socasuspen0_.[resumedate] as resumedate7_160_0_, socasuspen0_.[isactive] as isactive8_160_0_ from [socasuspendedtasks] socasuspen0_ where socasuspen0_.[suspendid]=?
2014-10-03 22:29:03,367 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 120
2014-10-03 22:29:03,368 [default-threads - 21] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 120
2014-10-03 22:29:03,369 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_160_0_]
2014-10-03 22:29:03,369 [default-threads - 21] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_160_0_]
2014-10-03 22:29:03,369 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [536938369] as column [suspende3_160_0_]
2014-10-03 22:29:03,370 [default-threads - 21] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [536938369] as column [suspende3_160_0_]
2014-10-03 22:29:03,370 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Unique Documentation Required Supervisor Suspend] as column [suspendd4_160_0_]
2014-10-03 22:29:03,371 [default-threads - 21] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Unique Documentation Required Supervisor Suspend] as column [suspendd4_160_0_]
2014-10-03 22:29:03,371 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Leslie Craft] as column [suspende5_160_0_]
2014-10-03 22:29:03,372 [default-threads - 21] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Leslie Craft] as column [suspende5_160_0_]
2014-10-03 22:29:03,372 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [isactive8_160_0_]
2014-10-03 22:29:03,373 [default-threads - 21] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [isactive8_160_0_]
2014-10-03 22:29:03,374 [default-threads - 29] DEBUG org.hibernate.SQL - delete from [socasuspendedtasks] where [suspendid]=?
2014-10-03 22:29:03,374 [default-threads - 21] DEBUG org.hibernate.SQL - delete from [socasuspendedtasks] where [suspendid]=?
2014-10-03 22:29:03,375 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 120
2014-10-03 22:29:03,375 [default-threads - 21] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 120
2014-10-03 22:29:03,376 [default-threads - 29] DEBUG org.hibernate.SQL - select socasuspen0_.[suspendid] as suspendid1_160_0_, socasuspen0_.[cadetailsid] as cadetail2_160_0_, socasuspen0_.[suspendedprocessid] as suspende3_160_0_, socasuspen0_.[suspenddescription] as suspendd4_160_0_, socasuspen0_.[suspendedby] as suspende5_160_0_, socasuspen0_.[suspendeddatetime] as suspende6_160_0_, socasuspen0_.[resumedate] as resumedate7_160_0_, socasuspen0_.[isactive] as isactive8_160_0_ from [socasuspendedtasks] socasuspen0_ where socasuspen0_.[suspendid]=?
2014-10-03 22:29:03,377 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 121
2014-10-03 22:29:03,378 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_160_0_]
2014-10-03 22:29:03,379 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [536938372] as column [suspende3_160_0_]
2014-10-03 22:29:03,379 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Block Shares in CRD Suspend] as column [suspendd4_160_0_]
2014-10-03 22:29:03,380 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Leslie Craft] as column [suspende5_160_0_]
2014-10-03 22:29:03,380 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [isactive8_160_0_]
2014-10-03 22:29:03,382 [default-threads - 29] DEBUG org.hibernate.SQL - delete from [socasuspendedtasks] where [suspendid]=?
2014-10-03 22:29:03,382 [default-threads - 29] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 121
2014-10-03 22:29:03,395 [default-threads - 21] DEBUG org.hibernate.SQL - select socasuspen0_.[suspendid] as suspendid1_160_0_, socasuspen0_.[cadetailsid] as cadetail2_160_0_, socasuspen0_.[suspendedprocessid] as suspende3_160_0_, socasuspen0_.[suspenddescription] as suspendd4_160_0_, socasuspen0_.[suspendedby] as suspende5_160_0_, socasuspen0_.[suspendeddatetime] as suspende6_160_0_, socasuspen0_.[resumedate] as resumedate7_160_0_, socasuspen0_.[isactive] as isactive8_160_0_ from [socasuspendedtasks] socasuspen0_ where socasuspen0_.[suspendid]=?
2014-10-03 22:29:03,401 [default-threads - 21] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 121
2014-10-03 22:29:03,403 [default-threads - 21] DEBUG org.hibernate.SQL - delete from [socasuspendedtasks] where [suspendid]=?
2014-10-03 22:29:03,404 [default-threads - 21] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 120
2014-10-03 22:29:03,406 [default-threads - 21] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=268443217, classname=com.appiancorp.process.runtime.activities.DeleteFromDataStoreSmartService
com.appiancorp.suiteapi.process.exceptions.SmartServiceException: An error occurred while trying to delete data. No data was deleted. Details: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1.
	at com.appiancorp.process.runtime.activities.DeleteFromDataStoreSmartService.run(DeleteFromDataStoreSmartService.java:104)
	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:101)
	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:98)
	at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:25)
	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor.execute(DefaultActivityExecutor.java:98)
	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute(UnattendedJavaActivityRequest.java:83)
	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute0(UnattendedJavaActivityRequest.java:55)
	at com.appiancorp.process.engine.ContinuationRequest.execute(ContinuationRequest.java:80)
	at com.appiancorp.mdb.UnattendedRequestHandlerBean.onMessage(UnattendedRequestHandlerBean.java:17)
	at sun.reflect.GeneratedMethodAccessor625.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
	at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
	at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:104)
	at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:56)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
	at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.as.ejb3.component.messagedriven.MessageDrivenComponentDescription$5$1.processInvocation(MessageDrivenComponentDescription.java:203)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
	at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)
	at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
	at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)
	at com.appiancorp.ra.workpoller.UnattendedRequestListener$$$view2.onMessage(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor622.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.doInvoke(MessageEndpointInvocationHandler.java:140)
	at org.jboss.as.ejb3.inflow.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:73)
	at com.sun.proxy.$Proxy417.onMessage(Unknown Source)
	at com.appiancorp.ra.workpoller.WorkItem.run(WorkItem.java:41)
	at org.jboss.jca.core.workmanager.WorkWrapper.run(WorkWrapper.java:218)
	at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
	at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:808)
	at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
	at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:849)
	at java.lang.Thread.run(Thread.java:745)
	at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
	at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:85)
	at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:70)
	at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:47)
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2707)
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2911)
	at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:189)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
	at com.appiancorp.type.external.teneoimpl.TeneoDataStore.commitTransaction(TeneoDataStore.java:259)
	at com.appiancorp.type.external.teneoimpl.TeneoDataStore.delete(TeneoDataStore.java:611)
	at com.appiancorp.process.runtime.activities.DeleteFromDataStoreSmartService.run(DeleteFromDataStoreSmartService.java:96)
	... 66 more
2014-10-03 22:29:05,536 [default-threads - 20] DEBUG org.hibernate.SQL - select this_.[uniquedocid] as uniquedo1_171_0_, this_.[cadetailsid] as cadetail2_171_0_, this_.[caeventid] as caeventid3_171_0_, this_.[wheretosend] as wheretos4_171_0_, this_.[wheretosendaddldetails] as wheretos5_171_0_, this_.[finaldeadlinedate] as finaldea6_171_0_, this_.[completeddate] as complete7_171_0_, this_.[completedby] as complete8_171_0_, this_.[nextescalationdate] as nextesca9_171_0_, this_.[securityname] as securit10_171_0_, this_.[iscomplete] as iscomplete11_171_0_ from [socauniquedocumentation] this_ where this_.[cadetailsid]=?
2014-10-03 22:29:05,538 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 15941
2014-10-03 22:29:05,539 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [30] as column [uniquedo1_171_0_]
2014-10-03 22:29:05,539 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_171_0_]
2014-10-03 22:29:05,540 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [JTRAC224] as column [caeventid3_171_0_]
2014-10-03 22:29:05,540 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Other] as column [wheretos4_171_0_]
2014-10-03 22:29:05,540 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Other] as column [wheretos5_171_0_]
2014-10-03 22:29:05,541 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Leslie Craft] as column [complete8_171_0_]
2014-10-03 22:29:05,541 [default-threads - 24] DEBUG org.hibernate.SQL - select this_.[avid] as avid1_180_0_, this_.[attributename] as attribut2_180_0_, this_.[attributeoption1] as attribut3_180_0_, this_.[attributeoption2] as attribut4_180_0_, this_.[attributeoption3] as attribut5_180_0_, this_.[isactive] as isactive6_180_0_, this_.[lastupdatedby] as lastupda7_180_0_, this_.[lastupdateddatetime] as lastupda8_180_0_ from [socaattributevalues] this_ where (this_.[attributename]=? and this_.[attributeoption1]=? and this_.[isactive]=?) order by this_.[attributeoption2] asc
2014-10-03 22:29:05,542 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [ZIONS BANCORP|4|06/20/2016] as column [securit10_171_0_]
2014-10-03 22:29:05,543 [default-threads - 24] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - blocked_shares_comment
2014-10-03 22:29:05,543 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [iscomplete11_171_0_]
2014-10-03 22:29:05,543 [default-threads - 24] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - CVV
2014-10-03 22:29:05,544 [default-threads - 24] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [BIT] - true
2014-10-03 22:29:05,575 [default-threads - 20] DEBUG org.hibernate.SQL - select this_.[caholdingid] as caholdin1_163_0_, this_.[cadetailsid] as cadetail2_163_0_, this_.[securityid] as securityid3_163_0_, this_.[accountcode] as accountc4_163_0_, this_.[accountdescription] as accountd5_163_0_, this_.[accounttype] as accountt6_163_0_, this_.[sma] as sma7_163_0_, this_.[sensitiveaccount] as sensitiv8_163_0_, this_.[manager] as manager9_163_0_, this_.[custodianname] as custodi10_163_0_, this_.[custodianaccountnumber] as custodi11_163_0_, this_.[initialasofdate] as initial12_163_0_, this_.[initialshares] as initial13_163_0_, this_.[initialsharestext] as initial14_163_0_, this_.[initialbookvalue] as initial15_163_0_, this_.[initialbookvaluetext] as initial16_163_0_, this_.[currentasofdate] as current17_163_0_, this_.[currentshares] as current18_163_0_, this_.[currentsharestext] as current19_163_0_, this_.[currentbookvalue] as current20_163_0_, this_.[currentbookvaluetext] as current21_163_0_, this_.[retrieveddatetime] as retriev22_163_0_, this_.[pmresponse] as pmresponse23_163_0_, this_.[pmresponseby] as pmrespo24_163_0_, this_.[pmresponsedatetime] as pmrespo25_163_0_, this_.[electionstatus] as electio26_163_0_, this_.[electedby] as electedby27_163_0_, this_.[electeddatetime] as elected28_163_0_, this_.[confirmationstatus] as confirm29_163_0_, this_.[confirmedby] as confirm30_163_0_, this_.[confirmeddatetime] as confirm31_163_0_, this_.[sentforqc] as sentforqc32_163_0_, this_.[qcdby] as qcdby33_163_0_, this_.[qcddatetime] as qcddate34_163_0_, this_.[isactive] as isactive35_163_0_, this_.[lastupdatedby] as lastupd36_163_0_, this_.[wasaddedwithupdate] as wasadde37_163_0_, this_.[haveshareschanged] as havesha38_163_0_, this_.[isqib] as isqib39_163_0_, this_.[wheredomiciled] as wheredo40_163_0_, this_.[returntopm] as returntopm41_163_0_, this_.[securityname] as securit42_163_0_ from [socaholdingsbysecurity] this_ where this_.[cadetailsid]=? order by this_.[accountcode] asc
2014-10-03 22:29:05,578 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 15941
2014-10-03 22:29:05,597 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [71299] as column [caholdin1_163_0_]
2014-10-03 22:29:05,598 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_163_0_]
2014-10-03 22:29:05,598 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [989701BC0] as column [securityid3_163_0_]
2014-10-03 22:29:05,599 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [11] as column [accountc4_163_0_]
2014-10-03 22:29:05,599 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Janus Short-Term Bond Fund] as column [accountd5_163_0_]
2014-10-03 22:29:05,600 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [FUND_TYPE] as column [accountt6_163_0_]
2014-10-03 22:29:05,600 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sma7_163_0_]
2014-10-03 22:29:05,600 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sensitiv8_163_0_]
2014-10-03 22:29:05,601 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Gibson Smith/Darrell Watters] as column [manager9_163_0_]
2014-10-03 22:29:05,601 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [State Street Bank-Janus Funds] as column [custodi10_163_0_]
2014-10-03 22:29:05,602 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [NB09] as column [custodi11_163_0_]
2014-10-03 22:29:05,603 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1465000.0] as column [initial13_163_0_]
2014-10-03 22:29:05,603 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1,465,000] as column [initial14_163_0_]
2014-10-03 22:29:05,604 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1475025.09] as column [initial15_163_0_]
2014-10-03 22:29:05,604 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1,475,025.09] as column [initial16_163_0_]
2014-10-03 22:29:05,605 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1465000.0] as column [current18_163_0_]
2014-10-03 22:29:05,605 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1,465,000] as column [current19_163_0_]
2014-10-03 22:29:05,606 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1475025.09] as column [current20_163_0_]
2014-10-03 22:29:05,606 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [1,475,025.09] as column [current21_163_0_]
2014-10-03 22:29:05,607 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmresponse23_163_0_]
2014-10-03 22:29:05,607 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmrespo24_163_0_]
2014-10-03 22:29:05,607 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electio26_163_0_]
2014-10-03 22:29:05,608 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electedby27_163_0_]
2014-10-03 22:29:05,608 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm29_163_0_]
2014-10-03 22:29:05,609 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm30_163_0_]
2014-10-03 22:29:05,609 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sentforqc32_163_0_]
2014-10-03 22:29:05,610 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [qcdby33_163_0_]
2014-10-03 22:29:05,611 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [isactive35_163_0_]
2014-10-03 22:29:05,611 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [System] as column [lastupd36_163_0_]
2014-10-03 22:29:05,611 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [wasadde37_163_0_]
2014-10-03 22:29:05,612 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [havesha38_163_0_]
2014-10-03 22:29:05,612 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [isqib39_163_0_]
2014-10-03 22:29:05,613 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [wheredo40_163_0_]
2014-10-03 22:29:05,613 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [returntopm41_163_0_]
2014-10-03 22:29:05,614 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [ZIONS BANCORP|4|06/20/2016] as column [securit42_163_0_]
2014-10-03 22:29:05,614 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [71293] as column [caholdin1_163_0_]
2014-10-03 22:29:05,615 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_163_0_]
2014-10-03 22:29:05,615 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [989701BC0] as column [securityid3_163_0_]
2014-10-03 22:29:05,616 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [137] as column [accountc4_163_0_]
2014-10-03 22:29:05,616 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Janus Real Return Fund] as column [accountd5_163_0_]
2014-10-03 22:29:05,617 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [FUND_TYPE] as column [accountt6_163_0_]
2014-10-03 22:29:05,617 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sma7_163_0_]
2014-10-03 22:29:05,618 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sensitiv8_163_0_]
2014-10-03 22:29:05,618 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Gibson Smith/Darrell Watters/Mayur Saigal] as column [manager9_163_0_]
2014-10-03 22:29:05,619 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [State Street Bank-Janus Funds] as column [custodi10_163_0_]
2014-10-03 22:29:05,619 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [JC5C] as column [custodi11_163_0_]
2014-10-03 22:29:05,620 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [179000.0] as column [initial13_163_0_]
2014-10-03 22:29:05,620 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [179,000] as column [initial14_163_0_]
2014-10-03 22:29:05,620 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [186522.82] as column [initial15_163_0_]
2014-10-03 22:29:05,621 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [186,522.82] as column [initial16_163_0_]
2014-10-03 22:29:05,622 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [179000.0] as column [current18_163_0_]
2014-10-03 22:29:05,622 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [179,000] as column [current19_163_0_]
2014-10-03 22:29:05,622 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [186522.82] as column [current20_163_0_]
2014-10-03 22:29:05,623 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [186,522.82] as column [current21_163_0_]
2014-10-03 22:29:05,623 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmresponse23_163_0_]
2014-10-03 22:29:05,624 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmrespo24_163_0_]
2014-10-03 22:29:05,624 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electio26_163_0_]
2014-10-03 22:29:05,625 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electedby27_163_0_]
2014-10-03 22:29:05,626 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm29_163_0_]
2014-10-03 22:29:05,626 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm30_163_0_]
2014-10-03 22:29:05,627 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sentforqc32_163_0_]
2014-10-03 22:29:05,627 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [qcdby33_163_0_]
2014-10-03 22:29:05,627 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [isactive35_163_0_]
2014-10-03 22:29:05,628 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [System] as column [lastupd36_163_0_]
2014-10-03 22:29:05,628 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [wasadde37_163_0_]
2014-10-03 22:29:05,629 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [havesha38_163_0_]
2014-10-03 22:29:05,629 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [isqib39_163_0_]
2014-10-03 22:29:05,630 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [wheredo40_163_0_]
2014-10-03 22:29:05,630 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [returntopm41_163_0_]
2014-10-03 22:29:05,630 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [ZIONS BANCORP|4|06/20/2016] as column [securit42_163_0_]
2014-10-03 22:29:05,631 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [71294] as column [caholdin1_163_0_]
2014-10-03 22:29:05,631 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_163_0_]
2014-10-03 22:29:05,632 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [989701BC0] as column [securityid3_163_0_]
2014-10-03 22:29:05,633 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [85] as column [accountc4_163_0_]
2014-10-03 22:29:05,633 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Janus US Short-Term Bond Fund] as column [accountd5_163_0_]
2014-10-03 22:29:05,634 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [PORTFOLIO_TYPE] as column [accountt6_163_0_]
2014-10-03 22:29:05,634 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sma7_163_0_]
2014-10-03 22:29:05,635 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sensitiv8_163_0_]
2014-10-03 22:29:05,635 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Gibson Smith/Darrell Watters] as column [manager9_163_0_]
2014-10-03 22:29:05,636 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Citibank] as column [custodi10_163_0_]
2014-10-03 22:29:05,636 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [613427501] as column [custodi11_163_0_]
2014-10-03 22:29:05,636 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [304000.0] as column [initial13_163_0_]
2014-10-03 22:29:05,637 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [304,000] as column [initial14_163_0_]
2014-10-03 22:29:05,638 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [308274.4] as column [initial15_163_0_]
2014-10-03 22:29:05,638 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [308,274.40] as column [initial16_163_0_]
2014-10-03 22:29:05,639 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [304000.0] as column [current18_163_0_]
2014-10-03 22:29:05,639 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [304,000] as column [current19_163_0_]
2014-10-03 22:29:05,640 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [308274.4] as column [current20_163_0_]
2014-10-03 22:29:05,640 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [308,274.40] as column [current21_163_0_]
2014-10-03 22:29:05,641 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmresponse23_163_0_]
2014-10-03 22:29:05,642 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmrespo24_163_0_]
2014-10-03 22:29:05,642 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electio26_163_0_]
2014-10-03 22:29:05,642 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electedby27_163_0_]
2014-10-03 22:29:05,643 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm29_163_0_]
2014-10-03 22:29:05,643 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm30_163_0_]
2014-10-03 22:29:05,644 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sentforqc32_163_0_]
2014-10-03 22:29:05,644 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [qcdby33_163_0_]
2014-10-03 22:29:05,645 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [isactive35_163_0_]
2014-10-03 22:29:05,645 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [System] as column [lastupd36_163_0_]
2014-10-03 22:29:05,646 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [wasadde37_163_0_]
2014-10-03 22:29:05,646 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [havesha38_163_0_]
2014-10-03 22:29:05,647 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [isqib39_163_0_]
2014-10-03 22:29:05,647 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [wheredo40_163_0_]
2014-10-03 22:29:05,647 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [returntopm41_163_0_]
2014-10-03 22:29:05,648 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [ZIONS BANCORP|4|06/20/2016] as column [securit42_163_0_]
2014-10-03 22:29:05,648 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [71297] as column [caholdin1_163_0_]
2014-10-03 22:29:05,649 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_163_0_]
2014-10-03 22:29:05,649 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [989701BC0] as column [securityid3_163_0_]
2014-10-03 22:29:05,650 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [AMU100] as column [accountc4_163_0_]
2014-10-03 22:29:05,650 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [American University] as column [accountd5_163_0_]
2014-10-03 22:29:05,651 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [PORTFOLIO_TYPE] as column [accountt6_163_0_]
2014-10-03 22:29:05,651 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sma7_163_0_]
2014-10-03 22:29:05,652 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sensitiv8_163_0_]
2014-10-03 22:29:05,652 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Gibson Smith/Darrell Watters] as column [manager9_163_0_]
2014-10-03 22:29:05,653 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Mellon Bank] as column [custodi10_163_0_]
2014-10-03 22:29:05,653 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [A81F70010002] as column [custodi11_163_0_]
2014-10-03 22:29:05,654 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [360000.0] as column [initial13_163_0_]
2014-10-03 22:29:05,654 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [360,000] as column [initial14_163_0_]
2014-10-03 22:29:05,655 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [374205.62] as column [initial15_163_0_]
2014-10-03 22:29:05,655 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [374,205.62] as column [initial16_163_0_]
2014-10-03 22:29:05,656 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [360000.0] as column [current18_163_0_]
2014-10-03 22:29:05,656 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [360,000] as column [current19_163_0_]
2014-10-03 22:29:05,657 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [374205.62] as column [current20_163_0_]
2014-10-03 22:29:05,657 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [374,205.62] as column [current21_163_0_]
2014-10-03 22:29:05,658 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmresponse23_163_0_]
2014-10-03 22:29:05,658 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmrespo24_163_0_]
2014-10-03 22:29:05,659 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electio26_163_0_]
2014-10-03 22:29:05,659 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electedby27_163_0_]
2014-10-03 22:29:05,660 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm29_163_0_]
2014-10-03 22:29:05,660 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm30_163_0_]
2014-10-03 22:29:05,661 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sentforqc32_163_0_]
2014-10-03 22:29:05,661 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [qcdby33_163_0_]
2014-10-03 22:29:05,662 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [isactive35_163_0_]
2014-10-03 22:29:05,662 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [System] as column [lastupd36_163_0_]
2014-10-03 22:29:05,663 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [wasadde37_163_0_]
2014-10-03 22:29:05,663 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [havesha38_163_0_]
2014-10-03 22:29:05,663 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [isqib39_163_0_]
2014-10-03 22:29:05,664 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [wheredo40_163_0_]
2014-10-03 22:29:05,664 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [returntopm41_163_0_]
2014-10-03 22:29:05,665 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [ZIONS BANCORP|4|06/20/2016] as column [securit42_163_0_]
2014-10-03 22:29:05,665 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [71296] as column [caholdin1_163_0_]
2014-10-03 22:29:05,666 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_163_0_]
2014-10-03 22:29:05,666 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [989701BC0] as column [securityid3_163_0_]
2014-10-03 22:29:05,667 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [DPA100] as column [accountc4_163_0_]
2014-10-03 22:29:05,667 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [California Savings Plus Progra] as column [accountd5_163_0_]
2014-10-03 22:29:05,667 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [PORTFOLIO_TYPE] as column [accountt6_163_0_]
2014-10-03 22:29:05,668 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sma7_163_0_]
2014-10-03 22:29:05,668 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sensitiv8_163_0_]
2014-10-03 22:29:05,669 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Gibson Smith/Darrell Watters] as column [manager9_163_0_]
2014-10-03 22:29:05,670 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [JP Morgan] as column [custodi10_163_0_]
2014-10-03 22:29:05,670 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [P31577] as column [custodi11_163_0_]
2014-10-03 22:29:05,670 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [3901000.0] as column [initial13_163_0_]
2014-10-03 22:29:05,671 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [3,901,000] as column [initial14_163_0_]
2014-10-03 22:29:05,672 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [4052055.77] as column [initial15_163_0_]
2014-10-03 22:29:05,672 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [4,052,055.77] as column [initial16_163_0_]
2014-10-03 22:29:05,672 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [3901000.0] as column [current18_163_0_]
2014-10-03 22:29:05,673 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [3,901,000] as column [current19_163_0_]
2014-10-03 22:29:05,674 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [4052055.77] as column [current20_163_0_]
2014-10-03 22:29:05,674 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [4,052,055.77] as column [current21_163_0_]
2014-10-03 22:29:05,675 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmresponse23_163_0_]
2014-10-03 22:29:05,675 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmrespo24_163_0_]
2014-10-03 22:29:05,675 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electio26_163_0_]
2014-10-03 22:29:05,676 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electedby27_163_0_]
2014-10-03 22:29:05,676 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm29_163_0_]
2014-10-03 22:29:05,677 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm30_163_0_]
2014-10-03 22:29:05,677 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sentforqc32_163_0_]
2014-10-03 22:29:05,678 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [qcdby33_163_0_]
2014-10-03 22:29:05,678 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [isactive35_163_0_]
2014-10-03 22:29:05,679 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [System] as column [lastupd36_163_0_]
2014-10-03 22:29:05,679 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [wasadde37_163_0_]
2014-10-03 22:29:05,680 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [havesha38_163_0_]
2014-10-03 22:29:05,680 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [isqib39_163_0_]
2014-10-03 22:29:05,681 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [wheredo40_163_0_]
2014-10-03 22:29:05,681 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [returntopm41_163_0_]
2014-10-03 22:29:05,682 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [ZIONS BANCORP|4|06/20/2016] as column [securit42_163_0_]
2014-10-03 22:29:05,682 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [71298] as column [caholdin1_163_0_]
2014-10-03 22:29:05,682 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_163_0_]
2014-10-03 22:29:05,683 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [989701BC0] as column [securityid3_163_0_]
2014-10-03 22:29:05,683 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [EVE100] as column [accountc4_163_0_]
2014-10-03 22:29:05,684 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Everest Reinsurance Company] as column [accountd5_163_0_]
2014-10-03 22:29:05,684 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [PORTFOLIO_TYPE] as column [accountt6_163_0_]
2014-10-03 22:29:05,685 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sma7_163_0_]
2014-10-03 22:29:05,685 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sensitiv8_163_0_]
2014-10-03 22:29:05,686 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Gibson Smith/Darrell Watters] as column [manager9_163_0_]
2014-10-03 22:29:05,686 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [State Street Bank] as column [custodi10_163_0_]
2014-10-03 22:29:05,687 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [EVRG] as column [custodi11_163_0_]
2014-10-03 22:29:05,687 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [829000.0] as column [initial13_163_0_]
2014-10-03 22:29:05,688 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [829,000] as column [initial14_163_0_]
2014-10-03 22:29:05,688 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [834027.14] as column [initial15_163_0_]
2014-10-03 22:29:05,688 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [834,027.14] as column [initial16_163_0_]
2014-10-03 22:29:05,689 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [829000.0] as column [current18_163_0_]
2014-10-03 22:29:05,689 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [829,000] as column [current19_163_0_]
2014-10-03 22:29:05,690 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [834027.14] as column [current20_163_0_]
2014-10-03 22:29:05,690 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [834,027.14] as column [current21_163_0_]
2014-10-03 22:29:05,691 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmresponse23_163_0_]
2014-10-03 22:29:05,691 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmrespo24_163_0_]
2014-10-03 22:29:05,692 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electio26_163_0_]
2014-10-03 22:29:05,692 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electedby27_163_0_]
2014-10-03 22:29:05,692 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm29_163_0_]
2014-10-03 22:29:05,693 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm30_163_0_]
2014-10-03 22:29:05,693 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sentforqc32_163_0_]
2014-10-03 22:29:05,694 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [qcdby33_163_0_]
2014-10-03 22:29:05,694 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [isactive35_163_0_]
2014-10-03 22:29:05,695 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [System] as column [lastupd36_163_0_]
2014-10-03 22:29:05,695 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [wasadde37_163_0_]
2014-10-03 22:29:05,696 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [havesha38_163_0_]
2014-10-03 22:29:05,696 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [isqib39_163_0_]
2014-10-03 22:29:05,697 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [wheredo40_163_0_]
2014-10-03 22:29:05,697 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [returntopm41_163_0_]
2014-10-03 22:29:05,698 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [ZIONS BANCORP|4|06/20/2016] as column [securit42_163_0_]
2014-10-03 22:29:05,698 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [71295] as column [caholdin1_163_0_]
2014-10-03 22:29:05,699 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [15941] as column [cadetail2_163_0_]
2014-10-03 22:29:05,699 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [989701BC0] as column [securityid3_163_0_]
2014-10-03 22:29:05,700 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [WLP100] as column [accountc4_163_0_]
2014-10-03 22:29:05,700 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [WellPoint Inc] as column [accountd5_163_0_]
2014-10-03 22:29:05,701 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [PORTFOLIO_TYPE] as column [accountt6_163_0_]
2014-10-03 22:29:05,701 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sma7_163_0_]
2014-10-03 22:29:05,702 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sensitiv8_163_0_]
2014-10-03 22:29:05,702 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Gibson Smith/Darrell Watters] as column [manager9_163_0_]
2014-10-03 22:29:05,702 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [Mellon Bank] as column [custodi10_163_0_]
2014-10-03 22:29:05,703 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [WHNF00023502] as column [custodi11_163_0_]
2014-10-03 22:29:05,704 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [355000.0] as column [initial13_163_0_]
2014-10-03 22:29:05,704 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [355,000] as column [initial14_163_0_]
2014-10-03 22:29:05,704 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [357152.76] as column [initial15_163_0_]
2014-10-03 22:29:05,705 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [357,152.76] as column [initial16_163_0_]
2014-10-03 22:29:05,705 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [355000.0] as column [current18_163_0_]
2014-10-03 22:29:05,706 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [355,000] as column [current19_163_0_]
2014-10-03 22:29:05,706 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [357152.76] as column [current20_163_0_]
2014-10-03 22:29:05,707 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [357,152.76] as column [current21_163_0_]
2014-10-03 22:29:05,707 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmresponse23_163_0_]
2014-10-03 22:29:05,708 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [pmrespo24_163_0_]
2014-10-03 22:29:05,708 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electio26_163_0_]
2014-10-03 22:29:05,709 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [electedby27_163_0_]
2014-10-03 22:29:05,709 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm29_163_0_]
2014-10-03 22:29:05,710 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [confirm30_163_0_]
2014-10-03 22:29:05,710 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [sentforqc32_163_0_]
2014-10-03 22:29:05,711 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [qcdby33_163_0_]
2014-10-03 22:29:05,711 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [true] as column [isactive35_163_0_]
2014-10-03 22:29:05,712 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [System] as column [lastupd36_163_0_]
2014-10-03 22:29:05,712 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [false] as column [wasadde37_163_0_]
2014-10-03 22:29:05,713 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [havesha38_163_0_]
2014-10-03 22:29:05,713 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [isqib39_163_0_]
2014-10-03 22:29:05,714 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [] as column [wheredo40_163_0_]
2014-10-03 22:29:05,714 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [null] as column [returntopm41_163_0_]
2014-10-03 22:29:05,715 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicExtractor - found [ZIONS BANCORP|4|06/20/2016] as column [securit42_163_0_]
2014-10-03 22:29:05,835 [default-threads - 20] DEBUG org.hibernate.SQL - select this_.[caholdingid] as caholdin1_163_0_, this_.[cadetailsid] as cadetail2_163_0_, this_.[securityid] as securityid3_163_0_, this_.[accountcode] as accountc4_163_0_, this_.[accountdescription] as accountd5_163_0_, this_.[accounttype] as accountt6_163_0_, this_.[sma] as sma7_163_0_, this_.[sensitiveaccount] as sensitiv8_163_0_, this_.[manager] as manager9_163_0_, this_.[custodianname] as custodi10_163_0_, this_.[custodianaccountnumber] as custodi11_163_0_, this_.[initialasofdate] as initial12_163_0_, this_.[initialshares] as initial13_163_0_, this_.[initialsharestext] as initial14_163_0_, this_.[initialbookvalue] as initial15_163_0_, this_.[initialbookvaluetext] as initial16_163_0_, this_.[currentasofdate] as current17_163_0_, this_.[currentshares] as current18_163_0_, this_.[currentsharestext] as current19_163_0_, this_.[currentbookvalue] as current20_163_0_, this_.[currentbookvaluetext] as current21_163_0_, this_.[retrieveddatetime] as retriev22_163_0_, this_.[pmresponse] as pmresponse23_163_0_, this_.[pmresponseby] as pmrespo24_163_0_, this_.[pmresponsedatetime] as pmrespo25_163_0_, this_.[electionstatus] as electio26_163_0_, this_.[electedby] as electedby27_163_0_, this_.[electeddatetime] as elected28_163_0_, this_.[confirmationstatus] as confirm29_163_0_, this_.[confirmedby] as confirm30_163_0_, this_.[confirmeddatetime] as confirm31_163_0_, this_.[sentforqc] as sentforqc32_163_0_, this_.[qcdby] as qcdby33_163_0_, this_.[qcddatetime] as qcddate34_163_0_, this_.[isactive] as isactive35_163_0_, this_.[lastupdatedby] as lastupd36_163_0_, this_.[wasaddedwithupdate] as wasadde37_163_0_, this_.[haveshareschanged] as havesha38_163_0_, this_.[isqib] as isqib39_163_0_, this_.[wheredomiciled] as wheredo40_163_0_, this_.[returntopm] as returntopm41_163_0_, this_.[securityname] as securit42_163_0_ from [socaholdingsbysecurity] this_ where (this_.[cadetailsid]=? and this_.[sensitiveaccount]=?) order by this_.[accountcode] asc
2014-10-03 22:29:05,838 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 15941
2014-10-03 22:29:05,838 [default-threads - 20] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [BIT] - true
2014-10-03 22:29:05,875 [default-threads - 20] DEBUG org.hibernate.SQL - select this_.[caholdingid] as caholdin1_163_0_, this_.[cadetailsid] as cadetail2_163_0_, this_.[securityid] as securityid3_163_0_, this_.[accountcode] as accountc4_163_0_, this_.[accountdescription] as accountd5_163_0_, this_.[accounttype] as accountt6_163_0_, this_.[sma] as sma7_163_0_, this_.[sensitiveaccount] as sensitiv8_163_0_, this_.[manager] as manager9_163_0_, this_.[custodianname] as custodi10_163_0_, this_.[custodianaccountnumber] as custodi11_163_0_, this_.[initialasofdate] as initial12_163_0_, this_.[initialshares] as initial13_163_0_, this_.[initialsharestext] as initial14_163_0_, this_.[initialbookvalue] as initial15_163_0_, this_.[initialbookvaluetext] as initial16_163_0_, this_.[currentasofdate] as current17_163_0_, this_.[currentshares] as current18_163_0_, this_.[currentsharestext] as current19_163_0_, this_.[currentbookvalue] as current20_163_0_, this_.[currentbookvaluetext] as current21_163_0_, this_.[retrieveddatetime] as retriev22_163_0_, this_.[pmresponse] as pmresponse23_163_0_, this_.[pmresponseby] as pmrespo24_163_0_, this_.[pmresponsedatetime] as pmrespo25_163_0_, this_.[electionstatus] as electio26_163_0_, this_.[electedby] as electedby27_163_0_, this_.[electeddatetime] as elected28_163_0_, this_.[confirmationstatus] as confirm29_163_0_, this_.[confirmedby] as confirm30_163_0_, this_.[confirmeddatetime] as confirm31_163_0_, this_.[sentforqc] as sentforqc32_163_0_, this_.[qcdby] as qcdby33_163_0_, this_.[qcddatetime] as qcddate34_163_0_, this_.[isactive] as isactive35_163_0_, this_.[lastupdatedby] as lastupd36_163_0_, this_.[wasaddedwithupdate] as wasadde37_163_0_, this_.[haveshareschanged] as havesha38_163_0_, this_.[isqib] as isqib39_163_0_, this_.[wheredomiciled] as wheredo40_163_0_, this_.[returntopm] as returntopm41_163_0_, this_.[securityname] as securit42_163_0_ from [socaholdingsbysecurity] this_ where (this_.[cadetailsid]=? and this_.[manager]=?) order by this_.[accountcode] asc