App Control: "Error: Could Not Find Stored Procedure"
book
Article ID: 288335
calendar_today
Updated On:
Products
Carbon Black App Control (formerly Cb Protection)
Issue/Introduction
Errors found when running a custom sql script, or when looking in "C:\Program Files (x86)\Bit9\Parity Console\WebUI\Logs\php_errors.txt"
Error: 'Could not find stored procedure bit9_public.ChangeGlobalFileState'
Error: 'Could not find stored procedure bit9_public.ChangeLocalFileState'
Error: 'Could not find stored procedure bit9_public.ChangePublisherState'
Error: 'Could not find stored procedure bit9_public.ChangeCertificateState'
Error: 'Could not find stored procedure bit9_public.MoveComputer
Environment
App Control (Formerly CB Protection): 7.x - 8.x
Microsoft Windows Server: All Supported Versions
Cause
There is a custom SQL job that is looking for the stored procedure that no longer exists.
Resolution
The stored procedures were deprecated and are no longer supported or tested. It's recommended to update any workflows to use the new procedures. For temporary use, they can be added back using the below steps: