<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8" /><meta name=Generator content="Microsoft Word 12 (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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 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:0cm;
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;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:black;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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-AU link=blue vlink=purple>
<P><BR /><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>Hi,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>sounds like you deleted some rows directly in the database. You should use the Shredder to fully delete items in RT, rather than playing in the DB directly.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>For now I would suggest you check out the docs for rt-validator, which may be able to help you find the orphaned rows.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><div><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:black'>Regards<o:p></o:p></span></b></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o:p></span></p><div></div></div>
<BR />
<TABLE style="WIDTH: 473px; HEIGHT: 165px" border=0 cellSpacing=0 cellPadding=0 width=473>
<TBODY>
<TR>
<TD style="HEIGHT: 50px" colSpan=3><SPAN style="LINE-HEIGHT: 16px; FONT-FAMILY: Arial, Helvetica, sans-serif; FONT-SIZE: 12px"><span style='font-family:Arial; font-size:11pt; font-weight: bold; '>Chris</span> <span style='font-family:Arial; font-size:11pt; font-weight: bold; '>O'Kelly</span><BR /><SPAN style="FONT-SIZE: 14px"><B><span style='font-family:Arial; font-size:9pt; font-weight: normal; '>Web Administrator</span></B></SPAN><BR /></SPAN></TD></TR>
<TR>
<TD style="WIDTH: 178px" height=112 vAlign=top width=199 align=left><SPAN style="LINE-HEIGHT: 16px; FONT-FAMILY: Arial, Helvetica, sans-serif; FONT-SIZE: 12px"><table class=95af439c-b34d-4edb-bee5-a4aa81e9771cTable><tr><td><span style='font-family:Arial; font-size:x-small; color: #000000; font-weight: bold; '>Minecorp Australia</span></td></tr><tr><td><span style='font-family:arial; font-size:9pt; '>37 Murdoch Circuit</span></td></tr><tr><td><span style='font-family:arial; font-size:9pt; '>Acacia Ridge QLD 4110</span></td></tr><tr><td><span style='font-family:Arial; font-size:9pt; color: #4F81BD; '><span style='font-family:arial; font-size:9pt; color: #0070C0; font-weight: bold; '><span style='font-family:arial; font-size:9pt; color: #0070C0; font-weight: bold; '><a href='http://www.minecorp.com.au' title='Minecorp Vehicle Solutions' target=''><span style='font-family:arial; font-size:9pt; color: #0070C0; font-weight: bold; '>minecorp.com.au</span></a></span></span></span></td></tr></table><BR /></SPAN></TD>
<TD style="WIDTH: 290px" height=112 vAlign=top width=250 align=left><SPAN style="LINE-HEIGHT: 16px; FONT-FAMILY: Arial, Helvetica, sans-serif; FONT-SIZE: 12px"><B><table class=95af439c-b34d-4edb-bee5-a4aa81e9771cTable><tr><td width=600px><span style='font-family:Arial; font-size:9pt; font-weight: bold; '>P: 07 3723 1000</span></td></tr><tr><td width=600px><span style='font-family:Arial; font-size:9pt; font-weight: bold; '>M: 0450 586 190</span></td></tr><tr><td width=600px><span style='font-family:arial; font-size:9pt; color: #4F81BD; font-weight: bold; '>E: <a href='mailto:Chris.okelly@minecorp.com.au' title='Click to send email to Chris O'Kelly' target=''>Chris.okelly@minecorp.com.au</a></span></td></tr><tr><td width=600px><span style='font-family:Arial; font-size:9pt; color: #4F81BD; font-weight: bold; '>S: <a href='http://skype.com' title='' target=''>chris.okelly.mvs</a></span></td></tr></table><BR /></B></SPAN></TD></TR></TBODY></TABLE> <IMG id=IMG1 border=0 src="http://i.imgur.com/xYx0A.png" width=600 height=108 /><BR /><BR /><div class=WordSection1><div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>Asanka Gunasekera<br /><b>Sent:</b> Wednesday, 14 November 2012 3:13 PM<br /><b>To:</b> rt-users@lists.bestpractical.com<br /><b>Subject:</b> Re: [rt-users] relations between reminder and ticket<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal style=background:white><span style=color:black><o:p> </o:p></span></p></div><div><p class=MsoNormal style=background:white><span style=color:black>Hi I am getting this messages "Couldn't find Ticket for reminder 2189. Please contact administrator." though I am running this cleanup scripts, can some one tell me what is going on<o:p></o:p></span></p></div><div><p class=MsoNormal style=background:white><span style=color:black><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style=color:black>This is not for all the reminders that I see this message, once in a while this would appear and I need to clean them up from the backend<o:p></o:p></span></p></div><div><p class=MsoNormal><span style=color:black><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style=color:black>Thanks and regards<o:p></o:p></span></p></div><div><p class=MsoNormal><span style=color:black><o:p> </o:p></span></p></div><div><div><div><div class=MsoNormal align=center style=text-align:center;background:white><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'><hr size=1 width="100%" align=center /></span></div><p class=MsoNormal style=background:white><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>From:</span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'> Asanka Gunasekera <asanka_gunasekera@yahoo.co.uk><br /><b>To:</b> "rt-users@lists.bestpractical.com" <rt-users@lists.bestpractical.com> <br /><b>Sent:</b> Monday, 8 October 2012, 22:42<br /><b>Subject:</b> Re: [rt-users] relations between reminder and ticket</span><span style=color:black><o:p></o:p></span></p></div><p class=MsoNormal style=background:white><span style=color:black><o:p> </o:p></span></p><div id=yiv840790732><div><div><p class=MsoNormal style=margin-bottom:12.0pt;background:white><span style=color:black>any one have came across this :(<br /><br /><o:p></o:p></span></p><div><p class=MsoNormal style=background:white><span style=color:black><o:p> </o:p></span></p></div><div><p class=MsoNormal style=background:white><span style=color:black><o:p> </o:p></span></p></div><div><div><div><div class=MsoNormal align=center style=text-align:center;background:white><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'><hr size=1 width="100%" align=center /></span></div><p class=MsoNormal style=background:white><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>From:</span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'> Asanka Gunasekera <asanka_gunasekera@yahoo.co.uk><br /><b>To:</b> "rt-users@lists.bestpractical.com" <rt-users@lists.bestpractical.com> <br /><b>Sent:</b> Tuesday, 25 September 2012, 13:06<br /><b>Subject:</b> Re: [rt-users] relations between reminder and ticket</span><span style=color:black><o:p></o:p></span></p></div><p class=MsoNormal style=background:white><span style=color:black><o:p> </o:p></span></p><div id=yiv840790732><div><div><div><p class=MsoNormal style=background:white><span style=color:black>Hi I am trying find why this is hapening "Couldn't find Ticket for reminder 2087. Please contact administrator." since I have put the cleanup scripts and they workes when I do testing. But once in a while I get this error on the dash board. What I do is log in to the DB and make it resolved<o:p></o:p></span></p></div><div><p class=MsoNormal><span style=color:black><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style=color:black>I have been going through the DB and unable to find the relation between the ticks and treminders<o:p></o:p></span></p></div><div><p class=MsoNormal><span style=color:black><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style=color:black>Thanks and Best Regards<o:p></o:p></span></p></div><div><p class=MsoNormal style=background:white><span style=color:black><o:p> </o:p></span></p></div><div><div><div><div class=MsoNormal align=center style=text-align:center;background:white><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'><hr size=1 width="100%" align=center /></span></div><p class=MsoNormal style=background:white><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>From:</span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'> Asanka Gunasekera <asanka_gunasekera@yahoo.co.uk><br /><b>To:</b> "rt-users@lists.bestpractical.com" <rt-users@lists.bestpractical.com> <br /><b>Sent:</b> Thursday, 20 September 2012, 14:14<br /><b>Subject:</b> [rt-users] relations between reminder and ticket</span><span style=color:black><o:p></o:p></span></p></div><p class=MsoNormal style=background:white><span style=color:black><o:p> </o:p></span></p><div id=yiv840790732><div><div><div><p class=MsoNormal style=background:white><span style=color:black>Hi anyone can tell me where RT keeps the relationship between a ticket and a reminder<o:p></o:p></span></p></div><div><p class=MsoNormal style=background:white><span style=color:black><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style=color:black>Thanks and Regards<o:p></o:p></span></p></div></div></div></div><p class=MsoNormal style=margin-bottom:12.0pt;background:white><span style=color:black><br /><br />--------<br />Final RT training for 2012 in Atlanta, GA - October 23 & 24<br /> <a href="http://bestpractical.com/training" target="_blank">http://bestpractical.com/training</a><br /><br />We're hiring! <a href="http://bestpractical.com/jobs" target="_blank">http://bestpractical.com/jobs</a><br /><br /><o:p></o:p></span></p></div></div></div></div></div><p class=MsoNormal style=margin-bottom:12.0pt;background:white><span style=color:black><o:p> </o:p></span></p></div></div></div></div></div><p class=MsoNormal style=margin-bottom:12.0pt;background:white><span style=color:black><o:p> </o:p></span></p></div></div></div></div>
</P></BODY></HTML>