07-23-2008 06:23 AM - edited 03-15-2019 12:09 PM
Hello people,
I have an issue with CDR insert.
CMR files are copied into the BAD directory by CCM.When i move them into the cmr directory,they are being copied again to the BAD directory instead of begin written into the database.
At the same time,i have the following message in the insertcdr traces:
07/23/2008 15:05:41.686 CDR| CMonitor::ConvertFile Processing file [\\DCCM01\CDR\CMR\cmr_GRP_AS02072320081504]|<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|-->CMonitor::SetupColumnNames |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|<--CMonitor::SetupColumnNames |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|-->CMonitor::SetupColumnTypes |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|<--CMonitor::SetupColumnTypes |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|-->CMonitor::InsertRecord Error |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR| CMonitor::InsertRecord Error *ERROR* ParseCsvStr failed|<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|<--CMonitor::InsertRecord Error |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|-->CMonitor::InsertRecord Error |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR| CMonitor::InsertRecord Error *ERROR* Insert failed S [42000] E [aa]|<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|Error executing "insert into CallDetailRecordDiagnostic (": [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '('.|<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|<--CMonitor::InsertRecord Error |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR| CMonitor::ConvertFile 1 records in 0 ms|<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR| CMonitor::ConvertFile Moving [\\DCCM01\CDR\CMR\cmr_GRP_AS02072320081504]->[\\DCCM01\CDR\Bad\cmr_GRP_AS02072320081504]|<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|<--CMonitor::ConvertFile |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR| CMonitor::ProcessDirectoryChange () Remove connection|<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|<--CMonitor::ProcessDirectoryChange () |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR| CMonitor::MonThreadProc NTFS FindNext|<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR| CMonitor::MonThreadProc NTFS close event|<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|-->CMonitor::ReadConfiguration |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.686 CDR|-->SDIControlLayer::ReadDatabase(a24) |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.718 CDR|<--SDIControlLayer::ReadDatabase(a24) |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.718 CDR|-->SDIControlBase::Init(a24) |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.718 CDR|<--SDIControlBase::Init(a24) |<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.749 CDR| CMonitor::ReadConfiguration Directory = '\\DCCM01\CDR\'|<CLID::GRP_AS><NID::10.10.180.3>
07/23/2008 15:05:41.749 CDR| CMonitor::ReadConfiguration DSN override is empty|<CLID::GRP_AS><NID::10.10.180.3>
Syntax error???
Anyone encountered this before?
cdr records are fine.
Thanks for some advise
Kind regards,
Kurt
Solved! Go to Solution.
07-29-2008 02:41 PM
CIPC produces funny characters in the VarVQMetrics column in CMR files, which causes the CMR files to get stuck in the BAD folder.
This bug might help: CSCsm57884
07-29-2008 02:41 PM
CIPC produces funny characters in the VarVQMetrics column in CMR files, which causes the CMR files to get stuck in the BAD folder.
This bug might help: CSCsm57884
07-30-2008 10:58 PM
Indeed,this is the bug.
I already openened a TAC case for that.
Hard to find this bug...
Ayway,thanks for the reply.
Kurt
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: