SQL Query not working

[PeterVígh]

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

[ewilson]

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

[PeterVígh]

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

[NileshJadhavBP]

Hi Peter,

Could you please share screenshot of your DB process.

Thanks

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

[PeterVígh]

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

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

[PeterVígh]

Cas zaciatku = Start Time

Cas ukoncenia = End Time

Vytvorenie SQL prikazu = Creating SQL command

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

[PeterVígh]

Maybe my process is not waiting to finish that action?

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

[ewilson]

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

[PeterVígh]

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

[ewilson]

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