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.

New Member

There are no string with RouterCallKeySequenceNumber = 0

Hello!

In Termination_Call_Detail some calls don't have string with  RouterCallKeySequenceNumber = 0.  Only 1,2.. end etc..

There are no some regularity for this calls.

Why it may happens?

15 REPLIES

This sounds like a strange

This sounds like a strange issue. Do you have any specific examples you could share?

-Jameson
 

-Jameson
New Member

Hi, Jameson!This is SQL

Hi, Jameson!

This is SQL request:

DECLARE @dt_s datetime, @dt_e datetime
SET @dt_s = '2014-06-04'
SET @dt_e = '2014-06-07'

SELECT *
FROM
(
SELECT RCD.RouterCallKeyDay, RCD.RouterCallKey
, [SeqN] = sum(CASE WHEN TCD.RouterCallKeySequenceNumber = 0 THEN 1 ELSE 0
END)
FROM ipcc_hds.dbo.t_Route_Call_Detail RCD
LEFT JOIN ipcc_hds.dbo.t_Termination_Call_Detail TCD WITH (INDEX
(XIE5Termination_Call_Detail)) ON TCD.RouterCallKeyDay = RCD.RouterCallKeyDay
AND TCD.RouterCallKey = RCD.RouterCallKey
WHERE RCD.DateTime BETWEEN @dt_s and @dt_e
AND RCD.FinalObjectID != 1009
AND RCD.CallTypeID = 5241
GROUP BY RCD.RouterCallKeyDay, RCD.RouterCallKey
)T
LEFT JOIN ipcc_hds.dbo.t_Termination_Call_Detail TCD ON TCD.RouterCallKeyDay
= T.RouterCallKeyDay AND TCD.RouterCallKey = T.RouterCallKey
WHERE T.SeqN = 0
ORDER BY T.RouterCallKeyDay, T.RouterCallKey, TCD.RouterCallKeySequenceNumber

 

results in attachment
 

I see that many of the

I see that many of the DateTime values with missing entries clump together. I would check your B-side AWHDS for any of the missing RouterCallKeySequenceNumber=0 entries. If they exist on B side and not A side, you may have some communications issues between sides, and possibly some synchronization issues.

-Jameson

-Jameson
New Member

The problem is actual.I can't

The problem is actual.

I can't find missing RouterCallKeySequenceNumber=0 entries on B-side.

In DataBase_schema_guide is written:  This value "currently set to zero(0)"

What does it mean? It must be zero or may be zero ?


Regards, Alexey

Alexey,There should be a

Alexey,

There should be a RouterCallKeySequenceNumber=0 entry for every call (and usually 1,2, etc).

I've run out of ideas on this one. Perhaps this would be an issue for Cisco TAC.

-Jameson

-Jameson
New Member

Hi, Jameson.Thank you for

Hi, Jameson.

Thank you for reply. 

Alexey,I actually just came

Alexey,

I actually just came across this issue in my TCD table. In my case, I found the missing RouterCallKeySequenceNumber=0 entry with RouterCallKey=0 and RouterCallKeyDay=0. The ANI is the same, and the CallGUID is the same. Call Disposition is 27: Failed Software. 

The Agent experience in this case was the following:

  1. Agent answered call
  2. Agent talked to caller
  3. Agent lost call
  4. Call entered CVP survivability, was delivered according to SRST rules on voice gateway

Can you check some of the CallGUID values for your missing RouterCallKeySequenceNumber=0 and see if you have any similar behavior?

-Jameson

-Jameson
New Member

Hi, JamesonMissing

Hi, Jameson

Missing RouterCallKeySequenceNumber=0 - it's not issue - oficcial answer of Cisco TAC.   

Hi,certainly, it's not an

Hi,

certainly, it's not an issue. The schema guide says: "This number is a best effort to describe the order in which call legs were created and bears no relation to the order in which calls ended." So there's no guarrantee since it's best effort.

And by the way, do not use tables (anything starting with t_, for instance t_Termination_Call_Deatil). Use the the views instead (Termination_Call_Detail).

G.

New Member

Ок. But we found a useful

Ок. But we found a useful feature (bug?). Duration in this string = full call duration, include time after transfer internal call on external number out of CC. It's very useful for reporting in our case.

But Cisco not approved this feature (

 

Alexey.

 Whaaaaat? Wow. Can you give

 

Whaaaaat? Wow. Can you give me the exact ICM and CUCM version (including ES's) please. G.

 

 

New Member

 With question "What

 With question "What condition for appearing of this string?" -  i was directed  to Developer Support  ))

 

CUCM 8.6.2.23900-10 

ICM VersionString:
8.5(3) BuildNumber=29007 ES=0 PatchInstallerVer=170

CVP Version 8.5
 

New Member

Important note: in my case

Important note:

 in my case call was arrived from one gw and was transfered to another..  

Alright, thanks. Just to

Alright, thanks. Just to confirm, it is the TCD we are talking about is this correct? Also, about sending you to Dev: did you talk to someone at PDI HD? Or was it just TAC? G.

 

New Member

Yes, disscusion about TCD

Yes, disscusion about TCD.

Just TAC...     

 

223
Views
0
Helpful
15
Replies