there must be something wrong with your query - and I am sorry but I can't help you out here.
I set up a test system, and tried to replicate the problem, but I failed. When I used the following SQL statement:
INSERT INTO t1 (val1,val2) VALUES ($s_cnic,$val2)
UCCX did not have any problems with it, the values (two Strings) appeared in the database table).
Thanks for your support and guidance. There was problem in my query and also the database table, we corrected this and now able to save the record in the database.
for those people following this thread and having the same issue:
I have had it too and spent/waste some time on it!
It worked all the time!
Unfortunatetly, I trust the "test step" and this was my problem. Working with static values, the "test step" shows me the altered rows, but working with variable it does not, so I try and try and try!
So if you don't have any other error (like exception), try to run the script. The syntax is quite simple, it doesn't matter if you put the commands in one row or different, it will work.
My version of ccx is 8.5.1 and used with oracle 11.
Hope it will save some time.
Hi Adeel Aslam,
Can you please share what was the error in Query and in Database Table?
I'm also facing same issue.Im trying to insert below query but DB write steps always going to SQL error branch.
INSERT INTO CallSurveyDetails (CallDetailID,AgentID,SurveyStartTime,SurveyEndTime,Question1_Response,Question2_Response,ACS_Completed)
VALUES ('67476931050500',3744,'2015-05-07 14:27:00:000','2015-05-07 14:30:00:000',5,10,'ACS_Completed')