[cisco-voip] UCCX database write help ...

[Biffle, Gerrad]

I’ve dumbed it down and still cannot write to the database.  Here is my current SQL command on the DB Write Properties: INSERT INTO contactcentersurvey (Purpose) VALUES ($Purpose).  Test fails and “number of altered rows” = 0.

If I change it to: INSERT INTO contactcentersurvey (Purpose) VALUES (‘1’) … the test completes fine and the “number of rows altered” = 1.  If I’m thinking correctly … that should rule out a permissions type issue.

Below is what I’m seeing from the MIVR log:

53249575: Feb 08 09:42:07.073 EST %MIVR-SS_DB-7-UNK:EDBSCon::executeSQLUpdate:SQL Statement to be executed :: INSERT INTO contactcentersurvey (Purpose) VALUES ('Purpose') bTurnOffAutoCommit : false
53249576: Feb 08 09:42:07.075 EST %MIVR-SS_DB-7-UNK:  Exception:  java.sql.DataTruncation: Data truncation ExecuteUpdate Error Occurred
53249577: Feb 08 09:42:07.075 EST %MIVR-SS_DB-3-EXECUTE_SQL_UPDATE_EXCEPTION:EXECUTE_SQL_UPDATE_EXCEPTION
53249578: Feb 08 09:42:07.075 EST %MIVR-DB_STEPS-3-EXECUTE_SQL_UPDATE_EXCEPTION:EXECUTE_SQL_UPDATE_EXCEPTION

If I can send anything else that will help troubleshoot this … let me know.

Thanks.

Gerrad

From: avholloway at gmail.com [mailto:avholloway at gmail.com] On Behalf Of Anthony Holloway
Sent: Friday, February 04, 2011 4:07 PM
To: Biffle, Gerrad
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] UCCX database write help ...

Gerrad,

From you what you have described, this looks ok.  Have you tried dumbing down your INSERT statement to a simple:

insert into test_table (col1) values ('value1')

There is a lot going on there, and we don't even know if you have permissions to write to the table.  Testing a simple insert on a test table would help us understand.

See if you can also attach an MIVR log for us.

Anthony
On Fri, Feb 4, 2011 at 2:17 PM, Biffle, Gerrad <Gerrad.Biffle at greensboro-nc.gov<mailto:Gerrad.Biffle at greensboro-nc.gov>> wrote:
Anthony Holloway or other UCCX gurus -

I know it’s late on a Friday … but I’m hoping someone can tell me what I might be missing on the following SQL statement for a database write from one of my scripts:

INSERT INTO contactcentersurvey (Purpose,FirstTime,Courteous,Helpful,Outcome,Rate,HearAbout,resourceID,CallingParty,DateTime) VALUES ($Purpose,$FirstTime,$Courteous,$Helpful,$Outcome,$Rate,$HearAbout,$resourceID,$CallingParty,GetDate())

I can see the database schema refreshes, the datasource is setup and test okay, etc. … but I cannot get my script to write to it.

Thanks.
_________________________________________

Gerrad Biffle, VOIP & Telephony Systems Manager
CGCIO, MCTS
Information Technology
City of Greensboro
300 W. Washington, Greensboro, NC  27401
www.greensboro-nc.gov<http://www.greensboro-nc.gov>
_________________________________________




=======================================================
Please note that email sent to and from this address is subject
to the North Carolina Public Records Law and may be disclosed to
third parties.


_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

=======================================================
Please note that email sent to and from this address is subject 
to the North Carolina Public Records Law and may be disclosed to 
third parties.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110208/b035bf30/attachment.html>