Joins do not work in Modelbuilder 10

TomMagdaleno

So far I have been working on fixing models almost exclusively for a week!  I have models with multiple joins and calculations and ever since we upgraded to 10 they do not work.  I have a "Remove Join" and then a second Join, but I get errors saying that my inputs are not current.  When I do a validation it will tell me so and so table is already joined.  So I have to exit out, delete the joined table then open the model again to validate the data.  Now the data before the join won???t work because it thinks the ???field name does not exist??? because the table is no longer joined! 

MODELBUILDER USED TO BE SMARTER THAN THIS!

Now I have to break up my models into several models and export out intermediate data so I can work with it.  This is what I was told to do by tech support.  This is driving me nuts!

Also, ???Make Table View??? changes every time the model is validated.  If I have only a few columns checked in the table view, then run a validate it will recheck all the columns and screw up my output.  Tech support tells me to not use .dbf tables, to put everything in a geodatabase, do permanent joins and export out intermediate data.  This is getting to be WAY more steps then just doing a few simple joins and calculates in ArcMap.  Is anyone else dealing with this crap?

BillBranson

That's quite unfair of a response. I can assume you did not read this thread nor do you work much outside of the ESRI environment in databases.

Jim W,

We all feel the pain. Richard Fairhurst has drunk the kool-aid, and can one expect anything different? That's who pays him for shilling on here.

The Root Cause is how ESRI has chosen to approach DB Management. For some reason(s), back before ArcGIS 8, ESRI has taken their own approach to DB structure and rules of interaction. Not only that, these "rules" don't seem to persist in precisely the same approach across major software 'updates'.

Like any large organization, responsibility for keeping it together isn't hanging on any one person or steering committee and therefore it breaks a lot when it clearly shouldn't.

Add to that the fact that ESRI is the only player (like Auto CAD in their field) and you get a geometric increase in inertia to make sane and timely changes. Being the only game in town makes them immune to reasonable requests from their user base.

Also, I think since looking at the 10.2 stuff it seems that ESRI is focused on monetizing their business in every way possible. I can only assume this is so because people are using their product less and less and so they need to squeeze more $$ out of every user. That focus drops this kind of software updates/fixes from �??low priority�?� to �??No priority�?�.

Now every answer will be the same: <chipper voice>"You can do this fast, easy, super awesome thing in 10.2!!! Just log into your account at ArcGIS Online</chipper voice>

And all ArcGIS users everywhere say? Ughh!