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.
