problem with inserting cmd records in the database

Answered Question
Jul 23rd, 2008

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

I have this problem too.
0 votes
Correct Answer by irisrios about 8 years 4 months ago

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
irisrios Tue, 07/29/2008 - 14:41

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

kurtdeneef Wed, 07/30/2008 - 22:58

Indeed,this is the bug.

I already openened a TAC case for that.

Hard to find this bug...

Ayway,thanks for the reply.

Kurt

Actions

This Discussion