
I was recently helping a customer with a problem that they were seeing when they had installed a plug-in one one of their Service-now.com instances. I found that they had duplicate records in the “Classes – Table” list. One record had the correct Super Class and the other one had no Super Class. This was causing their problem.
I deleted the errant record, but when I went to examine the table schema in the Table Viewer, I found that the Super Class fields were still not showing up.
After scratching my head for several minutes, I finally went to the Service Now Guru himself and asked him what he thought needed to be done.
He wondered if the information we were seeing in the database schema were simply a cache of old data before the correction that I had made. He proceeded to show me a quick and easy way to flush the database cache. All you have to do is add the following to your base Service-now.com url: “cache.do”. This url will call a script that flushes your database cache.
Sure enough, as soon as I flushed the cache with this nifty trick, I found myself looking at the corrected schema.
Please Note: Flushing the cache can cause system performance degradation until the cache is fully repopulated again.