'Unexpected Error Occurred' when writing to the Microsoft Access database from Silk Test Workbench
If you receive the following error when saving or running a Visual test or a dotNet script in Silk Test Workbench:
- the most likely cause is that you are using the default Microsoft Access Database and that the database is full. To resolve this problem you can try the following actions:-
1. Go to Start | All Programs | Silk | SilkTest | Administration | Database Maintenance
2. Go to File | Open Database | Access
3. Enter the DSN name
4. Go to Tools | Compact Database
This should free up some space and allow you to continue testing for a short time. You can also increase the amount of available space by purging old assets. Please refer to the 'Purging Asset Versions' topic in the Silk Test Workbench help file.
You can slow down the growth of the database by managing the way that the test assets are saved.
1. Go to Tools | Options | Global | Asset Management
2. Change the first two options to suit your method of working. Zero (0) in 'Maximum Asset Versions' means no restriction.
If none of the above suggestions works then your Access database may be within a few Mb of the 2Gb limit which will leave no room in the database for export or compression. In this case please log a new support incident with Micro Focus.
The very best solution is to move away from Microsoft Access onto a supported version of Microsoft SQL or a supported version Oracle as you will hit the Microsoft Access database size limitation again. As an interim solution you can try Microsoft SQL Server Express which will give you a database size of 8Gb while you decide which is the best database solution for your company.
The easiest way to transfer all assets is to use the “Copy” functionality in the Database Maintenance Utility. This allows you to completely copy an Access database to a SQL Server or an Oracle database.