Merchant user can't access the Merchant dashboard

After creating/activating new Merchant with valid email address, he is not able access the Merchant dashboard . It shows error message "No account associated with this user"

We checked this on QA 3 (Himalaya), observed the similar behavior.

Steps :

1. Create a Merchant having valid email address.
2.Activate the account by setting the password.
3.Try login to Merchant UI.

Actual result:
It shows error message "No account associated with this user"

Snippet of tomcat log:

{complete log file attached}

---------------------------
ID: 574
Response-Code: 200
Content-Type: application/json;charset=UTF-8;version=2.6.0-BETA12
Headers:

{Content-Type=[application/json;charset=UTF-8;version=2.6.0-BETA12], Date=[Thu, 26 Jun 2014 09:51:46 GMT], X-AML-API-ID=[9d7958bf-a956-480a-be09-c3261543c43f], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]}

Payload: ["ff81c538-69fa-4ad7-ae11-6d89f5600115","b59fa344-7ae0-47ec-a5a3-dd8e51caac9d","419f051c-9d36-11e2-87f6-93568ffb4923","04518081-0906-4c0e-8fb4-e279b50b4829"]
--------------------------------------
2014-06-26 09:51:46,762-10893201 [http-8080-14] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 575
Address: http://127.0.0.1:8080/sapi/rest/merchants?q=WHERE+UserId%3D%279be3a3f8-186c-4d7d-acda-b0d5addecea9%27
Http-Method: GET
Content-Type:
Headers:

{Accept=[application/json, text/plain], connection=[Keep-Alive], Content-Type=[null], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.2.1 (java 1.5)], x-tsa-authenticate=[LK3CYKUPKK2RWSHH4WECVVWVEGTAUXSWNRZ3PX4EYH5PJF3IXEMSDQMUU7FS76HZIYPPNYS4ZYKRDS6SOE6WEIH2ZCSG6IZRKVEL2U5DCFQB2ATYWMACBD2JWJQHKBDKNCJKJVYIKNJ6REXAANM45EWB4IIK57MZLAEN45MOFCCDUFG5LA4637LML4QUBCJOUU2HXEL3VU6OQPZV5YOZTNBJ4DREM4YBIUGQEPVM62QHZU3UHFXA4TVCHAMJK7VIIGT7ZKNPZTN5CX6WX76T4ACKU6EZPRPISFCKTIR7ZWIFSCGC5RBKFDS3RGR3O6OC2H4XVZZBDIKFNPCZK2463CCDISTL77L6QNEU4HYHNCD5TQPDWQJL4IS4DCLFGJSWFMG334S45FMZPKJ57WURH6C6K3IPK43ENAL2TSK7EBSP74AOBVEPPG2GMHMIBCXCFQCUUT72VMTAUA6INM4AIGW75CMCTKXR5KBXDBLYQ3GBCYUKLDCU6FDOVKZKEZP3Z6RTCG3UUHHRELRJAFCRQ24FBSB2MLWKS33SQAZVSSMZUICSYHLZOXMVJMMIDFFRRBDRGVNUMFOTQEFIGL2N2KPOLJ72IRI2NZ74VR32OJHI7X67Q5FYIZXUNJM7OPSMTEHP7A3AL3SGWS7H36BV66SNJFZRXA63TED3B5LSZWVX54D3UAV2G72BT6PJ46OM7JAX6PPOD4VGKMAC2RPENNGIS4PR7J5XYQTQYZRYMUURS55B2C6MFBCCEPZ7BXMCROVN5U5V3CDEHVRTBKUGNGFQJSQRHOSBKPPDATSWLOICEHNJCMUZ4WWRIIC5YYO7RXZAWEVO66OYXSMEWT7W25X7QSXRKPE2KENOBIM3TKXNT3RTV6ADDTSOVE6D72WXI2T4FAGBTHNUX4UKG7GPOF5ZJ25RJGPH4XDH57UWMRJ4QKI6KOYCLIMCCA7B7AF2WLAVIB2LKWSHP25NL4FU7SCPMGFICFVDKH2XODQ2AGL7BNS7GQLPAEE32BY7PFH4RFOCMTUKTSHXZ6JXSJPH4OSLDXEV6B4Y336ECHW5HWFDDXDNGWQ3PC3WSJ75N5D5SKRKLMPMVZYWA5EDK3DGJA2RXPMECU5OI6PSXVPCTMBWTKXUKIKOXDKEN4WIIYLS2FSBZMFPCZE6OOOY4WEWPFLUKYRCB2MEMUO3TBAT4RN42JQPHSSE36ZA52DR6MAO4VKRYMM2RAFVNNG5LDHN42XV2SBHBH3GJSDYN2MVTTJBMTYUXBJ43K3V3YVKKBIWCYNSZXKQBXR7OWJHFY6U4KEPMD5ZGL3GQINRJWRQEF4ASSEYFBKKS3U747ZMXNMJCPYCEK3MG3XXL3QYRE4IPPJOKRKKVBIFIIOPI6EYERTMCOMFJY7TUZHNLAOKNR4E4T44J2TJXVZ2YYL6LFEJ7X5HVGRREEG32E5N2WGOAQEDKNJPE2FWW26L4VD2O4GD57G2CD3VODZMXSHBV2XJACTPA7PQCMG3YM7SMXCFYIJBYOZ7AG3NBOTP37ECT3VH7XQNFYVJ75YOTSKI72K7B7RRFPFD5F4QAAUNXAFYE6HO4HPE466CYZYCO4NTVKPNY2D4GNPAVX553MMVAAPXSY6KSWX4PVINU4P2WJBDSHSZR5VNZA4A====]}

