# Health check through automation Designer **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [March 30, 2015, 4:23am UTC](https://forums.toadworld.com/t/health-check-through-automation-designer/33025 "2015-03-30T04:23:37Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![j.dekker](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/j.dekker/32/12003_2.png) [@j.dekker](https://forums.toadworld.com/u/j.dekker)\ **Post date:** [March 30, 2015, 4:23am UTC](https://forums.toadworld.com/t/health-check-through-automation-designer/33025/1 "2015-03-30T04:23:37Z")
Hi, When i check a database through automation Designer to check on invalid object i get Invalid Objects (PBAGNTH.WORLD) BASIS.PERCEEL (synonym) And now i start Toad and go to the database and set the current user to BASIS and select invalid objects. But there are no invalid objects. So the check throught automation disigner on invalids show me invalids but looking with Toad itself shows me nothing. How is this possible. Greetings Jan Dekker j.dekker@heerlen.nl ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [March 31, 2015, 8:32am UTC](https://forums.toadworld.com/t/health-check-through-automation-designer/33025/2 "2015-03-31T08:32:29Z")
As it's a synonym being reported as invalid, could it be that the object that it points to has a problem? Cheers, Norm [TeamT] On 31 March 2015 14:58:53 BST, "j.dekker" [bounce-jdekker@toadworld.com](mailto:bounce-jdekker@toadworld.com) wrote: > **[Health check through automation Designer](http://www.toadworld.com/products/toad-for-oracle/f/10/t/24267.aspx)** > Thread created by j.dekker > > Hi, > > When i check a database through automation Designer to check on invalid object i get > > Invalid Objects (PBAGNTH.WORLD) > BASIS.PERCEEL (synonym) > > And now i start Toad and go to the database and set the current user to BASIS and select invalid objects. But there are no invalid objects. > > So the check throught automation disigner on invalids show me invalids but looking with Toad itself shows me nothing. > > How is this possible. > > Greetings Jan Dekker > j.dekker@heerlen.nl > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/24267.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. > > Toad for Oracle - Discussion Forum > [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/24267.aspx?AbuseContentId=7ad8f501-69e0-4a84-a5e5-b8a0930915f7&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 1, 2015, 9:56am UTC](https://forums.toadworld.com/t/health-check-through-automation-designer/33025/3 "2015-04-01T09:56:17Z")
The health check is just looking for objects listed in DBA\_OBJECTS with at status of “INVALID”. The Schema Browser’s “Invalid Objects” listing is limited to “real” objects like views, packages, procedures, triggers, etc. I did a bit of googling for “invalid synonym” and got some hits. Here’s one: [rwijk.blogspot.com/…/invalid-synonyms.html](http://rwijk.blogspot.com/2008/02/invalid-synonyms.html) ---
**Author:** ![j.dekker](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/j.dekker/32/12003_2.png) [@j.dekker](https://forums.toadworld.com/u/j.dekker)\ **Post date:** [April 10, 2015, 2:12am UTC](https://forums.toadworld.com/t/health-check-through-automation-designer/33025/4 "2015-04-10T02:12:05Z")
Hi Norm, There isn’t a problem with that object. When i go to the owners synonym and look through TOAD in the right panel, i see Synonym: BASIS.PERCEEL Target Object: Table SPATIAL.LKI\_PERCEEL Synonym Created: 24/02/2015 11:43:36 And clicking on the TAB data i get the rows with data in the table. So i don’t think theres the problem. Gr. Jan ---
**Author:** ![j.dekker](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/j.dekker/32/12003_2.png) [@j.dekker](https://forums.toadworld.com/u/j.dekker)\ **Post date:** [April 10, 2015, 2:23am UTC](https://forums.toadworld.com/t/health-check-through-automation-designer/33025/5 "2015-04-10T02:23:06Z")
Hi John, The message i get is from the Health Check. And when i look through TOAD and go to the schema\_owner BASIS and select the invalid objects i got nothing to see. And going to the synonym (the only one) i see in the right pannel information about that synonym. I replied Norm already on the same issue. I think it is a setting within TOAD? Gr. Jan ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 10, 2015, 5:16am UTC](https://forums.toadworld.com/t/health-check-through-automation-designer/33025/6 "2015-04-10T05:16:27Z")
It’s not a setting in Toad. For whatever reason, Oracle has an INVALID status for your synonym. Toad is just reporting it to you. If it’s not important, then ignore it. Try running this query in the editor and you will find the same thing. select object\_type, status from dba\_objects where owner = ‘BASIS’ and object\_name = ‘PERCEEL’; ---
**Author:** ![j.dekker](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/j.dekker/32/12003_2.png) [@j.dekker](https://forums.toadworld.com/u/j.dekker)\ **Post date:** [June 1, 2015, 4:32am UTC](https://forums.toadworld.com/t/health-check-through-automation-designer/33025/7 "2015-06-01T04:32:54Z")
Hi John, I just running the query and there are no invalids. But , yes you know, through the Health Check it’s reported INVALID. I’m out of my ideas. Greetings Jan ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 1, 2015, 7:58am UTC](https://forums.toadworld.com/t/health-check-through-automation-designer/33025/8 "2015-06-01T07:58:06Z")
It’s been a while since you started this thread, so the situation may have changed, but originally, this was the problem: The SYNONYM was invalid (according to the STATUS column in DBA\_OBJECTS), but the target object was valid. Toad’s health check reports all invalid objects (including synonyms) but when you click on a synonym in the Schema Browser, it will show you the target object on the right hand side. Apparently, it is possible for Oracle to mark the synonym as invalid, even though the target object is valid. I think you can safely ignore it. ---
**Author:** ![j.dekker](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/j.dekker/32/12003_2.png) [@j.dekker](https://forums.toadworld.com/u/j.dekker)\ **Post date:** [June 8, 2015, 5:51am UTC](https://forums.toadworld.com/t/health-check-through-automation-designer/33025/9 "2015-06-08T05:51:51Z")
Hi John, Oké, i’ll ignore it and thx for answering gr. Jan