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

[Anthony Holloway]

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<http://www.squirrelsql.org/>
?
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/20111102/89e86d76/attachment.html>