Skip to main content
  • EN

We are converting a number of GIS-focused Automations in FME Flow 2024.0 to use the new SDE Database Connections instead of the old PATH resource.  FME Flow is returning an error when attempting to read the new database connection properties: ‘An error occurred while attempting to retrieve the connection parameters from the connection file’ 

For each of the FME Flow Database Connections, we used an FME Resource, ‘SDE_GISD’, for the path reference for the connection file.  We found if we use a UNC path instead of the FME Flow resource it works as expected.  Is this a limitation or are we doing something wrong?

Connection works as expected on local host, local server host, and with UNC path for the database connection within FME Flow.  Just not with using a Resource path in the connection.

Error:

315 2024-7-31 11:51:25 | Opening the Esri Geodatabase reader
316 2024-7-31 11:51:25 | An ArcGIS license is already checked out. The product checked out is 'ArcServer'
317 2024-7-31 11:51:25 | Installed ArcGIS version is '11.1'
318 2024-7-31 11:51:26 | An error occurred while attempting to retrieve the connection parameters from the connection file '$(SDE_GISD)\facilities-gisd.sde'

Hi @nchap,

Can you try moving the SDE file to the Data resource folder, modifying the connection to reference the file in the Data resource folder and then re-running the workspace?

Let me know if that works or if you’re still having issues!

 

 

@timatsafe 

 

Tim, uploading to the Data resource and remapping the file reference to said resource worked.  This had us a bit confused but this worked perfectly and folder uploads to the Data resource work which will help us organize all of our environments immensely. 

 

Thank you very much!

I’m having a similar issue with my workspace continuing to fail in FME Flow referencing the location where my original SDE connection file was (on the same machine as FME Form). I created a database connection in FME Form and uploaded it to Flow, and afterwards copied that connection file into the resources\data folder. 

Am I missing something?

Database Connection in Flow

 

Database Connection in workspace:

Message in Flow log (this is where my connection file is/was while developing the Form Workspace):

 

@timboberoosky

The configuration looks correct to me.  I don’t think it would matter but the one difference is I uploaded to the Resources/Data/ folder via Flow web UI, then created the shell connection in DB Connections, then mapped to the Resources/Data/ object.  

Hi @timboberoosky 

Are you still running into the same issue after trying out this suggestion?

@timboberoosky

The configuration looks correct to me.  I don’t think it would matter but the one difference is I uploaded to the Resources/Data/ folder via Flow web UI, then created the shell connection in DB Connections, then mapped to the Resources/Data/ object.  

 

Hi @timboberoosky 

Are you still running into the same issue after trying out this suggestion?

@timboberoosky

The configuration looks correct to me.  I don’t think it would matter but the one difference is I uploaded to the Resources/Data/ folder via Flow web UI, then created the shell connection in DB Connections, then mapped to the Resources/Data/ object.  

 

This continued to happen to me but with one specific workspace only. I gave up and re-built the workspace from scratch and the issue didn’t happen again. I still don’t know the root cause but several workspaces have been fine since, using the SDE connection in the Resources/Data folder.

Hi @timboberoosky,

Glad to hear that you’ve got it working! If you do end up running into the same issue you can submit a support case here and we can take a closer look!

 

Hi @timboberoosky,

Glad to hear that you’ve got it working! If you do end up running into the same issue you can submit a support case here and we can take a closer look!

 

Well, it happened to me again with a different workspace - all same settings, etc., though this time it’s referencing an SDE connection file in the workspace repository folder on the FME Flow machine:
 

I’ve compared the user parameters and database connections in this workspace against another, working one, and they appear the same. This workspace is smaller than the last so I can re-build it quickly enough, but I’ll probably be submitting a case about this so I can understand what’s going on and avoid in the future!

Reply


Community Stats

30,351
Posts
115,336
Replies
38,078
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.