[cisco-voip] UCCX accountnumber column in Informix database

[Damisch, Kevin]

I went a step further and set the Set Enterprise Info step to populate the customvariable10 and accountnumber variables both with the strAccountNumber value.  Attached are sanitized screenshots of a test script I just made to replicate the issue in its simplest form, but get the same results.  I have strAccountNumber == 1111111111111111 in the reactive debug and watched it step through Selected, Set Enterprise Call Info, Connected, and Goto END steps.  I talked to the agent who answered and verified they saw 1111111111111111 in both customervariable10 and accountnumber fields within CAD.  So, my question is how can CAD see it in both fields, yet the database doesn't show it in the accountnumber field?  If you look at the SQLResults screenshot, you can see that it does populate CustomVariable10, but accountnumber is blank.  Again, all other custom variables get populated correctly with no issues.  The accountnumber column is the only one that is blank, and its only when the call ends up going to an agent.

I have all 10 custom variables used up with other things, so I can't just move this value into one of those, which is why I'm trying to use the accountnumber custom variable to store, you know, the account number.

Thanks!
Kevin


From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Damisch, Kevin
Sent: Friday, May 02, 2014 1:53 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] UCCX accountnumber column in Informix database

I have a UCCX 8.5(1)SU3 deployment where we set values in custom variables 1 to 10 (actually Call.PeripheralVariable1 to 10) and also Call.AccountNumber via the Set Enterprise Info step.  Whether we check the values by setting up a linked server or by creating a db connection to the Informix database, we can see variables 1 to 10 and the accountnumber columns populated correctly in the contactcalldetail table.  Everything gets written to the database correctly when the call is ended while navigating the IVR or if they are in the queued branch of the select resource step.  If the caller ends up talking to an agent, the accountnumber column in the Informix database is empty for that record.  Even more strange, the accountnumber value still gets passed down to CAD and the agent sees it just fine, yet it isn't in the accountnumber column in the database.

Here is the SQL command I use to pull the values from the UCCX database:

Select sessionid, startdatetime,enddatetime, applicationname, originatordn, origcallednumber, destinationdn, destinationtype, contactdisposition, customvariable1,customvariable2, customvariable3,customvariable4,customvariable5,
customvariable6, customvariable7, customvariable8, customvariable9, customvariable10, accountnumber
from contactcalldetail ccd
where startdatetime >= '2014-05-01 00:00:00'

This sounds like a TAC case, but wanted to see if anyone on this list has seen this before.  And, does anyone know what xdebugging level needs checked to see the Set Enterprise Info steps in the MIVR logs?

Thanks!
Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140502/e62bc70b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SelectResource.JPG
Type: image/jpeg
Size: 32006 bytes
Desc: SelectResource.JPG
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140502/e62bc70b/attachment.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SetEnterpriseInfo.JPG
Type: image/jpeg
Size: 27906 bytes
Desc: SetEnterpriseInfo.JPG
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140502/e62bc70b/attachment-0001.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SQLResults.JPG
Type: image/jpeg
Size: 68148 bytes
Desc: SQLResults.JPG
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140502/e62bc70b/attachment-0002.jpe>