Pretty basic, all the values are string values in UCCx, VarChar in SQL. I get the following error in the MIVR logs in UCCx when I try to execute this step and the script drops to the SQL logic. The strange thing is that the data is put into the table, it is there, but the script never seems to know that it executed correctly. Any ideas/help is appreciated, I've battled this one for a week now... thanks!
MIVR Error (from log):
391026: Mar 02 10:28:48.046 EDT %MIVR-SS_DB-7-UNK: Exception: java.sql.SQLException: No row count was produced ExecuteUpdate Error Occurred
391027: Mar 02 10:28:48.046 EDT %MIVR-SS_DB-3-EXECUTE_SQL_UPDATE_EXCEPTION:Exception occured while executing SQL Update: SQL State=null,SQL Error code=null,Connection #=null
I don't know the interface you are working with that well (I don't recall using any INSERT or UPDATE statements when I coded to the DB steps - just SELECT) but is it possible you are not providing a variable to hold the number of rows affected?
In the Java SQL API, INSERT and UPDATE methods do that. For example:
Seems the UCCx didn't like the fact that there was some data already in the table from testing with SQL. Once I executed a DELETE from [tablename] on the table in question and ran my script the INSERT INTO executed without any issues and is working great. Go figure... I couldn't see anything different in the table data, but it is working so life is back on track after burning a week on this one... sigh!
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...