Skip to main content
Question

Error connecting to Oracle-DB, but only on FME Form (FME Flow ok)

vki
Contributor
Forum|alt.badge.img+7
  • vkiContributor
  • Contributor

We recently updated to 2024.1 (FME Form and Flow).

We have some jobs, that run daily on FME Flow, that read features from an Oracle-db and write to a PostGIS-DB.

I downloaded one of the workspaces to FME Form to change something. But in FMEForm I cannot connect to the Oracel-DB anymore. I get this error:

Error connecting to Oracle database: message was `OCI_INVALID_HANDLE'. (serverType=`ORACLE_NONSPATIAL', serverName=`xy', userName=`xy', password=`***', dbname=`')

I uploaded the workspace again to FME Flow and there it ran successfully.

Any ideas, what could be the problem? Thanks in advance.

Vera

2 replies

frro
Contributor
Forum|alt.badge.img+13
  • frroContributor
  • Contributor
  • October 9, 2024

There has been a change in connection storage encryption in FME Form 2024.0.

This may cause problems with your connections after upgrading from older versions of FME Form and Desktop. Have a look at this support article:
Changes to Connection Storage in FME Form 2024 – FME Support Center (safe.com)

This security enhancement, and its side effects, probably could have been more advertised in the community.

Hope this helps! 

vki
Contributor
Forum|alt.badge.img+7
  • vkiContributor
  • Author
  • Contributor
  • October 21, 2024

It was obviously a problem on the database side. Everything is working again now. 

Thanks.

Reply


Most helpful members this week

Community Stats

30,861
Posts
117,003
Replies
38,689
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.