<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>CDR flatfiles readonly, CDRinsert not filling database</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<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>
<P ALIGN=LEFT><SPAN LANG="en-us"></SPAN></P>
</BODY>
</HTML>