Hi.
We are executing WF and sometimes presents an issue when a WF is accessing a Postgresql V17 database.
It is the first step in our WF and generates the following message in the logfile:
2024/12/16 05:40:34 - WF_SetCredentials - Dispatching started for workflow [WF_SetCredentials]
2024/12/16 05:40:36 - TIn_Clientes.0 - ERROR (version 7.6.1 from 2023-11-20) : An error occurred, processing will be stopped:
2024/12/16 05:40:36 - TIn_Clientes.0 - Error occurred while trying to connect to the database
2024/12/16 05:40:36 - TIn_Clientes.0 -
2024/12/16 05:40:36 - TIn_Clientes.0 - Error connecting to database: (using class org.postgresql.Driver)
2024/12/16 05:40:36 - TIn_Clientes.0 - The connection attempt failed.
2024/12/16 05:40:36 - TIn_Clientes.0 - ERROR (version 7.6.1 from 2023-11-20) : Error initializing step [TIn_Clientes]
2024/12/16 05:40:36 - WF_SetCredentials - ERROR (version 7.6.1 from 2023-11-20) : Step [TIn_Clientes.0] failed to initialize!
2024/12/16 05:40:36 - TIn_Clientes.0 - Finished reading query, closing connection.
2024/12/16 05:40:36 - WF_SetCredentials - ERROR (version 7.6.1 from 2023-11-20) : Unable to prepare for execution of the workflow
2024/12/16 05:40:36 - WF_SetCredentials - ERROR (version 7.6.1 from 2023-11-20) : com.automationedge.ps.core.exception.ProcessStudioException:
2024/12/16 05:40:36 - WF_SetCredentials - An error occurred, processing will be stopped:
2024/12/16 05:40:36 - WF_SetCredentials - Error occurred while trying to connect to the database
2024/12/16 05:40:36 - WF_SetCredentials -
2024/12/16 05:40:36 - WF_SetCredentials - Error connecting to database: (using class org.postgresql.Driver)
2024/12/16 05:40:36 - WF_SetCredentials - The connection attempt failed.
2024/12/16 05:40:36 - WF_SetCredentials -
2024/12/16 05:40:36 - WF_SetCredentials - Step [TIn_Clientes] failed to initialize!
2024/12/16 05:40:36 - WF_SetCredentials -
2024/12/16 05:40:36 - WF_SetCredentials - at com.automationedge.ps.workflow.Workflow.prepareExecution(Workflow.java:1390)
2024/12/16 05:40:36 - WF_SetCredentials - at com.automationedge.ps.workflow.Workflow.execute(Workflow.java:791)
2024/12/16 05:40:36 - WF_SetCredentials - at com.automationedge.ps.process.entries.workflow.ProcessEntryWorkflow.execute(ProcessEntryWorkflow.java:886)
2024/12/16 05:40:36 - WF_SetCredentials - at com.automationedge.ps.process.Process.execute(Process.java:920)
2024/12/16 05:40:36 - WF_SetCredentials - at com.automationedge.ps.process.Process.execute(Process.java:1119)
2024/12/16 05:40:36 - WF_SetCredentials - at com.automationedge.ps.process.Process.execute(Process.java:1119)
2024/12/16 05:40:36 - WF_SetCredentials - at com.automationedge.ps.process.Process.execute(Process.java:1119)
2024/12/16 05:40:36 - WF_SetCredentials - at com.automationedge.ps.process.Process.execute(Process.java:1119)
2024/12/16 05:40:36 - WF_SetCredentials - at com.automationedge.ps.process.Process.execute(Process.java:720)
2024/12/16 05:40:36 - WF_SetCredentials - at com.automationedge.ps.process.Process.run(Process.java:588)
No explicit message is shown regarding the reason of the error.
Environment:
Agent executing on a Windows 10 environment.
Postgresql V17 on Debian 13 as a VM
All on the same network segment.
Any input will be appreciated.
