When a 'Publish' fails - Where to look for the issue?

peter.d.maxwell · February 22, 2017, 1:28pm

OK - last one for today…

When I have published a new script, and it runs, sometimes it just clocks until I have to cancel from TDP. I tried looking for a log file to determine what the issue is.

There is non on local machine for TDP. Is there something I can check on server that will tell me where the script was at when it started clocking/failed?

Debbie_Peabody · February 22, 2017, 2:50pm

i would try this.

When you publish the script uncheck the Test at bottom. This will publish the script but not run.
Then open up the manage script window and manually run the script. Be patient it takes time to start a copy of TDP on the TIC server and run.
When done you can look at the log tab and see the output.

Other things you can try are:

Adding email to begin, middle and end of script to tell you if it is reaching a specific point.
In the info tab of the script you published, you can see the path that it will run the script. If you have remote acccess to the TIC server you can go to that path and look for the log file in the Automation dir, It opens and writes to the log as it goes along.

If these things do not solve your issues, please open a support case and as to have a subcase sent to me.

peter.d.maxwell · February 22, 2017, 4:23pm

Thanks again Debbie.

From your answer, it appears that TIC doesn’t run the actual script, but TDP does?

I published from TDP 3.7. 3.7 seems to me to be the most stable for all the different things I use it for. Seems the TIC server installed TDP 4.0. Can there be issues with them being different? Can I also install 3.7 along with 4.0? I know on my desktop I run 3 versions. I know that the location of the log wouldn’t be the same for those two different versions. Also, the server is 2012 and doesn’t seem to have same file structure of my Win7 machine the script was developed on.

Remember a few years back when TDP was scrambling my Excel spreadsheets? It seems a similar problem I’ve noticed. After stopping the publish run, I find that the excel spreadsheet on the server is missing my macros sheet as well as a pivot sheet.

I’d love to get this server running and off load some of our teams scripts, but can’t risk it until everything is worked out.

Pete

Debbie_Peabody · February 27, 2017, 7:12pm

When using Toad Intelligence Central to run automation scripts it can only use one version. By default it will try to use the latest version. But you can force it to use a different version by setting a value in an ini file.

Running a macros is best done by the TDP Beta that we have posted. I would suggest you try using that Beta and then if there are any more issue open up a support ticket. Here we can work with you one on one to get this all up and running.

peter.d.maxwell · February 28, 2017, 7:31am

Thanks Debbie.

I HIGHLY suggest that there be a way to select the version you want to run and publish to during the publish process. There is far too much importance at the server level than at the desktop level. Perhaps a dropdown with the currently installed version. Default to the version that matches the user’s desktop if there is a match. Highest version if not.

I’ve gone through a lot of pain on my desktop version upgrading. I’m not willing to do that to a server with 7 or 8 people using.

Also, do I use up a license from our pool of TDP licenses or does the TDP version(s) on the TIC server know that it is running on the TIC server and consume it’s license for its own?

Thanks,

Pete

From: Debbie Peabody [mailto:bounce-Debbie_Peabody@toadworld.com]

Sent: Monday, February 27, 2017 9:13 PM

To: toadintelligencecentral@toadworld.com

Subject: RE: [Toad Intelligence Central - General Discussion] When a ‘Publish’ fails - Where to look for the issue?