Hello,
In theory, the SFP port should work with any standard SFP (SFP+ not supported) adapter.
However, if the adapter has some changes for compatibility sake with some other device, in this case I see that the SFP if compatible with Juniper devices, maybe they have some hardware changes required.
Maybe the SFP adapter does not report that it has a device connected to it, as that job now falls on the SFP adapter, to relay if the link is up or not.
Have you tried any other SFP adapters with RUTXR1?