Hello,<div> As requested by a few earlier in this thread here attached are some screenshots of the errors, and a snippet of the script that is doing the update, I have confirmed that this snippet yields the same error results, and the database is not updated.</div>
<div><br></div><div>When this snippet is happening in the script is after the user hangs up. In the beginning of the script we are running some DB selects and inserts to create a case in the ticketing system. If the user hangs up without speaking to an agent, then we want to run this update to close the case so they don't have a bunch of open cases where the caller never spoke to an service rep.</div>
<div><br></div><div>Abhay I will send you the MIVR logs shortly as well.<br></div><div><br></div><div><font class="Apple-style-span" face="'Times New Roman'" size="4"><span class="Apple-style-span" style="font-size: 16px; "><br>
</span></font></div><div><div class="gmail_quote">On Wed, Aug 19, 2009 at 12:31 AM, Abhay Kumar (abhakuma) <span dir="ltr"><<a href="mailto:abhakuma@cisco.com">abhakuma@cisco.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p><span style="font-size:11.0pt;color:#1F497D">Hi Denis,</span></p>
<p><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p><span style="font-size:11.0pt;color:#1F497D"> Run
the debug again once and Send me the latest 2-3 MIVR logs under C:\Program
Files\wfavvid\log\MIVR. If it’s a quick fix I will tell you right away.
If it requires considerable investigation then I will inform you and subsequently
can open a case with TAC for the same. Thanks</span></p>
<p><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p><span style="font-size:11.0pt;color:#1F497D">Regards,</span></p>
<p><span style="font-size:11.0pt;color:#1F497D">Abhay Kumar</span></p>
<p><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt"> Denis Pointer
[mailto:<a href="mailto:denis.mailer@gmail.com" target="_blank">denis.mailer@gmail.com</a>] <br>
<b>Sent:</b> Wednesday, August 19, 2009 5:37 AM</span></p><div class="im"><br>
<b>To:</b> <a href="mailto:Ask-icd-ivr-support@external.cisco.com" target="_blank">Ask-icd-ivr-support@external.cisco.com</a>; <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> Problems with DB Write and Update</div><p></p>
</div>
<p> </p>
<p>Hello Again,</p><div><div></div><div class="h5">
<div>
<p> </p>
</div>
<div>
<p>I am doing an integration with UCCX 7.01SR3 and Oracle 10g.
I am able to successfully do DB reads and DB writes to select and insert
data into a few different tables, The problem I am having now is with a
DBWrite doing an update. The update command we are using is:</p>
</div>
<div>
<p> </p>
</div>
<div>
<div>
<p>update esc_case </p>
</div>
<div>
<p> set</p>
</div>
<div>
<p>
resolution_desc = 'Call dropped while in IVR/ACD'</p>
</div>
<div>
<p>
,first_contact_resln_ind = 'N'</p>
</div>
<div>
<p> where</p>
</div>
<div>
<p> esc_case_id =
$escCaseID ;</p>
</div>
<div>
<p> </p>
</div>
<div>
<p>when I debug the script I get the following error on the write:</p>
</div>
<div>
<p> </p>
</div>
<div>
<p><b>null nested exception is:</b></p>
</div>
<div>
<p><b>java.lang.ArrayIndexOutOfBounds Exception</b></p>
</div>
<div>
<p> </p>
</div>
<div>
<p> </p>
</div>
<div>
<div>
<p>I am able to to select with this variable doing select
<stuff> from <table> where esc_case_id = $escCaseID ; and it works
fine</p>
</div>
<div>
<p> </p>
</div>
<div>
<p>I have confirmed the variable types match (both are double)</p>
</div>
<div>
<p> </p>
</div>
<div>
<p>If I hard code the esc_case_id and do the command as the
following it works fine:</p>
</div>
<div>
<p> </p>
</div>
<div>
<div>
<p>update esc_case </p>
</div>
<div>
<p> set</p>
</div>
<div>
<p>
resolution_desc = 'Call dropped while in IVR/ACD'</p>
</div>
<div>
<p>
,first_contact_resln_ind = 'N'</p>
</div>
<div>
<p> where</p>
</div>
<div>
<p> esc_case_id = 1180
;</p>
</div>
</div>
<div>
<p> </p>
</div>
</div>
<div>
<p> </p>
</div>
<div>
<p>Any idea why it is failing when I try and do the update
using the variable? During the debug the variable is showing as,
for example, 1180.0D</p>
</div>
<div>
<p> </p>
</div>
<div>
<p> </p>
</div>
<div>
<p>we have tried numerous variations of this command including
update <schema>.esc_case ..... etc. and always with the same results.</p>
</div>
<div>
<p> </p>
</div>
<div>
<p>Thanks in advance for any direction you can provide</p>
</div>
<div>
<p> </p>
</div>
<p>-- <br>
Denis Pointer, A. Sc. T.<br>
Customer Systems Analyst (Senior Design)<br>
<br>
CCVP, CCNA, CCDA<br>
Cisco Unified Contact Center Specialist<br>
Cisco IP Telephony Design Specialist<br>
Cisco Unity Design Specialist<br>
Cisco Unity Support Specialist<br>
Cisco IP Communications Express Specialist</p>
</div>
</div></div></div>
</div>
</blockquote></div><br><br clear="all"><br>-- <br>Denis Pointer, A. Sc. T.<br>Customer Systems Analyst (Senior Design)<br><br>CCVP, CCNA, CCDA<br>Cisco Unified Contact Center Specialist<br>Cisco IP Telephony Design Specialist<br>
Cisco Unity Design Specialist<br>Cisco Unity Support Specialist<br>Cisco IP Communications Express Specialist<br>
</div>