Hi,
We are running TIC 5.1.2.18 and users are integrated with Windows security.
Users are now switching the windows domain. As a result, we need to add their new user again. That's fine.
The issue is, all their objects, mostly automation scripts become orphan and invisible, but are still running.
Using TDP 5.1, when I connect to TIC using root user (which should have all the rights), I can't find these automation scripts on any of the data explorer sections. And I don't see any option to display archived or hidden.
Since users are still getting their files exported, there must be a way to find these scripts and reassign them to new user.
Using TIC web site, there is an option to search on objects, and transfer ownership. But again, these orphan scripts are not there.
Thanks for your help!
Hi,
Did you check under the Server/Health Check Dashboard/Object Owner Transfer?
Yes I tried but nothing show up in this screen.
All objects attached to old user ID are hidden everywhere, but I know they still exist as schedule emails are still sent.
Is there a way to connect directly to Toad database (mysql I believe) so that I can query to find the objects or schedules, and do manual updates?
Yes, you can connect directly to the TIC database. Instructions on how to do that you can find here - Toad Intelligence Central 6.4 - Getting Started Guide
In this case, the best solution is to open a Support ticket, since it is never a good idea to change the Toad Intelligence Central database manually.
Thanks, I was able to find out a few answers I think.
From the DB "hub_information_schema", I found on table "hub_audit" a first action taken by the system to delete the old user, then another one the next day to create the new user.
Our users are being migrated from an old domain to a new one, but the user ID remains the same. On toad, we are using Windows AD synchronization.
When looking at procedures triggered by this delete action, it actually physically delete records from "hub_ojbects" and other related user information.
This explains why objects are deleted and I can't find them.
But automated schedules are stored into DB "_toad_automation" and I still see running schedules, and their source file (.tas) on the server.
I think my solution at this point is: take a copy of all .tas scripts on the server and resend this to users so that they can republish them on the website (just in case they no longer have the file)
Then, manually update the flag "enabled" to 0 from the table "toad_auto_scripts" to stop running the old scripts...
