4 Replies Latest reply on Oct 12, 2010 6:10 AM by lftgly

    GDB_ObjectClasses ModelName blank in ArcGIS 10.0 geodatabase GDB tables after upgrade

    lftgly
      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...
        • Re: GDB_ObjectClasses ModelName blank in ArcGIS 10.0 geodatabase GDB tables after upg
          cgillgrass-esristaff
          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,
          • Re: GDB_ObjectClasses ModelName blank in ArcGIS 10.0 geodatabase GDB tables after upg
            lftgly
            Craig-
            I'll email you off-line
            thanks,
            -Jon
            • Re: GDB_ObjectClasses ModelName blank in ArcGIS 10.0 geodatabase GDB tables after upg
              lftgly
              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
              • Re: GDB_ObjectClasses ModelName blank in ArcGIS 10.0 geodatabase GDB tables after upg
                lftgly
                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