topic base table definition string is invalid in ArcGIS Enterprise Questions

base table definition string is invalid

PeterHoffman — Wed, 05 Sep 2012 15:08:15 GMT

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,

Re: base table definition string is invalid

PeterHoffman — Wed, 05 Sep 2012 17:17:24 GMT

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

Re: base table definition string is invalid

JoshWhite — Tue, 20 Nov 2012 13:50:40 GMT

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.

Re: base table definition string is invalid

PeterHoffman — Tue, 20 Nov 2012 13:59:53 GMT

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.

Re: base table definition string is invalid

JoshWhite — Tue, 20 Nov 2012 14:28:40 GMT

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.

Re: base table definition string is invalid

GISGroup — Tue, 04 Dec 2012 07:28:52 GMT

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

Re: base table definition string is invalid

PaulBird — Fri, 07 Dec 2012 23:19:34 GMT

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.

Re: base table definition string is invalid

ChrisNorth — Wed, 19 Dec 2012 18:55:17 GMT

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

Re: base table definition string is invalid

JoshWhite — Wed, 19 Dec 2012 18:58:55 GMT

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.

Re: base table definition string is invalid

RyanColeman — Wed, 19 Dec 2012 19:20:05 GMT

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

Re: base table definition string is invalid

JoshWhite — Thu, 20 Dec 2012 12:52:07 GMT

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.

Re: base table definition string is invalid

RyanColeman — Thu, 20 Dec 2012 19:27:04 GMT

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.

Re: base table definition string is invalid

RedLong — Mon, 24 Dec 2012 03:09:31 GMT

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

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

Regards,
RL

Re: base table definition string is invalid

Anonymous User — Sun, 20 Jan 2013 21:26:12 GMT

@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

Re: base table definition string is invalid

JamalNUMAN — Mon, 21 Jan 2013 16:11:43 GMT

@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

Re: base table definition string is invalid

JerrySimmons_GISP — Thu, 31 Jan 2013 17:34:46 GMT

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

Re: base table definition string is invalid

JamalNUMAN — Fri, 01 Feb 2013 22:16:35 GMT

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?

Re: base table definition string is invalid

RobChouinard — Sat, 02 Feb 2013 13:39:00 GMT

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.

Re: base table definition string is invalid

JerrySimmons_GISP — Mon, 04 Feb 2013 13:09:01 GMT

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

Re: base table definition string is invalid

JamalNUMAN — Thu, 07 Feb 2013 18:04:49 GMT

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