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.

muralidharan18's avatar
muralidharan18
Occasional Contributor

Im using the project variables like this in each script.  

Keys(Project.Variables.Sheet1.Value("Name"));

 

While executing the whole project suite I'm getting Jscript Error(Unspecified Error).  The Error is directly pointing to the line where I'm fetching data from excel sheet.  While executing separately each file runs perfectly without any error. While executing in whole project suite repeatedly its throwing the error after 56 Project variable (all 56 are in different scripts).

 

After 56 different project variables I repeated the same files which were executed first, these files run without any error.  Only the files which are fetching new values are throwing error.

 

Can any one help me?

tristaanogre's avatar
tristaanogre
Esteemed Contributor
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.

  • muralidharan18's avatar
    muralidharan18
    Occasional Contributor
    9 years ago

    As you said I opened mulitple connections but I didnt close it.

     

    Now I closed the connection like

     

    Project.Variables.Sheet1.Disconnect();

     

    Now its working

    Thank you for your information.