When the dataset is run first the preview is fine. It is only when I first click View Source Data. The preview searches the connection at C:\\Windows\\System32\\%connectionname% which is wrong. It should just go to the connection defined in the workspace
Question
Why seems the connection lost tot oracle table when using the View Source Data button and then Open in Data Inspector
+13- Safer
- 383 replies
Hi @ejmpost: I'm sorry you came across this issue. What version/build of FME are you using? I was able to reproduce the issue with FME 2022.2 by:
- adding an Oracle Reader Feature Type to Workbench,
- click on View Data Source (in the feature type context menu), which loaded the table in the Visual Preview window in Workbench.
- I then clicked on the Open in Data Inspector button in the visual preview. The table didn't load, and after viewing the entire log in the Data Inspector I see that it was connecting to C:\\Windows\\System32\\%connectionname%
I tried the same process in our latest build of FME 2023, and the issue no longer occurs. Data Inspector successfully loaded the Oracle table. Please try it out in FME 2023. If you're still experiencing an issue, I would suggest opening up a support case with us: https://community.safe.com/s/submit-case