CRA database fields store data in milliseconds and are presented on a wallboard in HH:MM:SS format

[TCC_2]

Core Issue

These database table fields in the RtCSQsSummary and the RtICDStatistics database tables store the date in milliseconds:

• avgTalkDuration
  
  
• avgWaitDuration
  
  
• longestTalkDuration
  
  
• longestWaitDuration
  
  
• oldestContact

Resolution

In order to include information described by these fields on a wallboard, use these fields, which store the same information but use the HH:MM:SS format:

• Use convAvgTalkDuration instead of avgTalkDuration.    
• Use convAvgWaitDuration instead of avgWaitDuration.    
• Use convLongestTalkDuration instead of longestTalkDuration.    
• Use convLongestWaitDuration instead of longestWaitDuration.    
• Use convOldestContact instead of oldestContact.

Refer to these documents for more information on resolving Cisco Customer Response Applications (CRA) or Customer Response Solution (CRS):

• Diagnosing and Correcting Cisco CRA Problems    
• Cisco IPCC Error Codes
  
  
  
• Troubleshooting TechNotes

Customer Response Solution (CRS) Version

CRS 3.x