[cisco-voip] Problems with DB Write and Update

[Denis Pointer]

Hello,  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.

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.

Abhay I will send you the MIVR logs shortly as well.


On Wed, Aug 19, 2009 at 12:31 AM, Abhay Kumar (abhakuma) <abhakuma at cisco.com
> wrote:

>  Hi Denis,
>
>
>
>                 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
>
>
>
> Regards,
>
> Abhay Kumar
>
>
>
> *From:* Denis Pointer [mailto:denis.mailer at gmail.com]
> *Sent:* Wednesday, August 19, 2009 5:37 AM
>
> *To:* Ask-icd-ivr-support at external.cisco.com; cisco-voip at puck.nether.net
> *Subject:* Problems with DB Write and Update
>
>
>
> Hello Again,
>
>
>
> 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:
>
>
>
> update esc_case
>
>      set
>
>             resolution_desc    = 'Call dropped while in IVR/ACD'
>
>            ,first_contact_resln_ind = 'N'
>
>      where
>
>            esc_case_id = $escCaseID ;
>
>
>
> when I debug the script I get the following error on the write:
>
>
>
> *null nested exception is:*
>
> *java.lang.ArrayIndexOutOfBounds Exception*
>
>
>
>
>
> I am able to to select with this variable doing select <stuff> from <table>
> where esc_case_id = $escCaseID ; and it works fine
>
>
>
> I have confirmed the variable types match (both are double)
>
>
>
> If I hard code the esc_case_id and do the command as the following it works
> fine:
>
>
>
> update esc_case
>
>      set
>
>             resolution_desc    = 'Call dropped while in IVR/ACD'
>
>            ,first_contact_resln_ind = 'N'
>
>      where
>
>            esc_case_id = 1180 ;
>
>
>
>
>
> 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
>
>
>
>
>
> we have tried numerous variations of this command including update
> <schema>.esc_case ..... etc. and always with the same results.
>
>
>
> Thanks in advance for any direction you can provide
>
>
>
> --
> Denis Pointer, A. Sc. T.
> Customer Systems Analyst (Senior Design)
>
> CCVP, CCNA, CCDA
> Cisco Unified Contact Center Specialist
> Cisco IP Telephony Design Specialist
> Cisco Unity Design Specialist
> Cisco Unity Support Specialist
> Cisco IP Communications Express Specialist
>



-- 
Denis Pointer, A. Sc. T.
Customer Systems Analyst (Senior Design)

CCVP, CCNA, CCDA
Cisco Unified Contact Center Specialist
Cisco IP Telephony Design Specialist
Cisco Unity Design Specialist
Cisco Unity Support Specialist
Cisco IP Communications Express Specialist
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090819/e10e7c32/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DBWrite-Error.PNG
Type: image/png
Size: 66293 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090819/e10e7c32/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DB-Update-Test.aef
Type: application/octet-stream
Size: 8885 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090819/e10e7c32/attachment.obj>