Toad Intelligence Central Community

Toad Intelligence Central Forum

Rod
Follow / 5 Dec 2017 at 10:11pm / Toad Intelligence Central
Latest post by on 11 Dec 2017 at 6:13am

Hi, I have a question: Is there a way to install TIC 4.3. without...

Expand content
Is there a way to install TIC 4.3. without having IIS 8.0 in the process ?

Is there a way to install TIC 4.3. without having  IIS 8.0 in the process ?

Unanswered 118 7 / Create an account to join the discussion.
ArjenLissenberg
Follow / 16 Nov 2017 at 9:06pm / Toad Intelligence Central
Latest post by on 7 Dec 2017 at 8:52am

Error: You have an error in your SQL syntax;' when contacting...

Expand content
When using a View in TIC as datasource in a Tableau workbook I constantly get the error that: Error: You 'have an error in your SQL syntax; check the manual that corresponds to your MySQL server...

When using a View in TIC as datasource in a Tableau workbook I constantly get the error that: 

Error: You 'have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (SGBSTDN.SGBSTDN_MAJR_CODE_1 = STVMAJR1.STVMAJR_CODE(+))' at line 84 

This seems to suggest that the MySQL server has trouble with the ANSI code for left outer joins (it's the '+' of the outer join syntax that the error indicates. Removing the '(+)' from the SQL simple shifts the error to the next '(+)' in that statement.

Meanwhile the dataset in the Tableau workbook seems to perform as normal. 

353 8 / Create an account to join the discussion.
ArjenLissenberg
Follow / 2 Nov 2017 at 5:15pm / Toad Intelligence Central
Latest post by on 29 Nov 2017 at 4:37am

Is it possible to use "User" information as parameter of...

Expand content
Is there a way to gain access to TIC User information to use in an automation. For instance I would like to use 1 automation to return different results (using different run-time parameters for instance...

Is there a way to gain access to TIC User information to use in an automation. For instance I would like to use 1 automation to return different results (using different run-time parameters for instance) based on the TIC User (or TIC Group the User belongs to) that is executing the automation in TIC. This would mean the difference between deploying 80 different automations shared with 80 different Users/Groups or 1 automation used by all. Basically, can I pass row-level security in an automation?

343 4 / Create an account to join the discussion.
ArjenLissenberg
Follow / 10 Nov 2017 at 9:14pm / Toad Intelligence Central
Latest post by on 27 Nov 2017 at 6:59pm

Find_Replace on TIC

Expand content
Is there a way to use the find and replace element of an automation on an artifact on TIC? Or should I design that automation on the TDP instance that is on the computer/server?

Is there a way to use the find and replace element of an automation on an artifact on TIC? Or should I design that automation on the TDP instance that is on the computer/server?

344 10 / Create an account to join the discussion.
ArjenLissenberg
Follow / 8 Nov 2017 at 9:46pm / Toad Intelligence Central
Latest post by on 9 Nov 2017 at 4:26pm

Using a view to query another view: SELECT command denied to

Expand content
I'm trying to set up a view for someone that will Query another view in TIC. The second view queries the first view as a table with some extra filters/limits and allowing some parameters. I have not...

I'm trying to set up a view for someone that will Query another view in TIC. The second view queries the first view as a table with some extra filters/limits and allowing some parameters. I have not shared the first view with other users but did share my database credentials with users of that view, for the second view I allow the user I share that view with to use my credentials to access the first view.

I want to emulate a type of row level security here on a view, that is also used for a mix of other reports. The results is however an error:


Error Cannot download data for view TIC_Demo.testview. SELECT command denied to user 'sfas'@'localhost' for table 'by_major_using_view'.

What did I miss here? logically the shared credentials in both views should allow this second view to work for whomever I share it with?

241 1 / Create an account to join the discussion.
peter.d.maxwell
Follow / 19 Sep 2017 at 9:00pm / Toad Intelligence Central
Latest post by on 29 Sep 2017 at 5:26pm

TIC Server Daily Report

Expand content
How can I get an emailed report of all scripts each day? I've been having to view manually and would like to save some time. Thanks Pete

How can I get an emailed report of all scripts each day?  I've been having to view manually and would like to save some time.

Thanks

Pete

464 6 / Create an account to join the discussion.
jraguse
Follow / 17 Nov 2015 at 5:48pm / Toad Intelligence Central
Latest post by on 24 Aug 2017 at 8:21pm

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?

1439 5 / Create an account to join the discussion.
jraguse
Follow / 12 Feb 2016 at 4:50pm / Toad Intelligence Central
Latest post by on 21 Jul 2017 at 2:45am

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 1973 9 / Create an account to join the discussion.
peter.d.maxwell
Follow / 22 Feb 2017 at 6:48pm / Toad Intelligence Central
Latest post by on 20 Jul 2017 at 9:02pm

New to Toad Intelligence Central - User Admin

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

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.

Pete

960 6 / Create an account to join the discussion.
N.B.
Follow / 29 Jun 2017 at 9:30pm / Toad Intelligence Central
Latest post by on 4 Jul 2017 at 2:19am

[TIC 3.3.0.212 CE] Active Directory Issues

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

Greetings,

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?

651 4 / Create an account to join the discussion.
Vaibhav Gupta
Follow / 5 May 2017 at 8:07am / Toad Intelligence Central
Latest post by on 14 Jun 2017 at 6:54am

Export template not firing Macro when published on TIC, working fine...

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

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

Unanswered 861 6 / Create an account to join the discussion.
peter.d.maxwell
Follow / 11 May 2017 at 4:05pm / Toad Intelligence Central
Latest post by on 19 May 2017 at 7:44pm

TIC Server / Script Logs

Expand content
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. Is it possible to set only...

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.

  • Is it possible to set only certain users to be able to see the logs?
  • Is there a way to hide the SQL from the log?
  • Is there a setting to suppress the log in web page and keep the full log for diagnosing issues?

I don't want to set the log to anything other than verbose - diagnosing issues is a high priority.

Pete

908 6 / Create an account to join the discussion.
peter.d.maxwell
Follow / 9 May 2017 at 4:35pm / Toad Intelligence Central
Latest post by on 11 May 2017 at 8:30am

TIC Upgrade Error

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

Pete Maxwell

1072 8 / Create an account to join the discussion.
peter.d.maxwell
Follow / 13 Apr 2017 at 4:18pm / Toad Intelligence Central
Latest post by on 13 Apr 2017 at 7:13pm

Is TIC 3.3 Available?

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

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.

604 3 / Create an account to join the discussion.
jraguse
Follow / 9 Mar 2017 at 9:05pm / Toad Intelligence Central
Latest post by on 13 Mar 2017 at 3:21am

Receive error when trying to connect to TIC server.

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

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?

Thanks for your help.

Jeff.

Unanswered 844 3 / Create an account to join the discussion.
peter.d.maxwell
Follow / 22 Feb 2017 at 9:28pm / Toad Intelligence Central
Latest post by on 4 Mar 2017 at 1:37am

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

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

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?

831 6 / Create an account to join the discussion.
peter.d.maxwell
Follow / 22 Feb 2017 at 8:20pm / Toad Intelligence Central
Latest post by on 22 Feb 2017 at 9:24pm

How to you add a non Active Directory user?

Expand content
How to you add a non Active Directory user to server? I don't seem to have that option.

How to you add a non Active Directory user to server?  I don't seem to have that option.

711 2 / 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?

1236 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 1060 1 / Create an account to join the discussion.
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

666 0 / Create an account to join the discussion.