i cant register new customer from webUI

[n4nd...@gmail.com]

Sep 29, 2014 12:56:05 PM org.apache.catalina.core.StandardWrapperValve invoke
INFO: DEBUG: org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'appServlet' processing POST request for [/sm-shop/shop/customer/register.html]
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /shop/customer/register.html
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Returning handler method [public java.lang.String com.salesmanager.web.shop.controller.customer.CustomerRegistrationController.registerCustomer(com.salesmanager.web.entity.customer.SecuredShopPersistableCustomer,org.springframework.validation.BindingResult,org.springframework.ui.Model,javax.servlet.http.HttpServletRequest,java.util.Locale) throws java.lang.Exception]
Hibernate: select zone0_.ZONE_ID as ZONE1_138_, zone0_.ZONE_CODE as ZONE2_138_, zone0_.COUNTRY_ID as COUNTRY3_138_ from SALESMANAGER.ZONE zone0_
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
WARN : org.hibernate.hql.internal.ast.QueryTranslatorImpl - HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!
Hibernate: select customer0_.CUSTOMER_ID as CUSTOMER1_160_0_, merchantst1_.MERCHANT_ID as MERCHANT1_135_1_, language2_.LANGUAGE_ID as LANGUAGE1_140_2_, group4_.GROUP_ID as GROUP1_191_3_, attributes5_.CUSTOMER_ATTRIBUTE_ID as CUSTOMER1_161_4_, customerop6_.CUSTOMER_OPTION_ID as CUSTOMER1_162_5_, descriptio8_.DESCRIPTION_ID as DESCRIPT1_163_6_, customerop7_.CUSTOMER_OPTION_VALUE_ID as CUSTOMER1_164_7_, descriptio9_.DESCRIPTION_ID as DESCRIPT1_166_8_, customer0_.CUSTOMER_ANONYMOUS as CUSTOMER2_160_0_, customer0_.BILLING_STREET_ADDRESS as BILLING3_160_0_, customer0_.BILLING_CITY as BILLING4_160_0_, customer0_.BILLING_COMPANY as BILLING5_160_0_, customer0_.BILLING_COUNTRY_ID as BILLING25_160_0_, customer0_.BILLING_FIRST_NAME as BILLING6_160_0_, customer0_.BILLING_LAST_NAME as BILLING7_160_0_, customer0_.BILLING_POSTCODE as BILLING8_160_0_, customer0_.BILLING_STATE as BILLING9_160_0_, customer0_.BILLING_TELEPHONE as BILLING10_160_0_, customer0_.BILLING_ZONE_ID as BILLING26_160_0_, customer0_.CUSTOMER_COMPANY as CUSTOMER11_160_0_, customer0_.CUSTOMER_DOB as CUSTOMER12_160_0_, customer0_.LANGUAGE_ID as LANGUAGE27_160_0_, customer0_.DELIVERY_STREET_ADDRESS as DELIVERY13_160_0_, customer0_.DELIVERY_CITY as DELIVERY14_160_0_, customer0_.DELIVERY_COMPANY as DELIVERY15_160_0_, customer0_.DELIVERY_COUNTRY_ID as DELIVERY28_160_0_, customer0_.DELIVERY_FIRST_NAME as DELIVERY16_160_0_, customer0_.DELIVERY_LAST_NAME as DELIVERY17_160_0_, customer0_.DELIVERY_POSTCODE as DELIVERY18_160_0_, customer0_.DELIVERY_STATE as DELIVERY19_160_0_, customer0_.DELIVERY_TELEPHONE as DELIVERY20_160_0_, customer0_.DELIVERY_ZONE_ID as DELIVERY29_160_0_, customer0_.CUSTOMER_EMAIL_ADDRESS as CUSTOMER21_160_0_, customer0_.CUSTOMER_GENDER as CUSTOMER22_160_0_, customer0_.MERCHANT_ID as MERCHANT30_160_0_, customer0_.CUSTOMER_NICK as CUSTOMER23_160_0_, customer0_.CUSTOMER_PASSWORD as CUSTOMER24_160_0_, merchantst1_.STORE_CODE as STORE2_135_1_, merchantst1_.CONTINUESHOPPINGURL as CONTINUE3_135_1_, merchantst1_.COUNTRY_ID as COUNTRY20_135_1_, merchantst1_.CURRENCY_ID as CURRENCY21_135_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_135_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_135_1_, merchantst1_.DOMAIN_NAME as DOMAIN5_135_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_135_1_, merchantst1_.INVOICE_TEMPLATE as INVOICE7_135_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_135_1_, merchantst1_.STORE_EMAIL as STORE9_135_1_, merchantst1_.STORE_LOGO as STORE10_135_1_, merchantst1_.STORE_TEMPLATE as STORE11_135_1_, merchantst1_.STORE_ADDRESS as STORE12_135_1_, merchantst1_.STORE_CITY as STORE13_135_1_, merchantst1_.STORE_NAME as STORE14_135_1_, merchantst1_.STORE_PHONE as STORE15_135_1_, merchantst1_.STORE_POSTAL_CODE as STORE16_135_1_, merchantst1_.STORE_STATE_PROV as STORE17_135_1_, merchantst1_.USE_CACHE as USE18_135_1_, merchantst1_.WEIGHTUNITCODE as WEIGHTU19_135_1_, merchantst1_.ZONE_ID as ZONE23_135_1_, language2_.DATE_CREATED as DATE2_140_2_, language2_.DATE_MODIFIED as DATE3_140_2_, language2_.UPDT_ID as UPDT4_140_2_, language2_.CODE as CODE140_2_, language2_.SORT_ORDER as SORT6_140_2_, group4_.DATE_CREATED as DATE2_191_3_, group4_.DATE_MODIFIED as DATE3_191_3_, group4_.UPDT_ID as UPDT4_191_3_, group4_.GROUP_NAME as GROUP5_191_3_, group4_.GROUP_TYPE as GROUP6_191_3_, groups3_.CUSTOMER_ID as CUSTOMER1_160_0__, groups3_.GROUP_ID as GROUP2_0__, attributes5_.CUSTOMER_ID as CUSTOMER3_161_4_, attributes5_.OPTION_ID as OPTION4_161_4_, attributes5_.OPTION_VALUE_ID as OPTION5_161_4_, attributes5_.CUSTOMER_ATTR_TXT_VAL as CUSTOMER2_161_4_, attributes5_.CUSTOMER_ID as CUSTOMER3_160_1__, attributes5_.CUSTOMER_ATTRIBUTE_ID as CUSTOMER1_1__, customerop6_.CUSTOMER_OPT_ACTIVE as CUSTOMER2_162_5_, customerop6_.CUSTOMER_OPT_CODE as CUSTOMER3_162_5_, customerop6_.CUSTOMER_OPTION_TYPE as CUSTOMER4_162_5_, customerop6_.MERCHANT_ID as MERCHANT7_162_5_, customerop6_.CUSTOMER_OPT_PUBLIC as CUSTOMER5_162_5_, customerop6_.SORT_ORDER as SORT6_162_5_, descriptio8_.DATE_CREATED as DATE2_163_6_, descriptio8_.DATE_MODIFIED as DATE3_163_6_, descriptio8_.UPDT_ID as UPDT4_163_6_, descriptio8_.DESCRIPTION as DESCRIPT5_163_6_, descriptio8_.LANGUAGE_ID as LANGUAGE9_163_6_, descriptio8_.NAME as NAME163_6_, descriptio8_.TITLE as TITLE163_6_, descriptio8_.CUSTOMER_OPTION_ID as CUSTOMER10_163_6_, descriptio8_.CUSTOMER_OPTION_COMMENT as CUSTOMER8_163_6_, descriptio8_.CUSTOMER_OPTION_ID as CUSTOMER10_162_2__, descriptio8_.DESCRIPTION_ID as DESCRIPT1_2__, customerop7_.CUSTOMER_OPT_VAL_CODE as CUSTOMER2_164_7_, customerop7_.CUSTOMER_OPT_VAL_IMAGE as CUSTOMER3_164_7_, customerop7_.MERCHANT_ID as MERCHANT5_164_7_, customerop7_.SORT_ORDER as SORT4_164_7_, descriptio9_.DATE_CREATED as DATE2_166_8_, descriptio9_.DATE_MODIFIED as DATE3_166_8_, descriptio9_.UPDT_ID as UPDT4_166_8_, descriptio9_.DESCRIPTION as DESCRIPT5_166_8_, descriptio9_.LANGUAGE_ID as LANGUAGE8_166_8_, descriptio9_.NAME as NAME166_8_, descriptio9_.TITLE as TITLE166_8_, descriptio9_.CUSTOMER_OPT_VAL_ID as CUSTOMER9_166_8_, descriptio9_.CUSTOMER_OPT_VAL_ID as CUSTOMER9_164_3__, descriptio9_.DESCRIPTION_ID as DESCRIPT1_3__ from SALESMANAGER.CUSTOMER customer0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1_ on customer0_.MERCHANT_ID=merchantst1_.MERCHANT_ID left outer join SALESMANAGER.LANGUAGE language2_ on customer0_.LANGUAGE_ID=language2_.LANGUAGE_ID left outer join SALESMANAGER.CUSTOMER_GROUP groups3_ on customer0_.CUSTOMER_ID=groups3_.CUSTOMER_ID left outer join SALESMANAGER.SM_GROUP group4_ on groups3_.GROUP_ID=group4_.GROUP_ID left outer join SALESMANAGER.CUSTOMER_ATTRIBUTE attributes5_ on customer0_.CUSTOMER_ID=attributes5_.CUSTOMER_ID left outer join SALESMANAGER.CUSTOMER_OPTION customerop6_ on attributes5_.OPTION_ID=customerop6_.CUSTOMER_OPTION_ID left outer join SALESMANAGER.CUSTOMER_OPTION_DESC descriptio8_ on customerop6_.CUSTOMER_OPTION_ID=descriptio8_.CUSTOMER_OPTION_ID left outer join SALESMANAGER.CUSTOMER_OPTION_VALUE customerop7_ on attributes5_.OPTION_VALUE_ID=customerop7_.CUSTOMER_OPTION_VALUE_ID left outer join SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION descriptio9_ on customerop7_.CUSTOMER_OPTION_VALUE_ID=descriptio9_.CUSTOMER_OPT_VAL_ID where customer0_.CUSTOMER_NICK=? and merchantst1_.MERCHANT_ID=?
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - No customer found with userName mukesh456 for store Net4Nuts
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - Starting customer registration process..
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - Starting to populate customer model from customer data
Hibernate: select language0_.LANGUAGE_ID as LANGUAGE1_140_, language0_.DATE_CREATED as DATE2_140_, language0_.DATE_MODIFIED as DATE3_140_, language0_.UPDT_ID as UPDT4_140_, language0_.CODE as CODE140_, language0_.SORT_ORDER as SORT6_140_ from SALESMANAGER.LANGUAGE language0_ where language0_.CODE=? limit ?
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - About to persist customer to database.
DEBUG: com.salesmanager.core.business.customer.service.CustomerServiceImpl - Creating Customer
Hibernate: select SEQ_COUNT from SALESMANAGER.SM_SEQUENCER where SEQ_NAME = 'CUSTOMER_SEQ_NEXT_VAL' for update
Hibernate: update SALESMANAGER.SM_SEQUENCER set SEQ_COUNT = ? where SEQ_COUNT = ? and SEQ_NAME = 'CUSTOMER_SEQ_NEXT_VAL'
Hibernate: insert into SALESMANAGER.CUSTOMER (CUSTOMER_ANONYMOUS, BILLING_STREET_ADDRESS, BILLING_CITY, BILLING_COMPANY, BILLING_COUNTRY_ID, BILLING_FIRST_NAME, BILLING_LAST_NAME, BILLING_POSTCODE, BILLING_STATE, BILLING_TELEPHONE, BILLING_ZONE_ID, CUSTOMER_COMPANY, CUSTOMER_DOB, LANGUAGE_ID, DELIVERY_STREET_ADDRESS, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY_ID, DELIVERY_FIRST_NAME, DELIVERY_LAST_NAME, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_TELEPHONE, DELIVERY_ZONE_ID, CUSTOMER_EMAIL_ADDRESS, CUSTOMER_GENDER, MERCHANT_ID, CUSTOMER_NICK, CUSTOMER_PASSWORD, CUSTOMER_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - Returning customer data to controller..
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - Retunring populated instance of customer entity
WARN : org.hibernate.hql.internal.ast.QueryTranslatorImpl - HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!
Hibernate: select customer0_.CUSTOMER_ID as CUSTOMER1_160_0_, merchantst1_.MERCHANT_ID as MERCHANT1_135_1_, language2_.LANGUAGE_ID as LANGUAGE1_140_2_, group4_.GROUP_ID as GROUP1_191_3_, attributes5_.CUSTOMER_ATTRIBUTE_ID as CUSTOMER1_161_4_, customerop6_.CUSTOMER_OPTION_ID as CUSTOMER1_162_5_, descriptio8_.DESCRIPTION_ID as DESCRIPT1_163_6_, customerop7_.CUSTOMER_OPTION_VALUE_ID as CUSTOMER1_164_7_, descriptio9_.DESCRIPTION_ID as DESCRIPT1_166_8_, customer0_.CUSTOMER_ANONYMOUS as CUSTOMER2_160_0_, customer0_.BILLING_STREET_ADDRESS as BILLING3_160_0_, customer0_.BILLING_CITY as BILLING4_160_0_, customer0_.BILLING_COMPANY as BILLING5_160_0_, customer0_.BILLING_COUNTRY_ID as BILLING25_160_0_, customer0_.BILLING_FIRST_NAME as BILLING6_160_0_, customer0_.BILLING_LAST_NAME as BILLING7_160_0_, customer0_.BILLING_POSTCODE as BILLING8_160_0_, customer0_.BILLING_STATE as BILLING9_160_0_, customer0_.BILLING_TELEPHONE as BILLING10_160_0_, customer0_.BILLING_ZONE_ID as BILLING26_160_0_, customer0_.CUSTOMER_COMPANY as CUSTOMER11_160_0_, customer0_.CUSTOMER_DOB as CUSTOMER12_160_0_, customer0_.LANGUAGE_ID as LANGUAGE27_160_0_, customer0_.DELIVERY_STREET_ADDRESS as DELIVERY13_160_0_, customer0_.DELIVERY_CITY as DELIVERY14_160_0_, customer0_.DELIVERY_COMPANY as DELIVERY15_160_0_, customer0_.DELIVERY_COUNTRY_ID as DELIVERY28_160_0_, customer0_.DELIVERY_FIRST_NAME as DELIVERY16_160_0_, customer0_.DELIVERY_LAST_NAME as DELIVERY17_160_0_, customer0_.DELIVERY_POSTCODE as DELIVERY18_160_0_, customer0_.DELIVERY_STATE as DELIVERY19_160_0_, customer0_.DELIVERY_TELEPHONE as DELIVERY20_160_0_, customer0_.DELIVERY_ZONE_ID as DELIVERY29_160_0_, customer0_.CUSTOMER_EMAIL_ADDRESS as CUSTOMER21_160_0_, customer0_.CUSTOMER_GENDER as CUSTOMER22_160_0_, customer0_.MERCHANT_ID as MERCHANT30_160_0_, customer0_.CUSTOMER_NICK as CUSTOMER23_160_0_, customer0_.CUSTOMER_PASSWORD as CUSTOMER24_160_0_, merchantst1_.STORE_CODE as STORE2_135_1_, merchantst1_.CONTINUESHOPPINGURL as CONTINUE3_135_1_, merchantst1_.COUNTRY_ID as COUNTRY20_135_1_, merchantst1_.CURRENCY_ID as CURRENCY21_135_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_135_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_135_1_, merchantst1_.DOMAIN_NAME as DOMAIN5_135_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_135_1_, merchantst1_.INVOICE_TEMPLATE as INVOICE7_135_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_135_1_, merchantst1_.STORE_EMAIL as STORE9_135_1_, merchantst1_.STORE_LOGO as STORE10_135_1_, merchantst1_.STORE_TEMPLATE as STORE11_135_1_, merchantst1_.STORE_ADDRESS as STORE12_135_1_, merchantst1_.STORE_CITY as STORE13_135_1_, merchantst1_.STORE_NAME as STORE14_135_1_, merchantst1_.STORE_PHONE as STORE15_135_1_, merchantst1_.STORE_POSTAL_CODE as STORE16_135_1_, merchantst1_.STORE_STATE_PROV as STORE17_135_1_, merchantst1_.USE_CACHE as USE18_135_1_, merchantst1_.WEIGHTUNITCODE as WEIGHTU19_135_1_, merchantst1_.ZONE_ID as ZONE23_135_1_, language2_.DATE_CREATED as DATE2_140_2_, language2_.DATE_MODIFIED as DATE3_140_2_, language2_.UPDT_ID as UPDT4_140_2_, language2_.CODE as CODE140_2_, language2_.SORT_ORDER as SORT6_140_2_, group4_.DATE_CREATED as DATE2_191_3_, group4_.DATE_MODIFIED as DATE3_191_3_, group4_.UPDT_ID as UPDT4_191_3_, group4_.GROUP_NAME as GROUP5_191_3_, group4_.GROUP_TYPE as GROUP6_191_3_, groups3_.CUSTOMER_ID as CUSTOMER1_160_0__, groups3_.GROUP_ID as GROUP2_0__, attributes5_.CUSTOMER_ID as CUSTOMER3_161_4_, attributes5_.OPTION_ID as OPTION4_161_4_, attributes5_.OPTION_VALUE_ID as OPTION5_161_4_, attributes5_.CUSTOMER_ATTR_TXT_VAL as CUSTOMER2_161_4_, attributes5_.CUSTOMER_ID as CUSTOMER3_160_1__, attributes5_.CUSTOMER_ATTRIBUTE_ID as CUSTOMER1_1__, customerop6_.CUSTOMER_OPT_ACTIVE as CUSTOMER2_162_5_, customerop6_.CUSTOMER_OPT_CODE as CUSTOMER3_162_5_, customerop6_.CUSTOMER_OPTION_TYPE as CUSTOMER4_162_5_, customerop6_.MERCHANT_ID as MERCHANT7_162_5_, customerop6_.CUSTOMER_OPT_PUBLIC as CUSTOMER5_162_5_, customerop6_.SORT_ORDER as SORT6_162_5_, descriptio8_.DATE_CREATED as DATE2_163_6_, descriptio8_.DATE_MODIFIED as DATE3_163_6_, descriptio8_.UPDT_ID as UPDT4_163_6_, descriptio8_.DESCRIPTION as DESCRIPT5_163_6_, descriptio8_.LANGUAGE_ID as LANGUAGE9_163_6_, descriptio8_.NAME as NAME163_6_, descriptio8_.TITLE as TITLE163_6_, descriptio8_.CUSTOMER_OPTION_ID as CUSTOMER10_163_6_, descriptio8_.CUSTOMER_OPTION_COMMENT as CUSTOMER8_163_6_, descriptio8_.CUSTOMER_OPTION_ID as CUSTOMER10_162_2__, descriptio8_.DESCRIPTION_ID as DESCRIPT1_2__, customerop7_.CUSTOMER_OPT_VAL_CODE as CUSTOMER2_164_7_, customerop7_.CUSTOMER_OPT_VAL_IMAGE as CUSTOMER3_164_7_, customerop7_.MERCHANT_ID as MERCHANT5_164_7_, customerop7_.SORT_ORDER as SORT4_164_7_, descriptio9_.DATE_CREATED as DATE2_166_8_, descriptio9_.DATE_MODIFIED as DATE3_166_8_, descriptio9_.UPDT_ID as UPDT4_166_8_, descriptio9_.DESCRIPTION as DESCRIPT5_166_8_, descriptio9_.LANGUAGE_ID as LANGUAGE8_166_8_, descriptio9_.NAME as NAME166_8_, descriptio9_.TITLE as TITLE166_8_, descriptio9_.CUSTOMER_OPT_VAL_ID as CUSTOMER9_166_8_, descriptio9_.CUSTOMER_OPT_VAL_ID as CUSTOMER9_164_3__, descriptio9_.DESCRIPTION_ID as DESCRIPT1_3__ from SALESMANAGER.CUSTOMER customer0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1_ on customer0_.MERCHANT_ID=merchantst1_.MERCHANT_ID left outer join SALESMANAGER.LANGUAGE language2_ on customer0_.LANGUAGE_ID=language2_.LANGUAGE_ID left outer join SALESMANAGER.CUSTOMER_GROUP groups3_ on customer0_.CUSTOMER_ID=groups3_.CUSTOMER_ID left outer join SALESMANAGER.SM_GROUP group4_ on groups3_.GROUP_ID=group4_.GROUP_ID left outer join SALESMANAGER.CUSTOMER_ATTRIBUTE attributes5_ on customer0_.CUSTOMER_ID=attributes5_.CUSTOMER_ID left outer join SALESMANAGER.CUSTOMER_OPTION customerop6_ on attributes5_.OPTION_ID=customerop6_.CUSTOMER_OPTION_ID left outer join SALESMANAGER.CUSTOMER_OPTION_DESC descriptio8_ on customerop6_.CUSTOMER_OPTION_ID=descriptio8_.CUSTOMER_OPTION_ID left outer join SALESMANAGER.CUSTOMER_OPTION_VALUE customerop7_ on attributes5_.OPTION_VALUE_ID=customerop7_.CUSTOMER_OPTION_VALUE_ID left outer join SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION descriptio9_ on customerop7_.CUSTOMER_OPTION_VALUE_ID=descriptio9_.CUSTOMER_OPT_VAL_ID where customer0_.CUSTOMER_NICK=? and merchantst1_.MERCHANT_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
ERROR: org.hibernate.hql.internal.ast.ErrorCounter - <AST>:0:0: unexpected end of subtree
ERROR: org.hibernate.hql.internal.ast.ErrorCounter - <AST>:0:0: unexpected end of subtree
<AST>:0:0: unexpected end of subtree
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3164)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:706)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:562)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.collectionFunctionOrSubselect(HqlSqlBaseWalker.java:4485)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.inRhs(HqlSqlBaseWalker.java:4390)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4065)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1935)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:794)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:595)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
    at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:216)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1207)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:256)
    at com.salesmanager.core.business.user.dao.PermissionDaoImpl.getPermissionsListByGroups(PermissionDaoImpl.java:63)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy134.getPermissionsListByGroups(Unknown Source)
    at com.salesmanager.core.business.user.service.PermissionServiceImpl.getPermissions(PermissionServiceImpl.java:81)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy136.getPermissions(Unknown Source)
    at com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl.authenticate(CustomerFacadeImpl.java:414)
    at com.salesmanager.web.shop.controller.customer.CustomerRegistrationController.registerCustomer(CustomerRegistrationController.java:229)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:207)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    at java.lang.Thread.run(Thread.java:722)
ERROR: com.salesmanager.web.shop.controller.customer.CustomerRegistrationController - Cannot authenticate user
org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select distinct p from com.salesmanager.core.business.user.model.Permission as p join fetch p.groups grous where grous.id in ()]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select distinct p from com.salesmanager.core.business.user.model.Permission as p join fetch p.groups grous where grous.id in ()]
    at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:301)
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:106)
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:403)
    at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
    at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy134.getPermissionsListByGroups(Unknown Source)
    at com.salesmanager.core.business.user.service.PermissionServiceImpl.getPermissions(PermissionServiceImpl.java:81)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy136.getPermissions(Unknown Source)
    at com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl.authenticate(CustomerFacadeImpl.java:414)
    at com.salesmanager.web.shop.controller.customer.CustomerRegistrationController.registerCustomer(CustomerRegistrationController.java:229)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:207)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select distinct p from com.salesmanager.core.business.user.model.Permission as p join fetch p.groups grous where grous.id in ()]
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1352)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1293)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:265)
    at com.salesmanager.core.business.user.dao.PermissionDaoImpl.getPermissionsListByGroups(PermissionDaoImpl.java:63)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)
    ... 83 more
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select distinct p from com.salesmanager.core.business.user.model.Permission as p join fetch p.groups grous where grous.id in ()]
    at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
    at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
    at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:79)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:255)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
    at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:216)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1207)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:256)
    ... 92 more
