Problem with the action DataBase Connect

Hi @erickbenitez ,

Could you try placing a String variable instead of the Default value into the Session Field?
If that doesn’t work, then the other option is to downgrade/upgrade the package and see if that resolves the issue.

Kind Regards,
Ashwin A.K

Hi @erickbenitez ,

Could you please share what's there in line 25?

In case you have mistakenly put the Disconnect command inside the loop, please move to the end of the BOT and try again.
 

Good point @Padmakumar i was thinking the same…

L25 would help to have a look at.

Thanks @Padmakumar and @Marc 1985 

This is the line 25:

Currently the action disconect is outside of the loop. The error continue...

Thanks @Ashwin A.K 

I already try using string variable, but the error continue:
 

How I can do this: “downgrade/upgrade the package” the package DataBase Connect?

Thanks @Ashwin A.K 

@erickbenitez Have you setup this db connectivity and verified in bot runner machine ?

1. Open the 64 bit ODBC Administrator:

   Windows 10 (64 bit version) supports 32 and 64 bit ODBC sources — always use the 64 bit ODBC Administrator.

   • Search for ODBC and choose ODBC Data Sources (64 bit):
     
   • Right Click and choose Run as Administrator:
     
2. Open the System DSN tab and click Add:
   
3. Choose the latest MySQL ODBC driver and click Finish:
   
4. Enter the ODBC credentials:
   • Use any Data Source Name and Description you prefer.
   • Enter the Network Name (or IP) of the MySQL Server in the TCP/IP Server field:
     Note: If you are unsure of this ask your DBA (database administrator).
   • Enter the User name and Password:
     Note: If you are unsure of these ask your DBA (database administrator).
   • Optional: Choose your default Database:
     
5. Test the data source connection:
   • Click Test Data Source…:
     
   • And if it works you are good to go:
     
   • Click OK to create the ODBC data source:
     

Thanks @rbkadiyam I will try this, right now. Only one question. 

Your recomendation can work for me, if I am using SQL Server?

Thanks.

Hi @erickbenitez 

Try to place it in the Error Catch, not only in the Finally sentence. Probably when you are  invoking  the Connect action it sends and error and goes to finally where the database sessión is not recognized

HTH

REgards

Raul Jaimes wrote:

Hi @erickbenitez 

Try to place it in the Error Catch, not only in the Finally sentence. Probably when you are  invoking  the Connect action it sends and error and goes to finally where the database sessión is not recognized

 

HTH

REgards

Ok @Raul Jaimes I will this now. I will give you a feedback. Thanks.

erickbenitez wrote:

Raul Jaimes wrote:

Hi @erickbenitez 

Try to place it in the Error Catch, not only in the Finally sentence. Probably when you are  invoking  the Connect action it sends and error and goes to finally where the database sessión is not recognized

 

HTH

REgards

 

 

Ok @Raul Jaimes I will this now. I will give you a feedback. Thanks.

I tried, but is the same result.. not work

@erickbenitez 

Thank for your feedback. Place it like in the screenshot and then move it forward accordingly. The intention is identify if exits any wrong reference 

Regards

Raul Jaimes wrote:

@erickbenitez

Thank for your feedback. Place it like in the screenshot and then move it forward accordingly. The intention is identify if exits any wrong reference 

 

Regards

