Not able run test case with large dataset file

Products

• Service Virtualization

Issue/Introduction

Created a test case by adding excel datasheet with 200 MB file and saved it. When we try to run the test case from ITR or when we close the test case and reopen the test case, workstation hangs and giving an error "Running out of memory"

Environment

All supported DevTest releases.

Cause

When Excel sheet is created with formulas and colors are added in it. Excel file size will be large (200 MB file).

Resolution

Formulas in excel sheet and using as a datasheet in test case will cause an OutofMemory error. Since excel is heavy weighted component, convert the excel file to csv file, so that formulas in excel will be replaced with its actual value and it is light weighted component. And use this csv file as a datasheet in test case to run in ITR properly.