ail4_18_6_, user6_.first_name as first_na5_18_6_, user6_.last_name as last_nam6_
18_6_, user6_.notifications as notifica7_18_6_, user6_.password as password8_18_
6_, user6_.role_id as role_id12_18_6_, user6_.signup_date as signup_d9_18_6_, us
er6_.state as state10_18_6_, user6_.tenant_id as tenant_13_18_6_, subscripti7_.i
d as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, subscripti7_.is
sue_date as issue_da3_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_,
subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti
8_.available_business_units as availabl2_14_8_, subscripti8_.available_users as
availabl3_14_8_, subscripti8_.available_vizis as availabl4_14_8_, subscripti8_.n
ame as name5_14_8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_users use
r0_ left outer join vzr_users user1_ on user0_.assigned_to=user1_.id left outer
join vzr_roles role2_ on user1_.role_id=role2_.id left outer join vzr_role_permi
ssions permission3_ on role2_.id=permission3_.r                                o
le_id left outer join vzr_permissions permission4_ on permission3_.permission_id
=permission4_.id left outer join vzr_tenants tenant5_ on user1_.tenant_id=tenant
5_.id left outer join vzr_users user6_ on tenant5_.admin_id=user6_.id left outer
 join vzr_subscriptions subscripti7_ on tenant5_.subscription_id=subscripti7_.id
 left outer join vzr_subscription_plans subscripti8_ on subscripti7_.plan_id=sub
scripti8_.id where user0_.id=?
2015-12-03 11:42:11.089 DEBUG 4052 --- [io-10002-exec-2] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:42:11.118 DEBUG 4052 --- [o-10002-exec-10] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select businessun0_.id as id1_1_, businessun0_.color_scheme as color_
sc2_1_, businessun0_.description as des                                        c
ript3_1_, businessun0_.email as email4_1_, businessun0_.font_face as font_fac5_1
_, businessun0_.guid as guid6_1_, businessun0_.name as name7_1_, businessun0_.ph
one as phone8_1_, businessun0_.state as state9_1_, businessun0_.tenant_id as ten
ant_12_1_, businessun0_.video_url as video_u10_1_, businessun0_.website as websi
te11_1_ from vzr_business_units businessun0_ where businessun0_.tenant_id=?
Hibernate: select role0_.id as id1_10_0_, role0_.description as descript2_10_0_,
 role0_.level as level3_10_0_, role0_.name as name4_10_0_, permission1_.role_id
as role_id1_10_1_, permission2_.id as permissi2_9_1_, permission2_.id as id1_6_2
_, permission2_.description as descript2_6_2_, permission2_.name as name3_6_2_ f
rom vzr_roles role0_ left outer join vzr_role_permissions permission1_ on role0_
.id=permission1_.role_id left outer join vzr_permissions permission2_ on permiss
ion1_.permission_id=permission2_.id where role0_.id=?
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.p                                         a
ssword as password8_18_2_, user2_.role_id as role_id12_18_2_, user2_.signup_date
 as signup_d9_18_2_, user2_.state as state10_18_2_, user2_.tenant_id as tenant_1
3_18_2_, role3_.id as id1_10_3_, role3_.description as descript2_10_3_, role3_.l
evel as level3_10_3_, role3_.name as name4_10_3_, permission4_.role_id as role_i
d1_10_4_, permission5_.id as permissi2_9_4_, permission5_.id as id1_6_5_, permis
sion5_.description as descript2_6_5_, permission5_.name as name3_6_5_, tenant6_.
id as id1_17_6_, tenant6_.is_active as is_activ2_17_6_, tenant6_.admin_id as adm
in_id5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.subscription_id as subscrip
6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.id as id1_15_7_, subscript
i7_.expiration_date as expirati2_15_7_, subscripti7_.issue_date as issue_da3_15_
7_, subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.plan_id as p
lan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_business_uni
ts as availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_, subscrip
ti8_.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subsc
ripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join v
zr_users user1_ on tenant0_.admin_id=user1_.id left outer join vzr_users user2_
on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.role_
id=role3_.id left outer join vzr_role_permissions permission4_ on role3_.id=perm
ission4_.role_id left outer join vzr_permissions permission5_ on permission4_.pe
rmission_id=permission5_.id left outer join vzr_tenants tenant6_ on user2_.tenan
t_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.subs
cription_id=subscripti7_.id left outer join vzr_subscription_plans subscripti8_
on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_per             m
issions permission0_ inner join vzr_permissions permission1_ on permission0_.per
mission_id=permission1_.id where permission0_.role_id=?
Hibernate: select count(vizi0_.id) as col_0_0_ from vzr_vizis vizi0_ left outer
join vzr_business_units businessun1_ on vizi0_.business_unit_id=businessun1_.id
where vizi0_.tenant_id=? and vizi0_.state<>?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_                                                              2
_, user2_.signup_date as signup_d9_18_2_, user2_.state as state10_18_2_, user2_.
tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.description as desc
ript2_10_3_, role3_.level as level3_10_3_, role3_.name as name4_10_3_, permissio
n4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_4_, permission5_.i
d as id1_6_5_, permission5_.description as descript2_6_5_, permission5_.name as
name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is_activ2_17_6_, ten
ant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.subscr
iption_id as subscrip6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.id as
 id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, subscripti7_.issue_
date as issue_da3_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subs
cripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.a
vailable_business_units as availabl2_14_8_, subscripti8_.available_users as avai
labl3_14_8_, subscripti8_.available_vizis as availabl4_14_8_, subscripti8_.name
as name5_14_8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenan
t0_ left outer join vzr_users user1_ on tenant0_.admin_id=user1_.id left outer j
oin vzr_users user2_ on user1_.assigned_to=user2_.id left outer join vzr_roles r
ole3_ on user2_.role_id=role3_.id left outer join vzr_role_permissions permissio
n4_ on role3_.id=permission4_.role_id left outer join vzr_permissions permission
5_ on permission4_.permission_id=permission5_.id left outer join vzr_tenants ten
ant6_ on user2_.tenant_id=tenant6_.id left outer join vzr_subscriptions subscrip
ti7_ on tenant6_.subscription_id=subscripti7_.id left outer join vzr_subscriptio
n_plans subscripti8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?

2015-12-03 11:42:11.190 DEBUG 4052 --- [io-10002-exec-4] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: select vizi0_.id as id1_21_, vizi0_.apply_link as apply_li2_21_, vizi
0_.assignee_id as ass                                                          i
gne25_21_, vizi0_.background_photo as backgrou3_21_, vizi0_.business_unit_id as
busines26_21_, vizi0_.color_scheme as color_sc4_21_, vizi0_.compensation as comp
ensa5_21_, vizi0_.config as config6_21_, vizi0_.creation_date as creation7_21_,
vizi0_.expiration_date as expirati8_21_, vizi0_.font_face as font_fac9_21_, vizi
0_.guid as guid10_21_, vizi0_.inactive_link as inactiv11_21_, vizi0_.industry as
 industr12_21_, vizi0_.introduction as introdu13_21_, vizi0_.issue_date as issue
_d14_21_, vizi0_.job_family as job_fam15_21_, vizi0_.level as level16_21_, vizi0
_.link as link17_21_, vizi0_.address as address18_21_, vizi0_.location as locati
o19_21_, vizi0_.requisition_number as requisi20_21_, vizi0_.state as state21_21_
, vizi0_.storage_key as storage22_21_, vizi0_.template as templat23_21_, vizi0_.
tenant_id as tenant_27_21_, vizi0_.title as title24_21_ from vzr_vizis vizi0_ le
ft outer join vzr_business_units businessun1_ on vizi0_.business_unit_id=busines
sun1_.id where vizi0_.tenant_id=? and vizi0_.state<>? order by vizi0_.title asc,
 vizi0_.id asc limit ?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select role0_.id as id1_10_0_, role0_.description as descript2_10_0_,
 role0_.level as level3_10_0_, role0_.name as name4_10_0_, permission1_.role_id
as role_id1_10_1_, permission2_.id as permissi2_9_1_, permission2_.id as id1_6_2
_, permission2_.description as descript2_6_2_, permission2_.name as name3_6_2_ f
rom vzr_roles ro                                                               l
e0_ left outer join vzr_role_permissions permission1_ on role0_.id=permission1_.
role_id left outer join vzr_permissions permission2_ on permission1_.permission_
id=permission2_.id where role0_.id=?
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select businessun0_.id as id1_1_0_, businessun0_.color_scheme as colo
r_sc2_1_0_, businessun0_.description as descript3_1_0_, businessun0_.email as em
ail4_1_0_, businessun0_.font_face as font_fac5_1_0_, businessun0_.guid as guid6_
1_0_, businessun0_.name as name7_1_0_, businessun0_.phone as phone8_1_0_, busine
ssun0_.state as state9_1_0_, businessun0_.tenant_id as tenant_12_1_0_, businessu
n0_.video_url as video_u10_1_0_, businessun0_.website as website11_1_0_, tenant1
_.id as id1_17_1_, tenant1_.is_active as is_activ2_17_1_, tenant1_.admin_id as a
dmin_id5_17_1_, tenant1_.guid as guid3_17_1_, tenant1_.subscription_id as subscr
ip6_17_1_, tenant1_.title as title4_17_1_, user2_.id as id1_18_2_, user2_.assign
ed_to as assigne11_18_2_, user2_.registration_key as registra2_18_2_, user2_.cre
ate_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_.first_name as
first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.notifications as no
tifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id as role_id12_1
8_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as state10_18_2_, user
2_.tenant_id as tenant_13_18_2_, user3_.id as id1_18_3_, user3_.assigned_to as a
ssigne11_18_3_, user3_.registration_key as registra2_18_3_, user3_.create_date a
s create_d3_18_3_, user3_.email as email4_18_3_, user3_.first_name as first_na5_
18_3_, user3_.last_name as last_nam6_18_3_, user3_.notifications as notifica7_18
_3_, user3_.password as password8_18_3_, user3_.role_id as role_id12_18_3_, user
3_.signup_date as signup_d9_18_3_, user3_.state as state10_18_3_, user3_.tenant_
id as tenant_13_18_3_, role4_.id as id1_10_4_, role4_.description as descript2_1
0_4_, role4_.level as level3_10_4_, role4_.name as n                           a
me4_10_4_, permission5_.role_id as role_id1_10_5_, permission6_.id as permissi2_
9_5_, permission6_.id as id1_6_6_, permission6_.description as descript2_6_6_, p
ermission6_.name as name3_6_6_, tenant7_.id as id1_17_7_, tenant7_.is_active as
is_activ2_17_7_, tenant7_.admin_id as admin_id5_17_7_, tenant7_.guid as guid3_17
_7_, tenant7_.subscription_id as subscrip6_17_7_, tenant7_.title as title4_17_7_
, subscripti8_.id as id1_15_8_, subscripti8_.expiration_date as expirati2_15_8_,
 subscripti8_.issue_date as issue_da3_15_8_, subscripti8_.last_payment_date as l
ast_pay4_15_8_, subscripti8_.plan_id as plan_id5_15_8_, subscripti9_.id as id1_1
4_9_, subscripti9_.available_business_units as availabl2_14_9_, subscripti9_.ava
ilable_users as availabl3_14_9_, subscripti9_.available_vizis as availabl4_14_9_
, subscripti9_.name as name5_14_9_, subscripti9_.is_public as is_publi6_14_9_ fr
om vzr_business_units businessun0_ left outer join vzr_tenants tenant1_ on busin
essun0_.tenant_id=tenant1_.id left outer join vzr_users user2_ on tenant1_.admin
_id=user2_.id left outer join vzr_users user3_ on user2_.assigned_to=user3_.id l
eft outer join vzr_roles role4_ on user3_.role_id=role4_.id left outer join vzr_
role_permissions permission5_ on role4_.id=permission5_.role_id left outer join
vzr_permissions permission6_ on permission5_.permission_id=permission6_.id left
outer join vzr_tenants tenant7_ on user3_.tenant_id=tenant7_.id left outer join
vzr_subscriptions subscripti8_ on tenant7_.subscription_id=subscripti8_.id left
outer join vzr_subscription_plans subscripti9_ on subscripti8_.plan_id=subscript
i9_.id where businessun0_.id=?
Hibernate: select user0_.id as id1_18_0_, user0_.assigned_to as assigne11_18_0_,
 user0_.registration_key as registra2_18_0_, user0_.create_date as create_d3_18_
0_, user0_.email as email4_18_0_, user0_.first_name as first_na5_18_0_, user0_.l
ast_name as last_nam6_18_0_, user0_.notifications as notifica7_18_0_, user0_.pas
sword as password8_18_0_, user0_.role_id as role_id12_18_0_, user0_.signup_date
as signup_d9_18                                                                _
0_, user0_.state as state10_18_0_, user0_.tenant_id as tenant_13_18_0_, user1_.i
d as id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key a
s registra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4
_18_1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1
_, user1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_,
user1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_
.state as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, role2_.id as id1_1
0_2_, role2_.description as descript2_10_2_, role2_.level as level3_10_2_, role2
_.name as name4_10_2_, permission3_.role_id as role_id1_10_3_, permission4_.id a
s permissi2_9_3_, permission4_.id as id1_6_4_, permission4_.description as descr
ipt2_6_4_, permission4_.name as name3_6_4_, tenant5_.id as id1_17_5_, tenant5_.i
s_active as is_activ2_17_5_, tenant5_.admin_id as admin_id5_17_5_, tenant5_.guid
 as guid3_17_5_, tenant5_.subscription_id as subscrip6_17_5_, tenant5_.title as
title4_17_5_, user6_.id as id1_18_6_, user6_.assigned_to as assigne11_18_6_, use
r6_.registration_key as registra2_18_6_, user6_.create_date as create_d3_18_6_,
user6_.email as email4_18_6_, user6_.first_name as first_na5_18_6_, user6_.last_
name as last_nam6_18_6_, user6_.notifications as notifica7_18_6_, user6_.passwor
d as password8_18_6_, user6_.role_id as role_id12_18_6_, user6_.signup_date as s
ignup_d9_18_6_, user6_.state as state10_18_6_, user6_.tenant_id as tenant_13_18_
6_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7
_, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as
 last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1
