07-14-2015 01:12 AM - edited 03-17-2019 03:38 AM
Hi All,
When I opened the CDR and Analysis Reporting, there was a warning message popup that said there is a suspected error billing table.
Then, When I generate the CDR error, i found this log :
31110: which means that dateTimeConnect in a CDR record is not a positive integer
My question is What does it means? and how to fix it?
Thanks,
Solved! Go to Solution.
07-14-2015 01:56 AM
Hi Helmi,
As per the following link:
https://supportforums.cisco.com/document/55821/troubleshooting-cdr
"In the above example, the error codes are:
31110: which means that dateTimeConnect in a CDR record is not a positive integer
and
31148: which means that destDeviceName in a CDR record is NULL
The above error codes imply that the call was not connected (i.e. it did not enter a connected state) but a CDR record was nevertheless created for it. Since the call was not connected, it's not a 'billable' call. Hence, the corresponding record is entered into tbl_billing_error (as opposed to tbl_billing_data). This behavior is frequently observed on systems where the CallManager service parameter: 'CDR Log Calls with Zero Duration Flag' is enabled. If this service parameter is entered, a CDR record will be generated for calls that were never connected or were connected for less than a second. Most common scenarios that cause such CDR records:
07-14-2015 01:56 AM
Hi Helmi,
As per the following link:
https://supportforums.cisco.com/document/55821/troubleshooting-cdr
"In the above example, the error codes are:
31110: which means that dateTimeConnect in a CDR record is not a positive integer
and
31148: which means that destDeviceName in a CDR record is NULL
The above error codes imply that the call was not connected (i.e. it did not enter a connected state) but a CDR record was nevertheless created for it. Since the call was not connected, it's not a 'billable' call. Hence, the corresponding record is entered into tbl_billing_error (as opposed to tbl_billing_data). This behavior is frequently observed on systems where the CallManager service parameter: 'CDR Log Calls with Zero Duration Flag' is enabled. If this service parameter is entered, a CDR record will be generated for calls that were never connected or were connected for less than a second. Most common scenarios that cause such CDR records:
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide