<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Jitendra,<br>
<br>
the issue is fixed in 1.9.2.Final. <br>
<br>
see <a class="moz-txt-link-freetext" href="https://github.com/keycloak/keycloak/pull/2352/files">https://github.com/keycloak/keycloak/pull/2352/files</a><br>
<br>
The cause is that Hibernate doesn't detect correct dialect for
MSSQL2014, which is causing some incorrectly generated SQL queries.
In 1.9.2.Final is auto-detected dialect overridden.<br>
<br>
Vlasta<br>
<br>
<div class="moz-cite-prefix">On 05/17/2016 03:25 PM, Jitendra P
Biswal wrote:<br>
</div>
<blockquote
cite="mid:922da49bb89e4ecda8a1207d49a7a77a@ind-mhp1mbx1301.mastek.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi All, <o:p></o:p></p>
<p class="MsoNormal">I am using keycloak-1.9.0.Final version and
configured it to point
<b>SQL Server 2014.<o:p></o:p></b></p>
<p class="MsoNormal">I was able to create new realm and create
user under the realm<o:p></o:p></p>
<p class="MsoNormal">But, when I am click on view all users
getting error. Server log attached.<o:p></o:p></p>
<p class="MsoNormal">Anybody have any solution please help.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks & Regards,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"
style="margin-bottom:7.5pt;background:white"><a
moz-do-not-send="true" href="http://www.majesco.com/"><span
style="font-size:7.5pt;font-family:"Helvetica","sans-serif";color:#24A939;text-decoration:none"><img
id="Picture_x0020_1"
src="cid:part1.07000203.02060704@redhat.com"
alt="Description: cid:image001.jpg@01D065A7.375670A0"
height="29" width="150" border="0"></span></a><span
style="color:#282828"> </span><o:p></o:p></p>
<p class="MsoNormal" style="background:#FEFEFE"><span
style="font-size:10.0pt;color:black">Jitendra Biswal</span><span
style="font-size:10.0pt;color:#212121"> </span><span
style="font-size:10.0pt;color:black">/ </span><span
style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:black">Software
Specialist</span><span
style="font-size:10.0pt;color:#545454"> </span><span
style="font-size:10.0pt;color:#212121"><br>
<br>
</span><b><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-IN">Majesco,</span></b><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-IN">
</span><span style="font-size:10.0pt;color:black">Majesco New
Development Centre</span><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-IN">,
</span><span style="font-size:10.0pt;color:black">MBP-P–136,136A,
Mahape,</span><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-IN">
Navi Mumbai - 400 710<br>
Phone: +91 22 6150 1800 Ext 5698<br>
</span><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:EN-IN"><a
moz-do-not-send="true" href="http://www.majesco.com/"><span
style="color:#17365D"><a class="moz-txt-link-freetext" href="http://www.majesco.com">http://www.majesco.com</a></span></a><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
keycloak-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/keycloak-user">https://lists.jboss.org/mailman/listinfo/keycloak-user</a></pre>
</blockquote>
<br>
</body>
</html>