<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Arjen,<DIV><BR class="khtml-block-placeholder"></DIV><DIV>Interesting. If you execute 'sp_who2' do you actually see CDRInsert logged in with all of those SPID's? If so, can you restart CDRInsert to see if they clear? If not, you will need to use 'kill <spid>' to kill the logins or restart SQL server.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>If you do review 'sp_who2' are there any waiting processes? And if so, what are they waiting on?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Troubleshooting prepare and unprepare SQL statements is covered here:</DIV><DIV><A href="http://support.microsoft.com/Default.aspx?id=224587">http://support.microsoft.com/Default.aspx?id=224587</A></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>/Wes</DIV><DIV><BR><DIV><DIV>On Jul 11, 2006, at 7:20 AM, Arjen de Vries wrote:</DIV><BR class="Apple-interchange-newline"><O:SMARTTAGTYPE namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="Street"> <O:SMARTTAGTYPE namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="address"> <DIV class="Section1"><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy">L.S,<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy">In short: We are having trouble with the CDR data in flatfiles not being inserted into the database. The flatfiles are saved in a readonly manner and when the CDR Insert process starts it’s getting a lot of threads in SQL Server and they seem to lockup.<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy">We have made some changes with Wes his tips but didn’t see any improvement that is why I am reporting back to this mailing list in hope to find some answers.<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy">Most solutions to our problems are related to user rights and setting them the right way. On both our servers we have synched the user settings and the services under which they are running. Now we still have the readonly problem with the flatfiles. And it causes many lockups in our SQL Server.<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy">I have included a screenshot of the information we get from SQL Server. In little time it produces over a thousand threads that are stuck with the message in last executed SQL command: “sp_unprepare;1”.<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy">If I can provide more information in order for anyone to help me in the right directions with this problem please do ask. I will try my best to give as many information needed to get some answers.<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy">Maybe I have missed some detail with which I could have solved this problem from Wes his mail. If so I apologize.<O:P></O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial;color:navy">Thanks for your time!<O:P></O:P></SPAN></FONT></P> <DIV><P class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><STRONG><B><FONT size="1" color="#570251" face="Verdana"><SPAN style="font-size:7.5pt;font-family: Verdana;color:#570251">Arjen F. de Vries</SPAN></FONT></B></STRONG><FONT color="black"><SPAN style="color:black"> <BR> </SPAN></FONT><FONT size="1" color="#017896" face="Verdana"><SPAN style="font-size: 7.5pt;font-family:Verdana;color:#017896">Consultant</SPAN></FONT><FONT color="black"><SPAN style="color:black"> </SPAN></FONT><FONT color="navy"><SPAN style="color:navy"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><FONT size="1" color="#017896" face="Verdana"><SPAN style="font-size:7.5pt;font-family: Verdana;color:#017896">M.06 18397581</SPAN></FONT><FONT color="black"><SPAN style="color:black"> </SPAN></FONT><FONT color="navy"><SPAN style="color:navy"><O:P></O:P></SPAN></FONT></P><P><B><FONT size="1" color="#570251" face="Verdana"><SPAN style="font-size:7.5pt; font-family:Verdana;color:#570251;font-weight:bold"><U1:STREET u2:insauthor="adevries" u2:insdate="2006-02-27T09:35:00Z" u2:endinsauthor="adevries" u2:endinsdate="2006-02-27T09:35:00Z"><U1:ADDRESS u2:insauthor="adevries" u2:insdate="2006-02-27T09:35:00Z" u2:endinsauthor="adevries" u2:endinsdate="2006-02-27T09:35:00Z">STS </U1:ADDRESS></U1:STREET></SPAN></FONT></B><B><FONT size="1" color="#017896" face="Verdana"><SPAN style="font-size:7.5pt;font-family:Verdana;color:#017896;font-weight:bold">Automatisering BV</SPAN></FONT></B><FONT color="navy"><SPAN style="color:navy"> <BR> </SPAN></FONT><FONT size="1" color="#570251" face="Verdana"><SPAN style="font-size: 7.5pt;font-family:Verdana;color:#570251">Fivelpoort 10B 9902 SR Appingedam</SPAN></FONT><FONT color="navy"><SPAN style="color:navy"> <BR> </SPAN></FONT><FONT size="1" color="#570251" face="Verdana"><SPAN style="font-size: 7.5pt;font-family:Verdana;color:#570251">Postbus 117 9930 AC Delfzijl</SPAN></FONT><FONT color="navy"><SPAN style="color:navy"> <BR> </SPAN></FONT><FONT size="1" color="#017896" face="Verdana"><SPAN style="font-size: 7.5pt;font-family:Verdana;color:#017896">Telefoon 0596-856550</SPAN></FONT><FONT color="navy"><SPAN style="color:navy"> <BR> </SPAN></FONT><FONT size="1" color="#017896" face="Verdana"><SPAN style="font-size: 7.5pt;font-family:Verdana;color:#017896">Telefax 0596-634818</SPAN></FONT><FONT color="black"><SPAN style="color:black"> <BR> </SPAN></FONT><FONT size="1" color="#570251" face="Verdana"><SPAN style="font-size: 7.5pt;font-family:Verdana;color:#570251">E-mail: </SPAN></FONT><FONT size="1" color="#570251" face="Verdana"><SPAN lang="EN-GB" style="font-size:7.5pt; font-family:Verdana;color:#570251"><A href="BLOCKED::mailto:arjen.devries@sts-automatisering.nl" title="mailto:arjen.devries@sts-automatisering.nl"><SPAN lang="EN-US"><SPAN title="mailto:arjen.devries@sts-automatisering.nl">arjen.devries@sts-automatisering.nl</SPAN></SPAN></A></SPAN></FONT><FONT color="black"><SPAN lang="EN-GB" style="color:black"> </SPAN></FONT><FONT size="1" color="#570251" face="Verdana"><SPAN style="font-size:7.5pt;font-family:Verdana; color:#570251"><BR> Web: </SPAN></FONT><FONT size="1" color="#570251" face="Verdana"><SPAN lang="EN-GB" style="font-size:7.5pt;font-family:Verdana;color:#570251"><A href="BLOCKED::http://www.sts-automatisering.nl" title="http://www.sts-automatisering.nl"><SPAN lang="EN-US"><SPAN title="http://www.sts-automatisering.nl">http://www.sts-automatisering.nl</SPAN></SPAN></A></SPAN></FONT><FONT color="black"><SPAN lang="EN-GB" style="color:black"> </SPAN></FONT><O:P></O:P></P> </DIV> <DIV> <DIV class="MsoNormal" align="center" style="text-align:center"><FONT size="3" face="Times New Roman"><SPAN style="font-size:12.0pt"> <HR size="2" width="100%" align="center" tabindex="-1"> </SPAN></FONT></DIV><P class="MsoNormal"><B><FONT size="2" face="Tahoma"><SPAN style="font-size:10.0pt; font-family:Tahoma;font-weight:bold">From:</SPAN></FONT></B><FONT size="2" face="Tahoma"><SPAN style="font-size:10.0pt;font-family:Tahoma"> Wes Sisk [<A href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</A>] <BR> <B><SPAN style="font-weight:bold">Sent:</SPAN></B> dinsdag 4 juli 2006 18:36<BR> <B><SPAN style="font-weight:bold">To:</SPAN></B> Arjen de Vries<BR> <B><SPAN style="font-weight:bold">Cc:</SPAN></B> <A href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR> <B><SPAN style="font-weight:bold">Subject:</SPAN></B> Re: [cisco-voip] CDR flatfiles readonly, CDRinsert not filling database</SPAN></FONT><O:P></O:P></P> </DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">Hello Arjen,<O:P></O:P></SPAN></FONT></P> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">Nice problem description.<O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">the cdr flat files are generated locally by ccm.exe running on the server. This process creates the files and the files should inherit the directory permissions - can you check what userid ccm.exe runs under on your publisher and subscriber? Then check the NTFS file permissions on the CallDetail,CDR, and CMR directories?<O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">Once files are written the Aupair.exe (Cisco Database Layer Monitor) process on the subscriber moves the files up to the publisher server via the windows share \\<publisher>\cdr. Can you verify what user Aupair.exe is running under on the subscriber? Can you verify permissions on the cdr share on the publisher?<O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">Then CDRInsert starts up and does its job reading files from the directory on the publisher.<O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">When you say the files are readonly, do you mean by file permissions or by the readonly attribute (attrib <filename> from cmd prompt)?<O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">I have found the cdr files marked as readonly just a few times on CM systems. I have never been able to find the process that marked them as readonly. Can you use filemon from <A href="http://www.sysinternals.com">www.sysinternals.com</A> to monitor the cdr files, clear the readonly attribute and capture the filemon log showing what process sets the readonly attribute?<O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">CSCsd88223 is another issue in recent versions of CM that prevent files from properly inserting into the database, but this is because of locks inside the SQL database. Typically one of the steps in the 'IPT Optimizations' SQL job grabs and holds locks causing this problem.<O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">/Wes<O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> <DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">On Jul 4, 2006, at 7:25 AM, Arjen de Vries wrote:<O:P></O:P></SPAN></FONT></P> </DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P><P><FONT size="2" face="Arial"><SPAN lang="NL" style="font-size:10.0pt;font-family: Arial">L.s,</SPAN></FONT><O:P></O:P></P><P><FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">Recentely we have started using Cisco Call Manager.</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">The</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">CDR data</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">is</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">stored in flat files.</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial">This data can be set to be updated to</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">a</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">database.</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">And it should insert the history (old flatfiles) to this database too.</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">Now</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">we have the next</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size: 10.0pt;font-family:Arial">problem. The CDRInsert process knows where the</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">flatfiles are located. These flatfiles seem to be read only, so the CDRinsert can’t process them. If we manually set the property</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">of the flatfiles</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">to be writeable, the CDRinsert</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">process changes it after the first processing of files and</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">doesn’t seem to insert anything in the</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt; font-family:Arial">datatable</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">CallDetailRecord.</SPAN></FONT><O:P></O:P></P><P><FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">We have 2 CallManagers, a publisher and a subscriber.</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">On both CallManagers there is a</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt; font-family:Arial">SQL Server running. On both servers there is the database CCM0300. On the first (publisher) server there is a CDR</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">database. In witch some of the CallDetailRecords are available.</SPAN></FONT><O:P></O:P></P><P><FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">Is this a known issue?</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">And is there some setting</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">I</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">have missed?</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt; font-family:Arial">I cant seem to find</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">information about this anywhere. If there is more information needed on the configuration please report back to me. I am not really comfortable with the call manager settings yet. So</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">I might need some direction on the information needed to properly</SPAN></FONT> <FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">analyze this problem.</SPAN></FONT><O:P></O:P></P><P><FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">Thanks in advance.</SPAN></FONT><O:P></O:P></P><P><FONT size="2" face="Arial"><SPAN style="font-size:10.0pt;font-family:Arial">Kindest regards,</SPAN></FONT><O:P></O:P></P><P><A name=""><B><FONT size="1" color="#570251" face="Verdana"><SPAN style="font-size:7.5pt;font-family:Verdana;color:#570251;font-weight:bold">Arjen F. de Vries</SPAN></FONT></B></A><FONT color="black" face="Arial"><SPAN style="font-family:Arial;color:black"> <BR> </SPAN></FONT><FONT size="1" color="#017896" face="Verdana"><SPAN style="font-size: 7.5pt;font-family:Verdana;color:#017896">Consultant</SPAN></FONT> <O:P></O:P></P><P><ST1:STREET w:st="on"><ST1:ADDRESS w:st="on"><B><FONT size="1" color="#570251" face="Verdana"><SPAN style="font-size:7.5pt;font-family:Verdana;color:#570251; font-weight:bold">STS</SPAN></FONT> </B><B><FONT size="1" color="#017896" face="Verdana"><SPAN style="font-size:7.5pt;font-family:Verdana;color:#017896; font-weight:bold">Automatisering BV</SPAN></FONT></B></ST1:ADDRESS></ST1:STREET><FONT face="Arial"><SPAN style="font-family:Arial"> <BR> </SPAN></FONT><FONT size="1" color="#570251" face="Verdana"><SPAN style="font-size: 7.5pt;font-family:Verdana;color:#570251">E-mail:</SPAN></FONT> <A href="BLOCKED::mailto:arjen.devries@sts-automatisering.nl"><FONT size="1" face="Verdana"><SPAN style="font-size:7.5pt;font-family:Verdana">arjen.devries@sts-automatisering.nl</SPAN></FONT></A><BR> <FONT size="1" color="#570251" face="Verdana"><SPAN style="font-size:7.5pt; font-family:Verdana;color:#570251">Web:</SPAN></FONT> <A href="BLOCKED::http://www.sts-automatisering.nl"><FONT size="1" face="Verdana"><SPAN style="font-size:7.5pt;font-family:Verdana">http://www.sts-automatisering.nl</SPAN></FONT></A> <O:P></O:P></P> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">_______________________________________________<O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt">cisco-voip mailing list<O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><A href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><O:P></O:P></SPAN></FONT></P> </DIV> <DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><A href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A><O:P></O:P></SPAN></FONT></P> </DIV> </DIV><P class="MsoNormal"><FONT size="3" face="Times New Roman"><SPAN style="font-size: 12.0pt"><O:P> </O:P></SPAN></FONT></P> </DIV> </DIV> </O:SMARTTAGTYPE></O:SMARTTAGTYPE><SPAN><DIV><SQL-server-CCM1_bw.gif></DIV></SPAN></DIV><BR></DIV></BODY></HTML>