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; } } }

base table definition string is invalid

PeterHoffman

I am trying to start the first new service on a 10.1 server. It has one layer. I get this error message:

Error: service started with errors.
Machine: TEST [service instance is started with errors. The base table definition string "Coast_line" is invalid]*

I have r/w permissions on the data folder for the arcgis arcgis user.

Thanks,

Find more posts tagged with

Accepted answers

PeterHoffman

I solved my own question - the output folder did not have the local arcgis user added with permissions.

All comments

TimDonoyou

Hi All

I know this thread is quite old but having just spent all morning registering and changing permissions on folders, sharing, creating local users, etc from suggestions on this thread I found another solution which was to re-run the "Configure ArcGIS Server Account utility" - just enter the username and password (twice), click next / next (the directories should stay the same) and then Configure...

BINGO...!

for me I can now successfully publish and use layers and raster catalogs saved on a network share outside of our ArcGIS Server machines...

hope this helps others too

cheers

Tim

BerendVeldkamp

I get the same error. I have an mxd with 1 featureclass and 3 related tables. The FC and 2 of the tables can be published, but the 3rd table gives the error "The StandaloneTable:'MyTable' in Map:'Layers' is invalid. The base table definition string "MYDATABASE.DBO.MyTable" is invalid. Failure to access the DBMS server."

The FC and the table are created by a script, so I assume that the privileges are the same for all of them. I can't really find any other difference between the tables.

10.1 SP 1 is already installed, so that cannot be the reason. I Also re-ran the "Configure ArcGIS Server account tool", but that didn't help either.
Other than the error above, the logs don't show anything suspicious (loglevel is set to DEBUG)

Any ideas?

EDIT: I found out what was going wrong. On the server, I opened the generated msd file (rename to .zip), and extracted layers.xml. Inspecting the WorkspaceConnectionString values revealed that one of the tables still pointed to the database on my development machine.
Unfortunately it is no longer possible to publish an msd, so what I had to do was, instead of publishing the service, create a service definition (sd file). Renaming that to .7z allowed me to open it, and extract the included msd. Rename that to .zip, extract and alter layers.xml, and then repack/rename everything to the original values.
The modified sd file could now be published.

F__BenGrieger

I was having this same problem using 10.2 today when I stopped some services to do routine work on a long-standing, stable geodatabase. I just added a feature class to a dataset, and this error came up on the existing FC's (not the new one) when I restarted the services. I've never seen this error before although I've done this operation many times. In addition, numerous other layers suddenly would not load in ArcMap (bad connection handles).

Solution (for me at least): I restarted ArcMap/ArcCatalogue and everything returned to normal- no more errors and the services would start normally. I can't explain it.

RossBrewer

Had same problem. Fixed it by deleting the existing service and republishing the service under the same name. You could probably just overwrite the old service, but building on a potentially corrupt service is risky to me.

TolardoClaudio

Hi, i had the same problem.

Solution

The standalone table that have a problem was on the last in the TOC "Lyst by source" into the mxd file.

I try to delete it and control if the rest work. Then the next last table failed.

So I try to add after my last table, one table with name 'z_something' and then publish my webservice.

Failed the last table with name 'z_something' but the rest work good.

Mistery !!!

KipkuleiHarison

Thanks peter,how do i add the arcgis user with permissions

kindly help,am stuck here,if need be take me through each step

PeterHoffman

I am running ArcGIS server 10.22 which means my server had the 10.1 version uninstalled and the new one installed. Therefore I have the users and permissions setup a little differently.

Try this:

Right click on computer, expand server manage>Configuration>Local users and groups>groups

Double click administrators and add ArcGIS local user to the administrators group.

image001.jpg

JulianGomez

I had the same problem today: this didn't have anything to do with permissions since I was using featureclasses in SQLEXPRESS and connected using the dataowner. Also not with permissions of the arcgis user since I could add the SOE before without problem.

I got the error after adding a new version of my SOE to the service and solved it as Ross Brewer said: deleting the service and publishing it again, and adding the SOE again.

By the way: I'm using AGS 10.2.2

AzinSharaf

I fixed this issue by disabling schema lock of map service and republishing.

GalenKeily1

After re-pathing my data from being referenced via Drive letter (Y:\geodatabase.gdb) to a UNC path, I was getting this error for all layers in my Map Services. Even though ArcMap showed that I was publishing with data referenced via UNC path, I realized that somehow the data published was still referencing my mapped drive letter (Y:\geodatabase.gdb)

Removing my mapped drive and ensuring that data was referenced via UNC path fixed the issue for me.

Hussam_AlJabri

Could you please show us in details how to do it?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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