[cisco-voip] Finding out what are error records in CAR in 5.1.2

[Wes Sisk]

Hi Erick,

The original "CDRInsert" process is replaced by the CAR loader.  CAR 
attempts to load the flat files directly into database and inserts 
errors into tbl_billing_error table.

Helpful statements from the CLI:
run sql select count(*) from car:tbl_billing_data where user_id='abc'
run sql select count(*) from car:tbl_billing_data where 
callingpartyunicodeloginuserid='abc'
run sql select count(*) from car:tbl_billing_data where 
finalcalledpartyunicodeloginuserid='abc'
run sql select * from car:tbl_billing_data where user_id='abc'
run sql select * from car:tbl_billing_data where 
callingpartyunicodeloginuserid='abc'
run sql select * from car:tbl_billing_data where 
finalcalledpartyunicodeloginuserid='abc'

then for the tbl_billing_error table:
run sql select first 1 * from car:tbl_billing_error
run sql select first 1 * from car:tbl_error_id_map

Here are the decodes for error_code:
CDR:
31101: CDR's globalCallID_callManagerId <= 0
31102: CDR's globalCallID_callId <= 0
31103: CDR's origLegCallIdentifier <= 0
31105: CDR's dateTimeOrigination <= 0
31108: CDR's destLegIdentifier <= 0
31110: CDR's dateTimeConnect <= 0
31111: CDR's dateTimeDisconnect <= 0
31122: CDR's duration < 0
31147: CDR's origDeviceName is empty
31148: CDR's destDeviceName is empty
31151: CDR's origCallTerminationOnBehalfOf < 0
31152: CDR's destCallTerminationOnBehalfOf < 0
31153: CDR's lastRedirectRedirectOnBehalfOf < 0
31155: CDR's destConversationId < 0
31156: CDR's globalCallId_ClusterID is empty

Orig CMR:
31123: Orig CMR's globalCallID_callManagerId <= 0
31124: Orig CMR's globalCallID_callId <= 0
31129: Orig CMR's callIdentifier <= 0
31125: Orig CMR's numberPacketsSent < 0
31126: Orig CMR's numberPacketsReceived < 0
31127: Orig CMR's jitter < 0
31149: Orig CMR's deviceName is empty
31157: Orig CMR's globalCallId_ClusterID is empty

Dest CMR:
31140: Dest CMR's globalCallID_callManagerId <= 0
31141: Dest CMR's globalCallID_callId <= 0
31145: Dest CMR's callIdentifier <= 0
31142: Dest CMR's numberPacketsSent < 0
31143: Dest CMR's numberPacketsReceived < 0
31144: Dest CMR's jitter < 0
31150: Dest CMR's deviceName is empty
31158: Dest CMR's globalCallId_ClusterID is empty



Erick Bergquist wrote:
> I have a issue where there are CDR records for various dates in the
> CDR database (from CDR search on extensions) but the System Summary,
> Traffic by extension report shows 0 calls for the same extensions
> selected in the CDR search.  There are 70,000 or so errors in the
> Tbl_Billing_Data database from looking at the table information under
> manual database purge.\
>
> In pre 5.x days, one could go look at the BAD subfolder and see what
> the bad records were, etc and fix them maybe and put them back to be
> loaded in. How can one tell what is bad record in 5.1.2 and why the
> records are not in CAR and showing up in the report?
>
> The version is 5.1.2.1000-11
>
> Erick
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>