[cisco-voip] SQL Query Rolls back Using UCCX DB Nodes

[shary shary]

thnx Anthony let me work on these steps and will share a result.
 
 



Date: Wed, 2 Nov 2011 11:52:45 -0500
Subject: Re: [cisco-voip] SQL Query Rolls back Using UCCX DB Nodes
From: avholloway+cisco-voip at gmail.com
To: shaary1 at hotmail.com
CC: cisco-voip at puck.nether.net; cisco-voip-bounces at puck.nether.net


Hi Shary,
 
*First off, did you mean to leave out the "$" on your insert statement?  That could be the problem.
 
Just like with any troubleshooting, you'll want to break things down a bit, in an effort to isolate the problem.
 
1. Focus on select statement first

a. Can you read the table directly via a tool like query analyzer?
b. Can you read the table from a remote machine via a tool like SQuirreL?
c. Can you read the table from a simple UCCX script and via active debugging (no variables, hard coded values)?
d. Can you read the table from a simple UCCX script and via active debugging (using variables for your values)?
2. Now focus on the insert statement

a. Can you modify the table directly via a tool like query analyzer?
b. Can you modify the table from a remote machine via a tool like SQuirreL?
c. Can you modify the table from a simple UCCX script and via active debugging (no variables, hard coded values)?
d. Can you modify the table from a simple UCCX script and via active debugging (using variables for your values)?
Knowing the answer to these questions will help you to isolate where the problem might be.
 
A couple of other troubleshooting suggestions if needed:
Create a new database and table for testing (make these as simple as possible)
Connect to a different database server for testing (MySQL, PostgreSQL, DB2, etc.)
 
Anthony 
 
 
On Wed, Nov 2, 2011 at 6:36 AM, shary shary <shaary1 at hotmail.com> wrote: 
 



hi all, i am facing a very strange issue in uccx while Reading or writing data into SQL DB from uccx DB Read and Write query.
For Read i am using the query "select * from tble where fil1=$customerinput" and for write "INSERT into tble (field1) Values (customerinput)" . When i test these queries it displays 1 row alterred while in at SQL side i can't see any new data. The DB guys are saying they are getting insert request from uccx but it rolls back intead of Commit. Same thing when i try to Read the data the call goes into success node but then from DB get node it passes from unsuccessful. Variable types are same at both side. What could e the issue. We are usign SQL ODBC connector. Your prompt will be appreaciateble.
  
thnx in advance
 
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
 
 
  		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20111103/b91982c7/attachment.html>