Skip to main content
Solved

FME Flow Error: SDE Database Connection & Resource Path


nchap
Contributor
Forum|alt.badge.img+1
  • Contributor

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'

Best answer by timatsafe

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!

 

 

View original
Did this help you find an answer to your question?

8 replies

timatsafe
Safer
Forum|alt.badge.img+3
  • Safer
  • Best Answer
  • August 1, 2024

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!

 

 


nchap
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • August 2, 2024

@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!


timboberoosky
Contributor
Forum|alt.badge.img+6

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):

 


nchap
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • October 7, 2024

@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.  


timatsafe
Safer
Forum|alt.badge.img+3
  • Safer
  • October 11, 2024

Hi @timboberoosky 

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

nchap wrote:

@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.  

 


timboberoosky
Contributor
Forum|alt.badge.img+6
timatsafe wrote:

Hi @timboberoosky 

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

nchap wrote:

@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.


timatsafe
Safer
Forum|alt.badge.img+3
  • Safer
  • October 15, 2024

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!

 


timboberoosky
Contributor
Forum|alt.badge.img+6
timatsafe wrote:

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!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings