Question

Database Connect fails with "An unexpected error occurred. Unexpected error sending message to process stdin Please contact system administrator"

  • 4 February 2022
  • 11 replies
  • 45 views

I am trying to connect to an Excel using Database Connect. This actions is part of a bot. This bot is invoked from inside a loop from a different bot. Database Connect action is successful for the first loop iteration but fails with "An unexpected error occurred. Unexpected error sending message to process stdin Please contact system administrator" error after that.

 

Bot Agent Version - 21.121

 

Is this a known issue? Is there any workaround?


11 replies

Userlevel 3
Badge +7

Could you please check the connection string?

 

https://developer.automationanywhere.com/blog/quicktip-connect-to-an-excel-spreadsheet-as-a-database/p>

 

 

The exception is thrown from Database Connect action. Validated thru try catch and checked the in the Bot_Launcher.log file as well.

 

2022-Feb-04 Fri 11:45:12.307 FATAL [BotRunner-xxxxx - com.automationanywhere.botcommand.database.commands.ConnectDatabaseCommand {deploymentId=xxxxxxxxxxxx, traceId=xxxxxxx} - execute(ConnectDatabaseCommand.java:649) - Unexpected error sending message to process stdin java.lang.RuntimeException: Unexpected error sending message to process stdin

 

The connection string is correct. And it works perfectly fine for the first loop iteration. It fails from second iteration of loop.

Userlevel 3
Badge +7

This bot is invoked from inside a loop from a different bot. You mentioned above, Please check the other task that might be caused the issue.

Userlevel 3
Badge +7

Thank you for letting me know

Userlevel 3
Badge +7

Hi @Yogesh Aggarwal​ ,

 

Would you be so kind as to include few screenshots of the workflow so that we may be in a better position to assist you?

 

Kind Regards,

Ashwin A.K

Is this issue resolved? Please let us know the solution

Is there any solution for this? having the same issue with an user

In our case, it was due to update of the the AccessDataEngine.exe version installed on the VDI. We were told by the support team to install AccessDataEngine.exe (2010) and that resolved the issue.

My bot agent is 21.81 and have already installed Microsoft Access Database Engine 2010. Still I am facing this issue. Any solution for this issue.

Userlevel 4
Badge +8

Hello @Yogesh Aggarwal​, Reported issue was identified as a Defect in product and will be addressed in upcoming A360.26 release.

 

You can try using Microsoft Access Database Engine 2010 and ODBC Microsoft Excel driver Version 14.00 and it should help.

Reply