I have a Desktop Workbench 2019, it works perfect when ran from the desktop. However, FME Server 2019 fails to write to the SDE Geodatabase.

In the FeatureWriter transformer, for the Connection File, I have the following syntax which works fine on Desktop:

\\\\SERVER\\fmeservershare\\resources\\data\\Configuration\\SDE_Connection.sde

Maybe the syntax to read it from FME server should be something like this??

$(FME_SHAREDRESOURCE_DATA)\\Configuration\\SDE_Connection.sde

I published the workbench to FME Server with the Connection file as: $(FME_SHAREDRESOURCE_DATA)\\Configuration\\SDE_Connection.sde but when I run it on FME Server, it doesn't write anything and no errors are giving in the log. It stops in line 107 and just hangs there. Is my Connection File syntax wrong?

107 Transactions are being used by the Geodatabase Writer

Thank you.