+ Reply to Thread
Results 1 to 6 of 6

Thread: Problem adding fields after a table join using a file geodatabase

  1. #1
    James McCarthy
    Join Date
    Dec 2010
    Posts
    11
    Points
    0
    Answers Provided
    0


    0

    Default Problem adding fields after a table join using a file geodatabase

    I'm working through what I think is a simple workflow in ArcGIS 10.1 (specifically ArcMap) and I've come across what seems to me like a bug. I've tried this with 2 different datasets and a colleague tried it with a third dataset and we both got the same result.

    What's happening is that I'm joining a standalone table to a feature class (both stored in the same file GDB), adding a field to the feature class (via the attribute table window), and what I see is that the data from the last column in the joined standalone table is moved to the new field. I thought it might just be a visual thing, but if you run statistics on the new field it uses the values that were moved over.

    If you look at the standalone table on its own it is unchanged. If you close/reopen the mxd the problem goes away, and if you remove the table join everything goes back to the way it should be. The problem seems to be limited to file geodatabases in my testing. Doing the same steps with the same data as a shapefile and a dbf file doesn't cause the problem.

    The workaround is straightforward: don't add fields to a feature class if there's an active table join. While investigating this I even discovered that you can't use the Add Field tool on a feature class while there's an active table join.

    Has anyone else run into this with 10.1 yet? I'm pretty sure it's a bug, but thought I'd check with the community before filing a report.

  2. #2
    Lance Shipman

    Join Date
    Oct 2009
    Posts
    390
    Points
    113
    Answers Provided
    19


    1

    Default Re: Problem adding fields after a table join using a file geodatabase

    This is a bug (10.1 sp1). I'll enter a bug and post the bug number.
    Lance Shipman
    Geodatabase Product Engineer, File Geodatabase, SQLite
    Esri

  3. 09-26-2012 08:03 AM

    Reason
    Duplicate comment

  4. #3
    Michael Volz
    Join Date
    May 2010
    Posts
    1,356
    Points
    173
    Answers Provided
    21


    0

    Question Re: Problem adding fields after a table join using a file geodatabase

    Lance:

    Does your reply mean that this is a bug that will be fixed by v10.1 sp1?

  5. #4
    James McCarthy
    Join Date
    Dec 2010
    Posts
    11
    Points
    0
    Answers Provided
    0


    0

    Default Re: Problem adding fields after a table join using a file geodatabase

    Hi Lance, thanks for confirming.

    Quote Originally Posted by lshipman View Post
    This is a bug (10.1 sp1). I'll enter a bug and post the bug number.

  6. #5
    Lance Shipman

    Join Date
    Oct 2009
    Posts
    390
    Points
    113
    Answers Provided
    19


    1
    This post is marked as the answer

    Default Re: Problem adding fields after a table join using a file geodatabase

    Quote Originally Posted by lshipman View Post
    This is a bug (10.1 sp1). I'll enter a bug and post the bug number.
    This has been entered as: NIM085216

    We plan on including it in 10.1 sp2. It's to late to be part of 10.1 sp1.
    Lance Shipman
    Geodatabase Product Engineer, File Geodatabase, SQLite
    Esri

  7. #6
    James McCarthy
    Join Date
    Dec 2010
    Posts
    11
    Points
    0
    Answers Provided
    0


    0

    Default Re: Problem adding fields after a table join using a file geodatabase

    Hi Lance,

    Thanks for posting that. Glad to hear it will get fixed eventually...just have to remember to modify my workflows in the meantime.

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts