topic Getting 999999 error on Join Field in model? in ModelBuilder Questions

Getting 999999 error on Join Field in model?

lah — Thu, 14 Nov 2019 19:47:28 GMT

Hello!

I am ~trying to~ build a model to snap line events to cartographically realigned routes. It is basically built, but I keep getting hung up on the join field section -- it gives me the dreaded 999999 error. I'm joining a table with a feature class by the unique ID - when I open the feature class after the tool fails, the 3 fields that I am trying to join are there, but the values are all null. Doing the join on the same table and feature class manually, outside of the model, works perfectly fine. Can someone help point me in the right direction here? I can't figure out what I am missing or what the issue is.

Re: Getting 999999 error on Join Field in model?

DanPatterson_Retired — Thu, 14 Nov 2019 21:14:30 GMT

hard to tell from the image, but

Join Field—Data Management toolbox | ArcGIS Desktop

says it would prefer Table View(s) (ie MakeTableView) if the inputs to the tool aren't already layers/tables

Re: Getting 999999 error on Join Field in model?

lah — Thu, 14 Nov 2019 22:17:36 GMT

Thanks for your reply, Dan. I ended up deleting the tool from the model and adding it back in the exact same way - and somehow that worked. Some more ArcPro funkiness, I suppose. On to the next issue! haha

Re: Getting 999999 error on Join Field in model?

DanPatterson_Retired — Thu, 14 Nov 2019 22:40:53 GMT

Can't plan for those issues