<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here is the SQL command I use to pull the values from the UCCX database:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Select sessionid, startdatetime,enddatetime, applicationname, originatordn, origcallednumber, destinationdn, destinationtype, contactdisposition, customvariable1,customvariable2, customvariable3,customvariable4,customvariable5,
<o:p></o:p></p>
<p class="MsoNormal">customvariable6, customvariable7, customvariable8, customvariable9, customvariable10, accountnumber<o:p></o:p></p>
<p class="MsoNormal">from contactcalldetail ccd<o:p></o:p></p>
<p class="MsoNormal">where startdatetime >= '2014-05-01 00:00:00'<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks!<o:p></o:p></p>
<p class="MsoNormal">Kevin<o:p></o:p></p>
</div>
</body>
</html>