Forum Discussion

muralidharan18's avatar
muralidharan18
Occasional Contributor
9 years ago

Project Variables

Hi, I am automating a project where I need to use more than 100 project variables.  While automating exactly after 55th project variable it throws jscript Runtime error.  Whats the maximum number of...
  • tristaanogre's avatar
    tristaanogre
    9 years ago

    That line is probably correct in how it is implemented.  However, as mentioned above, how the data is retrieved is a different story. While you're bringing things in via Excel, IIRC, it's still using the Microsoft Jet engine behind the seens and there are a maximum number of connections that can be opened.

    Can you give us the full code for the whole loop or even the code unit where the Excel sheet is accessed initially? It sounds like you are re-opening the data connection multiple times which could result in the problems you're having.

    You also mention "in each script". so, it sounds like you're calling that assign code in multiple places in multiple tests. I'm guessing that, in each script, you're opening a connection to the excel sheet and then making the assignment. Somehow, you need to make sure you close your data connection when you're done with it. So, again, having the code where you're making the initial connection to the Excel sheet is going to be helpful.