Error connecting to Oracle database in Data Inspector when I select View Source Data in Desktop 2022

Hi @smcd84​, have you had a chance to walk through the resolution for ORA-12154 error in this article? If this doesn't resolve your issue, please file a support case for this issue.

@smcd84​ 

I'm glad you reported this as I'm experiencing this ongoing issue for a little while now. Not sure if related but same symptoms.

Mine will also point to system32 or the path from where my workspace runs.

This problem only occurs when launching Data Inspector from the Workspace for viewing purposes.

DI does not seem to be able to find the connection. You have to manually select the correct one.

Looking at the log file one can tell it's obvious as no Db connection details/string would be found in System32 or elsewhere.

I've even created a new connection which did not exist at all and same result.

Full Log

C:\\Users\\ADMINI~1.MOL\\AppData\\Local\\Temp\\FMEDataInspector\\logs\\fmedatainspector_2022-09-23T08-43-18.log

'POSTGRES' reader was created successfully

FME Configuration: Connection Storage: 'E:\\FMEConnectionStorage-DO-NOT-DELETE'

Creating reader for format: PostgreSQL

Trying to find a DYNAMIC plugin for reader named `POSTGRES'

Loaded module 'POSTGRES' from file 'C:\\Program Files\\FME\\2022\\plugins/POSTGIS.dll'

FME API version of module 'POSTGIS' matches current internal version (4.0 20220615)

The dataset 'C:\\Windows\\System32\\MVDC_Layers-PSQL14' was opened successfully

The feature cache has not been loaded while a new setConstraints was performed. Now loading...

Opening POSTGRES reader for dataset 'C:\\Windows\\System32\\MVDC_Layers-PSQL14'

Error connecting to PostgreSQL database(host='', port='', dbname='C:\\Windows\\System32\\MVDC_Layers-PSQL14', user='', password='***'): 'could not connect to server: Connection refused (0x0000274D/10061)

               Is the server running on host "localhost" (::1) and accepting

               TCP/IP connections on port 5432?

could not connect to server: Connection refused (0x0000274D/10061)

               Is the server running on host "localhost" (127.0.0.1) and accepting

               TCP/IP connections on port 5432?

'

Reader failed in open() call

An error has occurred. Check the logfile above for details

Failed to specify the feature index as constraints on the reader

Removing dataset 'MVDC_Layers-PSQL14 [POSTGRES]' from View 1

The dataset 'C:\\Windows\\System32\\MVDC_Layers-PSQL14' was closed successfully

An error has occurred. Check the logfile above for details

Successfully closed POSTGRES database reader

The 'POSTGRES' reader was destroyed successfully

Worker 12180 > FMEObjects Worker is starting up...

Worker 12180 > FME session was created successfully

Same thing happening with a SQL Server Db Connection.

Log Output: C:\\Users\\ADMINI~1.MOL\\AppData\\Local\\Temp\\FMEDataInspector\\logs\\fmedatainspector_2022-09-23T08-24-49.log

'POSTGIS' reader was created successfully

FME Configuration: Connection Storage: 'E:\\FMEConnectionStorage-DO-NOT-DELETE'

Creating reader for format: PostGIS

Trying to find a DYNAMIC plugin for reader named `POSTGIS'

Loaded module 'POSTGIS' from file 'C:\\Program Files\\FME\\2022\\plugins/POSTGIS.dll'

FME API version of module 'POSTGIS' matches current internal version (4.0 20220615)

The dataset 'E:\\FME Workbench\\StatMap\\MVDC<space>Cloud<space>Db' was opened successfully

The feature cache has not been loaded while a new setConstraints was performed. Now loading...

Opening POSTGIS reader for dataset 'E:\\FME Workbench\\StatMap\\MVDC<space>Cloud<space>Db'

Error connecting to PostgreSQL database(host='', port='', dbname='E:\\FME Workbench\\StatMap\\MVDC<space>Cloud<space>Db', user='', password='***'): 'could not connect to server: Connection refused (0x0000274D/10061)

               Is the server running on host "localhost" (::1) and accepting

               TCP/IP connections on port 5432?

could not connect to server: Connection refused (0x0000274D/10061)

               Is the server running on host "localhost" (127.0.0.1) and accepting

               TCP/IP connections on port 5432?

'

Reader failed in open() call

An error has occurred. Check the logfile above for details

Failed to specify the feature index as constraints on the reader

Removing dataset 'MVDC Cloud Db [POSTGIS]' from View 1

The dataset 'E:\\FME Workbench\\StatMap\\MVDC<space>Cloud<space>Db' was closed successfully

An error has occurred. Check the logfile above for details

Successfully closed POSTGIS database reader.

I've reported this to my supplier but looking forward for a response here.

Hi @jennaatsafe​ . A support ticket has already been logged with supporting information (Contracted Safe Partner). Might be a bug which first appeared in release 2021 as it's when it started happening for me. It's not linked to a workspace. If I add an existing / newly created Db connection onto a blank workspace then view the data using the Inspector, I would get an error message. Viewing the data using the Workbench is fine. FME Server Automations / Scheduled jobs / … all working fine.

Data inspector appends %WINDIR%\\system32 or the path of a saved workspace to the Db connection if inspecting data from that location and that's what the problem is.

Hope this clarifies it better.