Skip to main content
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
Contributor
Forum|alt.badge.img+19
  • stalknechtContributor
  • Contributor
  • 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
  • August 4, 2017
stalknecht wrote:

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+19
  • stalknechtContributor
  • Contributor
  • August 4, 2017
stalknecht wrote:

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
  • August 4, 2017
stalknecht wrote:

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+19
  • stalknechtContributor
  • Contributor
  • August 4, 2017
wanta wrote:
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
  • August 4, 2017
stalknecht wrote:
Is your FME desktop instance where it's running correct also 64 bits?
the fme Desktop is 32bit

 

 

stalknecht
Contributor
Forum|alt.badge.img+19
  • stalknechtContributor
  • Contributor
  • 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+19
  • stalknechtContributor
  • Contributor
  • August 4, 2017
wanta wrote:
the fme Desktop is 32bit

 

 

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

 

W
  • wanta
  • Author
  • August 4, 2017
stalknecht wrote:

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+19
  • stalknechtContributor
  • Contributor
  • August 4, 2017
wanta wrote:
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
  • August 4, 2017
stalknecht wrote:
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+19
  • stalknechtContributor
  • Contributor
  • August 4, 2017
wanta wrote:
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+19
  • stalknechtContributor
  • Contributor
  • August 4, 2017
wanta wrote:
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
  • August 7, 2017
stalknecht wrote:
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+19
  • stalknechtContributor
  • Contributor
  • August 7, 2017
wanta wrote:
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
  • August 7, 2017
wanta wrote:
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+19
  • stalknechtContributor
  • Contributor
  • August 7, 2017
wanta wrote:
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+12

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
  • August 9, 2017
steveatsafe wrote:

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


Most helpful members this week

Community Stats

30,846
Posts
116,937
Replies
38,670
Members
Terms & ConditionsCookie settings

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