Description: In erwin Data Modeler, why when I try to import Bulk Editor changes from a CSV file, which was changed in Microsoft Excel, I am getting the error "An unexpected and serious condition occurred"? I click to import the CSV file I had exported from the Bulk Editor and I am getting the error for same rows in the file.
Solution: Bulk Editor is only for changing the values of objects, but not adding new objects. For example, you cannot add a new Table, Column Index, Domain or Datatype. Any object that has a unique erwin internal ID.
You can change the Domain a Column is assigned to, as long as the Domain exists and would be true for changing datatypes for a Column, changing what Index is attached to a Table and etc. types of changes.
What you can’t do is add something new that does not already exist in the model. Doing so will cause that error "An unexpected and serious condition occurred".
In summary, be careful what is changed in the CSV file in Microsoft Excel, before you try to import back in to erwin, to prevent the error form occurring, since any new value or object will cause the error.