cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Query not working

PeterVígh
Level 4
Hello!

I'm facing an issue,

I'm trying to input some data into an SQL table from collection, but its not working. When I'm running it just in the object its fine but when a try to run it in my process its not working. I tried to run step by step and like that its working as well,but when i try to run the process alone its not working. It's executing but not inserting into DB.

Thank you for your response.

------------------------------
Peter Vígh
------------------------------
17 REPLIES 17

So if i click the check again and there are no errors it's fine? Because after every process reset there are 2 errors but when i open it,there are no errors.

------------------------------
Peter Vígh
------------------------------

We are using BluePrism version 6.6 and sometimes we cannot identify and highlight elements in chrome. We added the chrome extension but sometimes it's still a problem. It's a version problem?

------------------------------
Peter Vígh
------------------------------

@Peter Vígh it's hard to say. There were some fixes for Chrome interaction in v6.6 and it looks like some additional enhancements in v6.8. What version of Chrome are you using?

My recommendation would be to open a ticket with support if this is an issue you can reproduce.

Cheers,


------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

VivekGoel
Level 10
Just try without giving semicolon at the end of query.

------------------------------
Vivek Goel
Winners of "The" RPACULT 2020
https://rpatools.com/2020/11/the-rpacult-2020-winners/
------------------------------

Hi Peter,

I am not sure below method will work for you or not but same issue i had faced long back ago.

I used below method and my issue was resolve ( it was just patch)

1.Use configure action first from Data - SQL VBO ( Pass all input and output para)
2.Create connection action using Data - SQL VBO ( Pass all input and output para)
3.Create one more connection action using Data - SQL VBO ( Pass all input and output para)
4. Link it and run it.

I hope it will help you.

Thanks

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------
Nilesh Jadhav.
Consultant
ADP,India

Still can't see the errors. If I just put there an action stage without link i can see that the error number increased but as soon as i open it,it shows me that there are 0 errors.

------------------------------
Peter Vígh
------------------------------

Still can't see the errors. If I just put there an action stage without link i can see that the error number increased but as soon as i open it,it shows me that there are 0 errors.

------------------------------
Peter Vígh
------------------------------

@Peter Vígh the error dialog is only going to show you design time errors (ex. missing links to stages, syntax errors in code stages, etc). It's not going to show you error responses from executing code.

Have you tried some of the other suggestions such as those from @VivekGoel and @Nilesh Jadhav? If so, and you're still experiencing an issue it might be best to share the actual SQL query you're trying the execute.

Cheers,
​​​

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------