CB Protection: Error running '80_md5_hash_getSyslogEvents.sql': 'This patch is viable for version 8.0'

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

• Following error received when running '80_md5_hash_getSyslogEvents.sql' file:

Parity Server database version not supported. This patch is viable for version 8.0

 

 

Environment

• CB Protection Server: Version 8.1.0.3324 and Higher
• Syslog 

Cause

Incorrect line in '80_md5_hash_getSyslogEvents.sql' file.

Resolution

1. Change the following line in '80_md5_hash_getSyslogEvents.sql' file:

IF NOT EXISTS (SELECT value FROM dbo.shepherd_configs WHERE name = 'DBSchemaVersion' AND value LIKE '8.0.%') 

To:

IF NOT EXISTS (SELECT value FROM dbo.shepherd_configs WHERE name = 'DBSchemaVersion' AND value LIKE '8.1.%')

2. Re-run the script
3. Restart the CB Protection Server and CB Protection Reporter services 

Additional Information

• These steps are a workaround until  '81_md5_hash_getSyslogEvents.sql' file becomes available.