Looking at this line of the error:

It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FME. If already installed, set the Esri ArcGIS Compatibility setting for this workspace to 'Esri ArcGIS Pro' under Navigator -> Workspace Parameters -> Translation

Suggests that you need to be using Pro.

In ArcMap (not FME), can you connect to that DB and load the feature class you're using above?

I can open the db in Arcmap and it's still working in an older version of FME

Could be worth having a play with this parameter?

https://community.safe.com/s/question/0D54Q00008IaM9DSAV/is-there-anyway-i-can-force-fme-to-utilize-the-arcgis-pro-libraries-rather-than-the-arcgis-desktop-libraries-when-both-are-installed

Thank you, but I tried all three options allready without any result.

I am getting the same issue.

Hi @stalknecht​ and @tyderian​ sorry that you've encountered this issue! As simple as this sounds, have you tried adding a new reader to the canvas to see if the issue persists? I've also seen that if you add a new reader but don't specify the table before clicking OK it will prompt you to select a table/feature service then and read without issue. Not sure why this happens occasionally.

If you have tried all of these things and you are still having this error, I would ask that you submit a support case with us so that we can investigate further. Sorry for the inconvenience.

Thank you,

The error pops up when you try to select the table by hitting the three dots next to it.

I have submited a support case under number C688736

I'm sorry for that. I've submitted a support case. If there are any updates then I will update this post to inform you.

I discovered that my Arcgis Pro Instance was not licensed well. After activating the Pro license FME started to read again. So, my workaround is to activate ArcgisPro. The setting of FME 2022.2.3.0 (20230131 - Build 22789 - WIN64)Is probably ignored and it always uses the Arcgis Pro License regardles of it's setting. (Auto / Esri Arcmap / Esri Argis Pro) The support team is still investigating but I have now a workaround. Thank you.

Didn't read about everyone's unique setups here, but did run into lots of upgrade issues myself. I manage numerous Esri / FME environments and had tons of issues to isolate for. I have boiled it down to a couple things:

1) Don't run fixed ArcGIS Desktop 10.7.1 or 10.8.2 AND ArcGIS Pro 3.1 AND FME 2022.2.4 at the same time (nothing but issues w/ Esri licensing in FME). Seems like the pivot point in this equation is ArcGIS Pro 3.1 (e.g. I think 2.x works fine in this scenario).

And, likely closer to this thread......in a clean Windows 11 Enterprise environment with just ArcGIS Pro 3.1 and FME 2022.2.4 installed (reading SDE 11):

I noticed my RO user could see and choose FCs and tables, but they'd fail to add to the canvas saying "The table name 'GLB_SETLD_EBIS_03_CV_IMPORTANCE' could not be found in the Geodatabase as either a feature class or a table. This may be because the current user does not have permission to see 'GLB_SETLD_EBIS_03_CV_IMPORTANCE'".

My RW user could see and add everything normally.

After ensuring there were no perms issues in ArcGIS Pro 3.1 and SSMS, I realized the FME 2022.2.4 SDE reader table chooser window no longer has the "schema chooser" up top (sometimes my databases will have dbo and DBO).

2) I added "dbo." (case doesn't matter) to the front of the table name, bingo, RO user works fine now.

In previous versions, you'd pick this as you added FCs and tables, kind of going through the motions. So, that's good.....all previous .FMW SDE readers already have the schema prefix added due to the past "forced chooser" = no job changes needed.