How-to - Fix the "Cannot alter the procedure sp_recCacheClear" error when syncing

Aim

How-to resolve the error

Agent:XXXXXXXXX Version:x-cise-agent-ver/3.4.0 Error:Calling RecVerUpdate Workflow failed: Error applying RecVer schema changes 3.1.3: SQL error: Cannot alter the procedure 'sp_recCacheClear', because it does not exist or you do not have permission.

This KB applies to:

Applies to Versions	All
Applies to Source Connectors	Lansweeper
Applies to Destination Connectors	ServiceNow

Process

This error occurs because the SQL Login used by the CI Sync Agent does not have the appropriate role assigned or the role has been removed.

For information regarding the permissions required, see the knowledge base article below under Related Articles. In particular, Task 3 (SQL): Create a Source System Connection using the CI Sync Agent Config Utility with a SQL RecVer DB

https://support.syncfish.com.au/cs/appendix-d-how-to-add-lansweeper-it-on-prem-as-a-s#AddLansweeperOn-Prem-Task3(SQL):CreateaSourceSystemConnectionusingtheCISyncAgentConfigUtilitywithaSQLRecVerDB

Control Information

Created	2026-03-16
Reviewed	2026-03-20
Data Classification	PUBLIC Classified in accordance with the Syncfish Data Classification Framework