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,

Trouver plus de publications taguées avec

Accepted answers

PeterHoffman

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

All comments

PeterHoffman

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

JoshWhite

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

I'm having the same error, what output folder are you referring to, maybe we're talking about something different but I'm trying to publish a service. The service starts automatically unlike what the error states but I still get this odd error that I don't normally get when serving a table in a map service.

This new table is from the same geodatabase as other layers in this map service.

PeterHoffman

I am talking about the c:\arcgisserver\directories folder. There are 4 subfolders on my machine - arcgisoutput was the one I had to add the user to.
Also install arcgis server sp1 as it fixes many bugs. I had to reset the source for any data added before the sp as the sp changes how the the source is connected in sde.

JoshWhite

I'm not using sde so this probably isn't the issue for me. Plus the problem just suddenly appeared. I'll check into sp 1.

GISGroup

Hi,

I installed arcgis 10.1 with sp1. i created mosaic dataset in file geodatabase. the geodatabase folder also registered with server and I am able publish the dataset as image service through arc catalog. However, if i added the mosaic dataset in ArcMap, i am unable to publish i got error as "the base table definition string AMD_sat_2011_CAT is invalid.

any suggestions?

regards
Kumar

PaulBird

Hi,

OK, Same problem... I have set permissions on the folders, I have set share on the folders, I have registered the folders, I have registered the databases. And still I get "ERROR: service started with errors, The base table definition string " " is invalid."!

Out of frustration, I removed ARC Server completely, and reloaded it all. It was and is 10.1 SP1... No change in results.

Any thoughts are very much appreciated.

gisgeeknorth

I had the same problem - but the solution was permission on the source data folder, not the output directory. I had to give the ArcGIS user account read/write permission on the folder containing the file geodatabase. I also registered the folder as a datasource.

Doing that got rid of the error.

Chris

JoshWhite

What I don't understand is that this table was in the same file geodatabase as the rest of the layers in the map. Also, I didn't get any errors when I analyzed it, I only got the error when I actually went to publish 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...

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

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.

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

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

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

JerrySimmons_GISP

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

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?

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.

JerrySimmons_GISP

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

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

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

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

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.

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.

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

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.

Laura_0-1740159902218.png

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

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

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

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

KipkuleiHarison

kindly shed more light on this ,am also trying to publish a servie and getting the same message base table definition string*** is invalid,what could be the reason?

PeterHoffman

Kipkulei,

I have not had a problem since I added the arcgis user with permissions since.

We are upto using arcgis server 10.22.

Have you looked at some of the other solutions tried in this message?

Peter

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.

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.

TheoFaull

'I had to add the user to.'

and how do you do that?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Se connecter
S'inscrire

Liens rapides

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