Question

Error when creating a database connection

  • 20 April 2023
  • 2 replies
  • 35 views
R
Badge

Hello,

I am using FME Server 2021.2.3 deployed on couple of machines in a fault tolerant configuration

We have an Oracle database 19c. I have tried to connect to the database in FME Server, but getting the error message below (see attached also). I can connect to the database from SQLDeveloper on the same server.

A similar issue was reported in https://community.safe.com/s/question/0D54Q000080heRDSAY/not-able-to-create-a-new-database-connection-on-fme-server

However the solution needed a reinstall of FME Server.

Does anyone have other suggestions ?

 

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

1 Attachment

2 replies

keziaatsafe
Rank
Userlevel 1
Badge +6

HI @ravinhasseea​ ,

In your install configuration, did you use your own ojdbc or the default one used by FME?

Are you able to connect to the database successfully from FME Form (Desktop)?

Does creating this database connection in FME Workbench and publishing it to FME Flow (Server) fail too?

 

Kezia

R
Badge

HI @ravinhasseea​ ,

In your install configuration, did you use your own ojdbc or the default one used by FME?

Are you able to connect to the database successfully from FME Form (Desktop)?

Does creating this database connection in FME Workbench and publishing it to FME Flow (Server) fail too?

 

Kezia

Thank you for the response @keziaatsafe​ 

We did manage to fix this by updating from ojdbc6 to ojdbc8

Reply


Community Stats

28,668
Posts
109,356
Replies
36,532
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.