Sorry the result is the same :(

@erickbenitez 

Check logfiles to identify any error message. 

C:\ProgramData\AutomationAnywhere\BotRunner\Logs\Node_Manager.log & Bot_Launcher_*.log

Regards

erickbenitez wrote:

Raul Jaimes wrote:

@erickbenitez

Thank for your feedback. Place it like in the screenshot and then move it forward accordingly. The intention is identify if exits any wrong reference 

 

Regards

 

Sorry the result is the same :(

 

Instead of putting a custom message inside the Catch action, please use the Error_Message and Error_Linenumber variables to see the exact error and where it is actually occurring. I don’t think the actual issue is with the Disconnect action.

Padmakumar wrote:

erickbenitez wrote:

Raul Jaimes wrote:

@erickbenitez

Thank for your feedback. Place it like in the screenshot and then move it forward accordingly. The intention is identify if exits any wrong reference 

 

Regards

 

Sorry the result is the same :(

 

 

Instead of putting a custom message inside the Catch action, please use the Error_Message and Error_Linenumber variables to see the exact error and where it is actually occurring. I don’t think the actual issue is with the Disconnect action.

Thanks @Padmakumar I was checking and I dont have the Error_Message and Error_Linenumber variables, I think a I need update something right?

I am sorry, my apologies for everyone, currently I am in my personal community account, Currently I am working like RPA Developer Junior but I am try to improve my skills in one test.

Padmakumar wrote:

erickbenitez wrote:

Raul Jaimes wrote:

@erickbenitez

Thank for your feedback. Place it like in the screenshot and then move it forward accordingly. The intention is identify if exits any wrong reference 

 

Regards

 

Sorry the result is the same :(

 

 

Instead of putting a custom message inside the Catch action, please use the Error_Message and Error_Linenumber variables to see the exact error and where it is actually occurring. I don’t think the actual issue is with the Disconnect action.

@Padmakumar I think get something:

Can you check please?

I think I need check something with the conection to the data base, right?

erickbenitez wrote:

Padmakumar wrote:

erickbenitez wrote:

Raul Jaimes wrote:

@erickbenitez

Thank for your feedback. Place it like in the screenshot and then move it forward accordingly. The intention is identify if exits any wrong reference 

 

Regards

 

Sorry the result is the same :(

 

 

Instead of putting a custom message inside the Catch action, please use the Error_Message and Error_Linenumber variables to see the exact error and where it is actually occurring. I don’t think the actual issue is with the Disconnect action.

 

@Padmakumar I think get something:

 

 

Can you check please?

I think I need check something with the conection to the data base, right?

This is something related to the connection request to your SQL server. Please check whether you are having proper access permission or not.

Padmakumar wrote:

erickbenitez wrote:

Padmakumar wrote:

erickbenitez wrote:

Raul Jaimes wrote:

@erickbenitez

Thank for your feedback. Place it like in the screenshot and then move it forward accordingly. The intention is identify if exits any wrong reference 

 

Regards

 

Sorry the result is the same :(

 

 

Instead of putting a custom message inside the Catch action, please use the Error_Message and Error_Linenumber variables to see the exact error and where it is actually occurring. I don’t think the actual issue is with the Disconnect action.

 

@Padmakumar I think get something:

 

 

Can you check please?

I think I need check something with the conection to the data base, right?

 

 

This is something related to the connection request to your SQL server. Please check whether you are having proper access permission or not.

Yes, until where I can investigate, I need put enable this option in the sql manager:
 

but also, the result is the same :(

Is possible, that this problem is because I am using automation anywhere Community Edition build 16667?

Thanks and thanks for your patient with me.

erickbenitez wrote:

Padmakumar wrote:

erickbenitez wrote:

Padmakumar wrote:

erickbenitez wrote:

Raul Jaimes wrote:

@erickbenitez

Thank for your feedback. Place it like in the screenshot and then move it forward accordingly. The intention is identify if exits any wrong reference 

 

Regards

 

Sorry the result is the same :(

 

 

Instead of putting a custom message inside the Catch action, please use the Error_Message and Error_Linenumber variables to see the exact error and where it is actually occurring. I don’t think the actual issue is with the Disconnect action.

 

@Padmakumar I think get something:

 

 

Can you check please?

I think I need check something with the conection to the data base, right?

 

 

This is something related to the connection request to your SQL server. Please check whether you are having proper access permission or not.

 

 

Yes, until where I can investigate, I need put enable this option in the sql manager:
 

 

but also, the result is the same :(

 

Is possible, that this problem is because I am using automation anywhere Community Edition build 16667?

 

Thanks and thanks for your patient with me.

Could you please try after changing the Database package version?

Padmakumar wrote:

erickbenitez wrote:

Padmakumar wrote:

erickbenitez wrote:

Padmakumar wrote:

erickbenitez wrote:

Raul Jaimes wrote:

@erickbenitez

Thank for your feedback. Place it like in the screenshot and then move it forward accordingly. The intention is identify if exits any wrong reference 

 

Regards

 

Sorry the result is the same :(

 

 

Instead of putting a custom message inside the Catch action, please use the Error_Message and Error_Linenumber variables to see the exact error and where it is actually occurring. I don’t think the actual issue is with the Disconnect action.

 

@Padmakumar I think get something:

 

 

Can you check please?

I think I need check something with the conection to the data base, right?

 

 

This is something related to the connection request to your SQL server. Please check whether you are having proper access permission or not.

 

 

Yes, until where I can investigate, I need put enable this option in the sql manager:
 

 

but also, the result is the same :(

 

Is possible, that this problem is because I am using automation anywhere Community Edition build 16667?

 

Thanks and thanks for your patient with me.

 

Could you please try after changing the Database package version?

Thanks @Padmakumar  I tried changing the version for many different version, but the result is the same.