• EN
Question

FME Server 2017.1 cant write to PostgreSQL DB

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.} "

19 replies

stalknecht
Rank
Userlevel 1
Badge +18

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

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
Rank
Userlevel 1
Badge +18

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

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
Rank
Userlevel 1
Badge +18
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
Is your FME desktop instance where it's running correct also 64 bits?
the fme Desktop is 32bit

 

 

stalknecht
Rank
Userlevel 1
Badge +18

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
Rank
Userlevel 1
Badge +18
the fme Desktop is 32bit

 

 

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

 

W

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
Rank
Userlevel 1
Badge +18
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
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
Rank
Userlevel 1
Badge +18
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
Rank
Userlevel 1
Badge +18
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
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
Rank
Userlevel 1
Badge +18
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
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
Rank
Userlevel 1
Badge +18
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
Rank
Badge +11

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

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

 

 

Reply


Community Stats

28,807
Posts
109,809
Replies
36,622
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.