_14_8_, subscripti8_.available_business_units as availabl2_14_8_, subscripti8_.a
vailable_users as availabl3_14_8_, subscripti8_.available_vizis as availabl4_14_
8_, subscripti8_.name as name5_14_8_, subscripti8_.is_public as is_publi6_14_8_
from vzr_users user0_ left outer join vzr_users
user1_ on user0_.assigned_to=user1_.id left outer join vzr_roles role2_ on user1
_.role_id=role2_.id left outer join vzr_role_permissions permission3_ on role2_.
id=permission3_.role_id left outer join vzr_permissions permission4_ on permissi
on3_.permission_id=permission4_.id left outer join vzr_tenants tenant5_ on user1
_.tenant_id=tenant5_.id left outer join vzr_users user6_ on tenant5_.admin_id=us
er6_.id left outer join vzr_subscriptions subscripti7_ on tenant5_.subscription_
id=subscripti7_.id left outer join vzr_subscription_plans subscripti8_ on subscr
ipti7_.plan_id=subscripti8_.id where user0_.id=?
Hibernate: select links0_.business_unit_id as business3_1_0_, links0_.id as id1_
0_0_, links0_.id as id1_0_1_, links0_.business_unit_id as business3_0_1_, links0
_.network_id as network_4_0_1_, links0_.url as url2_0_1_, socialnetw1_.id as id1
_12_2_, socialnetw1_.icon as icon2_12_2_, socialnetw1_.name as name3_12_2_, soci
alnetw1_.base_url as base_url4_12_2_ from vzr_business_unit_social_links links0_
 left outer join vzr_social_networks socialnetw1_ on links0_.network_id=socialne
tw1_.id where links0_.business_unit_id=?
Hibernate: select contentref0_.id as id1_2_, contentref0_.content_type as conten
t_2_2_, contentref0_.creation_date as creation3_2_, contentref0_.file_extension
as file_ext4_2_, contentref0_.hash as hash5_2_, contentref0_.object_id as object
_i6_2_, contentref0_.object_type as object_t7_2_, contentref0_.order_num as orde
r_nu8_2_ from vzr_content_ref contentref0_ where contentref0_.object_type=? and
contentref0_.object_id=? and contentref0_.content_type=?
2015-12-03 11:42:11.210 DEBUG 4052 --- [io-10002-exec-4] c.v.backoffice.web.rest
.UserResource     : Start searching users: page number null, page size null, col
umn null, direction null, roleId null
Hibernate: select role0_.id as id1_10_0_, role0_.description as descript2_10_0_,
 role0_.level as level3_10_0_, role0_.name as name4_10_0_, permission1_.role_id
as role_id1_10_1_, permission2_.id as permissi2_9_1_, permission2_.id as id1_6_2
_, permission2_.de                                                             s
cription as descript2_6_2_, permission2_.name as name3_6_2_ from vzr_roles role0
_ left outer join vzr_role_permissions permission1_ on role0_.id=permission1_.ro
le_id left outer join vzr_permissions permission2_ on permission1_.permission_id
=permission2_.id where role0_.id=?
Hibernate: select count(user0_.id) as col_0_0_ from vzr_users user0_ where user0
_.tenant_id=? and user0_.state=? and (user0_.role_id in (? , ? , ? , ?))
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subsc                                                              r
iption_id as subscrip6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.id as
 id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, subscripti7_.issue_
date as issue_da3_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subs
cripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.a
vailable_business_units as availabl2_14_8_, subscripti8_.available_users as avai
labl3_14_8_, subscripti8_.available_vizis as availabl4_14_8_, subscripti8_.name
as name5_14_8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenan
t0_ left outer join vzr_users user1_ on tenant0_.admin_id=user1_.id left outer j
oin vzr_users user2_ on user1_.assigned_to=user2_.id left outer join vzr_roles r
ole3_ on user2_.role_id=role3_.id left outer join vzr_role_permissions permissio
n4_ on role3_.id=permission4_.role_id left outer join vzr_permissions permission
5_ on permission4_.permission_id=permission5_.id left outer join vzr_tenants ten
ant6_ on user2_.tenant_id=tenant6_.id left outer join vzr_subscriptions subscrip
ti7_ on tenant6_.subscription_id=subscripti7_.id left outer join vzr_subscriptio
n_plans subscripti8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?

Hibernate: select user0_.id as id1_18_, user0_.assigned_to as assigne11_18_, use
r0_.registration_key as registra2_18_, user0_.create_date as create_d3_18_, user
0_.email as email4_18_, user0_.first_name as first_na5_18_, user0_.last_name as
last_nam6_18_, user0_.notifications as notifica7_18_, user0_.password as passwor
d8_18_, user0_.role_id as role_id12_18_, user0_.signup_date as signup_d9_18_, us
er0_.state as state10_18_, user0_.tenant_id as tenant_13_18_ from vzr_users user
0_ where user0_.tenant_id=? and user0_.state=? and (user0_.role_id in (? , ? , ?
 , ?)) order by user0_.id asc limit ?
Hibernate: select role0_.id as id1_10_0_, role0_.description as descript2_10_0_,
 role0_.level as level3_10_0_, role0_.name as name4_10_0_, permission1_.role_id
as role_id1_10_1_, permission2_.id as permissi2_9_1_, permission2_.id as id1_6_2
_, per                                                                         m
ission2_.description as descript2_6_2_, permission2_.name as name3_6_2_ from vzr
_roles role0_ left outer join vzr_role_permissions permission1_ on role0_.id=per
mission1_.role_id left outer join vzr_permissions permission2_ on permission1_.p
ermission_id=permission2_.id where role0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select businessun0_.id as id1_1_0_, businessun0_.color_scheme as colo
r_sc2_1_0_, businessun0_.description as descript3_1_0_, businessun0_.email as em
ail4_1_0_, businessun0_.font_face as font_fac5_1_0_, businessun0_.guid as guid6_
1_0_, businessun0_.name as name7_1_0_, businessun0_.phone as phone8_1_0_, busine
ssun0_.state as state9_1_0_, businessun0_.tenant_id as tenant_12_1_0_, businessu
n0_.video_url as video_u10_1_0_, businessun0_.website as website11_1_0_, tenant1
_.id as id1_17_1_, tenant1_.is_active as is_activ2_17_1_, tenant1_.admin_id as a
dmin_id5_17_1_, tenant1_.guid as guid3_17_1_, tenant1_.subscription_id as subscr
ip6_17_1_, tenant1_.title as title4_17_1_, user2_.id as id1_18_2_, user2_.assign
ed_to as assigne11_18_2_, user2_.registration_key as registra2_18_2_, user2_.cre
ate_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_.first_name as
first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.notifications as no
tifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id as role_id12_1
8_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as state10_18_       2
_, user2_.tenant_id as tenant_13_18_2_, user3_.id as id1_18_3_, user3_.assigned_
to as assigne11_18_3_, user3_.registration_key as registra2_18_3_, user3_.create
_date as create_d3_18_3_, user3_.email as email4_18_3_, user3_.first_name as fir
st_na5_18_3_, user3_.last_name as last_nam6_18_3_, user3_.notifications as notif
ica7_18_3_, user3_.password as password8_18_3_, user3_.role_id as role_id12_18_3
_, user3_.signup_date as signup_d9_18_3_, user3_.state as state10_18_3_, user3_.
tenant_id as tenant_13_18_3_, role4_.id as id1_10_4_, role4_.description as desc
ript2_10_4_, role4_.level as level3_10_4_, role4_.name as name4_10_4_, permissio
n5_.role_id as role_id1_10_5_, permission6_.id as permissi2_9_5_, permission6_.i
d as id1_6_6_, permission6_.description as descript2_6_6_, permission6_.name as
name3_6_6_, tenant7_.id as id1_17_7_, tenant7_.is_active as is_activ2_17_7_, ten
ant7_.admin_id as admin_id5_17_7_, tenant7_.guid as guid3_17_7_, tenant7_.subscr
iption_id as subscrip6_17_7_, tenant7_.title as title4_17_7_, subscripti8_.id as
 id1_15_8_, subscripti8_.expiration_date as expirati2_15_8_, subscripti8_.issue_
date as issue_da3_15_8_, subscripti8_.last_payment_date as last_pay4_15_8_, subs
cripti8_.plan_id as plan_id5_15_8_, subscripti9_.id as id1_14_9_, subscripti9_.a
vailable_business_units as availabl2_14_9_, subscripti9_.available_users as avai
labl3_14_9_, subscripti9_.available_vizis as availabl4_14_9_, subscripti9_.name
as name5_14_9_, subscripti9_.is_public as is_publi6_14_9_ from vzr_business_unit
s businessun0_ left outer join vzr_tenants tenant1_ on businessun0_.tenant_id=te
nant1_.id left outer join vzr_users user2_ on tenant1_.admin_id=user2_.id left o
uter join vzr_users user3_ on user2_.assigned_to=user3_.id left outer join vzr_r
oles role4_ on user3_.role_id=role4_.id left outer join vzr_role_permissions per
mission5_ on role4_.id=permission5_.role_id left outer join vzr_permissions perm
ission6_ on permission5_.permission_id=permission6_.id left outer join vzr_tenan
ts tenant7_ on user3_.tenant_id=tenant7_.id lef                                t
 outer join vzr_subscriptions subscripti8_ on tenant7_.subscription_id=subscript
i8_.id left outer join vzr_subscription_plans subscripti9_ on subscripti8_.plan_
id=subscripti9_.id where businessun0_.id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as las
t_p                                                                            a
y4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_,
subscripti8_.available_business_units as availabl2_14_8_, subscripti8_.available
_users as availabl3_14_8_, subscripti8_.available_vizis as availabl4_14_8_, subs
cripti8_.name as name5_14_8_, subscripti8_.is_public as is_publi6_14_8_ from vzr
_tenants tenant0_ left outer join vzr_users user1_ on tenant0_.admin_id=user1_.i
d left outer join vzr_users user2_ on user1_.assigned_to=user2_.id left outer jo
in vzr_roles role3_ on user2_.role_id=role3_.id left outer join vzr_role_permiss
ions permission4_ on role3_.id=permission4_.role_id left outer join vzr_permissi
ons permission5_ on permission4_.permission_id=permission5_.id left outer join v
zr_tenants tenant6_ on user2_.tenant_id=tenant6_.id left outer join vzr_subscrip
tions subscripti7_ on tenant6_.subscription_id=subscripti7_.id left outer join v
zr_subscription_plans subscripti8_ on subscripti7_.plan_id=subscripti8_.id where
 tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select count(vizi0_.id) as col_0_0_ from vzr_vizis vizi0_ where vizi0
_.assignee_id=? and (vizi0_.state in (? , ? , ?))
Hibernate: select assignees0_.assigned_to as assigne11_18_0_, assignees0_.id as
id1_18_0_, assignees0_.id as id1_18_1_, assignees0_.assigned_to as assigne11_18_
1_, assignees0_.registration_key as registra2_18_1_, assignees0_.create_date as
create_d3_18_1_, assignees0_.email as email4_18_1_, a                          s
signees0_.first_name as first_na5_18_1_, assignees0_.last_name as last_nam6_18_1
_, assignees0_.notifications as notifica7_18_1_, assignees0_.password as passwor
d8_18_1_, assignees0_.role_id as role_id12_18_1_, assignees0_.signup_date as sig
nup_d9_18_1_, assignees0_.state as state10_18_1_, assignees0_.tenant_id as tenan
t_13_18_1_, role1_.id as id1_10_2_, role1_.description as descript2_10_2_, role1
_.level as level3_10_2_, role1_.name as name4_10_2_, tenant2_.id as id1_17_3_, t
enant2_.is_active as is_activ2_17_3_, tenant2_.admin_id as admin_id5_17_3_, tena
nt2_.guid as guid3_17_3_, tenant2_.subscription_id as subscrip6_17_3_, tenant2_.
title as title4_17_3_, user3_.id as id1_18_4_, user3_.assigned_to as assigne11_1
8_4_, user3_.registration_key as registra2_18_4_, user3_.create_date as create_d
3_18_4_, user3_.email as email4_18_4_, user3_.first_name as first_na5_18_4_, use
r3_.last_name as last_nam6_18_4_, user3_.notifications as notifica7_18_4_, user3
_.password as password8_18_4_, user3_.role_id as role_id12_18_4_, user3_.signup_
date as signup_d9_18_4_, user3_.state as state10_18_4_, user3_.tenant_id as tena
nt_13_18_4_, subscripti4_.id as id1_15_5_, subscripti4_.expiration_date as expir
ati2_15_5_, subscripti4_.issue_date as issue_da3_15_5_, subscripti4_.last_paymen
t_date as last_pay4_15_5_, subscripti4_.plan_id as plan_id5_15_5_, subscripti5_.
id as id1_14_6_, subscripti5_.available_business_units as availabl2_14_6_, subsc
ripti5_.available_users as availabl3_14_6_, subscripti5_.available_vizis as avai
labl4_14_6_, subscripti5_.name as name5_14_6_, subscripti5_.is_public as is_publ
i6_14_6_ from vzr_users assignees0_ left outer join vzr_roles role1_ on assignee
s0_.role_id=role1_.id left outer join vzr_tenants tenant2_ on assignees0_.tenant
_id=tenant2_.id left outer join vzr_users user3_ on tenant2_.admin_id=user3_.id
left outer join vzr_subscriptions subscripti4_ on tenant2_.subscription_id=subsc
ripti4_.id left outer join vzr_subscription_plans subscripti5_ on subscripti4_.p
lan_id=subscripti5_.id where assignees0_.assign                                e
d_to=?
2015-12-03 11:44:34.998 DEBUG 4052 --- [io-10002-exec-5] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token null
2015-12-03 11:44:35.003 DEBUG 4052 --- [io-10002-exec-3] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token null
2015-12-03 11:44:35.103 DEBUG 4052 --- [io-10002-exec-6] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token null
2015-12-03 11:44:35.109 DEBUG 4052 --- [io-10002-exec-7] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token null
2015-12-03 11:44:35.109 DEBUG 4052 --- [io-10002-exec-8] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token null
2015-12-03 11:44:35.223 DEBUG 4052 --- [io-10002-exec-9] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as las
t_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_
8_, subscripti8_.available_business_units as availabl2_14_8_, subscripti8_.avail
able_users as availabl3_14_8_, subscripti8_.avai                               l
able_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is
_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users u
ser1_ on tenant0_.admin_id=user1_.id left outer join vzr_users user2_ on user1_.
assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.role_id=role3_.
id left outer join vzr_role_permissions permission4_ on role3_.id=permission4_.r
ole_id left outer join vzr_permissions permission5_ on permission4_.permission_i
d=permission5_.id left outer join vzr_tenants tenant6_ on user2_.tenant_id=tenan
t6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.subscription_i
d=subscripti7_.id left outer join vzr_subscription_plans subscripti8_ on subscri
pti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
2015-12-03 11:44:35.231 DEBUG 4052 --- [io-10002-exec-2] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
2015-12-03 11:44:35.232 DEBUG 4052 --- [io-10002-exec-1] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmissio                                                                        n
1_.id where permission0_.role_id=?
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_                                                     2
_, user2_.password as password8_18_2_, user2_.role_id as role_id12_18_2_, user2_
.signup_date as signup_d9_18_2_, user2_.state as state10_18_2_, user2_.tenant_id
 as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.description as descript2_10_
