Fixing the TRANLINE_INSERT Error 39

Occasionally, Artisan data is corrupted, often due to power outages or a sudden closing of Artisan while it's working. To fix this error execute the following steps in order.

1.) Invoke the magic command line (Alt-F10).

Run the following commands:

SELECT 0

USE TRANLINE

SET FILTER TO lineno > 99999

browse noedit

With the data being displayed, find the TRANSEQ number and copy it to your clipboard for later use.

From the magic command line execute the following commands:

SET ORDER TO lineno

SET FILTER TO TRANSEQ = 1000744816

BROWSE

Now its time to correct this data. The ordering of the line numbers, and any corrupted or missing line numbers need to be fixed. Any entries containing stars need to be replaced with numbers in the sequence.

Done.