<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Hello Arjen,<DIV><BR class="khtml-block-placeholder"></DIV><DIV>Nice problem description.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>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?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>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?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Then CDRInsert starts up and does its job reading files from the directory on the publisher.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>When you say the files are readonly, do you mean by file permissions or by the readonly attribute (attrib <filename> from cmd prompt)?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>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?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>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.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>/Wes</DIV><DIV><BR><DIV><DIV>On Jul 4, 2006, at 7:25 AM, Arjen de Vries wrote:</DIV><BR class="Apple-interchange-newline"><P align="LEFT"><SPAN lang="nl"><FONT size="2" face="Arial">L.s,</FONT></SPAN></P><P align="LEFT"><SPAN lang="en-us"><FONT size="2" face="Arial">Recentely we have started using Cisco Call Manager</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial">.</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial"></FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">The</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">CDR data</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">is</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">stored in flat files.</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">This data can be set to be updated to</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">a</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">database.</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">And it should insert the history (old flatfiles) to this database too.</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">Now</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">we have the next</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">problem. The CDRInsert process knows where the</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">flatfiles are located. These flatfiles seem to be read only, so the CDRinsert can</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial">’</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial">t process them. If we manually set the property</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">of the flatfiles</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">to be writeable</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial">, t</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial">he CDRinsert</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">process changes it after the first processing of files</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial"> and</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">doesn’t</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial"> seem to insert anything in the</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">data</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial">table</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">CallDetailRecord</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial">.</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"></SPAN></P><P align="LEFT"><SPAN lang="en-us"><FONT size="2" face="Arial">We have 2 CallManagers, a publisher and a subscriber.</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">On both CallManagers there is a</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">SQL Server running. On both servers there is the database CCM0300. On the first (publisher) server there is a CDR</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">database</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial">. In witch some of the CallDetailRecords are available.</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"></SPAN></P><P align="LEFT"><SPAN lang="en-us"><FONT size="2" face="Arial">Is this a known issue?</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">And is there some setting</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">I</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial"></FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">have missed?</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">I cant seem to find</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">information</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial"> about this anywhere.</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial"> 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</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">I</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial"> might need some direction on the information needed to properly</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"> <FONT size="2" face="Arial">analyze</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"><FONT size="2" face="Arial"> this problem.</FONT></SPAN></P><P align="LEFT"><SPAN lang="en-us"><FONT size="2" face="Arial">Thanks in advance.</FONT></SPAN></P><P align="LEFT"><SPAN lang="en-us"><FONT size="2" face="Arial">Kindest regards,</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="en-us"></SPAN></P><P align="LEFT"><B><SPAN lang="nl-nl"></SPAN></B><A name=""><B><SPAN lang="nl-nl"><FONT color="#570251" size="1" face="Verdana">Arjen F. de Vries</FONT></SPAN></B></A><SPAN lang="nl"></SPAN><SPAN lang="nl-nl"><FONT color="#000000" face="Arial"> <BR> </FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl-nl"><FONT color="#017896" size="1" face="Verdana">Consultant</FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl-nl"><FONT color="#000000" face="Arial"></FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl-nl"> </SPAN></P><P align="LEFT"><B><SPAN lang="nl-nl"><FONT color="#570251" size="1" face="Verdana">STS</FONT></SPAN></B><SPAN lang="nl"><B></B></SPAN><SPAN lang="nl"><B></B></SPAN><B><SPAN lang="nl-nl"> <FONT color="#017896" size="1" face="Verdana">Automatisering BV</FONT></SPAN></B><SPAN lang="nl"></SPAN><SPAN lang="nl-nl"><FONT face="Arial"> <BR> </FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl-nl"><FONT color="#570251" size="1" face="Verdana">E-mail:</FONT></SPAN><SPAN lang="nl"> </SPAN><A href="BLOCKED::mailto:arjen.devries@sts-automatisering.nl"><SPAN lang="nl"></SPAN><SPAN lang="nl"><U></U></SPAN><U><SPAN lang="nl-nl"><FONT color="#0000FF" size="1" face="Verdana">arjen.devries@sts-automatisering.nl</FONT></SPAN></U><SPAN lang="nl"></SPAN></A><SPAN lang="nl"></SPAN><SPAN lang="nl-nl"><FONT color="#000000" face="Arial"></FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl-nl"><BR> <FONT color="#570251" size="1" face="Verdana">Web:</FONT></SPAN><SPAN lang="nl"> </SPAN><A href="BLOCKED::http://www.sts-automatisering.nl"><SPAN lang="nl"></SPAN><SPAN lang="nl"><U></U></SPAN><U><SPAN lang="nl-nl"><FONT color="#0000FF" size="1" face="Verdana">http://www.sts-automatisering.nl</FONT></SPAN></U><SPAN lang="nl"></SPAN></A><SPAN lang="nl"></SPAN><SPAN lang="nl-nl"><FONT color="#000000" face="Arial"></FONT></SPAN><SPAN lang="nl"></SPAN><SPAN lang="nl-nl"> </SPAN></P><DIV><SPAN lang="en-us"></SPAN><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">cisco-voip mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A></DIV> </DIV><BR></DIV></BODY></HTML>