Missing stored procedure SQL Error (2812)
- Last UpdatedOct 02, 2024
- 1 minute read
- PI System
- PI Server 2018
- PI Server
When you see the following error:
System.ApplicationException: Unexpected Server Error: 'SQL Error (2812) Could not find stored procedure 'dbo.usp_AFDatabase_insert'.'.
Use Event Viewer to see the AF service log file for more information.
at OSIsoft.AF.PISystem.CheckServerError(dcServerError err)
A stored procedure is missing from the PI AF SQL Server database. Try the following:
Run GO.BAT to rerun the AF SQL scripts. See Create the PI AF SQL Server database manually.