kaiiii
7 years agoRegular Contributor
Too many fields defined
Call Project.Variables.Add_New_Payee_MAT_Inputs.Reset In the above line i am facing this error. What is the reason behind it and how can i solve it
Hi,
Please send a screenshot demonstrating the variable type and which data it stores. Is it an Excel sheet?
We are also facing the same issue. When we use our excel with .xls.
When we use .xlsx we are not facing the issue but it is slow on loading the excel. that is the reson we moved to .xls.
Any solution for this?
This thread is 2 years old so it's possible that circumstances may have changed.
What version of TC are you using? What's in the excel sheet? How are you attempting to use the variable?
Thanks for your reply.
We have moved to version 14.0. SO the Too many fields error is fixed. But still getting Access violation error. when we get this when we close the test complete and reopen it works fine. Is there any fix for this? just closing and reopening is working fine. we are not touching any of our VB script code. we use.xls verision to store our OR and it is keyword driven framework.
Quick question re. how often you access the xls file to read data. There is the limit to the amount of concurrent connections allowed and if you don't always close your connection at some point you may get an access violation. - someone else may have the correct number of connectins allowed... After you have read from the xls file, do you always close the connection ?
if(ExcelObj!= null) { ExcelObj.Workbooks.Close; ExcelObj=null; }