+ 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
    393
    Points
    117
    Answers Provided
    20


    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,381
    Points
    186
    Answers Provided
    23


    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
    393
    Points
    117
    Answers Provided
    20


    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