03-01-2018 04:44 AM - edited 03-14-2019 06:00 PM
Dears,
I am trying to run a script that gets data from MSSQL and tries to place a call to the number passed from the DB. The call is always "unsuccessful".
I tried to do the same script by passing the variable data from an HTML page and it worked, however it is not working when passing the same value from SQL. I put some prompts to read the data in the Called Number field and it read it correctly, however it is not calling out to the number when it reaches Place Call in the script. I am attaching the scripts I used for passing data from DB and HTML.
Any ideas why it is not working when passing the data from SQL?
Regards
Ali Alqwasmi
Solved! Go to Solution.
03-03-2018 08:28 PM
Hi Chris
I just figured out what the issue is. In MS-SQL the default length of the nchar of the field was 10. I just changed it to the right length (9) and the call was placed correctly.
Many thanks for your help
Ali
03-01-2018 10:30 AM
Your DB get should be under Successful branch of DB read, perhaps you are not connecting to your DB properly.
When you run in reactive debug mode do you see the connection successfully working and the variable getting polluted? Does it come across as proper type, i.e. String?
03-03-2018 07:59 PM
Hi Chris
I put it under the successful branch of DB Read and I put the required action under successful branch of DB get, but it is still the same. I set a "HTTP response" to send back the contents of the variable that contains the number to be called and it was correct. I even set a "Create Generated Prompt" to read the full number and it was correct.
I tried passing two types from SQL: char and nchar to java.lang.string in uccx, but still no luck.
thanks for your help
Ali
03-03-2018 08:28 PM
Hi Chris
I just figured out what the issue is. In MS-SQL the default length of the nchar of the field was 10. I just changed it to the right length (9) and the call was placed correctly.
Many thanks for your help
Ali
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide