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,

Encuentra más publicaciones etiquetadas con

Accepted answers

PeterHoffman

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

All comments

Hussam_AlJabri

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

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.

AzinSharaf

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

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

MatthewBaker2

This was the solution for me... I have a subfolder on our application server containing a geodatabase with my data for server. We gave the subfolder (not the root) full access to the 'arcgis' user and the service published just fine.

deleted-user-ugCMpXci8bn5

I received this error using ArcGIS for Server 10.2 when I tried to publish from an mxd in my C:/Users/user/Desktop folder. Once I moved the mxd and data to a folder higher in the directory structure (to C:/newFolder), I no longer had the error. I assume this was a permissions issue; this does seem to be (another) one of those ESRI errors which the error description itself is not really related to the actual problem.

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

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

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 !!!

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.

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.

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.

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

MatthewLawton

I was getting the same error messages after installing ArcGIS Server 10.1 on a new Windows Server 2008 R2 64-bit install, but the messages I received were followed by a SQL client connection error as well. Loading the SQL Server 2008 R2 client fixed it for me. See KB article 37287:

http://support.esri.com/es/knowledgebase/techarticles/detail/37287

The SQL Client for 2008 R2 64-bit is available here:

http://go.microsoft.com/fwlink/?LinkID=188401&clcid=0x409

DimaStikut

Had the same error when trying to deploy an SOE to a service.

Apparently, my arcgis account did not have full access to the folder which contains the SOE file. Once I've solved that, the error disappeard. Hopefully that helps someone

JamalNUMAN

I was having the same problem as is discussed in this thread. I was also getting this error:

Error: Error handling service request : Cannot obtain a free instance.; nested exception is: com.esri.arcgis.discovery.ejb.ArcGISServerEJBException: com.esri.arcgis.discovery.servicelib.AGSException: AutomationException: 0x80004005 - Unspecified error
Code: 500

Granting the ArcGIS Server user full security on the folder with my data resolved both problems.

Thanks Luke,

Cheers

Jamal

LukeBehling

I was having the same problem as is discussed in this thread. I was also getting this error:

Error: Error handling service request : Cannot obtain a free instance.; nested exception is: com.esri.arcgis.discovery.ejb.ArcGISServerEJBException: com.esri.arcgis.discovery.servicelib.AGSException: AutomationException: 0x80004005 - Unspecified error
Code: 500

Granting the ArcGIS Server user full security on the folder with my data resolved both problems.

JamalNUMAN

I loaded ArcTutor and copied the folder "C:\arcgis\ArcTutor\Parcel Editing" to "C:\Users\Public\Documents".

I then tried to publish ParcelEditing.mxd as a map service using ArcMap. It fails with the "base table definition string is invalid" error being discussed here.

ESRI support suggested adding the arcgis account to folder so I did. No difference. In fact I don't think that doing this should be necessary since the SERVICE group has access and both the ArcGISServer and ArcSOC processes are a member of the SERVICE group.

What does work to is to create a folder C:\GisData and then give the arcgis account access to it. So there is a permission issue here but it is not related to the arcgis account.

Seems like a bug to me. Let's see what ESRI support comes back with.

I have highlighted this issue in more than one thread but didn�??t get any solution

In my case, the data is stored in client machine and the user is trying to publish from this client machine where:
1. the folder containing the data is SHARED to the �??ArcGIS Server Account�?�
2. the �??ArcGIS Server Account�?� is granted full SECURITY on the folder containing the data
3. the folder contain the data is REGISTERED on the �??data store�?�

Nevertheless, I got the very frustrating messages like
1. �??packaging failed�?�
2. �??the data item is inaccessible�?�
3. �??Base definition table string is invalid�?�

How to
1. Store the data on the client machine
2. Publish from the client machine

Without having the abovementioned errors

Best

Jamal

RichardWatson

I loaded ArcTutor and copied the folder "C:\arcgis\ArcTutor\Parcel Editing" to "C:\Users\Public\Documents".

I then tried to publish ParcelEditing.mxd as a map service using ArcMap. It fails with the "base table definition string is invalid" error being discussed here.

ESRI support suggested adding the arcgis account to folder so I did. No difference. In fact I don't think that doing this should be necessary since the SERVICE group has access and both the ArcGISServer and ArcSOC processes are a member of the SERVICE group.

What does work to is to create a folder C:\GisData and then give the arcgis account access to it. So there is a permission issue here but it is not related to the arcgis account.

Seems like a bug to me. Let's see what ESRI support comes back with.

JamalNUMAN

That's the understatement of the year. I don't know how many times I've been given a generic error and had no idea how to fix it because I didn't know what the problem was. Many of the errors I've had require the use of MXD Doctor or checking each individual layer for problems. Of course, a generic error is better than no error at all which I've had a lot when I go to print and ArcMap locks up.

The thread below has related discussion

http://forums.arcgis.com/threads/77181-Granting-permissions-to-the-%E2%80%9CArcGIS-Server-Account%E2%80%9D-user-on-data-stored-in-client...?p=271438#post271438

Best

Jamal

JoshWhite

It would be helpful if ArcGIS Server provided additional/better error information.

That's the understatement of the year. I don't know how many times I've been given a generic error and had no idea how to fix it because I didn't know what the problem was. Many of the errors I've had require the use of MXD Doctor or checking each individual layer for problems. Of course, a generic error is better than no error at all which I've had a lot when I go to print and ArcMap locks up.

RichardWatson

A co-worker of mine encountered the problem "The base table definition string xyz is invalid" yesterday.

In this particular case, he diagnosed the problem to be related to installing custom features classes and class extensions on the server which referenced a missing DLL.

This implies to me that this failure message is very generic and is simply saying that the server has some type of configuration issue. It would be helpful if ArcGIS Server provided additional/better error information.

JamalNUMAN

I am not sure if this would help but I would install arcgis server 10.1 service pack 1, etc. It fixed several problems I was experiencing in editing.

Many thanks Peter for the contribution,

Best

Jamal

PeterHoffman

I am not sure if this would help but I would install arcgis server 10.1 service pack 1, etc. It fixed several problems I was experiencing in editing.

JamalNUMAN

you might want to check securtiy permissions on the file geodatabase to see if you arc user is allowed access

Many thanks guys for the help,

But how to give the ArcGIS Server Account�?� user (which is a user on the server machine) permissions on the client machine where my data (mxd and file geodatabase) is stored?

In the scenario of �??home network�?� there is no way to grant users of other machines some permissions in your machine as the users of other machines will never appear on your machine to be granted permissions.

[ATTACH=CONFIG]21578[/ATTACH], [ATTACH=CONFIG]21579[/ATTACH], [ATTACH=CONFIG]21580[/ATTACH]

This issue here is that we need to grant a user on the server machine a permission on the client machine. How this might be accomplished?

Best

Jamal

What if my data is file geodatabase but not SDE? how to give "select" permission?

you might want to check securtiy permissions on the file geodatabase to see if you arc user is allowed access

RobChouinard

I solved this problem by giving my ArcGIS Server user "full access" security rights to my folders containing File Geodatabases. Reason for full access is when the service is started it needs to be able to create schema locks on layers/tables you have in your service. All folders you have registered with ArcGIS Server need this.

JamalNUMAN

I had the same issue and resolved it by giving user arcgis SELECT rights to the database in SQL

What if my data is file geodatabase but not SDE? how to give "select" permission?

JerrySimmons_GISP

I had the same issue and resolved it by giving user arcgis SELECT rights to the database in SQL

JamalNUMAN

@ESRI - there's a lot of us getting this error message including myself. Can you shed some light on the possible causes of this issue?

Brad

Very frustrating:

[ATTACH=CONFIG]20923[/ATTACH], [ATTACH=CONFIG]20924[/ATTACH]

What might be the issue? how to be resolved

Thank you

best

Jamal

Clip_7.jpg

Clip_10.jpg

Anonymous User

@ESRI - there's a lot of us getting this error message including myself. Can you shed some light on the possible causes of this issue?

Brad

RedLong

Same error message here.
Above workarounds do not work for me. 😞

Any other ideas around?
What is a base table definition string anyway?

Regards,
RL

RyanColeman

So a few things I've figured out
1) You have to now give the arcgis server account editing privileges and versioning
2) You have to have no other layers in the service definition file except those you want to use in a feature service, so basically I had to create a new service with just the one layer I wanted to be a feature service. This wasn't the case in 10, as long as I didn't try to use the other layers as features there was no problem.

JoshWhite

Ryan,
This actually happened to me before installing the SP 1 as well and didn't appear to go away when I did install it.

RyanColeman

I have the same issue. The layer in question is in a SQL spatial database that is registered and validates fine. Both my ArcGIS Server Account and my user account have full permissions on the drive all this stuff is on and on SQL. No idea where to go from there.

It's probably just 10.1 SP1...

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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