[prev in list] [next in list] [prev in thread] [next in thread]
List: openmrs-implementers
Subject: RE: Possible provider bug
From: "Friedman, Roger (CDC/CGH/DGHA) (CTR)" <rdf4 () cdc ! gov>
Date: 2013-01-24 13:29:51
Message-ID: A72AAD7416DE69499D1D05407FB412F93CAAE813 () EMBX-CLFT4 ! cdc ! gov
[Download RAW message or body]
Are you responding to the "suspicious character" referred to by Daniel?
From: implementers@openmrs.org [mailto:implementers@openmrs.org] On Behalf Of Ben \
Wolfe
Sent: Tuesday, January 22, 2013 8:40 PM
To: OpenMRS Implementers
Subject: Re: Possible provider bug
Look for the string "-149". Select * from provider where name like '%-149%'. Or \
maybe in the person_name table?
You can turn on sql logging in your custom runtime properties file to see what \
hibernate is sending. I'd be surprised if its a single quote issue, hibernate is \
supposed to take care of those On Jan 22, 2013 4:50 AM, "Daniel Kayiwa" \
<kayiwadaniel@gmail.com<mailto:kayiwadaniel@gmail.com>> wrote: In your provider \
table, do you have any names or identifiers with suspicious character? On Tue, Jan \
22, 2013 at 2:45 AM, Tobin Greensweig \
<tobin@greensweig.net<mailto:tobin@greensweig.net>> wrote: I'm having a bizarre \
problem that I can't explain, not sure if it's a bug or a problem with my \
database...Here's what I did:
1. Open provider page \
(http://localhost:8081/openmrs-standalone/admin/provider/index.htm) 2. Click on the \
provider 3. Give reason and click retire
4. Back on the provider page I get this error in red at the top of the screen "A \
javascript error has occurred: could not execute query. The full stacktrace for this \
error can usually be found in your server's error logs. Hide error" here is what's in \
the error log: http://pastebin.com/q0aKWFx3 5. If I unretire the provider, the error \
goes away. It makes no difference what provider is retired - all do the same.
I can't reproduce it on a "clean" database where I just create providers. It only \
happens on my 1.9 database recently upgraded from 1.8.3.
Aside from this error it doesn't seem to be causing problems. I've looked at the \
provider table and everything seems to be as it should.
Thoughts? What's in the SQL statement that seems to be causing the problem?
Thanks in advance for the help!
Tobin
--
OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implementers@openmrs.org<mailto:implementers@openmrs.org>
Unsubscribe: implementers+unsubscribe@openmrs.org<mailto:implementers%2Bunsubscribe@openmrs.org>
Manage your OpenMRS subscriptions at https://id.openmrs.org/
--
If we keep uppermost in our minds the unkind and unjust acts of others, we shall find \
it impossible to love them as Christ has loved us; but if our thoughts dwell upon the \
wondrous love and pity of Christ for us, the same spirit will flow \
out to others.
--
OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implementers@openmrs.org<mailto:implementers@openmrs.org>
Unsubscribe: implementers+unsubscribe@openmrs.org<mailto:implementers%2Bunsubscribe@openmrs.org>
Manage your OpenMRS subscriptions at https://id.openmrs.org/
--
OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implementers@openmrs.org<mailto:implementers@openmrs.org>
Unsubscribe: implementers+unsubscribe@openmrs.org<mailto:implementers+unsubscribe@openmrs.org>
Manage your OpenMRS subscriptions at https://id.openmrs.org/
--
OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implementers@openmrs.org
Unsubscribe: implementers+unsubscribe@openmrs.org
Manage your OpenMRS subscriptions at https://id.openmrs.org/
[Attachment #3 (text/html)]
<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>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@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:12.0pt;
font-family:"Times New Roman","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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@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">
<div class="WordSection1">
<p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Are \
you responding to the "suspicious character" referred to by \
Daniel?<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<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""> \
implementers@openmrs.org [mailto:implementers@openmrs.org] <b>On Behalf Of </b>Ben \
Wolfe<br> <b>Sent:</b> Tuesday, January 22, 2013 8:40 PM<br>
<b>To:</b> OpenMRS Implementers<br>
<b>Subject:</b> Re: Possible provider bug<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p>Look for the string "-149". Select * from provider where name like \
'%-149%'. Or maybe in the person_name table? <o:p></o:p></p>
<p>You can turn on sql logging in your custom runtime properties file to see what \
hibernate is sending. I'd be surprised if its a single quote issue, hibernate is \
supposed to take care of those <o:p></o:p></p>
<div>
<p class="MsoNormal">On Jan 22, 2013 4:50 AM, "Daniel Kayiwa" <<a \
href="mailto:kayiwadaniel@gmail.com">kayiwadaniel@gmail.com</a>> \
wrote:<o:p></o:p></p> <p class="MsoNormal" style="margin-bottom:12.0pt">In your \
provider table, do you have any names or identifiers with suspicious \
character?<o:p></o:p></p> <div>
<p class="MsoNormal">On Tue, Jan 22, 2013 at 2:45 AM, Tobin Greensweig <<a \
href="mailto:tobin@greensweig.net" target="_blank">tobin@greensweig.net</a>> \
wrote:<o:p></o:p></p> <div>
<div>
<p class="MsoNormal">I'm having a bizarre problem that I can't explain, not sure if \
it's a bug or a problem with my database...Here's what I did:<o:p></o:p></p> </div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">1. Open provider page (<a \
href="http://localhost:8081/openmrs-standalone/admin/provider/index.htm" \
target="_blank">http://localhost:8081/openmrs-standalone/admin/provider/index.htm</a>)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">2. Click on the provider<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">3. Give reason and click retire<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">4. Back on the provider page I get this error in red at the top \
of the screen "A javascript error has occurred: could not execute query. The \
full stacktrace for this error can usually be found in your server's error logs. Hide \
error"<o:p></o:p></p> </div>
<div>
<p class="MsoNormal">here is what's in the error log: <a \
href="http://pastebin.com/q0aKWFx3" target="_blank"> \
http://pastebin.com/q0aKWFx3</a><o:p></o:p></p> </div>
<div>
<p class="MsoNormal">5. If I unretire the provider, the error goes away. It makes no \
difference what provider is retired - all do the same.<o:p></o:p></p> </div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I can't reproduce it on a "clean" database where I \
just create providers. It only happens on my 1.9 database recently upgraded from \
1.8.3.<o:p></o:p></p> </div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Aside from this error it doesn't seem to be causing problems. \
I've looked at the provider table and everything seems to be as it \
should.<o:p></o:p></p> </div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thoughts? What's in the SQL statement that seems to be causing \
the problem?<o:p></o:p></p> </div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks in advance for the help!<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#888888"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#888888">Tobin<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span style="color:#888888">-- <br>
OpenMRS Implementers: <a href="http://go.openmrs.org/implementers" target="_blank">
http://go.openmrs.org/implementers</a><br>
Post: <a href="mailto:implementers@openmrs.org" \
target="_blank">implementers@openmrs.org</a><br>
Unsubscribe: <a href="mailto:implementers%2Bunsubscribe@openmrs.org" target="_blank">
implementers+unsubscribe@openmrs.org</a><br>
Manage your OpenMRS subscriptions at <a href="https://id.openmrs.org/" \
target="_blank"> https://id.openmrs.org/</a><br>
<br>
</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <br>
If we keep uppermost in our minds the unkind and unjust acts of others, we shall find \
it impossible to love them as Christ has loved us; but if our thoughts dwell upon the \
wondrous love and pity of Christ for us, the same spirit will flow out to others. \
<o:p></o:p></p> <p class="MsoNormal">-- <br>
OpenMRS Implementers: <a href="http://go.openmrs.org/implementers" target="_blank">
http://go.openmrs.org/implementers</a><br>
Post: <a href="mailto:implementers@openmrs.org" \
target="_blank">implementers@openmrs.org</a><br>
Unsubscribe: <a href="mailto:implementers%2Bunsubscribe@openmrs.org" target="_blank">
implementers+unsubscribe@openmrs.org</a><br>
Manage your OpenMRS subscriptions at <a href="https://id.openmrs.org/" \
target="_blank"> https://id.openmrs.org/</a><br>
<br>
<o:p></o:p></p>
</div>
<p class="MsoNormal">-- <br>
OpenMRS Implementers: <a \
href="http://go.openmrs.org/implementers">http://go.openmrs.org/implementers</a><br>
Post: <a href="mailto:implementers@openmrs.org">implementers@openmrs.org</a><br>
Unsubscribe: <a href="mailto:implementers+unsubscribe@openmrs.org">implementers+unsubscribe@openmrs.org</a><br>
Manage your OpenMRS subscriptions at <a \
href="https://id.openmrs.org/">https://id.openmrs.org/</a><br> <br>
<o:p></o:p></p>
</div>
</body>
</html>
<p></p>
-- <br />
OpenMRS Implementers: <a \
href="http://go.openmrs.org/implementers">http://go.openmrs.org/implementers</a><br \
/>
Post: implementers@openmrs.org<br />
Unsubscribe: implementers+unsubscribe@openmrs.org<br />
Manage your OpenMRS subscriptions at <a \
href="https://id.openmrs.org/">https://id.openmrs.org/</a><br /> <br />
<br />
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic