Could you solve the "." problem. I cannot publish my service because of the dots in the layers name. Please let me know if you have any solution. Description of issue in detail: ############################### * ArcGIS Desktop version :10.4.1 * ArcGIS Server version: 10.4.1 * Enterprise Geodatabase version: I converted a SQL database to Geodatabase using ""Enable Enterprise Geodatabase" tool in Arcmap and registered the GDB at Arcgis server * SQL Server version: SQL Server 2012 I am creating a very simple service. the python code of script is: import arcpy arcpy . CheckOutExtension ( "3D" ) arcpy . RasterDomain_3d ( r "Database Connections\GS.sde\GS.DBO.R1" , r "Database Connections\GS.sde\GS_DBO_test" , "POLYGON" ) it works as a ArcGIS tool perfectly and generate the polygon output: Then I shared the tool as Geoprocessing service. when I run the service on my ArcCatalog as follows: I get the following error: I do not know why the arcGIS server makes the same output in the a"scratch.gdb" in the server and fails because of the "Dots" in the name. As you know, ArcGIS does not accept Dot as a layer name in file Geodatabase.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Unable to use a Geoprocessing Service. Error 000210. The Table name is Invalid

MohammadrezaNikfal1

Could you solve the "." problem. I cannot publish my service because of the dots in the layers name. Please let me know if you have any solution.

Description of issue in detail:

###############################

ArcGIS Desktop version :10.4.1
ArcGIS Server version: 10.4.1
Enterprise Geodatabase version: I converted a SQL database to Geodatabase using "
"Enable Enterprise Geodatabase" tool in Arcmap and registered the GDB at Arcgis server
SQL Server version: SQL Server 2012

I am creating a very simple service. the python code of script is:

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">import</SPAN> arcpy

arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>CheckOutExtension<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN><SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"3D"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN>
arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>RasterDomain_3d<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>r<SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"Database Connections\GS.sde\GS.DBO.R1"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; r<SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"Database Connections\GS.sde\GS_DBO_test"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"POLYGON"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="border-width: 0px 1px 0px 0px; border-style: initial solid initial initial; border-color: initial #999999 initial initial; font-weight: inherit;"></SPAN>

it works as a ArcGIS tool perfectly and generate the polygon output:

Then I shared the tool as Geoprocessing service. when I run the service on my ArcCatalog as follows:

I get the following error:

I do not know why the arcGIS server makes the same output in the a"scratch.gdb" in the server and fails because of the "Dots" in the name. As you know, ArcGIS does not accept Dot as a layer name in file Geodatabase.

Najděte více příspěvků označených jako

Accepted answers

All comments

JonathanQuinn

When you create a geoprocessing service, you shouldn't set the output location to an SDE database when running the tool in ArcMap. That will create the name using the syntax for a FC in a geodatabase, (instance.owner.table) as you know. When you run the GP service, all output feature classes will be written to the scratch.gdb. Since it simply takes the original name and saves it to the scratch.gdb, the original name becomes invalid. Save the output to a file geodatabase when running the tool in ArcMap, then publish it. You can use the os module and arcpy.env.scratchGDB environment variable:

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os

arcpy<SPAN class="punctuation token">.</SPAN>CheckOutExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"3D"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>RasterDomain_3d<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"Database Connections\GS.sde\GS.DBO.R1"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>scratchGDB<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"test"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POLYGON"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

XanderBakker

In addition, please note that a valid name can be created using ValidateTableName—Help | ArcGIS Desktop .

The other thing is to revise the content (if you have access) of the script after it is published to AGS (look at a folder like: arcgisserver\directories\arcgissystem\arcgisinput\OptionalFolderName\YourServiceName.GPServer\extracted\v101) In many cases the content of the script will be changed.

ModyBuchbinder

First you should think about the final GP that you need. Currently the tool takes one layer and create a second one, both with hard coded names. Such a service should work only once...

Do you want the user to select a feature class for input? Are you sure all outputs should be written into the database (what happens if to users give the same output name)?

Usually the output of a GP tool is temporary and send only to the user that run the tool.

In general the server does not have "Database Connection" this is something that exists in your profile only.

You should put a sde connection file in a directory that is registered in the server (C:\temp\GS.sde) Then it will be recognize in the publish process and will not be replaced by scratch gdb.

Have Fun

Mody

MohammadrezaNikfal1

ArcGIS Desktop version :10.4.1
ArcGIS Server version: 10.4.1
Enterprise Geodatabase version: I converted a SQL database to Geodatabase using "
"Enable Enterprise Geodatabase" tool in Arcmap and registered the GDB at Arcgis server
SQL Server version: SQL Server 2012

I am creating a very simple service. the python code of script is:

<SPAN class="keyword token">import</SPAN> arcpy

arcpy<SPAN class="punctuation token">.</SPAN>CheckOutExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"3D"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>RasterDomain_3d<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"Database Connections\GS.sde\GS.DBO.R1"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; r<SPAN class="string token">"Database Connections\GS.sde\GS_DBO_test"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POLYGON"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

it works as a ArcGIS tool perfectly and generate the polygon output:

Then I shared the tool as Geoprocessing service. when I run the service on my ArcCatalog as follows:

I get the following error:

Asrujit_SenGupta

This looks good and as expected.

GS --> Name of the database

DBO--> Schema that owns the data and was used to create the data

GS_DBO_test \ test--> name of the Object (table and Feature class)

So, I think you should posts a screenshot of the error you receive while Publishing and a brief outline of the workflow you are following to Publish.

Also the configuration details, such as:

ArcGIS Desktop version
ArcGIS Server version
Enterprise Geodatabase version
SQL Server version (Example: SQL Server 2014 SP2)

MohammadrezaNikfal1

Thank you,

I do not have any control on the name because the dots come from SQL server. When I switched the "." with "_", the output result is as follow:

If I publish the service, It will not run because of the new Dots!

Asrujit_SenGupta

Remove the "." in the Object name and replace with an "_" if needed. As discussed above, "." in object name is not supported by ArcGIS.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.