--------------------------------------
2014-06-26 09:51:46,864-10893303 [http-8080-14] ERROR com.thesearchagency.services.merchant.dao.MerchantDAO [timezone=Etc/UTC, principalId=9be3a3f8-186c-4d7d-acda-b0d5addecea9, requestId=39ce2072-a902-41f7-a257-edfb6cdd86e0, locale=en_US, authToken=LK3CYKUPKK2RWSHH4WECVVWVEGTAUXSWNRZ3PX4EYH5PJF3IXEMSDQMUU7FS76HZIYPPNYS4ZYKRDS6SOE6WEIH2ZCSG6IZRKVEL2U5DCFQB2ATYWMACBD2JWJQHKBDKNCJKJVYIKNJ6REXAANM45EWB4IIK57MZLAEN45MOFCCDUFG5LA4637LML4QUBCJOUU2HXEL3VU6OQPZV5YOZTNBJ4DREM4YBIUGQEPVM62QHZU3UHFXA4TVCHAMJK7VIIGT7ZKNPZTN5CX6WX76T4ACKU6EZPRPISFCKTIR7ZWIFSCGC5RBKFDS3RGR3O6OC2H4XVZZBDIKFNPCZK2463CCDISTL77L6QNEU4HYHNCD5TQPDWQJL4IS4DCLFGJSWFMG334S45FMZPKJ57WURH6C6K3IPK43ENAL2TSK7EBSP74AOBVEPPG2GMHMIBCXCFQCUUT72VMTAUA6INM4AIGW75CMCTKXR5KBXDBLYQ3GBCYUKLDCU6FDOVKZKEZP3Z6RTCG3UUHHRELRJAFCRQ24FBSB2MLWKS33SQAZVSSMZUICSYHLZOXMVJMMIDFFRRBDRGVNUMFOTQEFIGL2N2KPOLJ72IRI2NZ74VR32OJHI7X67Q5FYIZXUNJM7OPSMTEHP7A3AL3SGWS7H36BV66SNJFZRXA63TED3B5LSZWVX54D3UAV2G72BT6PJ46OM7JAX6PPOD4VGKMAC2RPENNGIS4PR7J5XYQTQYZRYMUURS55B2C6MFBCCEPZ7BXMCROVN5U5V3CDEHVRTBKUGNGFQJSQRHOSBKPPDATSWLOICEHNJCMUZ4WWRIIC5YYO7RXZAWEVO66OYXSMEWT7W25X7QSXRKPE2KENOBIM3TKXNT3RTV6ADDTSOVE6D72WXI2T4FAGBTHNUX4UKG7GPOF5ZJ25RJGPH4XDH57UWMRJ4QKI6KOYCLIMCCA7B7AF2WLAVIB2LKWSHP25NL4FU7SCPMGFICFVDKH2XODQ2AGL7BNS7GQLPAEE32BY7PFH4RFOCMTUKTSHXZ6JXSJPH4OSLDXEV6B4Y336ECHW5HWFDDXDNGWQ3PC3WSJ75N5D5SKRKLMPMVZYWA5EDK3DGJA2RXPMECU5OI6PSXVPCTMBWTKXUKIKOXDKEN4WIIYLS2FSBZMFPCZE6OOOY4WEWPFLUKYRCB2MEMUO3TBAT4RN42JQPHSSE36ZA52DR6MAO4VKRYMM2RAFVNNG5LDHN42XV2SBHBH3GJSDYN2MVTTJBMTYUXBJ43K3V3YVKKBIWCYNSZXKQBXR7OWJHFY6U4KEPMD5ZGL3GQINRJWRQEF4ASSEYFBKKS3U747ZMXNMJCPYCEK3MG3XXL3QYRE4IPPJOKRKKVBIFIIOPI6EYERTMCOMFJY7TUZHNLAOKNR4E4T44J2TJXVZ2YYL6LFEJ7X5HVGRREEG32E5N2WGOAQEDKNJPE2FWW26L4VD2O4GD57G2CD3VODZMXSHBV2XJACTPA7PQCMG3YM7SMXCFYIJBYOZ7AG3NBOTP37ECT3VH7XQNFYVJ75YOTSKI72K7B7RRFPFD5F4QAAUNXAFYE6HO4HPE466CYZYCO4NTVKPNY2D4GNPAVX553MMVAAPXSY6KSWX4PVINU4P2WJBDSHSZR5VNZA4A====, hostname=127.0.0.1, ipAddress=127.0.0.1] - Exception thrown in search()
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT merchants.*, u.id as _users_id, u.realm_id as _users_realm_id,u.type as _users_type,u.first_name as _users_first_name,u.last_name as _users_last_name,u.display as _users_display,u.description as _users_description,u.created_on as _users_created_on,u.created_by as _users_created_by,u.modified_on as _users_modified_on,u.modified_by as _users_modified_by,u.active as _users_active,u.password as _users_password,u.salt as _users_salt,u.organization as _users_organization,u.language as _users_language,u.country as _users_country,u.timezone as _users_timezone,u.gender as _users_gender,u.birthday as _users_birthday,u.login as _users_login,u.email as _users_email,u.homepage as _users_homepage,u.home_phone as _users_home_phone,u.work_phone as _users_work_phone,u.mobile_phone as _users_mobile_phone, creator.display as _creator_name, m.display as _modifier_name FROM `merchants` LEFT JOIN `users` u ON u.id = merchants.user_id LEFT JOIN `users` creator ON creator.id = merchants.created_by LEFT JOIN `users` m on m.id = merchants.modified_by WHERE (merchants.`realm_id` LIKE concat(?,'%')) AND (UserId = '9be3a3f8-186c-4d7d-acda-b0d5addecea9')]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'UserId' in 'where clause'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE]

.
.
.
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'UserId' in 'where clause'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.6.0_30]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.6.0_30]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.6.0_30]

Expected result:

Merchant user should able to access the Merchant dashboard.