3_, role3_.level as level3_10_3_, role3_.name as name4_10_3_, permission4_.role_
id as role_id1_10_4_, permission5_.id as permissi2_9_4_, permission5_.id as id1_
6_5_, permission5_.description as descript2_6_5_, permission5_.name as name3_6_5
_, tenant6_.id as id1_17_6_, tenant6_.is_active as is_activ2_17_6_, tenant6_.adm
in_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.subscription_id
 as subscrip6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.id as id1_15_7
_, subscripti7_.expiration_date as expirati2_15_7_, subscripti7_.issue_date as i
ssue_da3_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.
plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_
business_units as availabl2_14_8_, subscripti8_.available_users as availabl3_14_
8_, subscripti8_.available_vizis as availabl4_14_8_, subscripti8_.name as name5_
14_8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left
outer join vzr_users user1_ on tenant0_.admin_id=user1_.id left outer join vzr_u
sers user2_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on
user2_.role_id=role3_.id left outer join vzr_role_permissions permission4_ on ro
le3_.id=permission4_.role_id left outer join vzr_permissions permission5_ on per
mission4_.permission_id=permission5_.id left outer join vzr_tenants tenant6_ on
user2_.tenant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on t
enant6_.subscription_id=subscripti7_.id left outer join vzr_subscription_plans s
ubscripti8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id a                         s
 plan_id5_15_0_, subscripti1_.id as id1_14_1_, subscripti1_.available_business_u
nits as availabl2_14_1_, subscripti1_.available_users as availabl3_14_1_, subscr
ipti1_.available_vizis as availabl4_14_1_, subscripti1_.name as name5_14_1_, sub
scripti1_.is_public as is_publi6_14_1_ from vzr_subscriptions subscripti0_ left
outer join vzr_subscription_plans subscripti1_ on subscripti0_.plan_id=subscript
i1_.id where subscripti0_.id=?
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_             ,
 user1_.id as id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registrat
ion_key as registra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email
as email4_18_1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_
nam6_18_1_, user1_.notifications as notifica7_18_1_, user1_.password as password
8_18_1_, user1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1
_, user1_.state as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id
 as id1_18_2_, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as
 registra2_18_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_
18_2_, user2_.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_
, user2_.notifications as notifica7_18_2_, user2_.password as password8_18_2_, u
ser2_.role_id as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.
state as state10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10
_3_, role3_.description as descript2_10_3_, role3_.level as level3_10_3_, role3_
.name as name4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as
 permissi2_9_4_, permission5_.id as id1_6_5_, permission5_.description as descri
pt2_6_5_, permission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is
_active as is_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid
as guid3_17_6_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as t
itle4_17_6_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expir
ati2_15_7_, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_paymen
t_date as last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.
id as id1_14_8_, subscripti8_.available_business_units as availabl2_14_8_, subsc
ripti8_.available_users as availabl3_14_8_, subscripti8_.available_vizis as avai
labl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_public as is_publ
i6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users user1_ on tenant0_.
admin_id=user1_.id left outer join vzr_users us                                e
r2_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.r
ole_id=role3_.id left outer join vzr_role_permissions permission4_ on role3_.id=
permission4_.role_id left outer join vzr_permissions permission5_ on permission4
_.permission_id=permission5_.id left outer join vzr_tenants tenant6_ on user2_.t
enant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.
subscription_id=subscripti7_.id left outer join vzr_subscription_plans subscript
i8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
2015-12-03 11:44:35.245 DEBUG 4052 --- [o-10002-exec-10] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscr                                                                         i
pti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as availa
bl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is_publi6
_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscription_plan
s subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_.id=?
2015-12-03 11:44:35.249 DEBUG 4052 --- [io-10002-exec-9] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:44:35.256 DEBUG 4052 --- [io-10002-exec-1] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.leve                                     l
 as level3_10_3_, role3_.name as name4_10_3_, permission4_.role_id as role_id1_1
0_4_, permission5_.id as permissi2_9_4_, permission5_.id as id1_6_5_, permission
5_.description as descript2_6_5_, permission5_.name as name3_6_5_, tenant6_.id a
s id1_17_6_, tenant6_.is_active as is_activ2_17_6_, tenant6_.admin_id as admin_i
d5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.subscription_id as subscrip6_17
_6_, tenant6_.title as title4_17_6_, subscripti7_.id as id1_15_7_, subscripti7_.
expiration_date as expirati2_15_7_, subscripti7_.issue_date as issue_da3_15_7_,
subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.plan_id as plan_
id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_business_units a
s availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_, subscripti8_
.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subscript
i8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_u
sers user1_ on tenant0_.admin_id=user1_.id left outer join vzr_users user2_ on u
ser1_.assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.role_id=r
ole3_.id left outer join vzr_role_permissions permission4_ on role3_.id=permissi
on4_.role_id left outer join vzr_permissions permission5_ on permission4_.permis
sion_id=permission5_.id left outer join vzr_tenants tenant6_ on user2_.tenant_id
=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.subscrip
tion_id=subscripti7_.id left outer join vzr_subscription_plans subscripti8_ on s
ubscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:44:35.259 DEBUG 4052 --- [io-10002-exec-4] c.v.c.w.filter.TokenAut
horizationFilter  : Valida                                                     t
ing token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:44:35.289 DEBUG 4052 --- [io-10002-exec-9] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as
id1_18_2_, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as reg
istra2_18_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2
_, user2_.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, us
er2_.notifications as notifica7_18_2_, user2_.password as password8_18_2_, user2
_.role_id as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.stat
e as state10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_,
 role3_.description as descript2_10_3_, role3_.level as level3_10_3_, role3_.nam
e as name4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as per
missi2_9_4_, permission5_.id as id1_6_5_, permission5_.description as descript2_
6_5_, permission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_act
ive as is_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as g
uid3_17_6_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title
4_17_6_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2
_15_7_, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_da
te as last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id a
s id1_14_8_, subscripti8_.available_business_units as availabl2_14_8_, subscript
i8_.available_users as availabl3_14_8_, subscripti8_.available_vizis as availabl
4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_public as is_publi6_1
4_8_ from vzr_tenants tenant0_ left outer join vzr_users user1_ on tenant0_.admi
n_id=user1_.id left outer join vzr_users user2_ on user1_.assigned_to=user2_.id
left outer join vzr_roles role3_ on user2_.role_id=role3_.id left outer join vzr
_role_permissions permission4_ on role3_.id=permission4_.role_id left outer join
 vzr_permissions permission5_ on permission4_.permission_id=permission5_.id left
 outer join vzr_tenants tenant6_ on user2_.tenant_id=tenant6_.id left outer join
 vzr_subscriptions subscripti7_ on tenant6_.subscription_id=subscripti7_.id left
 outer join vzr_subscription_plans subscripti8_
on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
2015-12-03 11:44:35.300 DEBUG 4052 --- [io-10002-exec-1] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
2015-12-03 11:44:35.306 DEBUG 4052 --- [io-10002-exec-2] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
lun                                                                            i
v@softserveinc.com
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.passw                                     o
rd as password8_18_2_, user2_.role_id as role_id12_18_2_, user2_.signup_date as
signup_d9_18_2_, user2_.state as state10_18_2_, user2_.tenant_id as tenant_13_18
_2_, role3_.id as id1_10_3_, role3_.description as descript2_10_3_, role3_.level
 as level3_10_3_, role3_.name as name4_10_3_, permission4_.role_id as role_id1_1
0_4_, permission5_.id as permissi2_9_4_, permission5_.id as id1_6_5_, permission
5_.description as descript2_6_5_, permission5_.name as name3_6_5_, tenant6_.id a
s id1_17_6_, tenant6_.is_active as is_activ2_17_6_, tenant6_.admin_id as admin_i
d5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.subscription_id as subscrip6_17
_6_, tenant6_.title as title4_17_6_, subscripti7_.id as id1_15_7_, subscripti7_.
expiration_date as expirati2_15_7_, subscripti7_.issue_date as issue_da3_15_7_,
subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.plan_id as plan_
id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_business_units a
s availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_, subscripti8_
.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subscript
i8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_u
sers user1_ on tenant0_.admin_id=user1_.id left outer join vzr_users user2_ on u
ser1_.assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.role_id=r
ole3_.id left outer join vzr_role_permissions permission4_ on role3_.id=permissi
on4_.role_id left outer join vzr_permissions permission5_ on permission4_.permis
sion_id=permission5_.id left outer join vzr_tenants tenant6_ on user2_.tenant_id
=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.subscrip
tion_id=subscripti7_.id left outer join vzr_subscription_plans subscripti8_ on s
ubscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_         ,
 subscripti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl
2_14_1_, subscripti1_.available_users as availabl3_14_1_, subscripti1_.available
_vizis as availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_pub
lic as is_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_s
ubscription_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where sub
scripti0_.id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as                                                 s
ubscrip6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.id as id1_15_7_, su
bscripti7_.expiration_date as expirati2_15_7_, subscripti7_.issue_date as issue_
da3_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.plan_
id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_busin
ess_units as availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_, s
ubscripti8_.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_
, subscripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer
 join vzr_users user1_ on tenant0_.admin_id=user1_.id left outer join vzr_users
user2_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on user2
_.role_id=role3_.id left outer join vzr_role_permissions permission4_ on role3_.
id=permission4_.role_id left outer join vzr_permissions permission5_ on permissi
on4_.permission_id=permission5_.id left outer join vzr_tenants tenant6_ on user2
_.tenant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tenant
6_.subscription_id=subscripti7_.id left outer join vzr_subscription_plans subscr
ipti8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:44:35.343 DEBUG 4052 --- [o-10002-exec-10] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, su                                             b
scripti0_.plan_id as plan_id5_15_0_, subscripti1_.id as id1_14_1_, subscripti1_.
available_business_units as availabl2_14_1_, subscripti1_.available_users as ava
ilabl3_14_1_, subscripti1_.available_vizis as availabl4_14_1_, subscripti1_.name
 as name5_14_1_, subscripti1_.is_public as is_publi6_14_1_ from vzr_subscription
s subscripti0_ left outer join vzr_subscription_plans subscripti1_ on subscripti
0_.plan_id=subscripti1_.id where subscripti0_.id=?
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:44:35.352 DEBUG 4052 --- [io-10002-exec-2] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0                 _
.permission_id=permission1_.id where permission0_.role_id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as las
t_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_
8_, subscripti8_.available_business_units as availabl2_14_8_, subs             c
ripti8_.available_users as availabl3_14_8_, subscripti8_.available_vizis as avai
labl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_public as is_publ
i6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users user1_ on tenant0_.
admin_id=user1_.id left outer join vzr_users user2_ on user1_.assigned_to=user2_
.id left outer join vzr_roles role3_ on user2_.role_id=role3_.id left outer join
 vzr_role_permissions permission4_ on role3_.id=permission4_.role_id left outer
join vzr_permissions permission5_ on permission4_.permission_id=permission5_.id
left outer join vzr_tenants tenant6_ on user2_.tenant_id=tenant6_.id left outer
join vzr_subscriptions subscripti7_ on tenant6_.subscription_id=subscripti7_.id
left outer join vzr_subscription_plans subscripti8_ on subscripti7_.plan_id=subs
cripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:44:35.378 DEBUG 4052 --- [io-10002-exec-1] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
2015-12-03 11:44:35.381 DEBUG 4052 --- [o-10002-exec-10] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
2015-12-03 11:44:35.397 DEBUG 4052 --- [io-10002-exec-9] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_publi      c
 as is_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subs
cription_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscr
ipti0_.id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as las
t_pay4_15_7_, subscripti7_.plan_id
as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_business
_units as availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_, subs
cripti8_.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, s
ubscripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer jo
in vzr_users user1_ on tenant0_.admin_id=user1_.id left outer join vzr_users use
r2_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.r
ole_id=role3_.id left outer join vzr_role_permissions permission4_ on role3_.id=
permission4_.role_id left outer join vzr_permissions permission5_ on permission4
_.permission_id=permission5_.id left outer join vzr_tenants tenant6_ on user2_.t
enant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.
subscription_id=subscripti7_.id left outer join vzr_subscription_plans subscript
i8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select businessun0_.id as id1_1_, businessun0_.color_scheme as color_
sc2_1_, businessun0_.description as descript3_1_, businessun0_.email as email4_1
_, businessun0_.font_face as font_fac5_1_, businessun0_.guid as guid6_1_, busine
ssun0_.name as name7_1_, businessun0_.phone as phone8_1_, businessun0_.state as
state9_1_, businessun0_.tenant_id as tenant_12_1_, businessun0_.video_url as vid
eo_u10_1_, businessun0_.website as website11_1_ from vzr_business_units business
un0_ where businessun0_.tenant_id=?
Hibernate: select style0_.id as id1_13_, style0_.color_scheme as color_sc2_13_,
style0_.font_face as font_fac3_13_, style0_.tenant_id as tenant_i5_13_, style0_.
title as title4_13_ from vzr_styles style0_ where style0_.tenant_id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.r                                             o
le_id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_1     7
_6_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_
7_, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date a
s last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id
1_14_8_, subscripti8_.available_business_units as availabl2_14_8_, subscripti8_.
available_users as availabl3_14_8_, subscripti8_.available_vizis as availabl4_14
_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_public as is_publi6_14_8_
 from vzr_tenants tenant0_ left outer join vzr_users user1_ on tenant0_.admin_id
=user1_.id left outer join vzr_users user2_ on user1_.assigned_to=user2_.id left
 outer join vzr_roles role3_ on user2_.role_id=role3_.id left outer join vzr_rol
e_permissions permission4_ on role3_.id=permission4_.role_id left outer join vzr
_permissions permission5_ on permission4_.permission_id=permission5_.id left out
er join vzr_tenants tenant6_ on user2_.tenant_id=tenant6_.id left outer join vzr
_subscriptions subscripti7_ on tenant6_.subscription_id=subscripti7_.id left out
er join vzr_subscription_plans subscripti8_ on subscripti7_.plan_id=subscripti8_
.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
2015-12-03 11:44:35.432 DEBUG 4052 --- [io-10002-exec-2] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:44:35.436 DEBUG 4052 --- [io-10002-exec-4] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select role0_.id as id1_10_0_, role0_.description as descript2_10_0_,
 role0_.level as level3_10_0_, role0_.name as name4_10_0_, permission1_.role_id
as role_id1_10_1_, permission2_.id as permissi2_9_1_, permission2_.id as id1_6_2
_, permission2_.description as descript2_6_2_, permission2_.name as name3_6_2_ f
rom vzr_roles role0_ left outer join vzr_role_permissions permission1_ on role0_
.id=permission1_.role_id left outer join vzr_permissions permission2_ on permiss
ion1_.permission_id=permission2_.id where role0_.id=?
2015-12-03 11:44:35.503 DEBUG 4052 --- [o-10002-exec-10] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authoriz    e
d: mluniv@softserveinc.com
Hibernate: select links0_.business_unit_id as business3_1_0_, links0_.id as id1_
0_0_, links0_.id as id1_0_1_, links0_.business_unit_id as business3_0_1_, links0
_.network_id as network_4_0_1_, links0_.url as url2_0_1_, socialnetw1_.id as id1
_12_2_, socialnetw1_.icon as icon2_12_2_, socialnetw1_.name as name3_12_2_, soci
alnetw1_.base_url as base_url4_12_2_ from vzr_business_unit_social_links links0_
 left outer join vzr_social_networks socialnetw1_ on links0_.network_id=socialne
