Hi,
I have workspace which I have made with FME 2016. It works ok with 2017, I can run workspace, but I can not edit Joiners. Not even if I upgrade them. Here is error I get:
I am able to create and edit databasejoiner in new workspace.
Where can I download 2016.1 version? I have backup:)
Best answer by softwrite1
I was also having this issue in dozens of workspaces with Joiners to Oracle Non-Spatial except one.
I found that by comparing the good and bad workspaces in a text editor I was able to find the Parameter for the Joiner that was causing the issue. I edited the bad workspaces by updating the parameter and the error stopped. See below for the Parameter to find and change.
Bad
#! <XFORM_PARM PARM_NAME="ORACLE_NONSPATIAL_SERVER_TYPE" PARM_VALUE=""/>
Good
#! <XFORM_PARM PARM_NAME="ORACLE_NONSPATIAL_SERVER_TYPE" PARM_VALUE="ORACLE8i"/>
Hope this helps someone.
Mike B
Try deleting the Joiner and then re-creating, rather than editing. Alternatively try copy-pasting the whole workspace contents into a blank workspace.
If that doesn't work you may want to try reinstalling FME. You can download FME 2016 and earlier here:
http://www.safe.com/support/support-resources/fme-downloads/archived/
Also try running FME while logged on with admin privileges.
I was also having this issue in dozens of workspaces with Joiners to Oracle Non-Spatial except one.
I found that by comparing the good and bad workspaces in a text editor I was able to find the Parameter for the Joiner that was causing the issue. I edited the bad workspaces by updating the parameter and the error stopped. See below for the Parameter to find and change.
Bad
#! <XFORM_PARM PARM_NAME="ORACLE_NONSPATIAL_SERVER_TYPE" PARM_VALUE=""/>
Good
#! <XFORM_PARM PARM_NAME="ORACLE_NONSPATIAL_SERVER_TYPE" PARM_VALUE="ORACLE8i"/>
Hope this helps someone.
Mike B
+10Is there another solution than re-creating the joiners? I have 2 workspaces created in FME 2016 with more than 40 Joiners in each workspace. Editing the joiners isn't working in FME Desktop 2017.
I've downloaded FME 2018 and this doesn't seem to have resolved the issue either.
The parameter mentioned by softwrite1 is already in the good form if I open the workspace in a text editor.
+18Is there another solution than re-creating the joiners? I have 2 workspaces created in FME 2016 with more than 40 Joiners in each workspace. Editing the joiners isn't working in FME Desktop 2017.
I've downloaded FME 2018 and this doesn't seem to have resolved the issue either.
The parameter mentioned by softwrite1 is already in the good form if I open the workspace in a text editor.
+10
We've fixed this issue for FME 2018.1. This issue was a problem with showing Oracle table list in the DatabaseJoiner.
+18I was also having this issue in dozens of workspaces with Joiners to Oracle Non-Spatial except one.
I found that by comparing the good and bad workspaces in a text editor I was able to find the Parameter for the Joiner that was causing the issue. I edited the bad workspaces by updating the parameter and the error stopped. See below for the Parameter to find and change.
Bad
#! <XFORM_PARM PARM_NAME="ORACLE_NONSPATIAL_SERVER_TYPE" PARM_VALUE=""/>
Good
#! <XFORM_PARM PARM_NAME="ORACLE_NONSPATIAL_SERVER_TYPE" PARM_VALUE="ORACLE8i"/>
Hope this helps someone.
Mike B
@softwrite1: Yes it did... (help someone). I understand Safe can't promote editing .fmw files in notepad++ or alike, but thanks for finding this one.
Recreating dozens of Oracle Joiners in dozens of workspaces, ensuring maintained functionality, is quite a labor intensive task nobody is very enthusiastic about getting it assigned.
This issue is still popping up for me in FME 2019 .1 with SQL Executors. Deleting it and re-adding appears to have fixed the issue for this workspace.
@david_whiteside
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
