cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

3400
Views
5
Helpful
33
Replies
Advocate

DB Write Step Does Not Work in CCX Script Editor

Hi,

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).

G.

Beginner

DB Write Step Does Not Work in CCX Script Editor

Hi Gergely

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.

Regards

Adeel Aslam

Beginner

DB Write Step Does Not Work in CCX Script Editor

Hi everybody,

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.

Regards,

Heiko

Highlighted

Hi Adeel Aslam,Can you please

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')

 

Thanks

Fakhrul Islam

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here