layer data source is not supported

[abdullahqasrawi]

Hi all

I used (make query table tool), then published the result but I found massage say “layer data source is not supported”

as the attached screenshot

Any help regard this?

[Asrujit_SenGupta]

I am not completely sure if the Query Table is a supported Data Source.

00004: Layer's data source is not supported—Documentation | ArcGIS Enterprise 

Unsupported data sources	Suggested alternatives
ArcInfo coverage	Convert the data to feature classes in a geodatabase.
CAD	Import CAD content into a geodatabase feature class.
Excel file	Generate features for each Excel spreadsheet and load the resulting feature classes into a geodatabase feature class.
ArcIMS feature service	Load the original data source into a geodatabase feature class.
In-memory feature class	Save in-memory data as a feature class in a geodatabase.

Also, Make Query Table—Data Management toolbox | ArcGIS Desktop 

The layer that is created by the tool is temporary and will not persist after the session ends unless the document is saved.

So this "maybe" the issue.

[AdamZiegler1]

Do you have this patch applied? What version of Server are you running?

ArcGIS for Server Publishing Patch 

Adam Z

[abdullahqasrawi]

I m using ArcGis server 10.5

[JonathanQuinn]

I don't think non-persistent data sources, (like the output of the Make Query Table tool), are supported.  You can try to create a view in the database/geodatabase that joins the tables so a data source is persisted there and see if you can publish.