Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

'Unexpected Error Occurred' when writing to the Microsoft Access database from Silk Test Workbench

'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.

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2018-01-04 21:27
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.