1 Reply by aaland (edited by aaland 12-07-2007 13:14:30)

  • aaland
  • New member
  • Offline
  • Registered: 12-07-2007
  • Posts: 2

Re: Operation is not allowed when the object is closed (Dict upgrade)

Hi there.

Part way through the dictionary upgrade, it fails with the above error. The ImortRejects.txt contains the following:
Items rejected by Recorder 6 in data imported at 11:49:11 on 12/07/2007:

Failed to insert NHMSYS0001436012 into TAXON_COMMON_NAME
Database Error Message:
Non-nullable column cannot be updated to Null.
--------------------

The database being used is not the default NBNData, it has a different name, but it is certainly trying to upgrade the correct database. The table also appears to have the same configuration as a live system.

Any pointers would be greatly appreciated.

Using V693 upgrade kit for 6.7.2

Richard

2 Reply by aaland

  • aaland
  • New member
  • Offline
  • Registered: 12-07-2007
  • Posts: 2

Re: Operation is not allowed when the object is closed (Dict upgrade)

For info, despite having the V693 Recorder client on the machine, the RecorderUpdate.exe still has to be run to upgrade the database before the Dictionary Upgrade can take place.

The Dictionary upgrade still complained about the same record, but did complete.

Thanks to Mike Weideli for this gem.