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 a friend 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.
Here is a sample URL that flushes your cache:
https://YourSNInstance.service-now.com/cache.do
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.
