Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When upgrading ACM from a DB version 36 or lower to DB version 37 or higher you may see an error message with text similar to the following:
”ALTER TABLE ALTER COLUMN ID failed because on or more objects access this column”

it This is because SQLUpdate_37 makes a change to the primary key of tblItems to change it from an INT to a BIG INT. This column is used by replication and as such, the table must be removed from the publisher as an “Article of Replication” first.

...