cancel
Showing results for 
Search instead for 
Did you mean: 

error in TE

SOLVED
Highlighted
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
Highlighted
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
Highlighted
Community Hero

Re: error in TE

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

Highlighted
Valued Contributor

Re: error in TE

 

@Marsha_R 

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

 

Highlighted
Community Hero

Re: error in TE

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

Highlighted
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
Highlighted
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

 

 

Highlighted
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

Highlighted
Valued Contributor

Re: error in TE

 

 

Highlighted
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

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
New Here?
Join us and watch the welcome video:
Read the Latest News
JuneSCNJ
Top Kudoed Authors