Ask a Question

error in TE

SOLVED
NisHera
Valued Contributor

error in TE

I have a script prefectly run on my local machine with TC.

But if runs on TE at server machine  it gives error........

Capture.PNG

method is something like..

class revers():
..................................
............................................    
  def updatePay_Last(self):
    Delay(12000,'delay for a while')  #--------the error fired here------------
    Log.Message("Just Loggg")
    Log.Message(str(Project.Variables.VariableExists('RunNoCollect')))
    Log.Message( Project.Variables.GetVariableType('RunNoCollect'))
    Log.Message(str(Project.Variables.RunNoCollect.RowCount)+"........."+str(Project.Variables.RunNoCollect.ColumnCount))
    Log.Message( Project.Variables.GetVariableDescription('RunNoCollect'))
    Log.Message(str(Project.Variables.RunNoCollect.Item[1,2])+" is the problem child...........")
    MyVar = Project.Variables.RunNoCollect
    Iterator = MyVar.Iterator
    # Initializes the iterator
    Iterator.Reset()
    # Iterates through the rows 
    while not Iterator.IsEOF():
      # Returns the column name by its index 
      ColName = MyVar.ColumnName[1]
      # Retrieves values and posts them to the log     
      value = Iterator.Value[ColName]
      Log.Message(value)
      # Forwards the iterator to the next row 
      Iterator.Next()
      
    runNo = Project.Variables.RunNoCollect.Item[1,2]
   ..............
  ...................

def main():
  reversOBJ = revers()
.................................
....................................
  reversOBJ.checkYTDValues('Final')
  reversOBJ.updatePay02()
  reversOBJ.checkRun(Project.Variables.RunNoCollect.Item[1,1],'checkRun02')
  reversOBJ.updatePay_Last() # ---------this is where calling happens---------
  reversOBJ.checkRun(Project.Variables.RunNoCollect.Item[1,2],'checkRun03')
  reversOBJ.checkFinal()

but if I run below no problem...

def just_test():
  reversOBJ = revers()
  reversOBJ.updatePay_Last()

any idea is appreciated..

 

1 ACCEPTED SOLUTION

Accepted Solutions
tristaanogre
Community Hero

Re: error in TE

It might not be that it doesn't work in TE but more that the machine running TE may be having problems opening the connection.  I know for a fact that the method you're calling works just fine in both (I use it myself).  So, the next investigation point I'd look at is network connectivity to the SQL server from the remote TE box, possibly firewall or user permission issues or something like that.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available

View solution in original post

8 REPLIES 8
Marsha_R
Community Hero

Re: error in TE

What happens if you run it on TC on the server machine?


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
NisHera
Valued Contributor

Re: error in TE

 

@Marsha_R 

Can not ..!Smiley Sad  it's a vertual machine in AWS 

 

Marsha_R
Community Hero

Re: error in TE

If you can run TE there,  you can run TC there.  


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
tristaanogre
Community Hero

Re: error in TE

My thought:

 

While the error seems to come at that "Delay" call, I suspect, actually, that might be mistaken.  It seems that the error message is indicating that the error is happening on some sort of connection to an application which seems to be indicating the call BEFORE it... somethjing, perhaps, in checkrun.  Have you attempted to add some logging to the checkrun method to see what steps it fails at?


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
NisHera
Valued Contributor

Re: error in TE

@tristaanogre  you are spot on..

The checkrun method call database connection several times.

after a while it could not further create ADO.CreateConnection() object.

all previous connections closed properly after use.

 

Is there any reason ADO.CreateConnection() dosn't  in TE but work in TC?

is there possibility to  ADO.CreateConnection()  intract with DDT.Exceldriver ? 

TC,TE, SQLServer are x64

 

 

tristaanogre
Community Hero

Re: error in TE

It might not be that it doesn't work in TE but more that the machine running TE may be having problems opening the connection.  I know for a fact that the method you're calling works just fine in both (I use it myself).  So, the next investigation point I'd look at is network connectivity to the SQL server from the remote TE box, possibly firewall or user permission issues or something like that.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available

View solution in original post

NisHera
Valued Contributor

Re: error in TE

 

 

sonya_m
Community Manager

Re: error in TE

Thank you everyone for your help!

 

@NisHera I just see a blank message where your yesterday's reply is supposed to be. Could you check this?


Sonya Mihaljova
Community and Education Specialist

cancel
Showing results for 
Search instead for 
Did you mean: