Blue Prism Product

last person joined: 9 hours ago 

Chat about Blue Prism products
Expand all | Collapse all

SQL Query not working

  • 1.  SQL Query not working

    Posted 11-23-2020 04:31
    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
    ------------------------------


  • 2.  RE: SQL Query not working

    Posted 11-23-2020 06:55
    @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
    ------------------------------



  • 3.  RE: SQL Query not working

    Posted 11-23-2020 07:40
    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
    ------------------------------



  • 4.  RE: SQL Query not working

    Posted 11-23-2020 08:09
    Hi Peter,

    Could you please share screenshot of your DB process.

    Thanks

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



  • 5.  RE: SQL Query not working

    Posted 11-23-2020 08:13
    Here is my SQL Object where i want to insert data to DB


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



  • 6.  RE: SQL Query not working

    Posted 11-23-2020 08:34

    Cas zaciatku = Start Time

    Cas ukoncenia = End Time

    Vytvorenie SQL prikazu = Creating SQL command



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



  • 7.  RE: SQL Query not working

    Posted 11-23-2020 08:49
    Maybe my process is not waiting to finish that action?

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



  • 8.  RE: SQL Query not working

    Posted 11-23-2020 10:00
    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
    ------------------------------



  • 9.  RE: SQL Query not working

    Posted 11-23-2020 12:03

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



  • 10.  RE: SQL Query not working

    Posted 11-23-2020 13:01
    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
    ------------------------------



  • 11.  RE: SQL Query not working

    Posted 11-23-2020 13:06
    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
    ------------------------------



  • 12.  RE: SQL Query not working

    Posted 11-23-2020 13:07
    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
    ------------------------------



  • 13.  RE: SQL Query not working

    Posted 11-23-2020 13:19
    @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
    ------------------------------



  • 14.  RE: SQL Query not working

    Posted 11-24-2020 12:44
    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
    ------------------------------



  • 15.  RE: SQL Query not working

    Posted 11-24-2020 13:21
    @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 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
    ------------------------------



  • 16.  RE: SQL Query not working

    Posted 11-24-2020 13:20
    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
    ------------------------------



  • 17.  RE: SQL Query not working

    Posted 11-24-2020 10:18
    Edited by Nilesh Jadhav 11-24-2020 10:18
    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
    ------------------------------



  • 18.  RE: SQL Query not working

    Posted 11-24-2020 09:55
    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/
    ------------------------------



Share