tw1_.id where links0_.business_unit_id=?
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:44:35.512 DEBUG 4052 --- [io-10002-exec-4] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select contentref0_.id as id1_2_, contentref0_.content_type as conten
t_2_2_, contentref0_.creation_date as creation3_2_, contentref0_.file_extension
as file_ext4_2_, contentref0_.hash as hash5_                                   2
_, contentref0_.object_id as object_i6_2_, contentref0_.object_type as object_t7
_2_, contentref0_.order_num as order_nu8_2_ from vzr_content_ref contentref0_ wh
ere contentref0_.object_type=? and contentref0_.object_id=? and contentref0_.con
tent_type=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da                                             3
_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.plan_id
as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_business
_units as availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_, subs
cripti8_.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, s
ubscripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer jo
in vzr_users user1_ on tenant0_.admin_id=user1_.id left outer join vzr_users use
r2_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.r
ole_id=role3_.id left outer join vzr_role_permissions permission4_ on role3_.id=
permission4_.role_id left outer join vzr_permissions permission5_ on permission4
_.permission_id=permission5_.id left outer join vzr_tenants tenant6_ on user2_.t
enant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.
subscription_id=subscripti7_.id left outer join vzr_subscription_plans subscript
i8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:44:35.585 DEBUG 4052 --- [io-10002-exec-4] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:44:38.455 DEBUG 4052 --- [io-10002-exec-5] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as las
t_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_
8_, subscripti8_.available_business_units as availabl2_14_8_, subscripti8_.avail
able_users as availabl3_14_8_, subscripti8_.avai                               l
able_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is
_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users u
ser1_ on tenant0_.admin_id=user1_.id left outer join vzr_users user2_ on user1_.
assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.role_id=role3_.
id left outer join vzr_role_permissions permission4_ on role3_.id=permission4_.r
ole_id left outer join vzr_permissions permission5_ on permission4_.permission_i
d=permission5_.id left outer join vzr_tenants tenant6_ on user2_.tenant_id=tenan
t6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.subscription_i
d=subscripti7_.id left outer join vzr_subscription_plans subscripti8_ on subscri
pti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:44:38.473 DEBUG 4052 --- [io-10002-exec-5] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
t                                                                              e
=?, user_id=?, value=? where id=?
2015-12-03 11:44:38.484 DEBUG 4052 --- [io-10002-exec-5] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3                                           _
18_2_, user2_.email as email4_18_2_, user2_.first_name as first_na5_18_2_, user2
_.last_name as last_nam6_18_2_, user2_.notifications as notifica7_18_2_, user2_.
password as password8_18_2_, user2_.role_id as role_id12_18_2_, user2_.signup_da
te as signup_d9_18_2_, user2_.state as state10_18_2_, user2_.tenant_id as tenant
_13_18_2_, role3_.id as id1_10_3_, role3_.description as descript2_10_3_, role3_
.level as level3_10_3_, role3_.name as name4_10_3_, permission4_.role_id as role
_id1_10_4_, permission5_.id as permissi2_9_4_, permission5_.id as id1_6_5_, perm
ission5_.description as descript2_6_5_, permission5_.name as name3_6_5_, tenant6
_.id as id1_17_6_, tenant6_.is_active as is_activ2_17_6_, tenant6_.admin_id as a
dmin_id5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.subscription_id as subscr
ip6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.id as id1_15_7_, subscri
pti7_.expiration_date as expirati2_15_7_, subscripti7_.issue_date as issue_da3_1
5_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.plan_id as
 plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_business_u
nits as availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_, subscr
ipti8_.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, sub
scripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join
 vzr_users user1_ on tenant0_.admin_id=user1_.id left outer join vzr_users user2
_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.rol
e_id=role3_.id left outer join vzr_role_permissions permission4_ on role3_.id=pe
rmission4_.role_id left outer join vzr_permissions permission5_ on permission4_.
permission_id=permission5_.id left outer join vzr_tenants tenant6_ on user2_.ten
ant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.su
bscription_id=subscripti7_.id left outer join vzr_subscription_plans subscripti8
_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
2015-12-03 11:44:38.490 DEBUG 4052 --- [io-10002-exec-3] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner joi         n
 vzr_roles role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as las
t_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_
8_, subscripti8_.available_business_units as availabl                          2
_14_8_, subscripti8_.available_users as availabl3_14_8_, subscripti8_.available_
vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_publ
ic as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users user1_
 on tenant0_.admin_id=user1_.id left outer join vzr_users user2_ on user1_.assig
ned_to=user2_.id left outer join vzr_roles role3_ on user2_.role_id=role3_.id le
ft outer join vzr_role_permissions permission4_ on role3_.id=permission4_.role_i
d left outer join vzr_permissions permission5_ on permission4_.permission_id=per
mission5_.id left outer join vzr_tenants tenant6_ on user2_.tenant_id=tenant6_.i
d left outer join vzr_subscriptions subscripti7_ on tenant6_.subscription_id=sub
scripti7_.id left outer join vzr_subscription_plans subscripti8_ on subscripti7_
.plan_id=subscripti8_.id where tenant0_.id=?
2015-12-03 11:44:38.503 DEBUG 4052 --- [io-10002-exec-5] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner
join vzr_permissions permission1_ on permission0_.permission_id=permission1_.id
where permission0_.role_id=?
2015-12-03 11:44:38.523 DEBUG 4052 --- [io-10002-exec-3] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:44:38.527 DEBUG 4052 --- [io-10002-exec-3] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name a                   s
 last_nam6_18_1_, user1_.notifications as notifica7_18_1_, user1_.password as pa
ssword8_18_1_, user1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d
9_18_1_, user1_.state as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, use
r2_.id as id1_18_2_, user2_.assigned_to as assigne11_18_2_, user2_.registration_
key as registra2_18_2_, user2_.create_date as create_d3_18_2_, user2_.email as e
mail4_18_2_, user2_.first_name as first_na5_18_2_, user2_.last_name as last_nam6
_18_2_, user2_.notifications as notifica7_18_2_, user2_.password as password8_18
_2_, user2_.role_id as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, u
ser2_.state as state10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as
id1_10_3_, role3_.description as descript2_10_3_, role3_.level as level3_10_3_,
role3_.name as name4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_
.id as permissi2_9_4_, permission5_.id as id1_6_5_, permission5_.description as
descript2_6_5_, permission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenan
t6_.is_active as is_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_
.guid as guid3_17_6_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.titl
e as title4_17_6_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as
 expirati2_15_7_, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_
payment_date as last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscri
pti8_.id as id1_14_8_, subscripti8_.available_business_units as availabl2_14_8_,
 subscripti8_.available_users as availabl3_14_8_, subscripti8_.available_vizis a
s availabl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_public as i
s_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users user1_ on ten
ant0_.admin_id=user1_.id left outer join vzr_users user2_ on user1_.assigned_to=
user2_.id left outer join vzr_roles role3_ on user2_.role_id=role3_.id left oute
r join vzr_role_permissions permission4_ on role3_.id=permission4_.role_id left
outer join vzr_permissions permission5_ on perm                                i
ssion4_.permission_id=permission5_.id left outer join vzr_tenants tenant6_ on us
er2_.tenant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on ten
ant6_.subscription_id=subscripti7_.id left outer join vzr_subscription_plans sub
scripti8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:44:38.549 DEBUG 4052 --- [io-10002-exec-3] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:45:05.735 DEBUG 4052 --- [io-10002-exec-6] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as las
t_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_
8_, subscripti8_.available_business_units as availabl2_14_8_, subscripti8_.avail
able_users as availabl3_14_8_, subscripti8_.avai                               l
able_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is
_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users u
ser1_ on tenant0_.admin_id=user1_.id left outer join vzr_users user2_ on user1_.
assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.role_id=role3_.
id left outer join vzr_role_permissions permission4_ on role3_.id=permission4_.r
ole_id left outer join vzr_permissions permission5_ on permission4_.permission_i
d=permission5_.id left outer join vzr_tenants tenant6_ on user2_.tenant_id=tenan
t6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.subscription_i
d=subscripti7_.id left outer join vzr_subscription_plans subscripti8_ on subscri
pti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:45:05.748 DEBUG 4052 --- [io-10002-exec-6] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
t                                                                              e
=?, user_id=?, value=? where id=?
2015-12-03 11:45:05.753 DEBUG 4052 --- [io-10002-exec-6] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3                                           _
18_2_, user2_.email as email4_18_2_, user2_.first_name as first_na5_18_2_, user2
_.last_name as last_nam6_18_2_, user2_.notifications as notifica7_18_2_, user2_.
password as password8_18_2_, user2_.role_id as role_id12_18_2_, user2_.signup_da
te as signup_d9_18_2_, user2_.state as state10_18_2_, user2_.tenant_id as tenant
_13_18_2_, role3_.id as id1_10_3_, role3_.description as descript2_10_3_, role3_
.level as level3_10_3_, role3_.name as name4_10_3_, permission4_.role_id as role
_id1_10_4_, permission5_.id as permissi2_9_4_, permission5_.id as id1_6_5_, perm
ission5_.description as descript2_6_5_, permission5_.name as name3_6_5_, tenant6
_.id as id1_17_6_, tenant6_.is_active as is_activ2_17_6_, tenant6_.admin_id as a
dmin_id5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.subscription_id as subscr
ip6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.id as id1_15_7_, subscri
pti7_.expiration_date as expirati2_15_7_, subscripti7_.issue_date as issue_da3_1
5_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.plan_id as
 plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_business_u
nits as availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_, subscr
ipti8_.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, sub
scripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join
 vzr_users user1_ on tenant0_.admin_id=user1_.id left outer join vzr_users user2
_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.rol
e_id=role3_.id left outer join vzr_role_permissions permission4_ on role3_.id=pe
rmission4_.role_id left outer join vzr_permissions permission5_ on permission4_.
permission_id=permission5_.id left outer join vzr_tenants tenant6_ on user2_.ten
ant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.su
bscription_id=subscripti7_.id left outer join vzr_subscription_plans subscripti8
_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:45:05.766 DEBUG 4052 --- [io-10002-exec-6] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select style0_.id as id1_13_, style0_.color_scheme as color_sc2_13_,
style0_.font_face as font_fac3_13_, style0_.tenant_id as tenant_i5_13_, style0_.
title as title4_13_ from vzr_styles style0_ where style0_.tenant_id=?
2015-12-03 11:45:33.248 DEBUG 4052 --- [io-10002-exec-8] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token null
2015-12-03 11:45:33.266 DEBUG 4052 --- [io-10002-exec-7] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2                _
, user2_.role_id as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user
2_.state as state10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1
_10_3_, role3_.description as descript2_10_3_, role3_.level as level3_10_3_, rol
e3_.name as name4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id
 as permissi2_9_4_, permission5_.id as id1_6_5_, permission5_.description as des
cript2_6_5_, permission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_
.is_active as is_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.gu
id as guid3_17_6_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title a
s title4_17_6_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as ex
pirati2_15_7_, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_pay
ment_date as last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti
8_.id as id1_14_8_, subscripti8_.available_business_units as availabl2_14_8_, su
bscripti8_.available_users as availabl3_14_8_, subscripti8_.available_vizis as a
vailabl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_public as is_p
ubli6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users user1_ on tenant
0_.admin_id=user1_.id left outer join vzr_users user2_ on user1_.assigned_to=use
r2_.id left outer join vzr_roles role3_ on user2_.role_id=role3_.id left outer j
oin vzr_role_permissions permission4_ on role3_.id=permission4_.role_id left out
er join vzr_permissions permission5_ on permission4_.permission_id=permission5_.
id left outer join vzr_tenants tenant6_ on user2_.tenant_id=tenant6_.id left out
er join vzr_subscriptions subscripti7_ on tenant6_.subscription_id=subscripti7_.
id left outer join vzr_subscription_plans subscripti8_ on subscripti7_.plan_id=s
ubscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as                                                                     i
d1_14_1_, subscripti1_.available_business_units as availabl2_14_1_, subscripti1_
.available_users as availabl3_14_1_, subscripti1_.available_vizis as availabl4_1
4_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is_publi6_14_1
_ from vzr_subscriptions subscripti0_ left outer join vzr_subscription_plans sub
scripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:45:33.276 DEBUG 4052 --- [io-10002-exec-7] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:45:33.279 DEBUG 4052 --- [io-10002-exec-7] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_                                           2
_ from vzr_persistent_tokens persistent0_ inner join vzr_users user1_ on persist
ent0_.user_id=user1_.id inner join vzr_roles role2_ on user1_.role_id=role2_.id
where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as las
t_pay4_15_7_, subsc                                                            r
ipti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.ava
ilable_business_units as availabl2_14_8_, subscripti8_.available_users as availa
bl3_14_8_, subscripti8_.available_vizis as availabl4_14_8_, subscripti8_.name as
 name5_14_8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0
_ left outer join vzr_users user1_ on tenant0_.admin_id=user1_.id left outer joi
n vzr_users user2_ on user1_.assigned_to=user2_.id left outer join vzr_roles rol
e3_ on user2_.role_id=role3_.id left outer join vzr_role_permissions permission4
_ on role3_.id=permission4_.role_id left outer join vzr_permissions permission5_
 on permission4_.permission_id=permission5_.id left outer join vzr_tenants tenan
t6_ on user2_.tenant_id=tenant6_.id left outer join vzr_subscriptions subscripti
7_ on tenant6_.subscription_id=subscripti7_.id left outer join vzr_subscription_
plans subscripti8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:45:33.294 DEBUG 4052 --- [io-10002-exec-7] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:45:33.299 DEBUG 4052 --- [io-10002-exec-7] c.v.backoffice.web.rest
.ViziResource     : Attempting to construct and save vizi. Need publish: true
Hibernate: select businessun0_.id as id1_1_, businessun0_.color_scheme as color_
sc2_1_, businessun0_.description as descript3_1_, businessun0_.email as email4_1
_, businessun0_.font_face as font_fac5_1_, businessun0_.guid as guid6_1_, busine
ssun0_.name as name7_1_, businessun0_.phone as phone8_1_, businessun0_.state as
state9_1_, businessun0_.tenant_id as tenant_12_1_, businessun0_.video_url as vid
eo_u10_1_, businessun0_.website as website11_1_ from vzr_business_units business
un0_ where businessun0_.id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as ten                                             a
nt_13_18_2_, role3_.id as id1_10_3_, role3_.description as descript2_10_3_, role
3_.level as level3_10_3_, role3_.name as name4_10_3_, permission4_.role_id as ro
le_id1_10_4_, permission5_.id as permissi2_9_4_, permission5_.id as id1_6_5_, pe
rmission5_.description as descript2_6_5_, permission5_.name as name3_6_5_, tenan
t6_.id as id1_17_6_, tenant6_.is_active as is_activ2_17_6_, tenant6_.admin_id as
 admin_id5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.subscription_id as subs
