Can you please provide the query ?
Please cross check if ‘Hazra’ is correctly spelled or if something is to be added as prefix or suffix. Maybe if you are using excel as database ensure there is no space after word ‘Hazra’ in excel if it is the column name.
Lastly, if ‘Hazra’ is absent in some instances while query is executed.
Also, please share your query if you can to understand better.
Cheers,
Shubham
yes done it was a sql object error that means i haven’t select proper object. now got exception .
thanks and regards
Hazra
Hi @Satanand_Hazra ,
Please Share the SQL Query , Probably it needs some formatting.
Thanks,
Gautham.
Hi,
I just want to connect from SQL query to UiPath studio and run the program .
there have query only table format.
Hi @Satanand_Hazra ,
When we want to execute any query in db, There are 3 steps involved
- Connect to DB
- Execute Query
- Disconnect From DB
In your case , Bot has reached execute query which means connection to db was successfully established.
The error is showing Invalid object ‘Hazra’ which means there is some formatting issues with the query or it needs some fine tuning.
If you cannot share the query, Please try executing it from db, You might be able to troubleshoot. Post that use the corrected query inside the code.
The above is the reason why I requested you to share the query.
Thanks,
Gautham.
Database1.xaml (11.1 KB)
if i am able to send the query please once confirm me
however if not able to see the query then will shyer the screen in between we would elaborate regarding query.
Hi @Satanand_Hazra ,
I could see that this is the query you are trying to execute,
Select * From Hazra;
‘Hazra’ is the table name, Could you please check if the table name does exist in the db.?
If yes, Check the exist in the ‘Master’ DB.
Once you have made sure the table “Hazra” is available under “master” then check if the bot account has the permission to excecute this query in your db as well.
Above 3 factors might cause this invalid object name , it just means UiPath bot is unable to access db .
Looking forward to help you resolve.
yes its successful the output
The code is executing now or you are able to run the query in db.?
I couldn’t think of any other possibilities here.
- Check if the table Hazra exists in Master schema
- Check if the connection string points to the schema where the table is present
- Check the security settings in db.
If all checkpoints in the above list is also in line, am also not sure why it is not working.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.