Skip to main content
Solved

Not able to create a new Database Connection on FME Server

lau
Forum|alt.badge.img+3

Hello,

I have just finished to install FME Server (build 19 617).

(Installation with our own Oracle db).

I can connect to the Web interface, launch workspaces, build automations, create new user, publish workspace, etc.

BUT I CANNOT create a new Database Connection (Oracle or geodatabase, etc.). When I tried I get this message :

The rest api "/fmerest/v3/namedconnections/connections" get a code 500 in response.

 

I also tried to publish a workspace with a database connection but I get this message :

 

Database connections access failed - FME Server encountered an error and reported the following message.

929028:SQL Query SELECT NCID FROM fme_nc_namedconnections WHERE connectionname = ? AND username IS NULL failed. Error: Unsupported feature

Request to http://xxxxxxxxxx/fmerest/v3/namedconnections/connections returned status code 500.

 

I found a dirty workaround :

1. Insert a new row in the table fme_nc_namedconnections in the Oracle FME Server database

2. Then the connection is visible via the Web Interface and I can modify it !

 

So it seems FME Server is able to access the database and modify a configuration but not able to create a new entry.

 

Do you know how I can fix this ?

Thank you !

Best answer by lau

Hi @nrich,

We fix the issue by re-installing FME Server and using another ojdbc (ojdbc7-12.1.0.2.jar). This is the one used by FME Server 2018 by default.

 

 

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

12 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • Contributor
  • September 6, 2019

Looks like FME Server has SELECT privileges on the table, not INSERT privileges.

Not sure what user FME Server is using to connect, but granting INSERT on the table could fix the issue.

Hope this helps.

I would report it to Safe: www.safe.com/support as others might face the same issue.

lau
Forum|alt.badge.img+3
  • lau
  • Author
  • September 9, 2019
erik_jan wrote:

Looks like FME Server has SELECT privileges on the table, not INSERT privileges.

Not sure what user FME Server is using to connect, but granting INSERT on the table could fix the issue.

Hope this helps.

I would report it to Safe: www.safe.com/support as others might face the same issue.

Hello @erik_jan,

Thank you for your reply.

We have checked but it doesn't seem to be that. In addition, we are able to create new users/roles. (New entry in the database). Do you have any other suggestions ?

erik_jan
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • Contributor
  • September 9, 2019
lau wrote:

Hello @erik_jan,

Thank you for your reply.

We have checked but it doesn't seem to be that. In addition, we are able to create new users/roles. (New entry in the database). Do you have any other suggestions ?

Hi @lau,

I do believe that, by inserting a record in the table, you made the next sequence number invalid.

The installation creates a sequence for the primary key of the table (starting with 1).

The inserted record has bypassed the sequence number and inserting a new record will generate an existing primary key.

Possibly that is causing the issue.

The create scripts for the database can be found here:

<fme server folder>\\Server\\database\\oracle

Hope this helps.

nrich_defra
Contributor
Forum|alt.badge.img+5
  • nrich_defraContributor
  • Contributor
  • September 9, 2019

Hi, we're having the same problem, and it means we can't add web services either.

I don't think the fme server user privileges are a problem, but will check the sequence number, we had a pretty clean install however.

any other pointers greatly appreciated.

(fme bld 19238, windows server 2012r2, with repo db tier in oracle 11g on sles (i think!) )

nrich_defra
Contributor
Forum|alt.badge.img+5
  • nrich_defraContributor
  • Contributor
  • September 9, 2019
nrich wrote:

Hi, we're having the same problem, and it means we can't add web services either.

I don't think the fme server user privileges are a problem, but will check the sequence number, we had a pretty clean install however.

any other pointers greatly appreciated.

(fme bld 19238, windows server 2012r2, with repo db tier in oracle 11g on sles (i think!) )

the database looks okay as far as i can tell, and fme server is logging in as the same user that generated the schema.

nrich_defra
Contributor
Forum|alt.badge.img+5
  • nrich_defraContributor
  • Contributor
  • September 9, 2019
nrich wrote:

Hi, we're having the same problem, and it means we can't add web services either.

I don't think the fme server user privileges are a problem, but will check the sequence number, we had a pretty clean install however.

any other pointers greatly appreciated.

(fme bld 19238, windows server 2012r2, with repo db tier in oracle 11g on sles (i think!) )

Does FME Server need to be configured for SSL perhaps?

lau
Forum|alt.badge.img+3
  • lau
  • Author
  • September 10, 2019
nrich wrote:

Does FME Server need to be configured for SSL perhaps?

Hi @nrich,

During the installation we must specify a custom jdbc for Oracle. Could it be related to our problem?

nrich_defra
Contributor
Forum|alt.badge.img+5
  • nrich_defraContributor
  • Contributor
  • September 10, 2019
nrich wrote:

Hi, we're having the same problem, and it means we can't add web services either.

I don't think the fme server user privileges are a problem, but will check the sequence number, we had a pretty clean install however.

any other pointers greatly appreciated.

(fme bld 19238, windows server 2012r2, with repo db tier in oracle 11g on sles (i think!) )

I considered, that as we had to use an older version because of our oracle version, however it has no issues writing/reading to everything else? Have you got SSL configured in fme server, we haven’t yet? That’s my best guess so far.

lau
Forum|alt.badge.img+3
  • lau
  • Author
  • Best Answer
  • September 13, 2019

Hi @nrich,

We fix the issue by re-installing FME Server and using another ojdbc (ojdbc7-12.1.0.2.jar). This is the one used by FME Server 2018 by default.

 

 

bernarddinon
Forum|alt.badge.img+1
lau wrote:

Hi @nrich,

We fix the issue by re-installing FME Server and using another ojdbc (ojdbc7-12.1.0.2.jar). This is the one used by FME Server 2018 by default.

 

 

It works well. Good Job.

steveatsafe
Safer
Forum|alt.badge.img+12
  • steveatsafeSafer
  • Safer
  • September 19, 2019
lau wrote:

Hi @nrich,

We fix the issue by re-installing FME Server and using another ojdbc (ojdbc7-12.1.0.2.jar). This is the one used by FME Server 2018 by default.

 

 

Great investigation. I never thought about the jar file you are using as being a factor. That is just mean. Were you using the ODBC6 version by chance?

SteveatSafe
lau
Forum|alt.badge.img+3
  • lau
  • Author
  • September 19, 2019
steveatsafe wrote:

Great investigation. I never thought about the jar file you are using as being a factor. That is just mean. Were you using the ODBC6 version by chance?

Yes we were using the odbc6 !

Reply


Helpful Members This Week

Community Stats

31,260
Posts
118,545
Replies
38,851
Members

Latest FME

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.