VERIFIED SOLUTION i

"Unknown object type 'SEQUENCE' used in a CREATE, DROP, or ALTER statement." message in EngageOne Server 4.4.x

Product Affected: EngageOne Server 4.4.x
Product Feature: Database / SQL
 

Issue

The following error is thrown when running the SQL database install or upgrade script for EngageOne Server version 4.4.x:
Unknown object type 'SEQUENCE' used in a CREATE, DROP, or ALTER statement.

Cause

The version of SQL Server database used was SQL Server 2008 and SQL Server object type of 'SEQUENCE' is only supported as of SQL Server 2012 hence the error when EngageOne Server 4.4.x install or upgrade script attempts to create, drop, or alter a 'SEQUENCE'.

Resolution

UPDATED: July 18, 2019
EngageOne Server 4.4.x does not support SQL Server 2008. For full list of supported SQL Server database versions, refer to the 'EngageOne_4.4_SoftwareAndHardwareRequirements.pdf' guide which comes with the installation package of EngageOne Server 4.4.x.