The following error message pops up every day at 16:00.
--------------------------------------------------------------------------------
Product:
Spotlight on Oracle 4.5.0.835
--------------------------------------------------------------------------------
Message:
An error occurred while refreshing the table "Memory" in connection "<connection name>".
* Click OK to continue,
* Click Ignore to ignore any further errors related to this table, or
* Click Disconnect to close this connection.
--------------------------------------------------------------------------------
Details:
System Message: Remote procedure call failed
--------------------------------------------------------------------------------
I only can reconnect to solve the problem.
It happens only if I connect to a Windows system, there are no problems connecting to an AIX system.
Expired Kerberos ticket
This is not a Spotlight problem it is related to the Kerberos ticket which expired after 10 hours.
Every morning Spotlight started up automatically at 06:00 and at 16:00 in the afternoon the error comes up. If Spotlight starts up one hour later the error comes up also one hour later.
You need to change the expiry date of the Kerberos ticket or restart Spotlight when the error occurs.
NOTE:
Spotlight is not a 24*7 monitoring tool. It is designed as a diagnostic tool and should be started when a problem occurs. If you use it this way there shouldn't be any problems with an expired Kerberos ticket.
To validate the expiry date of the Kerberos ticket you can use the tool kerbtray.