[cisco-voip] CDR flatfiles readonly, CDRinsert not filling database

[Wes Sisk]

Hello Arjen,

Nice problem description.

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?

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?

Then CDRInsert starts up and does its job reading files from the  
directory on the publisher.

When you say the files are readonly, do you mean by file permissions  
or by the readonly attribute (attrib <filename> from cmd prompt)?

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 www.sysinternals.com to  
monitor the cdr files, clear the readonly attribute and capture the  
filemon log showing what process sets the readonly attribute?

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.

/Wes

On Jul 4, 2006, at 7:25 AM, Arjen de Vries wrote:

L.s,

Recentely we have started using Cisco Call Manager. The CDR data is  
stored in flat files. This data can be set to be updated to a  
database. And it should insert the history (old flatfiles) to this  
database too. Now we have the next problem. The CDRInsert process  
knows where the flatfiles are located. These flatfiles seem to be  
read only, so the CDRinsert can’t process them. If we manually set  
the property of the flatfiles to be writeable, the CDRinsert process  
changes it after the first processing of files and doesn’t seem to  
insert anything in the datatable CallDetailRecord.

We have 2 CallManagers, a publisher and a subscriber. On both  
CallManagers there is a SQL Server running. On both servers there is  
the database CCM0300. On the first (publisher) server there is a CDR  
database. In witch some of the CallDetailRecords are available.

Is this a known issue? And is there some setting I have missed? I  
cant seem to find 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 I  
might need some direction on the information needed to properly  
analyze this problem.

Thanks in advance.

Kindest regards,

Arjen F. de Vries
Consultant

STS Automatisering BV
E-mail: arjen.devries at sts-automatisering.nl
Web: http://www.sts-automatisering.nl


_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060704/79f321a4/attachment.html