Question

Error when attempting to turn automation off

  • 9 February 2024
  • 1 reply
  • 57 views

Badge +2

Hi,

also see item Error when attempting to turn automation off - Have to run jobs via automation | Community (safe.com).

We also encounter this issue after fresh install of FME Flow 2023.2.1 on a new Windows 2022 server. Below are all answers on questions asked in the related topic. Can anyone suggest some path to solutions?:

 

  1. What version and build of FME Flow are you using?

FME Flow 2023.1.1 Build 23774 Win64

  1. Is this an express, distributed, or fault-tolerant deployment of FME Flow? 

Distributed (database on a separate MS-SQL Server)

  1. If you restart FME Flow, does it resolve (even if temporary)?

We restarted FME Flow and that resolved it once. Later we ran into the same issue and after another restart it did not resolve.

  1. what is the FME Flow database? The default Postgres, or another, like SQL Server? 

This is a MSSQL 2019 Database

Connect string: DB_JDBC_URL=jdbc:sqlserver://guo10794.k-domstad.org;port=1433;databaseName=fmeserver;TrustServerCertificate=true

The connect string uses jdbc driver. On the Windows 2022 server also OLE DB driver is installed:

 

 

  1. Is there any errors reported in the fmeconnection.log?

After the first issue we found this:

Wed-31-Jan-2024 03:01:08.137 AM   ERROR    healthnodeclient   SQLException: The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts.

Wed-31-Jan-2024 03:01:08.138 AM   ERROR    healthnodeclient   com.microsoft.sqlserver.jdbc.SQLServerException: The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts.

COM.safe.fmeserver.api.FMEServerException: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts.

                at COM.safe.fmeserver.database.ManagerBase.execute(ManagerBase.java:146)

                at COM.safe.fmeserver.database.healthNode.HealthNodeOps.healthNodeKeepAlive(HealthNodeOps.java:42)

                at COM.safe.fmeserver.database.healthNode.HealthNodeClient.run(HealthNodeClient.java:92)

                at java.base/java.lang.Thread.run(Unknown Source)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts.

                at com.microsoft.sqlserver.jdbc.ReconnectThread.run(IdleConnectionResiliency.java:498)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host guo10794.k-domstad.org, port 1433 has failed. Error: "Connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

 

The second time we encountered the issue there’s this in the fmeconnection.log:

 

 

Fri-09-Feb-2024 02:01:10.413 PM   INFORM   requesthandler   401831 : Accepted new client connection from /172.29.80.164 on port 7071

Fri-09-Feb-2024 02:01:10.454 PM   ERROR    requesthandler   929028:SQL Query SELECT ncid, connectionname, connectiontype, servicename, username FROM fme_nc_namedconnections WHERE username IS NULL ORDER BY username DESC failed.  Error: Could not find prepared statement with handle 1.

Fri-09-Feb-2024 02:01:10.456 PM   ERROR    pool-6-thread-1   410113 : (Automations) Unable to disassemble automation. 929028:SQL Query SELECT ncid, connectionname, connectiontype, servicename, username FROM fme_nc_namedconnections WHERE username IS NULL ORDER BY username DESC failed.  Error: Could not find prepared statement with handle 1.

Fri-09-Feb-2024 02:01:57.928 PM   INFORM   requesthandler   401937 : Accepted new FME Engine connection.

Fri-09-Feb-2024 02:01:57.929 PM   INFORM   requesthandler   401950 : Registering FME Engine...

Fri-09-Feb-2024 02:01:57.985 PM   ERROR    requesthandler   401959 : FME Server license does not allow more than maximum of 1 FME Engine(s).

Fri-09-Feb-2024 02:01:57.989 PM   ERROR    requesthandler   401939 : Failed to register FME Engine.

 

Kind regards,

Gerro Zegeling

 

 

 


1 reply

Badge +9

Hi gerrozegeling,

 

I’m really sorry you are encountering this issue. As it has been reported before, our development team is currently investigating the issue. Please create a case here: https://support.safe.com/s/submit-case and someone from our team will follow up with you. 

 

For anyone else experiencing this issue please also make a case and reference the ticket number: FMEFLOW-22307

 

Thank you!

Reply