Revision error 3225 of revision set 1121 when applying 2.91 patch 40 -- Invalid column name 'SEQUENCE'

Revision text: LoadSpec: 3225.CMSObjectTypeObjectTask.DataList.xml Blackbaud.AppFx.Galileo.ServiceRevisions.Specs1121.zip --->
Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.LoadSpecException: Procedure Return Code: 0 --->
System.Exception: Invalid column name 'SEQUENCE'. --->
System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_LOADSPEC": 
System.Data.SqlClient.SqlException: Invalid column name 'SEQUENCE'.

 
 reload the CMSOBJECTTYPEOBJECTTASK table spec:

exec usp_loadspec '
<TableSpec xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="bb_appfx_table" ID="8989d631-1916-48df-9c03-c53fa4578f0d" Name="CMS Object Type Object Task" Description="Defines the object tasks associated with each CMS object type." Author="BBNT\MatthewBe" Tablename="CMSOBJECTTYPEOBJECTTASK" IsBuiltIn="true">
  <Fields>
    <ForeignKeyField Name="OBJECTTYPEID" ForeignTable="OBJECTTYPES" ForeignDataType="int" />
    <ForeignKeyField Name="OBJECTTASKID" ForeignTable="CMSOBJECTTASK" />
    <BooleanField Name="DEFAULTVALUE" />
    <BooleanField Name="ALLOWEVERYONE" DefaultValue="true" />
    <SequenceField Name="SEQUENCE" />
  </Fields>
  <Indexes>
    <Index IsUnique="true">
      <IndexFields>
        <IndexField Name="OBJECTTYPEID" />
        <IndexField Name="OBJECTTASKID" />
      </IndexFields>
    </Index>
  </Indexes>
</TableSpec>
'
 

Environment

 2.91.1535.33

Was this article helpful?