You will no longer receive e-mail notifications from this forum.
Log-In to post
Contact Support on Twitter
We have several Toad automations that are scheduled to run at various times throughout the day and are published to Toad Intelligence Central (TIC). These automations "push" reports with information to employees based on the schedule that we have set up. Some of these employees would also like the option to "pull" the reports on an adhoc basis - in other words at a time that is not already scheduled. For security reasons, we don't wish to give Toad access to all employees.
I guess what we are wondering, is it possible to send a set of instructions to the server where Toad Intelligence Central resides that would immediately run an automation that is already installed within TIC? The set of instructions would need to come from an employee that does not have access to Toad.
I figure that with all of the Toad users out there, that this question has already been addressed, but I didn't locate an answer yet on Toad World.
Thanks for your help.
I've published my first script to the server. I noticed that I must use my AD network credentials as the server runs on an account that can't access the network shares.
How does the server handle when users must change their network password? Obviously, making changes to the amount of scripts we run isn't a valid option.
Any help/thoughts on this situation would be appreciated.
I'm trying out TIC for the first time, but I'm running into an issue synchronizing our Active Directory with TIC. Is there a maximum limit on the AD size?
The first time I tried was through the TIC Server Properties > Active Directory (tab) > Sync Now. This ran for quite a few hours before finally failing with a 'Java Heap' message, and nothing else.
Instead of trying to do a full synchronization, I tried to add just specific users by going to Users & Groups > Add from Active Directory. I get a progress bar for a few seconds, and then the message "Failed to load Domain users and groups from Active Directory" and nothing else.
Are there any logs which might provide more information as to why TIC is failing to synchronize and/or load from AD?
I have an Automation script that is published on TIC. It basically uses an "Export activity" to get the export from a SQL query and then run the macro. If I run this autoamtion script from TDP it fires the macro, however if I publish this to TIC it does not fire the macro and just the import can be achieved, I have already "Enabled all Macros" ?
Any help is much appreciated?
P.S I am using Toad 3.7
It appears that anyone who adds themselves to the TIC server can expand the logs. In many of the logs, it is possible to see he SQL query that was used within the script.
I don't want to set the log to anything other than verbose - diagnosing issues is a high priority.
I downloaded and tried to upgrade all 3 pieces of the TIC Server. Toad Intelligence Central and Admin Console upgraded.
The Web Server however, fails and now there is no web access to the server.
I've tried rebooting server.
The error in within a cmd popup window very soon after starting that portion of the install. It say it fails to extract files.
The web server is now saying the 'site can't be reached' so this is a big issue.
Any known issues?
When connecting to the TIC server from TDP today, I got information that I should upgrade to 3.3. I don't see any information about this anywhere on this site.
I have remoted in to our TIC server, and have opened the TIC admin console. I am then attempting to connect to the TIC server, and receive the following error:
Error connecting to the Intelligence Central server "root@localhost", java.util.ConcurrentModificationException
Any ideas on how to fix this?
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?
How to you add a non Active Directory user to server? I don't seem to have that option.
(I had originally posted this on the IBM db2 forum)
I am attempting to join 2 Toad Intelligence Central tables with an excel (97-2003 version) spreadsheet in a query. The query opens with no issues, but when I try to execute it, I encounter the following error: "Missing MySQL ODBC Driver: To execute a Cross-Query that uses a Toad Intelligence Central connection you will need to install a MySQL ODBC Driver on this client."
I am able to execute the same query on the TIC server, so it doesn't appear to be an issue with the TIC server.
When I look at the ODBC Data Source Administrator on my desktop (where the query fails), the drivers tab shows 2 MySQL drivers: MySQL ODBC 5.3 ANSI Driver and MySQL ODBC 5.3 Unicode Driver. I tried uninstalling the MySQL drivers and installing the latest MySQL drivers with the same error.
I have run this query before (a month or so ago) on my desktop with no issues. I am currently using TDP 18.104.22.1686 and TIC 22.214.171.124 with no recent upgrades.
We have many automated jobs set up in TIC. When we look at the script manager in Toad Data Point (or for that matter, when we look at the jobs on the server in TIC), we can see that the jobs completed normally and the last duration time. Our assumption is that the last duration time shows the total elapsed time that the job took to complete, and that the task is finished upon completion. However, the administrators of our IBM iSeries database servers are seeing run times that extend way beyond what we see on our end.
For example, one particular job was scheduled for 5:00 am this morning. According to the script manager, it completed normally as scheduled and the last duration is listed at "00:00:37", so I would assume that the entire job took 37 seconds to complete. However, our database administrators are saying that this job is still running several hours later. The database administrators are seeing similar differences on all of our automated jobs.
Is there anything that could still be happening on these jobs after they are shown as complete?
We are currently using TDP 4.0.1 and TIC 126.96.36.199 on the server where TIC is installed.
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
I am trying import a large .csv file using the import wizard. It always ends up failing to successfully import any rows. When I look at the error log on the import report it actually says the rows were successfully imported but then on the next line it notes that all the imported rows were rolled back. I tried turning on the autocommit feature with the hopes that it would automatically commit without rolling back but that has not work. Can someone please clarify why the TOAD import wizard is rolling back the rows on large files? How can I disable this? Sorry if this has been asked but I didn't see this issue on the forum.
We currently have dozens of automations set up using the "export data wizard" option. Within the export, we are sending data to excel files, and the file path utilizes the universal naming convention (UNC).
We will be replacing our existing server with a new server and a new server address. As a result, all of our UNC path names will be changing.
My question is this - is there an easy way to revise all of the UNC path names within the automations to reflect the new UNC path name?
As an example, let's say the current excel file name receiving the exported data is "\\XYZ-1\Shared\Automation\File1.xlsm". The new name will be "\\ABC-2\Shared\Automation\File1.xlsm". Is it necessary to go into each automation, physically change the path name, and republish the automation, or is there an easier way?
The plan is to replace the server the night of 10/06/16, so a quick response would be ideal.
Thank you for any help you can provide.
I have published an automation to TIC that opens up a MS Access db and copies the contents of a table into an Oracle table. When I manually run it in Toad Data Point Pro it works fine. However, once I published it to TIC I get the following error when the automation test runs:
Any help would be greatly appreciated - thanks!
Just started my TIC installations, and want to use AD for user authentication.
Using the TIC admin console, I try to add users in my domain, but only 3 of the 100+ users are retrieved and are selectable. There are no AD issues with this server.
Any ideas on how to see the whole list of users that are on the domain
I have a couple of question about the TIC web sever functionality
I look forward to any feedback.
Thanks in advance..
Hi, I have been trying to setup some scheduled tasks in TIC and I have noticed some unusual behavior regarding the time I was setting for the task to execute.
My setup is
Now I wanted to check which timezone I should set the the schedule in as TDP stated that all times are according to server time so I was confused if this was the TIC Server or oracle DB Server. So at 11am GMT I set a "One Time" execution for 11.10am GMT. The Script ran with no issues so I assumed that the time was set to the TIC server (GMT) and I configured the task to run at 5am every morning. The next day I checked to see if the task had run but there was no Log of the task. I checked the scheduled task and could see that it said its next runtime was 5am that morning but obviously it didn't run. Now I could not check if the task would run later that day because the TIC server was at 11am and the Oracle DB was 3am and you cannot schedule a task in the past.
So to fix this I changed the TIC Server timezone to match the Oracle DB Time zone and then retested the task at 3.30am (11.30am GMT) and then the task worked correctly?
Can someone confirm that this is normal behavior? How does the "One Time" setup trigger at the TIC server timezone but the daily automation Trigger at the DB timezone?
Hi I have just setup Toad Intelligence Central (TIC) and I was hoping to setup a few automation scripts with it but i seem to be running into an issue with the Data sources setup. When I publish the script ("Created the script on the same machine that is running it) I get a connection error on the TIC side but i can run the script with no issue in TDP.
Intelligence Central Error:
-- 01/04/2016 12:09:38: LANDSTRIPW_MFG_MATERIASACSTR.log: Begin execution script activities-- 01/04/2016 12:09:38: LANDSTRIPW_MFG_MATERIASACSTR.log: Connection description = LANSTRIP_D-- 01/04/2016 12:09:39: LANDSTRIPW_MFG_MATERIASACSTR.log: Connection description was not found in Connection Manager-- 01/04/2016 12:09:39: LANDSTRIPW_MFG_MATERIASACSTR.log: Connection failed-- 01/04/2016 12:09:39: LANDSTRIPW_MFG_MATERIASACSTR.log: Execute_Data_1 - Connection failed
I was thinking that the issue was with missing a Data source in TIC so I tried to create one but I get a TNS error when I try this.
I also created a connection Via ODBC Administrator using the oracle 11g driver which works when testing the connection.
My next step was to create a View, Snapshot and Data set to check if these functions where working which they did and I now noticed that TIC had created a new data source automatically.
But when I tried to populate the user and Password for this Connecting I got the same error? But even more confusing was when I right clicked on Mappable objects under this data source it asked me for connection credentials which when I entered them from here it worked?
It seems to me that when you create a connection to Oracle, when the system is testing the connection before saving, it does not use the credentials provided and then fails to save the connection. The connection that was auto created has the same problem but you can right click the connection and select "enter personal authentication" and this works.
I would appreciate any help with resolving this issue