GDB_ObjectClasses ModelName blank in ArcGIS 10.0 geodatabase GDB tables after upgrade

2139
4
10-04-2010 02:26 PM
JonHall
Occasional Contributor II
Using ArcCatalog 10.0, I've created a new ArcGIS 10.0 Desktop ("Personal") SDE database, File Geodatabase, and Personal (MS-Access .mdb) Geodatabase, then copied data from ArcSDE 9.3.1 SP2 database and pasted into all 3 types of 10.0 geodatabase, with the same results:

The former GDB_ObjectClasses ModelName is blank, when my code tries to retrieve the IModelInfo.Modelname values from any of 3 ArcGIS 10.0 geodatabase types.

The new GDB tables are normalized beyond any human-readable recognition - I cannot find anything like that attribute in the new GDB_Items table, where I assume it would be along with the Name and AliasName from GDB_ObjectClasses

Is lack of ModelName support a 'known issue' in the new geodatabase GDB table schemas?

Or an issue with the ability of ArcCatalog 10.0 to copy and paste that ModelInfo attribute value from older geodatabases into ArcGIS 10.0 databases?

Thanks...
0 Kudos
4 Replies
CraigGillgrass
Esri Regular Contributor
I'm not able to reproduce this behavior using 10.0 or our current builds. A couple of questions that will help narrow this down:

  • Have you confirmed that the ModelName is set in the 9.3.1 SP2 geodatabase?

  • Are you using ArcGIS 10.0 without any patches or hot fixes?

  • Can you supply the code you are using to retrieve the ModelName, I may be doing something differently in my repro case.


Finally, what type of ArcSDE database are you using; Oracle, SQL Server, etc?  What is the size of the database?  We may need to get the database in house to reproduce the issue.

thanks,
0 Kudos
JonHall
Occasional Contributor II
Craig-
I'll email you off-line
thanks,
-Jon
0 Kudos
JonHall
Occasional Contributor II
Craig-
I can also reproduce this with a File geodatabase.

I have an ArcGIS 9.3.1 File geodatabase, and the ModelName of teatureclasses and tables is populated.

When I use ArcCatalog 10.0 to create a new ArcGIS 10.0 File geodatabase, then copy the data from the ArcGIS 9.3.1 File geodatabase, and paste it into the new ArcGIS 10.0 File geodatabase, all the Modelnames are blank in the ArcGIS 10.0 File geodatabase.

It does not appear to be exclusively an ArcSDE issue.
Regards, Jon
0 Kudos
JonHall
Occasional Contributor II
ESRI was able to reproduce the issue, but apparently the IModelInfo.Modelname was not blank in the databases.

Something broke in the 9.x to 10.0 upgrade, when the casting an IDatasetName object to IModelInfo, as in this example:
                    If TypeOf pDatasetName Is Geodatabase.IModelInfo Then
                        pModelInfo = pDatasetName
                        sTable = pModelInfo.ModelName.ToString
                        Debug.Print("Modelname: " & stable)
                    End If

ESRI found that if you open the IDatasetName objects as an IDataset object, and then cast from the IDataset to IModelName; it should print out the ModelName correctly.

This issue is logged as NIM061873 and ESRI will be addressing this issue in SP2 for 10.0
0 Kudos