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.