In memory-joins between data in different file geodatabases are not recognized in referenced map services.

Workaround

Several workaround options:

• Have the data in the same file geodatabase.
• For the publisher and server path, keep them the same (note that this is only possible with Windows).
• Refer to the following article for other alternatives: https://pro.arcgis.com/en/pro-app/latest/help/sharing/analyzer-error-messages/00226-in-memory-joins-and-relates-are-not-supported.htm.

Steps to Reproduce