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?
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 sourcesSuggested alternativesArcInfo coverageConvert the data to feature classes in a geodatabase.CADImport CAD content into a geodatabase feature class.Excel fileGenerate features for each Excel spreadsheet and load the resulting feature classes into a geodatabase feature class.ArcIMS feature serviceLoad the original data source into a geodatabase feature class.In-memory feature classSave in-memory data as a feature class in a geodatabase.
Convert the data to feature classes in a geodatabase.
Import CAD content into a geodatabase feature class.
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.
Do you have this patch applied? What version of Server are you running?
ArcGIS for Server Publishing Patch
I m using ArcGis server 10.5
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.
Retrieving data ...