<HTML xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><HEAD><!-- Template generated by Exclaimer Mail Disclaimers on 06:03:43 Friday, 28 December 2012 -->
<STYLE type=text/css>P.456a1a06-98db-4184-9b1e-fba6999bdd39 {
MARGIN: 0cm 0cm 0pt
}
LI.456a1a06-98db-4184-9b1e-fba6999bdd39 {
MARGIN: 0cm 0cm 0pt
}
DIV.456a1a06-98db-4184-9b1e-fba6999bdd39 {
MARGIN: 0cm 0cm 0pt
}
TABLE.456a1a06-98db-4184-9b1e-fba6999bdd39Table {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</STYLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8" /><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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
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;
font-size:10.0pt;}
@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]--></HEAD>
<BODY lang=EN-US link=blue vlink=purple>
<P><div class=WordSection1><p class=MsoNormal><span style=color:#1F497D>We had this issue too on 8.6.2.<o:p></o:p></span></p><p class=MsoNormal><span style=color:#1F497D><br />Add a second search criteria when specifying what phones to update and the query will be returned correctly (e.g. add starts with “SEP” to your search items). <o:p></o:p></span></p><p class=MsoNormal><span style=color:#1F497D><o:p> </o:p></span></p><p class=MsoNormal><span style=color:#1F497D>Sincerely, <o:p></o:p></span></p><p class=MsoNormal><span style=color:#1F497D><o:p> </o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 align=left style=border-collapse:collapse;margin-left:-2.25pt;margin-right:-2.25pt><tr><td width=191 valign=top style="width:143.6pt;border:none;border-bottom:solid gray 1.5pt;padding:0in 0in 0in 0in"><p class=MsoNormal style=mso-element:frame;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly><span style=color:black><img width=184 height=36 id="Picture_x0020_1" src='cid:image001.gif@01CDE4DA.3BDD3A50' alt="Description: cid:image001.gif@01CBE6F2.E6E73FA0" /></span><span style=font-size:12.0pt;color:black><o:p></o:p></span></p></td></tr></table><p class=MsoNormal><b><i><span style=color:#1F497D><o:p> </o:p></span></i></b></p><p class=MsoNormal><b><i><span style=color:#1F497D><o:p> </o:p></span></i></b></p><p class=MsoNormal><b><i><span style=color:#1F497D><br />Matthew M. Linsemier, CCNP / CCDP</span></i></b><span style=font-size:8.0pt;color:#1F497D><o:p></o:p></span></p><p class=MsoNormal><span style=font-size:10.0pt;color:#1F497D>Senior Network Engineer<o:p></o:p></span></p><p class=MsoNormal><span style=font-size:10.0pt;color:#1F497D>The Doctors Company</span><span style=color:#1F497D><br /><br /></span><span style=font-size:8.0pt;color:#1F497D><o:p></o:p></span></p><p class=MsoNormal><span style=font-size:8.0pt;font-family:Wingdings;color:#474747>( </span><span style=font-size:8.0pt;color:#1F497D>517.324.6695<o:p></o:p></span></p><p class=MsoNormal><span style=font-size:8.0pt;font-family:Wingdings;color:blue>* </span><span style=font-size:8.0pt;color:#1F497D>mlinsemier@thedoctors.com</span><span style=font-size:8.0pt;color:#1F497D><o:p></o:p></span></p><p class=MsoNormal><span style=color:#1F497D><o:p> </o:p></span></p><p class=MsoNormal><span style=color:#1F497D><o:p> </o:p></span></p><p class=MsoNormal><span style=color:#1F497D><o:p> </o:p></span></p><div></div></div><FONT style="FONT-FAMILY: Verdana; COLOR: silver; FONT-SIZE: 7pt" color=silver><FONT size=2><FONT face="Times New Roman"><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; BACKGROUND: white; COLOR: #7d7d7d; FONT-SIZE: 7.5pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-family: 'Times New Roman'"></SPAN></FONT></FONT></FONT></P>
<P class=456a1a06-98db-4184-9b1e-fba6999bdd39><FONT style="FONT-FAMILY: Verdana; COLOR: silver; FONT-SIZE: 7pt" color=silver size=1 face=Verdana><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; BACKGROUND: white; COLOR: #7d7d7d; FONT-SIZE: 7.5pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-family: 'Times New Roman'"></SPAN></FONT><div class=WordSection1><div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b>On Behalf Of </b>Mike <br /><b>Sent:</b> Thursday, December 27, 2012 10:47 PM<br /><b>To:</b> 'cisco voip'<br /><b>Subject:</b> [cisco-voip] BAT SQL error<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’m trying to update softkey template by using BAT and get the following error after I select the phones for updating.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style=mso-margin-top-alt:5.0pt;margin-right:0in;margin-bottom:5.0pt;margin-left:0in;text-autospace:none><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>Error occurred while retrieving information from database. java.sql.SQLException: A syntax error has occurred.<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>CCM ver: <span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>8.6.2.22900-9<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div> </P>
<P class=456a1a06-98db-4184-9b1e-fba6999bdd39> </P>
<P class=456a1a06-98db-4184-9b1e-fba6999bdd39><FONT style="FONT-FAMILY: Verdana; COLOR: silver; FONT-SIZE: 7pt" color=silver><FONT size=2><FONT face="Times New Roman"><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; BACKGROUND: white; COLOR: #7d7d7d; FONT-SIZE: 7.5pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><STRONG>Confidentiality
Notice</STRONG></SPAN><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; BACKGROUND: white; COLOR: #7d7d7d; FONT-SIZE: 7.5pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-family: 'Times New Roman'">:
This message and any attachments hereto may contain confidential and privileged
communications or information and/or attorney client communications or
work-product protected by law. The information contained herein is transmitted
for the sole use of the intended recipient(s). If you are not the intended
recipient or designated agent of the recipient of such information, you are
hereby notified that any use, dissemination, copying or retention of this e-mail
or the information contained herein is strictly prohibited and may subject you
to penalties under federal and/or state law. If you received this e-mail in
error, please notify the sender immediately and permanently delete this
e-mail.</SPAN></FONT></FONT></FONT></P></BODY></HTML>