Skip to main content
Question

FME Server 2017.1 cant write to PostgreSQL DB

  • August 4, 2017
  • 19 replies
  • 26 views
W

Tried to copy feature classes from a Microsoft SQL database to a postgresql database using SDE Connection files. The workbenche does fine on FME Desktop 2017 but on the fme Server 2017.1 i get following error:

 

"Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.} "

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

19 replies

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • August 4, 2017

The Arcgis client software should be installed on the server also. The engine must be 32 bits if u use 32 bits third party software.

W
  • wanta
  • Author
  • 10 replies
  • August 4, 2017

The Arcgis client software should be installed on the server also. The engine must be 32 bits if u use 32 bits third party software.

it should be installed by arcmap Desktop ... or i am i wrong?

 

and all workbenches without postgre Connection working fine

 

 

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • August 4, 2017

The Arcgis client software should be installed on the server also. The engine must be 32 bits if u use 32 bits third party software.

 

Yep, is the engine 32 bits?
W
  • wanta
  • Author
  • 10 replies
  • August 4, 2017

The Arcgis client software should be installed on the server also. The engine must be 32 bits if u use 32 bits third party software.

engine and server 64bit, arcmap Desktop (10.4.1) 32bit + backgroundgeoprocessing 64bit

 

 

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • August 4, 2017
engine and server 64bit, arcmap Desktop (10.4.1) 32bit + backgroundgeoprocessing 64bit

 

 

Is your FME desktop instance where it's running correct also 64 bits?
W
  • wanta
  • Author
  • 10 replies
  • August 4, 2017
Is your FME desktop instance where it's running correct also 64 bits?
the fme Desktop is 32bit

 

 

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • August 4, 2017

You've told me that in workbench 32 bits it is working. Either install 32 bits Engine or Esri 64 bit Background Geoprocessing Module on the server and Postgres should be in the same architecture you choose.

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • August 4, 2017
the fme Desktop is 32bit

 

 

Either install 32 bits Engine or Esri 64 bit Background Geoprocessing Module on the server

 

W
  • wanta
  • Author
  • 10 replies
  • August 4, 2017

You've told me that in workbench 32 bits it is working. Either install 32 bits Engine or Esri 64 bit Background Geoprocessing Module on the server and Postgres should be in the same architecture you choose.

Esri 64 bit Background Geoprocessing Module is already installed and the postgre is 64 bit too

 

 

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • August 4, 2017
Esri 64 bit Background Geoprocessing Module is already installed and the postgre is 64 bit too

 

 

Could you check if you can write to postgres without using the SDE?

 

 

W
  • wanta
  • Author
  • 10 replies
  • August 4, 2017
Could you check if you can write to postgres without using the SDE?

 

 

tested with direct conenction to the postgres database and it worked on the server

 

 

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • August 4, 2017
tested with direct conenction to the postgres database and it worked on the server

 

 

The Account running the engine must have administrator privileges. Can you confirm it has the administrator rights and is not local system?

 

 

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • August 4, 2017
tested with direct conenction to the postgres database and it worked on the server

 

 

Can you share the PATH variable from the server?

 

open a cmd-prompt and type path.

 

Link

 

 

W
  • wanta
  • Author
  • 10 replies
  • August 7, 2017
Can you share the PATH variable from the server?

 

open a cmd-prompt and type path.

 

Link

 

 

yes, the user running the fme Services is adminstrator

 

 

PATH=D:\\Python27\\ArcGISx6410.4;D:\\Program Files (x86)\\ArcGIS\\Desktop10.4;C:\\Wind

 

ows\\system32;C:\\Windows;C:\\Windows\\System32\\Wbem;C:\\Windows\\System32\\WindowsPowe

 

rShell\\v1.0\\;D:\\Program Files\\FMEServer\\Utilities\\jre\\bin\\client;D:\\Program File

 

s\\FMEServer\\Server\\fme;D:\\Program Files\\FMEServer\\

 

 

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • August 7, 2017
yes, the user running the fme Services is adminstrator

 

 

PATH=D:\\Python27\\ArcGISx6410.4;D:\\Program Files (x86)\\ArcGIS\\Desktop10.4;C:\\Wind

 

ows\\system32;C:\\Windows;C:\\Windows\\System32\\Wbem;C:\\Windows\\System32\\WindowsPowe

 

rShell\\v1.0\\;D:\\Program Files\\FMEServer\\Utilities\\jre\\bin\\client;D:\\Program File

 

s\\FMEServer\\Server\\fme;D:\\Program Files\\FMEServer\\

 

 

Can you change the path of the ArcGis libraries to a 64 bits path?

 

(the PATH you are listing is this the one you get when you are logged on as the user that's running the engine?)

 

 

W
  • wanta
  • Author
  • 10 replies
  • August 7, 2017
tested with direct conenction to the postgres database and it worked on the server

 

 

there is no other arcgis path :S

 

yes, it is from the engine user

 

 

stalknecht
Contributor
Forum|alt.badge.img+21
  • stalknechtContributor
  • Contributor
  • 305 replies
  • August 7, 2017
there is no other arcgis path :S

 

yes, it is from the engine user

 

 

Here are some links for further investigation.

 

https://knowledge.safe.com/questions/1931/enterprise-geodatabase-readerwriter-failing-to-loa.html

 

 

https://knowledge.safe.com/questions/3950/problem-using-direct-connect-to-esri-geodatabase-f.html

 

 

http://support.esri.com/en/technical-article/000010576

 

 

If you still experience trouble create a support call. Your FME reseller can do this for you.

 

 

best regards,

 

Wilko Stalknecht

 

steveatsafe
Safer
Forum|alt.badge.img+13
  • steveatsafeSafer
  • Safer
  • 422 replies
  • August 8, 2017

I have seen some misleading messages from ArcMap before. Is it possible something else is interfering here? Is your FME Desktop and FME Server on the same system where this is working? Seems like it is an ArcGIS issue. Can you connect to the postgreSQL DB OK with the ArcGIS software (on the same system that FME Server is installed)?

SteveatSafe
W
  • wanta
  • Author
  • 10 replies
  • August 9, 2017

I have seen some misleading messages from ArcMap before. Is it possible something else is interfering here? Is your FME Desktop and FME Server on the same system where this is working? Seems like it is an ArcGIS issue. Can you connect to the postgreSQL DB OK with the ArcGIS software (on the same system that FME Server is installed)?

The FME Desktop and Server are on different machines.

 

Yes, i can connect with ArcMap on the Server sytem to my postgrs db

 

 

Community Stats

32,058
Posts
121,723
Replies
39,686
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.