I am having a problem with TableToExcel geoprocessing tool. My data in SDE database which works on MSSQL 2016. Script works fine in ArcMap what after puplish it as GPService it gives below error.
Error executing tool. TableToExcel_log Job ID: jdfcc06e8e5564b39bc507928ae9aeb28 : Traceback (most recent call last): File "E:\arcgisserver\directories\arcgissystem\arcgisinput\Geoprocessing\TableToExcel_log.GPServer\extracted\v101\geoprocessing\TableToExcel_msa.py", line 241, in arcpy.GetParameter(3)) File "E:\arcgisserver\directories\arcgissystem\arcgisinput\Geoprocessing\TableToExcel_log.GPServer\extracted\v101\geoprocessing\TableToExcel_msa.py", line 141, in table_to_excel fields = get_field_defs(in_table, use_domain_desc) File "E:\arcgisserver\directories\arcgissystem\arcgisinput\Geoprocessing\TableToExcel_log.GPServer\extracted\v101\geoprocessing\TableToExcel_msa.py", line 98, in get_field_defs if arcpy.Describe(ws).dataType == 'FeatureDataset': File "c:\program files\arcgis\server\arcpy\arcpy\__init__.py", line 1253, in Describe return gp.describe(value) File "c:\program files\arcgis\server\arcpy\arcpy\geoprocessing\_base.py", line 376, in describe self._gp.Describe(*gp_fixargs(args, True))) IOError: "\gisdb.GDB.Services" does not exist Failed to execute (TableToExcel-log). Failed to execute (TableToExcel_log).
I tested the same tool with with other layers which the data source is filegeodatabase and it works fine.
Is there any one can guide me to about problem.
Also the tool is not working when subtype and domain option true and if there are some empty value in subtype field. This problem is solved for me when values are entered.
Thanks...