App Control: "Error: Could Not Find Stored Procedure"

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:

1. Download ExtendedPublicAPI.sql
2. Login to Cb Protection SQL Server
3. Open SQL Management Studio
4. Execute the Query:
   1. Navigate to File tab > Open > File
   2. Select "ExtendedPublicAPI.sql" to open it
   3. Click Execute