topic Re: Invalid function argument in OpenTable method - API 1.3 in File Geodatabase API Questions

Invalid function argument in OpenTable method - API 1.3

SunilTerkar — Thu, 19 Jun 2014 07:33:47 GMT

Hello,

I am using API 1.3 with VS 2010, target framework .NET 4.0 and ArcGIS 10.0 with service pack 5.0. The file geo database is created in same ArcGIS version.

The File geodatabase uses British Coordinate System. It contains among few feature classes, polygon feature class "DMA". Below is my c# code causing me problem.

Geodatabase geodatbase = Geodatabase.open("D:\\Clean Water\\CW_Assets.gdb");
Table esriTable = geodatabase.OpenTable("DMA");

on the second line I am getting an error message "Invalid function argument". From other discussion thread on same topic I learned that API doesn't support customized coordinate system, but british coordinate system is not customized, it's standard coordinate system available in ArcGIS.

I did tried other method to check if I can access attribute data of "DMA".

RowCollection attributeQuery = geodatabase.ExecuteSQL("Select * from DMA"), the error message I got was "table not found".

I could see the existence of feature class "DMA" in ArcCatalog.

Can somebody advise what am I doing wrong?

Thanks in advance.

Sunil

Re: Invalid function argument in OpenTable method - API 1.3

LanceShipman — Thu, 19 Jun 2014 13:44:53 GMT

Try:

Table esriTable = geodatabase.OpenTable("\\DMA");

Re: Invalid function argument in OpenTable method - API 1.3

SunilTerkar — Thu, 19 Jun 2014 15:32:30 GMT

Hello,

I tried;

Table esriTable = geoDatabase.OpenTable("\\DMA");

But still getting "Invalid function arguments" error.

Any more advise.

Thanks,

Sunil

Re: Invalid function argument in OpenTable method - API 1.3

LanceShipman — Thu, 19 Jun 2014 19:27:29 GMT

I'm able to open a table named "DMA", so it's not a name issue.

Can you supply more information on the coordinate system? What is the name of the projection? The datum? Amy details would be helpful. As an experiment reproject the data or a subset into Robinson or similar.

Is the feature class involved in a network, topology or anything similar?

Re: Invalid function argument in OpenTable method - API 1.3

SunilTerkar — Fri, 20 Jun 2014 12:45:03 GMT

Hello,

Here are details of coordinate system used for "DMA" feature class and another feature classes in geodatabase.
Name of Coordinate System:- British National Grid
Projection:- Transverse_Mercator
Datum:- Ordinance Survey Great Brit.

It's pretty much standard system used in this part of world (UK). "DMA" feature class is not involve in any network but geodatabase contains Feature Dataset and some participating feature classes in geometric network. Following is a tree of feature classes as viewd in ArcCatalog

CW_Assets.gdb
FDS - Feature dataset
---CW_wDistributionMain - Feature class in Geometric network
---CW_wNetworkMeter - Feature class in Geometric network
---GN - Geometric network
---GN_Junctions -
DMA - Feature class
GN_BUILDERR - Table

Let me know if you need more information.

Thanks,

Sunil

Re: Invalid function argument in OpenTable method - API 1.3

LanceShipman — Fri, 20 Jun 2014 13:56:20 GMT

I'm able to open a feature class named "DMA" which is in the UK national grid, so the coordinate system is unlikely to be the problem.

The fact that you can't open it and ExecureSQL can't find it, but ArcCatalog can see it. Was the file geodatabase upgraded from an earlier version (9.x). If so create a new file geodatabase and copy the data into it. Try to open the DMA feature class in the new file geodatabase.

Can you compile and run the C# samples? The display sample will not compile without additional software (see the readme). Run the Query sample.

Re: Invalid function argument in OpenTable method - API 1.3

SunilTerkar — Fri, 20 Jun 2014 14:12:37 GMT

Hello,

The filegeodatabase is created by ArcGIS 10.0 which is currently am using. I can compile c# sample code but cannot test it for lack of sample database. I did followed the steps given in sample code for writing my code. It seems kind of issue not able to figure out.

Thanks,

Sunil

Re: Invalid function argument in OpenTable method - API 1.3

VinceAngelo — Fri, 20 Jun 2014 14:33:25 GMT

I suspect your initial diagnosis (custom projection) is the problem. The only way
we'll know for sure is if you copy the DMA table to a new file geodatabase, then
zip the new .gdb folder and post it here.

- V

Re: Invalid function argument in OpenTable method - API 1.3

SunilTerkar — Fri, 20 Jun 2014 14:59:39 GMT

Hello,

Please find "DMA" feature class in new file geodatabase as requested for testing.

Thanks,

Sunil

Re: Invalid function argument in OpenTable method - API 1.3

LanceShipman — Fri, 20 Jun 2014 15:25:20 GMT

ArcGIS see's your feature class as a "Custom" projection. The feature class I created as UK National Grid is not seen as "Custom". The projection information is the same. The xy domains are very different. I'll talk to the projection team and see what they have to say.

Re: Invalid function argument in OpenTable method - API 1.3

LanceShipman — Fri, 20 Jun 2014 16:33:10 GMT

This is what is expected by ArcGIS:
PROJCS["British_National_Grid",GEOGCS["GCS_OSGB_1936",DATUM["D_OSGB_1936",SPHEROID["Airy_1830",6377563.396,299.3249646]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",-100000.0],PARAMETER["Central_Meridian",-2.0],PARAMETER["Scale_Factor",0.9996012717],PARAMETER["Latitude_Of_Origin",49.0],UNIT["Meter",1.0]]

This is what your feature class contains:
PROJCS["British National Grid",GEOGCS["Ordnance Survey Great Brit",DATUM["Ordnance Survey Great Brit",SPHEROID["Airy 1830",6377563.396,299.3249646]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",-100000.0],PARAMETER["Central_Meridian",-2.0],PARAMETER["Scale_Factor",0.9996012717],PARAMETER["Latitude_Of_Origin",49.0],UNIT["Meter",1.0]]

ArcOBJECTS and the File Geodatabase API compare these strings and since yours is seen as different, it is seen as "Custom".

What was the source of this data and how was it loaded?

Re: Invalid function argument in OpenTable method - API 1.3

SunilTerkar — Fri, 20 Jun 2014 17:22:46 GMT

Hello,

The data was received from client who is using ArcGIS for ages and I just copied the features class to new geodatbase for using file geodatabase API.

Alternatively, in my another application developed in ArcObject, same coordinate system doesn't give me any problem. I reckon, either something has changed between versions of ArcGIS or Client has edited the .prj file just to replace couple of text.

I am about to revert British coordinate system given in feature class to ArcGIS and test the application and will report.

Thanks for your help.

Sunil

Re: Invalid function argument in OpenTable method - API 1.3

SunilTerkar — Mon, 23 Jun 2014 07:51:53 GMT

Hello,

I can now confirm that issue is resolved after reverting back to "British National Grid" given in ArcGIS.

Thanks for your help.

Sunil