topic Re: Object Reference not set to an instance of an object in Transportation Questions

Object Reference not set to an instance of an object

JohnDye — Fri, 17 Aug 2012 13:50:38 GMT

I'm trying to batch a trade area creation process. We have over a thousand of them to do but I'm just testing with 5 tables right now. In any case, I've created the script but it keeps erroring out with the error:

An unhandled exception has occured in Business Analyst. Please contact your system Administrator.

Object reference not set to an instance of an object.

I've embeded a copy of the script and the error I'm receiving. I can't click on details because I have to cancel the script first...which it won't cancel so I have to shut it down via the Task Manager which closes the entire ArcGIS application I'm running the script tool from.

[ATTACH=CONFIG]17039[/ATTACH]
[ATTACH=CONFIG]17041[/ATTACH]

Re: Object Reference not set to an instance of an object

MikeHunter — Sun, 19 Aug 2012 02:26:36 GMT

I'm not that familiar with the functions you are using, but right off the bat I notice that the name "Table" is unreferenced in the line with ValidateTableName. That's supposed to be a string denoting the name of the table in the given workspace. The name Table at this point in your script does not point to anything.

good luck,
Mike

Re: Object Reference not set to an instance of an object

Anonymous User — Fri, 24 Aug 2012 12:06:47 GMT

Original User: johnmdye

Thanks Mahunter243,
ESRI Technical Support pointed out the same thing. I moved the OutFC reference to be inside the loop so that it can reference the table created by the for loop. However, that didn't change anything. I still received the same error. Here's a copy of the updated script and the persisting error. I even tried just completely removing the arcpy.ValidateTableName function and just using the table name by naming the output feature class as <Table + "_TradeArea"> but still received the object not referenced error.

[ATTACH=CONFIG]17211[/ATTACH]
[ATTACH=CONFIG]17213[/ATTACH]

Re: Object Reference not set to an instance of an object

JohnDye — Wed, 12 Sep 2012 14:52:02 GMT

Update: There was an issue with the table schema, not the code.