digmapper

Make one field equal another. (CalculateField_management)

Discussion created by digmapper on Sep 29, 2011
I have a simple python script that use to work but now I can't seem to get it to work. I just want a field in my parcels (attibute table) to equal a field in our oracle database by joining them. Here is the process I used:

# Process: Make Query Table
arcpy.MakeQueryTable_management(OwnerParcel, lyrView, "ADD_VIRTUAL_KEY_FIELD", "", "", "")

# Process: Make Query Table (2)
arcpy.MakeQueryTable_management(dbo_OR_XREF, tblView, "ADD_VIRTUAL_KEY_FIELD", "", "", "")

# Process: Add Join
arcpy.AddJoin_management(lyrView, "GEOCODE", tblView, "GEO_CODE", "KEEP_ALL")

# Process: Calculate Field
arcpy.CalculateField_management(lyrView__3_, "lyrView.TAX_ID", "[TAXID]", "VB", "")

When I run this in Model Builder, it gets to the Calculate Field step, and seems to start calculating but than I get this error:

ERROR 999999: Error executing function.
Invalid object name 'GDB_Release'.
Cancelled function
(Calculate Field) aborted by User.

I didn't abort anything so I am a little confused by this message. I think the logic is sound because, like I said, it worked before. Any suggestions would be appreciated.

Outcomes