Environment
- App Control (Formerly CB Protection): 7.x - 8.x
- Microsoft Windows Server: All Supported Versions
Symptoms
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
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:
- Download ExtendedPublicAPI.sql
- Login to Cb Protection SQL Server
- Open SQL Management Studio
- Execute the Query:
- Navigate to File tab > Open > File
- Select "ExtendedPublicAPI.sql" to open it
- Click Execute