Toad Intelligence Central Forum - Toad Intelligence Central - Toad World

Toad Intelligence Central Community

Toad Intelligence Central Forum

Danny Torres
Follow / 1 Nov 2016 at 1:30pm / Toad Intelligence Central

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
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

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

211 0 / Create an account to join the discussion.
jraguse
Follow / 10 Jan 2017 at 10:06pm / Toad Intelligence Central
Latest post by on 12 Jan 2017 at 3:35pm

Missing MySQL ODBC Driver

Expand content
(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,...

(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 4.0.0.396 and TIC 3.1.0.22 with no recent upgrades.


Any ideas?

116 9 / Create an account to join the discussion.
jraguse
Follow / 1 Nov 2016 at 4:13pm / Toad Intelligence Central
Latest post by on 2 Nov 2016 at 10:55am

TIC Run Times

Expand content
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...

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 3.1.0.22 on the server where TIC is installed.

Unanswered 334 1 / Create an account to join the discussion.
tgothmann
Follow / 6 Oct 2016 at 11:33pm / Toad Intelligence Central
Latest post by on 14 Oct 2016 at 7:49am

TOAD Import Wizard: "Imported rows were rolled back."

Expand content
Greetings, 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...

Greetings,

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.

Thanks,

Tyler

551 7 / Create an account to join the discussion.
jraguse
Follow / 5 Oct 2016 at 10:48pm / Toad Intelligence Central
Latest post by on 10 Oct 2016 at 6:16pm

TIC Migration to a new server

Expand content
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...

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.

551 6 / Create an account to join the discussion.
bigsky155
Follow / 26 Aug 2016 at 6:07pm / Toad Intelligence Central
Latest post by on 26 Aug 2016 at 6:35pm

TIC Automation error using MS Access

Expand content
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...

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!

Unanswered 421 1 / Create an account to join the discussion.
geralds34
Follow / 22 Aug 2016 at 8:48pm / Toad Intelligence Central
Latest post by on 25 Aug 2016 at 12:56pm

Active Directory Users

Expand content
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...

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

735 8 / Create an account to join the discussion.
Tr3Bird
Follow / 11 May 2016 at 5:15pm / Toad Intelligence Central
Latest post by on 11 May 2016 at 8:13pm

TIC Web server questions

Expand content
Hi, I have a couple of question about the TIC web sever functionality When using the Web Interface and I want to download a Data-set or Table View and I click on the button "Prepare Download"...

Hi,

I have a couple of question about the TIC web sever functionality

  1. When using the Web Interface and I want to download a Data-set or Table View and I click on the button "Prepare Download" nothing seems to happen. I do not get a popup message or any flag or visual Cue to say if the data is being prepared or ready. If it is a small results set I can re-click the  "Prepare Download"  button and if the data is ready (yet no completed notification was or is shown)  it just starts downloading. if on the other hand it is a large data set of results and i re-click the "prepare download" button nothing seems to happen and if i repeatedly click it 7-8 times I then get a message say "you data is being prepared and you will be notified when it is ready" but I never get notified? I have tried both chrome and IE and disabled pop-ups but i do not received any information after clicking the button.

  2. Is there a way to trigger automation scripts from the web interface. Would be useful if you could trigger a script that either fed a data set or email a results set to the user.

I look forward to any feedback.

Thanks in advance..

T.

Unanswered 559 1 / Create an account to join the discussion.
Tr3Bird
Follow / 7 Apr 2016 at 12:15pm / Toad Intelligence Central
Latest post by on 8 Apr 2016 at 7:34pm

TIC Scheduling and Time Zones

Expand content
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 Client: WIN7 Laptop (TZ...

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

  1. Client: WIN7 Laptop (TZ GMT) running TDP 3.8
  2. TIC Server: WIN7 VM on Server (TZ GMT) Running TIC 2.7
  3. DB: Oracle DB (TZ UTC - 7). 

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? 

R,

Trevor

681 5 / Create an account to join the discussion.
Tr3Bird
Follow / 1 Apr 2016 at 3:24pm / Toad Intelligence Central
Latest post by on 8 Apr 2016 at 1:24am

Issue Creating Data Sources in Intelligence central

Expand content
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...

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 

R,

Trevor

Answered 872 6 / Create an account to join the discussion.
EE
Follow / 28 Mar 2016 at 2:53pm / Toad Intelligence Central
Latest post by on 1 Apr 2016 at 3:04pm

TIC

Expand content
when i share reports or diagram from Toad Data Point to Toad intelligence central when user use web browser to connect to Toad intelligence central, if he didn't have Toad data point or toad installed...

when i share reports or diagram from Toad Data Point to Toad intelligence central

when user use web browser to connect to Toad intelligence central, if he didn't have Toad data point or toad installed on his machine, How he will view reports, diagram, visulaize,.....from TIC

453 1 / Create an account to join the discussion.
jraguse
Follow / 14 Mar 2016 at 2:03pm / Toad Intelligence Central
Latest post by on 1 Apr 2016 at 2:58pm

Our Toad Intelligence Central jobs are running an hour late after...

Expand content
Our scheduled jobs on TIC are running an hour late yesterday and today. The switch to DST occurred early Sunday (3/13/16) morning, and our scheduled jobs are continuing to run on standard time. We are...

Our scheduled jobs on TIC are running an hour late yesterday and today.  The switch to DST occurred early Sunday (3/13/16) morning, and our scheduled jobs are continuing to run on standard time.  We are currently using TIC 2.7.0.134.  I also have a service ticket set up for this issue.  

533 5 / Create an account to join the discussion.
jraguse
Follow / 12 Feb 2016 at 4:50pm / Toad Intelligence Central
Latest post by on 18 Feb 2016 at 5:33pm

Is it possible to call a Toad automation from outside of Toad?

Expand content
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...

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.

Unanswered 584 2 / Create an account to join the discussion.
EE
Follow / 18 Jan 2016 at 8:10pm / Toad Intelligence Central
Latest post by on 25 Jan 2016 at 4:35pm

E-

Expand content
Hi I have oracle E-business, please i need to know the benefits from Toad intelligence central in my work? if this tool will help me in analysis my data or what? I didn't find any screenshot for...

Hi

I have oracle E-business, please i need to know the benefits from Toad intelligence central in my work? if this tool will help me in analysis my data or what? 

I didn't find any screenshot for this tool 

Thanks

688 6 / Create an account to join the discussion.
ss
Follow / 18 Jan 2016 at 11:38am / Toad Intelligence Central
Latest post by on 19 Jan 2016 at 6:42am

Error

Expand content
Hello , When i try to install Toad Intelligence central, appear error that (Toadintelligencecentral) failed to start. Verify that you have sufficient privilege to start system servies and i using local...

Hello ,

When i try to install Toad Intelligence central, appear error that (Toadintelligencecentral) failed to start. Verify that you have sufficient privilege to start system servies

and i using local administrator how i can solve this issue to complete the setup

Thanks

496 1 / Create an account to join the discussion.
bigsky155
Follow / 27 Nov 2015 at 10:02pm / Toad Intelligence Central
Latest post by on 30 Nov 2015 at 4:29pm

How to publish an automation script onto Toad Intelligence Central...

Expand content
Im new to Toad Intelligence Server....just trying to figure out how I can schedule automated jobs that I have built on Toad Data Point and publish and schedule them onto Toad Intelligence Central. We used...

Im new to Toad Intelligence Server....just trying to figure out how I can schedule automated jobs that I have built on Toad Data Point and publish and schedule them onto Toad Intelligence Central.  We used Toad Data Point 3.5.0 Base edition. Everything I have seen shows a Publish button on the bottom tray of an automation script in TD.... Im not seeing that option. Is this possible in the TD base edition Im using?

Unanswered 767 1 / Create an account to join the discussion.
jraguse
Follow / 4 Nov 2015 at 10:33pm / Toad Intelligence Central
Latest post by on 27 Nov 2015 at 4:15pm

Toad Intelligence Central - Scheduling Options

Expand content
When publishing an automation script to TIC, is there a way to schedule the script to run once every 2 hours from 9:45 am to 1:45 pm (3 times each weekday)? I can set up this type of automation schedule...

When publishing an automation script to TIC, is there a way to schedule the script to run once every 2 hours from 9:45 am to 1:45 pm (3 times each weekday)?

I can set up this type of automation schedule in toad data point on my desktop, but haven't located a way to do this kind of automation schedule within TIC.  It doesn't appear that TIC uses the Task Scheduler to set up schedules - is there some other software that I can work with to set up these kinds of schedules?

There are other scheduling options that I would like to utilize if I could find additional options under TIC.

1790 10 / Create an account to join the discussion.
jraguse
Follow / 17 Nov 2015 at 5:48pm / Toad Intelligence Central
Latest post by on 20 Nov 2015 at 1:47pm

Intelligence Central automation hangs after populating Excel file...

Expand content
I have several automations published on TIC currently. Most follow the process of running one or more queries, export the data to a single Excel file, then call an Excel macro within that file which further...

I have several automations published on TIC currently.  Most follow the process of running one or more queries, export the data to a single Excel file, then call an Excel macro within that file which further summarizes the data and sends out an email (using CDO messaging).  To date, all of the other automations of this type have worked successfully.

This latest one, however, starts the update process by running three queries, and exporting the data to the Excel file.  This works fine.  Then the process does not move forward - the excel file is left open indefinitely (I have to end the Excel process with the Task Manager) - it does not appear that the macro is ever initiated, as even the first statement is not executed.

This same automation has worked fine many times when I run it on my desktop, but operates as noted above when published to TIC.

Any ideas?

723 4 / Create an account to join the discussion.
Trevor Tubbs
Follow / 17 Nov 2015 at 2:43pm / Toad Intelligence Central
Latest post by on 19 Nov 2015 at 2:28am

Using Toad Intelligence Central Web Server

Expand content
From the description in the Toad Intelligence Central Server Installer it sounded like Toad Intelligence Central Web Server could be used to interact with TIC and possibly do some administration as well...

From the description in the Toad Intelligence Central Server Installer it sounded like Toad Intelligence Central Web Server could be used to interact with TIC and possibly do some administration as well.  I have been unable to find any documentation on how to use this tool.  When I browse to it at http://{server}/ I am redirected to http://{server}/ToadOracle/CodeAnalysis/#/.  The information on the page talks about running analysis on Oracle databases.  I don't have any Oracle databases.  Where can I find the documentation for this tool?  Is this tool only designed for use with Oracle databases?  Is there another path in this application that will provide me with additional options?

Answered 689 1 / Create an account to join the discussion.
jraguse
Follow / 9 Nov 2015 at 2:53pm / Toad Intelligence Central
Latest post by on 11 Nov 2015 at 6:24am

Toad Intelligence Central - Automation script by active directory...

Expand content
I am attempting to publish an automation script on TIC. The script contains 2 "refresh snapshot" activities and 1 "execute script" activity. I then get the message "We do not currently...

I am attempting to publish an automation script on TIC.  The script contains 2 "refresh snapshot" activities and 1 "execute script" activity.  I then get the message "We do not currently support publishing automation scripts that contain connections made by Active Directory users.  Please modify or remove the following connections before publishing:"  The connection that is listed is my connection to TIC.  I have tried changing all of the connections that I am allowed to change to a different connection, but continue to get the same error message.  Any ideas as to how to solve this?

675 3 / Create an account to join the discussion.