UPGRADE (v4.0)TRIAL (v4.0)
Toad Intelligence Central
FREE Toad Data Point Viewer
Toad Data Point v4.0 is now available. Learn what's new in this release
What's better than data sharing, SQL sharing and workflow sharing? Getting it for FREE.Find out how you could get a FREE perpetual TOAD INTELLIGENCE CENTRAL ... $5000 value. Offer valid only until September 30th.
Toad™ Data Point is a multi-platform database query tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare it all, and produce datasets and reports for analysis. It dramatically simplifies data access, writing SQL queries and data preparation – all from a single tool and without needing to be a SQL expert. With Toad, you can:
Use these links below to learn more about the most popular Toad Data Point topics!
We’re seeing many organizations move toward agile methodologies. But with the transition from manual change-and-release management to an automated approach of continuous integration comes new challenges ...
Are you struggling to manage an increasingly complex database environment? If so, you’re not alone. Research shows that data growth is doubling every 18 months. And it’s not...
Is there a limit to the # of active connections permitted when using the "Loop Connections" activity in Toad Data Point v3.6 automation scripts?
I have approximately 73 unique connections which I need to cycle through while executing queries and outputting data in excel.
The script I've created runs like a gem and executes flawlessly for ~440 iterations of the total ~730, but at the 440th iteration the script stops, and completes, without error. The log just says "done" and processing stops.
Anyone know if there's a system limitation at play here?
Hi, I'm experiencing an abnormally high amount of error messages daily on our server machine running TDP 4.0. It's stating that TDP has encountered an error and must close. Interestingly enough though, the logs show that the job is complete and ran successfully, so I believe its happening at the end of the script during shutdown possibly.
Below is the message details that I copy to the clipboard before closing. It seem to be the same one each time TDP shuts down for a task. Has anyone else seen anything like this on their TDP 4.0? It does keep TDP hung up on the task scheduler until I shut down the message and the scheduler thinks there's an error even know there isn't one.
I'd be happy to provide further information, just let me know what you may need.
---------------------------------------------TargetInvocationExceptionException has been thrown by the target of an invocation.
Stack Trace: at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments) at System.Reflection.RuntimeMethodInfo.UnsafeInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture) at System.Delegate.DynamicInvokeImpl(Object args) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
I upgraded TDP to 4.0 yesterday and upgrade my automation scripts. I have several that export data to a tab in Excel files with existing pivot tables. When the scripts ran this morning, the resulting Excel files were corrupt and needed to be repaired. It appears as if Toad collapsed a bunch of rows in the pivot table causing the problem. I was able to fix this by selecting the entire worksheet with the pivot table and double clicking the rows to expand, then saving the repaired file and re-running the automation script. I will document this in better detail, but I just wanted to get something on the forum in case anyone else is having the same problem.