BV update 2018 - Data corruption
- Take backup of all the data before starting BV update 2018.
- Do the steps according to the Kb article 18257 for the files ORDADDRS.BTR, SLSORD.BTR and SLSORDD.BTR
1. Retrieve File Records to Sequential File
- Click Start, All Programs, Pervasive, Pervasive.SQL, Other Utilities, Maintenance.
- Click Data, Save.
- In the From MicroKernel File box, select damaged file (for example C:\BusinessVision\Data\Gl.btr).
- In the To Sequential File box, specify a filename for the sequence file that will be created.(for example C:\BusinessVision\Data\Gl.seq).
- Click Execute.
- Click Close.
2. Create Blank Data File
- Click Options, Show Information Editor.
- Click Load Information.
- Select the damaged file (for example C:\BusinessVision\Data\Gl.btr), and then click Open.
- Click Create File....
- In the File Name box, specify a name for the new file that will be created (for example C:\BusinessVision\Data\Glnew.btr). Do not use the same filename.
- Click OK.
- Click OK to clear message.
- Close the File Information Editor window.
3. Load Records Into Blank Data File
- Click Data, Load.
- In the From Sequential File box, select the file created in section 1 (for example C:\BusinessVision\Data\Gl.seq).
- In the To MicroKernel File box, select the file created is section 2 (for example C:\BusinessVision\Data\Glnew.btr).
- Click Execute.
- Click Close.
- Close the Maintenance Utility.
4. Rename Files
- Browse your data folder. Rename the damaged file to something else (for example C:\BusinessVision\Data\Gl.btr to C:\BusinessVision\Data\Glbad.btr).
- Rename the file create in section 2 to the proper name (for example C:\BusinessVision\Glnew.btr to C:\BusinessVision\Data\Gl.btr).
3. Install BV 2018. Open the backup company first and update its data to 2018.
4. Copy the ORDADDRS..BTR, SLSORD.BTR and SLSORDD.BTR from backup data to the live data.
5. Verify if user can change order details.