crip6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.id as id1_15_7_, subsc
ripti7_.expiration_date as expirati2_15_7_, subscripti7_.issue_date as issue_da3
_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.plan_id
as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_business
_units as availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_, subs
cripti8_.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, s
ubscripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer jo
in vzr_users user1_ on tenant0_.admin_id=user1_.id left outer join vzr_users use
r2_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.r
ole_id=role3_.id left outer join vzr_role_permissions permission4_ on role3_.id=
permission4_.role_id left outer join vzr_permissions permission5_ on permission4
_.permission_id=permission5_.id left outer join vzr_tenants tenant6_ on user2_.t
enant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.
subscription_id=subscripti7_.id left outer join vzr_subscription_plans subscript
i8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.                 a
vailable_vizis as availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1
_.is_public as is_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer jo
in vzr_subscription_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id w
here subscripti0_.id=?
Hibernate: select role0_.id as id1_10_0_, role0_.description as descript2_10_0_,
 role0_.level as level3_10_0_, role0_.name as name4_10_0_, permission1_.role_id
as role_id1_10_1_, permission2_.id as permissi2_9_1_, permission2_.id as id1_6_2
_, permission2_.description as descript2_6_2_, permission2_.name as name3_6_2_ f
rom vzr_roles role0_ left outer join vzr_role_permissions permission1_ on role0_
.id=permission1_.role_id left outer join vzr_permissions permission2_ on permiss
ion1_.permission_id=permission2_.id where role0_.id=?
Hibernate: select section0_.id as id1_11_, section0_.order as order2_11_, sectio
n0_.title as title3_11_ from vzr_sections section0_ where section0_.id=?
Hibernate: select section0_.id as id1_11_, section0_.order as order2_11_, sectio
n0_.title as title3_11_ from vzr_sections section0_ where section0_.id=?
Hibernate: select section0_.id as id1_11_, section0_.order as order2_11_, sectio
n0_.title as title3_11_ from vzr_sections section0_ where section0_.id=?
Hibernate: insert into vzr_vizis (apply_link, assignee_id, background_photo, bus
iness_unit_id, color_scheme, compensation, config, creation_date, expiration_dat
e, font_face, guid, inactive_link, industry, introduction, issue_date, job_famil
y, level, link, address, location, requisition_number, state, storage_key, templ
ate, tenant_id, title) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into vzr_vizi_sections (description, section_id, vizi_id) valu
es (?, ?, ?)
Hibernate: insert into vzr_vizi_sections (description, section_id, vizi_id) valu
es (?, ?, ?)
Hibernate: insert into vzr_vizi_sections (description, section_id, vizi_id) valu
es (?, ?, ?)
Hibernate: select vizi0_.id as id1_21_, vizi0_.apply_link as apply_li2_21_, vizi
0_.assignee_id as assigne25_21_, vizi0_.background_photo as backgrou3_21_, vizi0
_.business_unit_id as busines26_21_, vizi0_.color_scheme as color_sc4_21_, vizi0
_.compensation as compensa5_21_, vizi0_.config as config6_21_, vizi0_.creation_d
ate as creation7_21_, vizi0_.expiration_date as expirati8_21_, vizi0_.font_face
as font_fac9_21_, vizi0_.guid as guid10_21_, vizi0_.inactive_link as inactiv11_2
1_, vizi0_.industry as industr12_21_, vizi0_.introduction as introdu13_21_, vizi
0_.issue_date as issue_d14_21_, vizi0_.job_family as job_fam15_21_, vizi0_.level
 as level16_21_, vizi0_.link as link17_21_, vizi0_.address as address18_21_, viz
i0_.location as locatio19_21_, vizi0_.requisition_number as requisi20_21_, vizi0
_.state as state21_21_, vizi0_.storage_key as storage22_21_, vizi0_.template as
templat23_21_, vizi0_.tenant_id as tenant_27_21_, vizi0_.title as title24_21_ fr
om vzr_vizis vizi0_ where vizi0_.id=? and vizi0_.tenant_id=? limit ?
2015-12-03 11:45:33.372  WARN 4052 --- [io-10002-exec-7] c.amazonaws.services.s3
.AmazonS3Client   : No content length specified for stream data.  Stream content
s will be buffered in memory and could result in out of memory errors.
2015-12-03 11:45:34.579  WARN 4052 --- [io-10002-exec-7] c.amazonaws.services.s3
.AmazonS3Client   : No content length specified for stream data.  Stream content
s will be buffered in memory and could result in out of memory errors.
Hibernate: update vzr_vizis set apply_link=?, assignee_id=?, business_unit_id=?,
 compensation=?, config=?, creation_date=?, expiration_date=?, guid=?, inactive_
link=?, industry=?, introduction=?, issue_date=?, job_family=?, level=?, link=?,
 address=?, location=?, requisition_number=?, state=?, storage_key=?, template=?
, tenant_id=?, title=? where id=?
2015-12-03 11:45:35.594 DEBUG 4052 --- [io-10002-exec-7] c.v.backoffice.web.rest
.ViziResource     : Vizi #19 has been successfully published. Result url: /Chard
e-Foreman-1/Magnam-q-Et-no/index.html
2015-12-03 11:45:35.695 DEBUG 4052 --- [io-10002-exec-9] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token null
2015-12-03 11:45:35.695 DEBUG 4052 --- [io-10002-exec-1] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token null
2015-12-03 11:45:35.704 DEBUG 4052 --- [io-10002-exec-2] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
2015-12-03 11:45:35.704 DEBUG 4052 --- [o-10002-exec-10] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token null
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assig                                                  n
e11_18_2_, user2_.registration_key as registra2_18_2_, user2_.create_date as cre
ate_d3_18_2_, user2_.email as email4_18_2_, user2_.first_name as first_na5_18_2_
, user2_.last_name as last_nam6_18_2_, user2_.notifications as notifica7_18_2_,
user2_.password as password8_18_2_, user2_.role_id as role_id12_18_2_, user2_.si
gnup_date as signup_d9_18_2_, user2_.state as state10_18_2_, user2_.tenant_id as
 tenant_13_18_2_, role3_.id as id1_10_3_, role3_.description as descript2_10_3_,
 role3_.level as level3_10_3_, role3_.name as name4_10_3_, permission4_.role_id
as role_id1_10_4_, permission5_.id as permissi2_9_4_, permission5_.id as id1_6_5
_, permission5_.description as descript2_6_5_, permission5_.name as name3_6_5_,
tenant6_.id as id1_17_6_, tenant6_.is_active as is_activ2_17_6_, tenant6_.admin_
id as admin_id5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.subscription_id as
 subscrip6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.id as id1_15_7_,
subscripti7_.expiration_date as expirati2_15_7_, subscripti7_.issue_date as issu
e_da3_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.pla
n_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_bus
iness_units as availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_,
 subscripti8_.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_
8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left out
er join vzr_users user1_ on tenant0_.admin_id=user1_.id left outer join vzr_user
s user2_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on use
r2_.role_id=role3_.id left outer join vzr_role_permissions permission4_ on role3
_.id=permission4_.role_id left outer join vzr_permissions permission5_ on permis
sion4_.permission_id=permission5_.id left outer join vzr_tenants tenant6_ on use
r2_.tenant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tena
nt6_.subscription_id=subscripti7_.id left outer join vzr_subscription_plans subs
cripti8_ on subscripti7_.plan_id=subscripti8_.i                                d
 where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
2015-12-03 11:45:35.713 DEBUG 4052 --- [io-10002-exec-2] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:45:35.716 DEBUG 4052 --- [io-10002-exec-2] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1                                                                             _
, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user1_.
signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_id
as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as level
3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ inne
r join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_roles r
ole2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.gui              d
 as guid3_17_6_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as
title4_17_6_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expi
rati2_15_7_, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payme
nt_date as last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_
.id as id1_14_8_, subscripti8_.available_business_units as availabl2_14_8_, subs
cripti8_.available_users as availabl3_14_8_, subscripti8_.available_vizis as ava
ilabl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_public as is_pub
li6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users user1_ on tenant0_
.admin_id=user1_.id left outer join vzr_users user2_ on user1_.assigned_to=user2
_.id left outer join vzr_roles role3_ on user2_.role_id=role3_.id left outer joi
n vzr_role_permissions permission4_ on role3_.id=permission4_.role_id left outer
 join vzr_permissions permission5_ on permission4_.permission_id=permission5_.id
 left outer join vzr_tenants tenant6_ on user2_.tenant_id=tenant6_.id left outer
 join vzr_subscriptions subscripti7_ on tenant6_.subscription_id=subscripti7_.id
 left outer join vzr_subscription_plans subscripti8_ on subscripti7_.plan_id=sub
scripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descr                                                                         i
pt2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permission0_
 inner join vzr_permissions permission1_ on permission0_.permission_id=permissio
n1_.id where permission0_.role_id=?
2015-12-03 11:45:35.728 DEBUG 4052 --- [io-10002-exec-2] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select businessun0_.id as id1_1_, businessun0_.color_scheme as color_
sc2_1_, businessun0_.description as descript3_1_, businessun0_.email as email4_1
_, businessun0_.font_face as font_fac5_1_, businessun0_.guid as guid6_1_, busine
ssun0_.name as name7_1_, businessun0_.phone as phone8_1_, businessun0_.state as
state9_1_, businessun0_.tenant_id as tenant_12_1_, businessun0_.video_url as vid
eo_u10_1_, businessun0_.website as website11_1_ from vzr_business_units business
un0_ where businessun0_.tenant_id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_       .
role_id as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state
as state10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, r
ole3_.description as descript2_10_3_, role3_.level as level3_10_3_, role3_.name
as name4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permi
ssi2_9_4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_
5_, permission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_activ
e as is_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as gui
d3_17_6_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_
17_6_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_1
5_7_, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date
 as last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as
id1_14_8_, subscripti8_.available_business_units as availabl2_14_8_, subscripti8
_.available_users as availabl3_14_8_, subscripti8_.available_vizis as availabl4_
14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_public as is_publi6_14_
8_ from vzr_tenants tenant0_ left outer join vzr_users user1_ on tenant0_.admin_
id=user1_.id left outer join vzr_users user2_ on user1_.assigned_to=user2_.id le
ft outer join vzr_roles role3_ on user2_.role_id=role3_.id left outer join vzr_r
ole_permissions permission4_ on role3_.id=permission4_.role_id left outer join v
zr_permissions permission5_ on permission4_.permission_id=permission5_.id left o
uter join vzr_tenants tenant6_ on user2_.tenant_id=tenant6_.id left outer join v
zr_subscriptions subscripti7_ on tenant6_.subscription_id=subscripti7_.id left o
uter join vzr_subscription_plans subscripti8_ on subscripti7_.plan_id=subscripti
8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_                                                           ,
 subscripti1_.available_business_units as availabl2_14_1_, subscripti1_.availabl
e_users as availabl3_14_1_, subscripti1_.available_vizis as availabl4_14_1_, sub
scripti1_.name as name5_14_1_, subscripti1_.is_public as is_publi6_14_1_ from vz
r_subscriptions subscripti0_ left outer join vzr_subscription_plans subscripti1_
 on subscripti0_.plan_id=subscripti1_.id where subscripti0_.id=?
Hibernate: select role0_.id as id1_10_0_, role0_.description as descript2_10_0_,
 role0_.level as level3_10_0_, role0_.name as name4_10_0_, permission1_.role_id
as role_id1_10_1_, permission2_.id as permissi2_9_1_, permission2_.id as id1_6_2
_, permission2_.description as descript2_6_2_, permission2_.name as name3_6_2_ f
rom vzr_roles role0_ left outer join vzr_role_permissions permission1_ on role0_
.id=permission1_.role_id left outer join vzr_permissions permission2_ on permiss
ion1_.permission_id=permission2_.id where role0_.id=?
Hibernate: select links0_.business_unit_id as business3_1_0_, links0_.id as id1_
0_0_, links0_.id as id1_0_1_, links0_.business_unit_id as business3_0_1_, links0
_.network_id as network_4_0_1_, links0_.url as url2_0_1_, socialnetw1_.id as id1
_12_2_, socialnetw1_.icon as icon2_12_2_, socialnetw1_.name as name3_12_2_, soci
alnetw1_.base_url as base_url4_12_2_ from vzr_business_unit_social_links links0_
 left outer join vzr_social_networks socialnetw1_ on links0_.network_id=socialne
tw1_.id where links0_.business_unit_id=?
Hibernate: select contentref0_.id as id1_2_, contentref0_.content_type as conten
t_2_2_, contentref0_.creation_date as creation3_2_, contentref0_.file_extension
as file_ext4_2_, contentref0_.hash as hash5_2_, contentref0_.object_id as object
_i6_2_, contentref0_.object_type as object_t7_2_, contentref0_.order_num as orde
r_nu8_2_ from vzr_content_ref contentref0_ where contentref0_.object_type=? and
contentref0_.object_id=? and contentref0_.content_type=?
2015-12-03 11:45:35.858 DEBUG 4052 --- [io-10002-exec-3] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as las
t_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_
8_, subscripti8_.available_business_units as availabl2_14_8_, subscripti8_.avail
able_users as availabl3_14_8_, subscripti8_.avai                               l
able_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is
_public as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users u
ser1_ on tenant0_.admin_id=user1_.id left outer join vzr_users user2_ on user1_.
assigned_to=user2_.id left outer join vzr_roles role3_ on user2_.role_id=role3_.
id left outer join vzr_role_permissions permission4_ on role3_.id=permission4_.r
ole_id left outer join vzr_permissions permission5_ on permission4_.permission_i
d=permission5_.id left outer join vzr_tenants tenant6_ on user2_.tenant_id=tenan
t6_.id left outer join vzr_subscriptions subscripti7_ on tenant6_.subscription_i
d=subscripti7_.id left outer join vzr_subscription_plans subscripti8_ on subscri
pti7_.plan_id=subscripti8_.id where tenant0_.id=?
2015-12-03 11:45:35.861 DEBUG 4052 --- [io-10002-exec-4] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na 5
_18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_1
8_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, use
r1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant
_id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as l
evel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_
inner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_rol
es role2_ on user1_.role_id=role2_.id where persistent0_.value=?
2015-12-03 11:45:35.869 DEBUG 4052 --- [io-10002-exec-5] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmiss                                                                          i
on1_.id where permission0_.role_id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6
_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_,
subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, s
ubscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as las
t_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_
8_, subscripti8_.available_business_units as availabl2_14_8_, subscripti8_.avail
able_user                                                                      s
 as availabl3_14_8_, subscripti8_.available_vizis as availabl4_14_8_, subscripti