DEBUG: org.springframework.web.servlet.DispatcherServlet - Rendering view [org.springframework.web.servlet.view.tiles2.TilesView: name 'register.bootstrap'; URL [register.bootstrap]] in DispatcherServlet with name 'appServlet'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'recapatcha_public_key' of type [java.lang.String] to request in view with name 'register.bootstrap'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'customer' of type [com.salesmanager.web.entity.customer.SecuredShopPersistableCustomer] to request in view with name 'register.bootstrap'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'countryList' of type [java.util.ArrayList] to request in view with name 'register.bootstrap'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'org.springframework.validation.BindingResult.customer' of type [org.springframework.validation.BeanPropertyBindingResult] to request in view with name 'register.bootstrap'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'zoneList' of type [java.util.ArrayList] to request in view with name 'register.bootstrap'
DEBUG: org.springframework.web.servlet.DispatcherServlet - Successfully completed request


-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
hi all,

for create  new customer from Shopizer Web UI then give above Error on my Tomcat.

email are send to customer account but password are empty.

and its display
   "Unable to complete registration, please try again later" this message.

so plz help me

Thanks

[Umesh Awasthi]

Can you describe steps to reproduce this bug?

are you getting error on the UI also? or is it coming only in tomcat console?

this will help us to debug issues

--
You received this message because you are subscribed to the Google Groups "Shopizer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shopizer+u...@googlegroups.com.
To post to this group, send email to shop...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/shopizer/bc19c067-8b26-42bc-80dd-892900eb2ba9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
With Regards
Umesh Awasthi
http://www.travellingrants.com/

   

[n4nd...@gmail.com]

hi
        if i drag drop singin.  i select the Not Yet Registered?  after its give me register  page  i fill all information.
    then submit form its give me  "Unable to complete registration, please try again later".
  but email will send on specific email address,  and In email only username is there password are blank.

In my Tomcat consol display following Message

[n4nd...@gmail.com]

 hello sir
                   plz reply me

[n4nd...@gmail.com]

hi sir,
            Error will display both UI and Tomcat.
           Thanks for Reply me.
           plz give me solution....

[Umesh Awasthi]

I will try to reproduce it at my end and will share my findings.

--

You received this message because you are subscribed to the Google Groups "Shopizer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shopizer+u...@googlegroups.com.
To post to this group, send email to shop...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/shopizer/33aeab3b-b2d4-4013-bbde-bede5a1061e1%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[n4nd...@gmail.com]

hi  Sir
             ok sir  i am waiting for it. also i have problem in using multi store using. How can i use Second Store not Default?
plz reply

Thanks
Ravi

[shopizer]

1- Make sure you are using Shopizer version 2.0.0

2- Make sure your email server is configured and working as the email communication is part of the signin / registration process