Could not find stored procedure 'proc_ar_BumpCacheInvalidationCounter'
If you have a MOSS 2007 Standard Edition environment and you run a full Profile Import (either scheduled or manual) you can get the following message in the event log:
Error messages 7888 - "System.Data.SqlClient.SqlException: Could not find stored procedure 'proc_ar_BumpCacheInvalidationCounter'."
This is a known issue, the missing stored procedure is part of the BDC functionality, which is a MOSS 2007 Enterprise feature. The error messages can be safely ignored.
NB: The same error (or similar) can appear if you are trying to use BDC functionality on a MOSS 2007 standard environment. BDC is an enterprise functionality and need enterprise license of MOSS.