<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:st1="urn:schemas-microsoft-com:office:smarttags" 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 11 (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]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
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";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue style='word-wrap: break-word;-khtml-nbsp-mode: space;
-khtml-line-break: after-white-space'>
<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
</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</u1:address></u1:Street></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
[mailto:wsisk@cisco.com] <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> cisco-voip@puck.nether.net<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>
</body>
</html>