topic RE: SQL Query not working in Product Forum

SQL Query not working

PeterVígh — Mon, 23 Nov 2020 09:31:00 GMT

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

RE: SQL Query not working

ewilson — Mon, 23 Nov 2020 11:55:00 GMT

@Peter Vígh can you provide more details? I assume you're trying to use the Data -SQL Server VBO? What's the exact query you're trying to execute? Are you testing against the same DB when you step through the VBO vs run the process? Do you receive an error message?

Cheers

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

RE: SQL Query not working

PeterVígh — Mon, 23 Nov 2020 12:40:00 GMT

Yes,I'm using the Data - SQL Server VBO and yes I'm testing against the same DB. The problem is that i didn't get the error message just a message that commit was successful. It looks to me that the robot is skipping the querry action.

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

RE: SQL Query not working

NileshJadhavBP — Mon, 23 Nov 2020 13:09:00 GMT

Hi Peter,

Could you please share screenshot of your DB process.

Thanks

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------

RE: SQL Query not working

PeterVígh — Mon, 23 Nov 2020 13:13:00 GMT

Here is my SQL Object where i want to insert data to DB

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

RE: SQL Query not working

PeterVígh — Mon, 23 Nov 2020 13:34:00 GMT

Cas zaciatku = Start Time

Cas ukoncenia = End Time

Vytvorenie SQL prikazu = Creating SQL command

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

RE: SQL Query not working

PeterVígh — Mon, 23 Nov 2020 13:49:00 GMT

Maybe my process is not waiting to finish that action?

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

RE: SQL Query not working

ewilson — Mon, 23 Nov 2020 15:00:00 GMT

Hi @Peter Vígh,

Do you call the Configure action of the VBO anywhere? If not, you may want to call that first and set the Raise Exception on Any Failure flag to True. That way, if the transaction is hitting some weird SQL exception you should see it.

Cheers,

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

RE: SQL Query not working

PeterVígh — Mon, 23 Nov 2020 17:03:00 GMT

The problem was somewhere else,the file download was too slow and he started insert before that file.

But i have another question,in the top left bar we have the error icon it is showing me that i have 2 errors but when i open it ,it shows me 0 errors.

So now, i have errors? Or what is that?

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

RE: SQL Query not working

ewilson — Mon, 23 Nov 2020 18:01:00 GMT

The icon that shows the count of errors isn't updated in real time. Sometimes you need to open the dialog for it to refresh. As long as nothing is listed in the actual dialog, then you have no errors.

While you're in the dialog you can tell it to recheck by clicking the "Check Again" button on the left of the form.

Cheers,

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

RE: SQL Query not working

PeterVígh — Mon, 23 Nov 2020 18:06:00 GMT

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

RE: SQL Query not working

PeterVígh — Mon, 23 Nov 2020 18:07:00 GMT

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

RE: SQL Query not working

ewilson — Mon, 23 Nov 2020 18:19:00 GMT

@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
------------------------------

RE: SQL Query not working

vivek.kumar.goel — Tue, 24 Nov 2020 14:55:00 GMT

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/
------------------------------

RE: SQL Query not working

NileshJadhavBP — Tue, 24 Nov 2020 15:18:00 GMT

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

RE: SQL Query not working

PeterVígh — Tue, 24 Nov 2020 17:44:00 GMT

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

RE: SQL Query not working

PeterVígh — Tue, 24 Nov 2020 18:20:00 GMT

RE: SQL Query not working

ewilson — Tue, 24 Nov 2020 18:21:00 GMT

@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 @vivek.kumar.goel 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
------------------------------