Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

Calls with zero duration are sent with 1/1/1970 timestamp

Hello.

We are configuring billing on a third-party server for a hospitality projects.

All is fine so far. However we saw that calls with zero duration (such as missed calls, busy tones etc) are tagged with a wrong timestamp of 1/1/70.

Since we are passing this over to the hotel PMS, they are having trouble interpret it and often their interface crashes.

Has someone encountered any similar issue?

Our System version: 9.1.1.20000-5

Everyone's tags (2)
2 ACCEPTED SOLUTIONS

Accepted Solutions

Calls with zero duration are sent with 1/1/1970 timestamp

I only see the 1970 date in fields like Call Connection time. And for a missed/busy call, that's the best you can do as the call didn't connect, so the call can't have a connection time. Either the field has the 1970 date, or it has NULL in it. Either way, if your third party software can't cope with it, it's broken as this is all as per Cisco's spec.

The use of the 1970 date is (OK, a time of zero) is clearly documented

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/service/9_1_1/cdrdef/CUCM_BK_C268EF1B_00_cucm-cdr-admin-guide-91/CUCM_BK_C268EF1B_00_cucm-cdr-admin-guide-91_chapter_010.html#CUCM_RF_T0347117_00

GTG

Please rate all helpful posts.

Please rate all helpful posts.

Calls with zero duration are sent with 1/1/1970 timestamp

The other option, of course, is to disable zero duration records in CallManager:

System -> Service Parameters -> (Server) -> CallManager -> CDR Log Calls with Zero Duration Flag

GTG

Please rate all helpful posts.

Please rate all helpful posts.
6 REPLIES

Calls with zero duration are sent with 1/1/1970 timestamp

I only see the 1970 date in fields like Call Connection time. And for a missed/busy call, that's the best you can do as the call didn't connect, so the call can't have a connection time. Either the field has the 1970 date, or it has NULL in it. Either way, if your third party software can't cope with it, it's broken as this is all as per Cisco's spec.

The use of the 1970 date is (OK, a time of zero) is clearly documented

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/service/9_1_1/cdrdef/CUCM_BK_C268EF1B_00_cucm-cdr-admin-guide-91/CUCM_BK_C268EF1B_00_cucm-cdr-admin-guide-91_chapter_010.html#CUCM_RF_T0347117_00

GTG

Please rate all helpful posts.

Please rate all helpful posts.

Calls with zero duration are sent with 1/1/1970 timestamp

Developers are working to have the system remove the zero call durations when sending to PMS.

Weird why CUCM should do something like that for zero duration calls

Calls with zero duration are sent with 1/1/1970 timestamp

As I said, the 1970 date only appears in the call connect field, and a missed call never connects!

GTG

Please rate all helpful posts.

Please rate all helpful posts.

Calls with zero duration are sent with 1/1/1970 timestamp

The other option, of course, is to disable zero duration records in CallManager:

System -> Service Parameters -> (Server) -> CallManager -> CDR Log Calls with Zero Duration Flag

GTG

Please rate all helpful posts.

Please rate all helpful posts.

Calls with zero duration are sent with 1/1/1970 timestamp

Hello Gordon.

We tried to disable the zero duration records in callmanager to no avail.

So the developers rewrote the code to remove the records containing 1970 and now we are no more sending these to PMS.

By the way, is this feature new as from CUCM 9.1? we has been installing this 3rd party server since CUCM 6.1.5 and this is the first time we encounter this issue.

Thanks for your kind help.

Calls with zero duration are sent with 1/1/1970 timestamp

It's there in CUCM 3.x!

From http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/cdr_def/3_x/CDR.html#wp33440

The dateTimeConnect field is defined as:

"Identifies the date and time that the call connected. UTC specifies the  time. If the call is never answered, this value shows zero."

GTG

Please rate all helpful posts.

Please rate all helpful posts.
336
Views
0
Helpful
6
Replies