8_.name as name5_14_8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_tenan
ts tenant0_ left outer join vzr_users user1_ on tenant0_.admin_id=user1_.id left
 outer join vzr_users user2_ on user1_.assigned_to=user2_.id left outer join vzr
_roles role3_ on user2_.role_id=role3_.id left outer join vzr_role_permissions p
ermission4_ on role3_.id=permission4_.role_id left outer join vzr_permissions pe
rmission5_ on permission4_.permission_id=permission5_.id left outer join vzr_ten
ants tenant6_ on user2_.tenant_id=tenant6_.id left outer join vzr_subscriptions
subscripti7_ on tenant6_.subscription_id=subscripti7_.id left outer join vzr_sub
scription_plans subscripti8_ on subscripti7_.plan_id=subscripti8_.id where tenan
t0_.id=?
2015-12-03 11:45:35.883 DEBUG 4052 --- [io-10002-exec-3] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12                                                                  _
18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as state10_18_2_, use
r2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.description as
descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name4_10_3_, permi
ssion4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_4_, permission
5_.id as id1_6_5_, permission5_.description as descript2_6_5_, permission5_.name
 as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is_activ2_17_6_,
 tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.su
bscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.i
d as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, subscripti7_.is
sue_date as issue_da3_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_,
subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti
8_.available_business_units as availabl2_14_8_, subscripti8_.available_users as
availabl3_14_8_, subscripti8_.available_vizis as availabl4_14_8_, subscripti8_.n
ame as name5_14_8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_tenants t
enant0_ left outer join vzr_users user1_ on tenant0_.admin_id=user1_.id left out
er join vzr_users user2_ on user1_.assigned_to=user2_.id left outer join vzr_rol
es role3_ on user2_.role_id=role3_.id left outer join vzr_role_permissions permi
ssion4_ on role3_.id=permission4_.role_id left outer join vzr_permissions permis
sion5_ on permission4_.permission_id=permission5_.id left outer join vzr_tenants
 tenant6_ on user2_.tenant_id=tenant6_.id left outer join vzr_subscriptions subs
cripti7_ on tenant6_.subscription_id=subscripti7_.id left outer join vzr_subscri
ption_plans subscripti8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.
id=?
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayme                                                                           n
t_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscripti1_.
id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_, subsc
ripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as avai
labl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is_publ
i6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscription_pl
ans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_.id=?

Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
2015-12-03 11:45:35.910 DEBUG 4052 --- [io-10002-exec-3] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
2015-12-03 11:45:35.936 DEBUG 4052 --- [io-10002-exec-4] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_                    0
_, persistent0_.user_id as user_id6_7_0_, persistent0_.value as value5_7_0_, use
r1_.assigned_to as assigne11_18_1_, user1_.registration_key as registra2_18_1_,
user1_.create_date as create_d3_18_1_, user1_.email as email4_18_1_, user1_.firs
t_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, user1_.notificat
ions as notifica7_18_1_, user1_.password as password8_18_1_, user1_.role_id as r
ole_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.state as state10_1
8_1_, user1_.tenant_id as tenant_13_18_1_, role2_.description as descript2_10_2_
, role2_.level as level3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_t
okens persistent0_ inner join vzr_users user1_ on persistent0_.user_id=user1_.id
 inner join vzr_roles role2_ on user1_.role_id=role2_.id where persistent0_.valu
e=?
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_1                                                                          8
_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.descrip
tion as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name4_10_3
_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_4_, pe
rmission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, permissio
n5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is_activ
2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6_, ten
ant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_, subscr
ipti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, subscri
pti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as last_pay4
_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, su
bscripti8_.available_business_units as availabl2_14_8_, subscripti8_.available_u
sers as availabl3_14_8_, subscripti8_.available_vizis as availabl4_14_8_, subscr
ipti8_.name as name5_14_8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_t
enants tenant0_ left outer join vzr_users user1_ on tenant0_.admin_id=user1_.id
left outer join vzr_users user2_ on user1_.assigned_to=user2_.id left outer join
 vzr_roles role3_ on user2_.role_id=role3_.id left outer join vzr_role_permissio
ns permission4_ on role3_.id=permission4_.role_id left outer join vzr_permission
s permission5_ on permission4_.permission_id=permission5_.id left outer join vzr
_tenants tenant6_ on user2_.tenant_id=tenant6_.id left outer join vzr_subscripti
ons subscripti7_ on tenant6_.subscription_id=subscripti7_.id left outer join vzr
_subscription_plans subscripti8_ on subscripti7_.plan_id=subscripti8_.id where t
enant0_.id=?
2015-12-03 11:45:35.942 DEBUG 4052 --- [io-10002-exec-4] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_dat                                     e
 as token_da4_7_0_, persistent0_.user_id as user_id6_7_0_, persistent0_.value as
 value5_7_0_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as
registra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_1
8_1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_,
 user1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, us
er1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.s
tate as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, role2_.description a
s descript2_10_2_, role2_.level as level3_10_2_, role2_.name as name4_10_2_ from
 vzr_persistent_tokens persistent0_ inner join vzr_users user1_ on persistent0_.
user_id=user1_.id inner join vzr_roles role2_ on user1_.role_id=role2_.id where
persistent0_.value=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as                          t
itle4_17_0_, user1_.id as id1_18_1_, user1_.assigned_to as assigne11_18_1_, user
1_.registration_key as registra2_18_1_, user1_.create_date as create_d3_18_1_, u
ser1_.email as email4_18_1_, user1_.first_name as first_na5_18_1_, user1_.last_n
ame as last_nam6_18_1_, user1_.notifications as notifica7_18_1_, user1_.password
 as password8_18_1_, user1_.role_id as role_id12_18_1_, user1_.signup_date as si
gnup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_id as tenant_13_18_1
_, user2_.id as id1_18_2_, user2_.assigned_to as assigne11_18_2_, user2_.registr
ation_key as registra2_18_2_, user2_.create_date as create_d3_18_2_, user2_.emai
l as email4_18_2_, user2_.first_name as first_na5_18_2_, user2_.last_name as las
t_nam6_18_2_, user2_.notifications as notifica7_18_2_, user2_.password as passwo
rd8_18_2_, user2_.role_id as role_id12_18_2_, user2_.signup_date as signup_d9_18
_2_, user2_.state as state10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.
id as id1_10_3_, role3_.description as descript2_10_3_, role3_.level as level3_1
0_3_, role3_.name as name4_10_3_, permission4_.role_id as role_id1_10_4_, permis
sion5_.id as permissi2_9_4_, permission5_.id as id1_6_5_, permission5_.descripti
on as descript2_6_5_, permission5_.name as name3_6_5_, tenant6_.id as id1_17_6_,
 tenant6_.is_active as is_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, te
nant6_.guid as guid3_17_6_, tenant6_.subscription_id as subscrip6_17_6_, tenant6
_.title as title4_17_6_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_d
ate as expirati2_15_7_, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_
.last_payment_date as last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, s
ubscripti8_.id as id1_14_8_, subscripti8_.available_business_units as availabl2_
14_8_, subscripti8_.available_users as availabl3_14_8_, subscripti8_.available_v
izis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_publi
c as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users user1_
on tenant0_.admin_id=user1_.id left outer join                                 v
zr_users user2_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_
 on user2_.role_id=role3_.id left outer join vzr_role_permissions permission4_ o
n role3_.id=permission4_.role_id left outer join vzr_permissions permission5_ on
 permission4_.permission_id=permission5_.id left outer join vzr_tenants tenant6_
 on user2_.tenant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_
on tenant6_.subscription_id=subscripti7_.id left outer join vzr_subscription_pla
ns subscripti8_ on subscripti7_.plan_id=subscripti8_.id where tenant0_.id=?
2015-12-03 11:45:35.981 DEBUG 4052 --- [io-10002-exec-5] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, p                                                             e
rmission1_.name as name3_6_1_ from vzr_role_permissions permission0_ inner join
vzr_permissions permission1_ on permission0_.permission_id=permission1_.id where
 permission0_.role_id=?
2015-12-03 11:45:35.998 DEBUG 4052 --- [io-10002-exec-3] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:45:36.001 DEBUG 4052 --- [io-10002-exec-4] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
2015-12-03 11:45:36.006 DEBUG 4052 --- [io-10002-exec-5] c.v.c.w.filter.TokenAut
horizationFilter  : Validating token 4aeafc5df9864240bb7f7a59fa8f49bc
Hibernate: select persistent0_.id as id1_7_0_, user1_.id as id1_18_1_, role2_.id
 as id1_10_2_, persistent0_.ip_addr as ip_addr2_7_0_, persistent0_.modified_date
 as modified3_7_0_, persistent0_.token_date as token_da4_7_0_, persistent0_.user
_id as user_id6_7_0_, persistent0_.value as value5_7_0_, user1_.assigned_to as a
ssigne11_18_1_, user1_.registration_key as registra2_18_1_, user1_.create_date a
s create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_name as first_na5_
18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications as notifica7_18
_1_, user1_.password as password8_18_1_, user1_.role_id as role_id12_18_1_, user
1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_
id as tenant_13_18_1_, role2_.description as descript2_10_2_, role2_.level as le
vel3_10_2_, role2_.name as name4_10_2_ from vzr_persistent_tokens persistent0_ i
nner join vzr_users user1_ on persistent0_.user_id=user1_.id inner join vzr_role
s role2_ on user1_.role_id=role2_.id where persistent0_.value=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, t                                                                           e
nant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.subsc
ription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as id1_
18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as registr
a2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_1_, u
ser1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, user1_
.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user1_.ro
le_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.state as
 state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_, use
r2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18_2_,
user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_.firs
t_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.notificat
ions as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id as r
ole_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as state10_1
8_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.descri
ption as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name4_10_
3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_4_, p
ermission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, permissi
on5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is_acti
v2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_17_6_, te
nant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6_, subsc
ripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, subscr
ipti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as last_pay
4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, s
ubscripti8_.available_business_units as availabl2_14_8_, subscripti8_.available_
users as availabl3_14_8_, subscripti8_.available_vizis as availabl4_14_8_, subsc
ripti8_.name as name5_14_8_, subscripti8_.is_pu                                b
lic as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users user1
_ on tenant0_.admin_id=user1_.id left outer join vzr_users user2_ on user1_.assi
gned_to=user2_.id left outer join vzr_roles role3_ on user2_.role_id=role3_.id l
eft outer join vzr_role_permissions permission4_ on role3_.id=permission4_.role_
id left outer join vzr_permissions permission5_ on permission4_.permission_id=pe
rmission5_.id left outer join vzr_tenants tenant6_ on user2_.tenant_id=tenant6_.
id left outer join vzr_subscriptions subscripti7_ on tenant6_.subscription_id=su
bscripti7_.id left outer join vzr_subscription_plans subscripti8_ on subscripti7
_.plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select count(vizi0_.id) as col_0_0_ from vzr_vizis vizi0_ left outer
join vzr_business_units businessun1_ on vizi0_.business_unit_id=businessun1_.id
where vizi0_.tenant_id=? and vizi0_.state<>?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select vizi0_.id as id1_21_, vizi0_.apply_link as apply_li2_21_, vizi
0_.assignee_id as assigne25_21_, vizi0_.background_photo as backgrou3_21_, vizi0
_.business_unit_id as busines26_21_, vizi0_.color_scheme as color_sc4_21_, vizi0
_.compensation as compensa5_21_, vizi0_.config as config6_21_, vizi0_.creation_d
ate as creation7_21_, vizi0_.expiration_date as expirati8_21_, vizi0_.font_face
as font_fac9_21_, vizi0_.guid as guid10_21_, vizi0_.inactive_link as inactiv11_2
1_, vizi0_.industry as indu                                                    s
tr12_21_, vizi0_.introduction as introdu13_21_, vizi0_.issue_date as issue_d14_2
1_, vizi0_.job_family as job_fam15_21_, vizi0_.level as level16_21_, vizi0_.link
 as link17_21_, vizi0_.address as address18_21_, vizi0_.location as locatio19_21
_, vizi0_.requisition_number as requisi20_21_, vizi0_.state as state21_21_, vizi
0_.storage_key as storage22_21_, vizi0_.template as templat23_21_, vizi0_.tenant
_id as tenant_27_21_, vizi0_.title as title24_21_ from vzr_vizis vizi0_ left out
er join vzr_business_units businessun1_ on vizi0_.business_unit_id=businessun1_.
id where vizi0_.tenant_id=? and vizi0_.state<>? order by vizi0_.title asc, vizi0
_.id asc limit ?
Hibernate: select permission0_.role_id as role_id1_10_0_, permission0_.permissio
n_id as permissi2_9_0_, permission1_.id as id1_6_1_, permission1_.description as
 descript2_6_1_, permission1_.name as name3_6_1_ from vzr_role_permissions permi
ssion0_ inner join vzr_permissions permission1_ on permission0_.permission_id=pe
rmission1_.id where permission0_.role_id=?
Hibernate: select count(vizi0_.id) as col_0_0_ from vzr_vizis vizi0_ left outer
join vzr_business_units businessun1_ on vizi0_.business_unit_id=businessun1_.id
where vizi0_.tenant_id=? and vizi0_.state<>?
2015-12-03 11:45:36.031 DEBUG 4052 --- [io-10002-exec-5] .s.t.TransactionalPersi
stentTokenService : FOUND TOKEN: 4aeafc5df9864240bb7f7a59fa8f49bc. Authorized: m
luniv@softserveinc.com
Hibernate: update vzr_persistent_tokens set ip_addr=?, modified_date=?, token_da
te=?, user_id=?, value=? where id=?
Hibernate: select user0_.id as id1_18_0_, user0_.assigned_to as assigne11_18_0_,
 user0_.registration_key as registra2_18_0_, user0_.create_date as create_d3_18_
0_, user0_.email as email4_18_0_, user0_.first_name as first_na5_18_0_, user0_.l
ast_name as last_nam6_18_0_, user0_.notifications as notifica7_18_0_, user0_.pas
sword as password8_18_0_, user0_.role_id as role_id12_18_0_, user0_.signup_date
as signup_d9_18_0_, user0_.state as state10_18_0_, user0_.tenant_id as tenant_13
_18_0_, user1_.id as id1_18_1_, user1_                                         .
assigned_to as assigne11_18_1_, user1_.registration_key as registra2_18_1_, user
1_.create_date as create_d3_18_1_, user1_.email as email4_18_1_, user1_.first_na
me as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, user1_.notifications
 as notifica7_18_1_, user1_.password as password8_18_1_, user1_.role_id as role_
id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.state as state10_18_1_
, user1_.tenant_id as tenant_13_18_1_, role2_.id as id1_10_2_, role2_.descriptio
n as descript2_10_2_, role2_.level as level3_10_2_, role2_.name as name4_10_2_,
permission3_.role_id as role_id1_10_3_, permission4_.id as permissi2_9_3_, permi
ssion4_.id as id1_6_4_, permission4_.description as descript2_6_4_, permission4_
.name as name3_6_4_, tenant5_.id as id1_17_5_, tenant5_.is_active as is_activ2_1
7_5_, tenant5_.admin_id as admin_id5_17_5_, tenant5_.guid as guid3_17_5_, tenant
5_.subscription_id as subscrip6_17_5_, tenant5_.title as title4_17_5_, user6_.id
 as id1_18_6_, user6_.assigned_to as assigne11_18_6_, user6_.registration_key as
 registra2_18_6_, user6_.create_date as create_d3_18_6_, user6_.email as email4_
18_6_, user6_.first_name as first_na5_18_6_, user6_.last_name as last_nam6_18_6_
, user6_.notifications as notifica7_18_6_, user6_.password as password8_18_6_, u
ser6_.role_id as role_id12_18_6_, user6_.signup_date as signup_d9_18_6_, user6_.
state as state10_18_6_, user6_.tenant_id as tenant_13_18_6_, subscripti7_.id as
id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_, subscripti7_.issue_d
ate as issue_da3_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subsc
ripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.av
ailable_business_units as availabl2_14_8_, subscripti8_.available_users as avail
abl3_14_8_, subscripti8_.available_vizis as availabl4_14_8_, subscripti8_.name a
s name5_14_8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_users user0_ l
eft outer join vzr_users user1_ on user0_.assigned_to=user1_.id left outer join
vzr_roles role2_ on user1_.role_id=role2_.id le                                f
t outer join vzr_role_permissions permission3_ on role2_.id=permission3_.role_id
 left outer join vzr_permissions permission4_ on permission3_.permission_id=perm
ission4_.id left outer join vzr_tenants tenant5_ on user1_.tenant_id=tenant5_.id
 left outer join vzr_users user6_ on tenant5_.admin_id=user6_.id left outer join
 vzr_subscriptions subscripti7_ on tenant5_.subscription_id=subscripti7_.id left
 outer join vzr_subscription_plans subscripti8_ on subscripti7_.plan_id=subscrip
ti8_.id where user0_.id=?
Hibernate: select vizi0_.id as id1_21_, vizi0_.apply_link as apply_li2_21_, vizi
0_.assignee_id as assigne25_21_, vizi0_.background_photo as backgrou3_21_, vizi0
_.business_unit_id as busines26_21_, vizi0_.color_scheme as color_sc4_21_, vizi0
_.compensation as compensa5_21_, vizi0_.config as config6_21_, vizi0_.creation_d
ate as creation7_21_, vizi0_.expiration_date as expirati8_21_, vizi0_.font_face
as font_fac9_21_, vizi0_.guid as guid10_21_, vizi0_.inactive_link as inactiv11_2
1_, vizi0_.industry as industr12_21_, vizi0_.introduction as introdu13_21_, vizi
0_.issue_date as issue_d14_21_, vizi0_.job_family as job_fam15_21_, vizi0_.level
 as level16_21_, vizi0_.link as link17_21_, vizi0_.address as address18_21_, viz
i0_.location as locatio19_21_, vizi0_.requisition_number as requisi20_21_, vizi0
_.state as state21_21_, vizi0_.storage_key as storage22_21_, vizi0_.template as
templat23_21_, vizi0_.tenant_id as tenant_27_21_, vizi0_.title as title24_21_ fr
om vzr_vizis vizi0_ left outer join vzr_business_units businessun1_ on vizi0_.bu
siness_unit_id=businessun1_.id where vizi0_.tenant_id=? and vizi0_.state<>? orde
r by vizi0_.title asc limit ?
Hibernate: select role0_.id as id1_10_0_, role0_.description as descript2_10_0_,
 role0_.level as level3_10_0_, role0_.name as name4_10_0_, permission1_.role_id
as role_id1_10_1_, permission2_.id as permissi2_9_1_, permission2_.id as id1_6_2
_, permission2_.description as descript2_6_2_, permission2_.name as name3_6_2_ f
rom vzr_roles role0_ left outer join vzr_role_permissions permission1          _
 on role0_.id=permission1_.role_id left outer join vzr_permissions permission2_
on permission1_.permission_id=permission2_.id where role0_.id=?
Hibernate: select user0_.id as id1_18_0_, user0_.assigned_to as assigne11_18_0_,
 user0_.registration_key as registra2_18_0_, user0_.create_date as create_d3_18_
0_, user0_.email as email4_18_0_, user0_.first_name as first_na5_18_0_, user0_.l
ast_name as last_nam6_18_0_, user0_.notifications as notifica7_18_0_, user0_.pas
sword as password8_18_0_, user0_.role_id as role_id12_18_0_, user0_.signup_date
as signup_d9_18_0_, user0_.state as state10_18_0_, user0_.tenant_id as tenant_13
_18_0_, user1_.id as id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.re
gistration_key as registra2_18_1_, user1_.create_date as create_d3_18_1_, user1_
.email as email4_18_1_, user1_.first_name as first_na5_18_1_, user1_.last_name a
s last_nam6_18_1_, user1_.notifications as notifica7_18_1_, user1_.password as p
assword8_18_1_, user1_.role_id as role_id12_18_1_, user1_.signup_date as signup_
d9_18_1_, user1_.state as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, ro
le2_.id as id1_10_2_, role2_.description as descript2_10_2_, role2_.level as lev
el3_10_2_, role2_.name as name4_10_2_, permission3_.role_id as role_id1_10_3_, p
ermission4_.id as permissi2_9_3_, permission4_.id as id1_6_4_, permission4_.desc
ription as descript2_6_4_, permission4_.name as name3_6_4_, tenant5_.id as id1_1
7_5_, tenant5_.is_active as is_activ2_17_5_, tenant5_.admin_id as admin_id5_17_5
_, tenant5_.guid as guid3_17_5_, tenant5_.subscription_id as subscrip6_17_5_, te
nant5_.title as title4_17_5_, user6_.id as id1_18_6_, user6_.assigned_to as assi
gne11_18_6_, user6_.registration_key as registra2_18_6_, user6_.create_date as c
reate_d3_18_6_, user6_.email as email4_18_6_, user6_.first_name as first_na5_18_
6_, user6_.last_name as last_nam6_18_6_, user6_.notifications as notifica7_18_6_
, user6_.password as password8_18_6_, user6_.role_id as role_id12_18_6_, user6_.
signup_date as signup_d9_18_6_, user6_.state as state10_18_6_,
user6_.tenant_id as tenant_13_18_6_, subscripti7_.id as id1_15_7_, subscripti7_.
expiration_date as expirati2_15_7_, subscripti7_.issue_date as issue_da3_15_7_,
subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.plan_id as plan_
id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_business_units a
s availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_, subscripti8_
.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subscript
i8_.is_public as is_publi6_14_8_ from vzr_users user0_ left outer join vzr_users
 user1_ on user0_.assigned_to=user1_.id left outer join vzr_roles role2_ on user
1_.role_id=role2_.id left outer join vzr_role_permissions permission3_ on role2_
.id=permission3_.role_id left outer join vzr_permissions permission4_ on permiss
ion3_.permission_id=permission4_.id left outer join vzr_tenants tenant5_ on user
1_.tenant_id=tenant5_.id left outer join vzr_users user6_ on tenant5_.admin_id=u
ser6_.id left outer join vzr_subscriptions subscripti7_ on tenant5_.subscription
_id=subscripti7_.id left outer join vzr_subscription_plans subscripti8_ on subsc
ripti7_.plan_id=subscripti8_.id where user0_.id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, us   e
r2_.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.n
otifications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role
_id as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as s
tate10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3
_.description as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as n
ame4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2
_9_4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_,
permission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as
 is_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, tenant6_.guid as guid3_1
7_6_, tenant6_.subscription_id as subscrip6_17_6_, tenant6_.title as title4_17_6
_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_date as expirati2_15_7_
, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_.last_payment_date as
last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, subscripti8_.id as id1_
14_8_, subscripti8_.available_business_units as availabl2_14_8_, subscripti8_.av
ailable_users as availabl3_14_8_, subscripti8_.available_vizis as availabl4_14_8
_, subscripti8_.name as name5_14_8_, subscripti8_.is_public as is_publi6_14_8_ f
rom vzr_tenants tenant0_ left outer join vzr_users user1_ on tenant0_.admin_id=u
ser1_.id left outer join vzr_users user2_ on user1_.assigned_to=user2_.id left o
uter join vzr_roles role3_ on user2_.role_id=role3_.id left outer join vzr_role_
permissions permission4_ on role3_.id=permission4_.role_id left outer join vzr_p
ermissions permission5_ on permission4_.permission_id=permission5_.id left outer
 join vzr_tenants tenant6_ on user2_.tenant_id=tenant6_.id left outer join vzr_s
ubscriptions subscripti7_ on tenant6_.subscription_id=subscripti7_.id left outer
 join vzr_subscription_plans subscripti8_ on subscripti7_.plan_id=subscripti8_.i
d where tenant0_.id=?
2015-12-03 11:45:36.062 DEBUG 4052 --- [io-10002-exec-5] c.v.backoffice.web.rest
.UserResource     : Star                                                       t
 searching users: page number null, page size null, column null, direction null,
 roleId null
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select businessun0_.id as id1_1_0_, businessun0_.color_scheme as colo
r_sc2_1_0_, businessun0_.description as descript3_1_0_, businessun0_.email as em
ail4_1_0_, businessun0_.font_face as font_fac5_1_0_, businessun0_.guid as guid6_
1_0_, businessun0_.name as name7_1_0_, businessun0_.phone as phone8_1_0_, busine
ssun0_.state as state9_1_0_, businessun0_.tenant_id as tenant_12_1_0_, businessu
n0_.video_url as video_u10_1_0_, businessun0_.website as website11_1_0_, tenant1
_.id as id1_17_1_, tenant1_.is_active as is_activ2_17_1_, tenant1_.admin_id as a
dmin_id5_17_1_, tenant1_.guid as guid3_17_1_, tenant1_.subscription_id as subscr
ip6_17_1_, tenant1_.title as title4_17_1_, user2_.id as id1_18_2_, user2_.assign
ed_to as assigne11_18_2_, user2_.registration_key as registra2_18_2_, user2_.cre
ate_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_.first_name as
first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.notifications as no
tifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id as role_id12_1
8_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as state10_18_2_, user
2_.tenant_id as tenant_13_18_2_, user3_.id as id1_18_3_, user3_.assigned_to as a
ssigne11_18_3_, user3_.registration_key as registra2_18_3_, user3_.create_date a
s create_d3_18_3_, user3_.                                                     e
mail as email4_18_3_, user3_.first_name as first_na5_18_3_, user3_.last_name as
last_nam6_18_3_, user3_.notifications as notifica7_18_3_, user3_.password as pas
sword8_18_3_, user3_.role_id as role_id12_18_3_, user3_.signup_date as signup_d9
_18_3_, user3_.state as state10_18_3_, user3_.tenant_id as tenant_13_18_3_, role
4_.id as id1_10_4_, role4_.description as descript2_10_4_, role4_.level as level
3_10_4_, role4_.name as name4_10_4_, permission5_.role_id as role_id1_10_5_, per
mission6_.id as permissi2_9_5_, permission6_.id as id1_6_6_, permission6_.descri
ption as descript2_6_6_, permission6_.name as name3_6_6_, tenant7_.id as id1_17_
7_, tenant7_.is_active as is_activ2_17_7_, tenant7_.admin_id as admin_id5_17_7_,
 tenant7_.guid as guid3_17_7_, tenant7_.subscription_id as subscrip6_17_7_, tena
nt7_.title as title4_17_7_, subscripti8_.id as id1_15_8_, subscripti8_.expiratio
n_date as expirati2_15_8_, subscripti8_.issue_date as issue_da3_15_8_, subscript
i8_.last_payment_date as last_pay4_15_8_, subscripti8_.plan_id as plan_id5_15_8_
, subscripti9_.id as id1_14_9_, subscripti9_.available_business_units as availab
l2_14_9_, subscripti9_.available_users as availabl3_14_9_, subscripti9_.availabl
e_vizis as availabl4_14_9_, subscripti9_.name as name5_14_9_, subscripti9_.is_pu
blic as is_publi6_14_9_ from vzr_business_units businessun0_ left outer join vzr
_tenants tenant1_ on businessun0_.tenant_id=tenant1_.id left outer join vzr_user
s user2_ on tenant1_.admin_id=user2_.id left outer join vzr_users user3_ on user
2_.assigned_to=user3_.id left outer join vzr_roles role4_ on user3_.role_id=role
4_.id left outer join vzr_role_permissions permission5_ on role4_.id=permission5
_.role_id left outer join vzr_permissions permission6_ on permission5_.permissio
n_id=permission6_.id left outer join vzr_tenants tenant7_ on user3_.tenant_id=te
nant7_.id left outer join vzr_subscriptions subscripti8_ on tenant7_.subscriptio
n_id=subscripti8_.id left outer join vzr_subscription_plans subscripti9_ on subs
cripti8_.plan_id=subscripti9_.id where business                                u
n0_.id=?
Hibernate: select role0_.id as id1_10_0_, role0_.description as descript2_10_0_,
 role0_.level as level3_10_0_, role0_.name as name4_10_0_, permission1_.role_id
as role_id1_10_1_, permission2_.id as permissi2_9_1_, permission2_.id as id1_6_2
_, permission2_.description as descript2_6_2_, permission2_.name as name3_6_2_ f
rom vzr_roles role0_ left outer join vzr_role_permissions permission1_ on role0_
.id=permission1_.role_id left outer join vzr_permissions permission2_ on permiss
ion1_.permission_id=permission2_.id where role0_.id=?
Hibernate: select count(user0_.id) as col_0_0_ from vzr_users user0_ where user0
_.tenant_id=? and user0_.state=? and (user0_.role_id in (? , ? , ? , ?))
Hibernate: select user0_.id as id1_18_, user0_.assigned_to as assigne11_18_, use
r0_.registration_key as registra2_18_, user0_.create_date as create_d3_18_, user
0_.email as email4_18_, user0_.first_name as first_na5_18_, user0_.last_name as
last_nam6_18_, user0_.notifications as notifica7_18_, user0_.password as passwor
d8_18_, user0_.role_id as role_id12_18_, user0_.signup_date as signup_d9_18_, us
er0_.state as state10_18_, user0_.tenant_id as tenant_13_18_ from vzr_users user
0_ where user0_.tenant_id=? and user0_.state=? and (user0_.role_id in (? , ? , ?
 , ?)) order by user0_.id asc limit ?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assig                                                  n
e11_18_2_, user2_.registration_key as registra2_18_2_, user2_.create_date as cre
ate_d3_18_2_, user2_.email as email4_18_2_, user2_.first_name as first_na5_18_2_
, user2_.last_name as last_nam6_18_2_, user2_.notifications as notifica7_18_2_,
user2_.password as password8_18_2_, user2_.role_id as role_id12_18_2_, user2_.si
gnup_date as signup_d9_18_2_, user2_.state as state10_18_2_, user2_.tenant_id as
 tenant_13_18_2_, role3_.id as id1_10_3_, role3_.description as descript2_10_3_,
 role3_.level as level3_10_3_, role3_.name as name4_10_3_, permission4_.role_id
as role_id1_10_4_, permission5_.id as permissi2_9_4_, permission5_.id as id1_6_5
_, permission5_.description as descript2_6_5_, permission5_.name as name3_6_5_,
tenant6_.id as id1_17_6_, tenant6_.is_active as is_activ2_17_6_, tenant6_.admin_
id as admin_id5_17_6_, tenant6_.guid as guid3_17_6_, tenant6_.subscription_id as
 subscrip6_17_6_, tenant6_.title as title4_17_6_, subscripti7_.id as id1_15_7_,
subscripti7_.expiration_date as expirati2_15_7_, subscripti7_.issue_date as issu
e_da3_15_7_, subscripti7_.last_payment_date as last_pay4_15_7_, subscripti7_.pla
n_id as plan_id5_15_7_, subscripti8_.id as id1_14_8_, subscripti8_.available_bus
iness_units as availabl2_14_8_, subscripti8_.available_users as availabl3_14_8_,
 subscripti8_.available_vizis as availabl4_14_8_, subscripti8_.name as name5_14_
8_, subscripti8_.is_public as is_publi6_14_8_ from vzr_tenants tenant0_ left out
er join vzr_users user1_ on tenant0_.admin_id=user1_.id left outer join vzr_user
s user2_ on user1_.assigned_to=user2_.id left outer join vzr_roles role3_ on use
r2_.role_id=role3_.id left outer join vzr_role_permissions permission4_ on role3
_.id=permission4_.role_id left outer join vzr_permissions permission5_ on permis
sion4_.permission_id=permission5_.id left outer join vzr_tenants tenant6_ on use
r2_.tenant_id=tenant6_.id left outer join vzr_subscriptions subscripti7_ on tena
nt6_.subscription_id=subscripti7_.id left outer join vzr_subscription_plans subs
cripti8_ on subscripti7_.plan_id=subscripti8_.i                                d
 where tenant0_.id=?
Hibernate: select role0_.id as id1_10_0_, role0_.description as descript2_10_0_,
 role0_.level as level3_10_0_, role0_.name as name4_10_0_, permission1_.role_id
as role_id1_10_1_, permission2_.id as permissi2_9_1_, permission2_.id as id1_6_2
_, permission2_.description as descript2_6_2_, permission2_.name as name3_6_2_ f
rom vzr_roles role0_ left outer join vzr_role_permissions permission1_ on role0_
.id=permission1_.role_id left outer join vzr_permissions permission2_ on permiss
ion1_.permission_id=permission2_.id where role0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select businessun0_.id as id1_1_0_, businessun0_.color_scheme as colo
r_sc2_1_0_, businessun0_.description as descript3_1_0_, businessun0_.email as em
ail4_1_0_, businessun0_.font_face as font_fac5_1_0_, businessun0_.guid as guid6_
1_0_, businessun0_.name as name7_1_0_, businessun0_.phone as phone8_1_0_, busine
ssun0_.state as state9_1_0_, businessun0_.tenant_id as tenant_12_1_0_, businessu
n0_.video_url as video_u10_1_0_, businessun0_.website as website11_1_0_, tenant1
_.id as id1_17_1_, tenant1_.is_active as is_activ2_17_1_, tenant1_.admin_id as a
dmin_id5_17_1_, tenant1_.guid as guid3_17_1_, tenant1_.subscription_id as subscr
ip6_17_1_, tenant1_.title as title4_17_1_, user2_.id as id1_18_2_, user2_.assign
ed_to as assigne11_18_2_, user2_.registration_key as registra2_18_2_, user2_.cre
ate_date as create_d3_18_2_, user2_.email a                                    s
 email4_18_2_, user2_.first_name as first_na5_18_2_, user2_.last_name as last_na
m6_18_2_, user2_.notifications as notifica7_18_2_, user2_.password as password8_
18_2_, user2_.role_id as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_,
 user2_.state as state10_18_2_, user2_.tenant_id as tenant_13_18_2_, user3_.id a
s id1_18_3_, user3_.assigned_to as assigne11_18_3_, user3_.registration_key as r
egistra2_18_3_, user3_.create_date as create_d3_18_3_, user3_.email as email4_18
_3_, user3_.first_name as first_na5_18_3_, user3_.last_name as last_nam6_18_3_,
user3_.notifications as notifica7_18_3_, user3_.password as password8_18_3_, use
r3_.role_id as role_id12_18_3_, user3_.signup_date as signup_d9_18_3_, user3_.st
ate as state10_18_3_, user3_.tenant_id as tenant_13_18_3_, role4_.id as id1_10_4
_, role4_.description as descript2_10_4_, role4_.level as level3_10_4_, role4_.n
ame as name4_10_4_, permission5_.role_id as role_id1_10_5_, permission6_.id as p
ermissi2_9_5_, permission6_.id as id1_6_6_, permission6_.description as descript
2_6_6_, permission6_.name as name3_6_6_, tenant7_.id as id1_17_7_, tenant7_.is_a
ctive as is_activ2_17_7_, tenant7_.admin_id as admin_id5_17_7_, tenant7_.guid as
 guid3_17_7_, tenant7_.subscription_id as subscrip6_17_7_, tenant7_.title as tit
le4_17_7_, subscripti8_.id as id1_15_8_, subscripti8_.expiration_date as expirat
i2_15_8_, subscripti8_.issue_date as issue_da3_15_8_, subscripti8_.last_payment_
date as last_pay4_15_8_, subscripti8_.plan_id as plan_id5_15_8_, subscripti9_.id
 as id1_14_9_, subscripti9_.available_business_units as availabl2_14_9_, subscri
pti9_.available_users as availabl3_14_9_, subscripti9_.available_vizis as availa
bl4_14_9_, subscripti9_.name as name5_14_9_, subscripti9_.is_public as is_publi6
_14_9_ from vzr_business_units businessun0_ left outer join vzr_tenants tenant1_
 on businessun0_.tenant_id=tenant1_.id left outer join vzr_users user2_ on tenan
t1_.admin_id=user2_.id left outer join vzr_users user3_ on user2_.assigned_to=us
er3_.id left outer join vzr_roles role4_ on use                                r
3_.role_id=role4_.id left outer join vzr_role_permissions permission5_ on role4_
.id=permission5_.role_id left outer join vzr_permissions permission6_ on permiss
ion5_.permission_id=permission6_.id left outer join vzr_tenants tenant7_ on user
3_.tenant_id=tenant7_.id left outer join vzr_subscriptions subscripti8_ on tenan
t7_.subscription_id=subscripti8_.id left outer join vzr_subscription_plans subsc
ripti9_ on subscripti8_.plan_id=subscripti9_.id where businessun0_.id=?
Hibernate: select tenant0_.id as id1_17_0_, tenant0_.is_active as is_activ2_17_0
_, tenant0_.admin_id as admin_id5_17_0_, tenant0_.guid as guid3_17_0_, tenant0_.
subscription_id as subscrip6_17_0_, tenant0_.title as title4_17_0_, user1_.id as
 id1_18_1_, user1_.assigned_to as assigne11_18_1_, user1_.registration_key as re
gistra2_18_1_, user1_.create_date as create_d3_18_1_, user1_.email as email4_18_
1_, user1_.first_name as first_na5_18_1_, user1_.last_name as last_nam6_18_1_, u
ser1_.notifications as notifica7_18_1_, user1_.password as password8_18_1_, user
1_.role_id as role_id12_18_1_, user1_.signup_date as signup_d9_18_1_, user1_.sta
te as state10_18_1_, user1_.tenant_id as tenant_13_18_1_, user2_.id as id1_18_2_
, user2_.assigned_to as assigne11_18_2_, user2_.registration_key as registra2_18
_2_, user2_.create_date as create_d3_18_2_, user2_.email as email4_18_2_, user2_
.first_name as first_na5_18_2_, user2_.last_name as last_nam6_18_2_, user2_.noti
fications as notifica7_18_2_, user2_.password as password8_18_2_, user2_.role_id
 as role_id12_18_2_, user2_.signup_date as signup_d9_18_2_, user2_.state as stat
e10_18_2_, user2_.tenant_id as tenant_13_18_2_, role3_.id as id1_10_3_, role3_.d
escription as descript2_10_3_, role3_.level as level3_10_3_, role3_.name as name
4_10_3_, permission4_.role_id as role_id1_10_4_, permission5_.id as permissi2_9_
4_, permission5_.id as id1_6_5_, permission5_.description as descript2_6_5_, per
mission5_.name as name3_6_5_, tenant6_.id as id1_17_6_, tenant6_.is_active as is
_activ2_17_6_, tenant6_.admin_id as admin_id5_17_6_, t                         e
nant6_.guid as guid3_17_6_, tenant6_.subscription_id as subscrip6_17_6_, tenant6
_.title as title4_17_6_, subscripti7_.id as id1_15_7_, subscripti7_.expiration_d
ate as expirati2_15_7_, subscripti7_.issue_date as issue_da3_15_7_, subscripti7_
.last_payment_date as last_pay4_15_7_, subscripti7_.plan_id as plan_id5_15_7_, s
ubscripti8_.id as id1_14_8_, subscripti8_.available_business_units as availabl2_
14_8_, subscripti8_.available_users as availabl3_14_8_, subscripti8_.available_v
izis as availabl4_14_8_, subscripti8_.name as name5_14_8_, subscripti8_.is_publi
c as is_publi6_14_8_ from vzr_tenants tenant0_ left outer join vzr_users user1_
on tenant0_.admin_id=user1_.id left outer join vzr_users user2_ on user1_.assign
ed_to=user2_.id left outer join vzr_roles role3_ on user2_.role_id=role3_.id lef
t outer join vzr_role_permissions permission4_ on role3_.id=permission4_.role_id
 left outer join vzr_permissions permission5_ on permission4_.permission_id=perm
ission5_.id left outer join vzr_tenants tenant6_ on user2_.tenant_id=tenant6_.id
 left outer join vzr_subscriptions subscripti7_ on tenant6_.subscription_id=subs
cripti7_.id left outer join vzr_subscription_plans subscripti8_ on subscripti7_.
plan_id=subscripti8_.id where tenant0_.id=?
Hibernate: select subscripti0_.id as id1_15_0_, subscripti0_.expiration_date as
expirati2_15_0_, subscripti0_.issue_date as issue_da3_15_0_, subscripti0_.last_p
ayment_date as last_pay4_15_0_, subscripti0_.plan_id as plan_id5_15_0_, subscrip
ti1_.id as id1_14_1_, subscripti1_.available_business_units as availabl2_14_1_,
subscripti1_.available_users as availabl3_14_1_, subscripti1_.available_vizis as
 availabl4_14_1_, subscripti1_.name as name5_14_1_, subscripti1_.is_public as is
_publi6_14_1_ from vzr_subscriptions subscripti0_ left outer join vzr_subscripti
on_plans subscripti1_ on subscripti0_.plan_id=subscripti1_.id where subscripti0_
.id=?
Hibernate: select count(vizi0_.id) as col_0_0_ from vzr_vizis vizi0_ where vizi0
_.assignee_id=? and (vizi0_.state in (? , ? , ?))
Hibernate: select assignees0_.assigned_to as assigne11_18_0_, assignees0_.id as
id1_18_0_, assignees0_.id as id1_18_1_, assignees0_.assigned_to as assigne11_18_
1_, assignees0_.registration_key as registra2_18_1_, assignees0_.create_date as
create_d3_18_1_, assignees0_.email as email4_18_1_, assignees0_.first_name as fi
rst_na5_18_1_, assignees0_.last_name as last_nam6_18_1_, assignees0_.notificatio
ns as notifica7_18_1_, assignees0_.password as password8_18_1_, assignees0_.role
_id as role_id12_18_1_, assignees0_.signup_date as signup_d9_18_1_, assignees0_.
state as state10_18_1_, assignees0_.tenant_id as tenant_13_18_1_, role1_.id as i
d1_10_2_, role1_.description as descript2_10_2_, role1_.level as level3_10_2_, r
ole1_.name as name4_10_2_, tenant2_.id as id1_17_3_, tenant2_.is_active as is_ac
tiv2_17_3_, tenant2_.admin_id as admin_id5_17_3_, tenant2_.guid as guid3_17_3_,
tenant2_.subscription_id as subscrip6_17_3_, tenant2_.title as title4_17_3_, use
r3_.id as id1_18_4_, user3_.assigned_to as assigne11_18_4_, user3_.registration_
key as registra2_18_4_, user3_.create_date as create_d3_18_4_, user3_.email as e
mail4_18_4_, user3_.first_name as first_na5_18_4_, user3_.last_name as last_nam6
_18_4_, user3_.notifications as notifica7_18_4_, user3_.password as password8_18
_4_, user3_.role_id as role_id12_18_4_, user3_.signup_date as signup_d9_18_4_, u
ser3_.state as state10_18_4_, user3_.tenant_id as tenant_13_18_4_, subscripti4_.
id as id1_15_5_, subscripti4_.expiration_date as expirati2_15_5_, subscripti4_.i
ssue_date as issue_da3_15_5_, subscripti4_.last_payment_date as last_pay4_15_5_,
 subscripti4_.plan_id as plan_id5_15_5_, subscripti5_.id as id1_14_6_, subscript
i5_.available_business_units as availabl2_14_6_, subscripti5_.available_users as
 availabl3_14_6_, subscripti5_.available_vizis as availabl4_14_6_, subscripti5_.
name as name5_14_6_, subscripti5_.is_public as is_publi6_14_6_ from vzr_users as
signees0_ left outer join vzr_roles role1_ on assignees0_.role_id=role1_.id left
 outer join vzr_tenants tenant2_ on assignees0_.tenant_id=tenant2_.id le       f
t outer join vzr_users user3_ on tenant2_.admin_id=user3_.id left outer join vzr
_subscriptions subscripti4_ on tenant2_.subscription_id=subscripti4_.id left out
er join vzr_subscription_plans subscripti5_ on subscripti4_.plan_id=subscripti5_
.id where assignees0_.assigned_to=?
> Building 95% > :backoffice:bootRun