Redefining, Regenerating, and Deleting Tables › Regenerating Tables › Unsuccessful Regenerate

Unsuccessful Regenerate

Possible Reasons

If you receive the message ERROR ON GENERATE, your table did not generate properly. This could be due to several reasons:

• Creating a duplicate key by removing a field from a unique concatenated key
• Adding a unique key
• Lessening the width of a numeric field causing a truncation error when moving the numeric value to its new field

Use Log

At this point, ASF has interrupted the data conversion to write the rows in question to the log. You can look at this log to determine where the problem lies. When the ERROR ON REGENERATE warning displays:

1. Look at the Message screen ([PF6]). The Message screen displays a WARNING ON REGENERATE statement. This means that some of the rows you tried to add were not added to the table.
2. Press [Clear] to return to the Table Definition screen.
3. Finish generating the table ([PF3]) to continue processing where it was interrupted.
4. After the table is generated, look at the log to determine the rows that need to be reentered. (Duplicate rows are written to the log, and cannot be added to the table until they have been corrected.)
5. Reenter the rows, taking care to correct the problems.