Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2008
    Posts
    13

    Unanswered: Table "xxx" has been altered outside of synchronizaton

    We are using MobiLink for our replication needs and we are still on ASA 8.0. I made a few table changes to the consolidated database:

    Alter table orders
    MODIFY ordmilestojob numeric(6,2);
    commit;

    Alter table tickhist
    MODIFY hst_grosswt numeric(11,2),
    MODIFY hst_trkgross numeric(9,0),
    MODIFY hst_taxamt numeric(7,2),
    MODIFY hst_haulprice numeric(9,2)
    commit;

    Alter table tickchange
    MODIFY hst_grosswt numeric(11,2),
    MODIFY Hst_trkgross numeric(8,0),
    MODIFY hst_taxamt numeric(7,2),
    MODIFY hst_haulprice numeric(9,2)
    commit;

    After the consolidated changes were made, I stopped replication and then made similar changes to the remote:

    BACKUP DATABASE
    DIRECTORY 'D:\\Backup'

    ***At this point, the backup took so long to complete, we stopped running the script and shut the database down and made a copy of the database and the log file. Then reran the following script:****

    --Drop publication for tables that need to be altered
    ALTER PUBLICATION pub
    delete TABLE orders ,
    delete table tickhist,
    delete table tickchange,
    delete table truck
    commit;

    --Alter tables
    Alter table orders
    modify ordmilestojob numeric(6,2);
    commit;

    Alter table tickhist
    modify hst_grosswt numeric(11,2),
    MODIFY hst_trkgross numeric(9,0),
    MODIFY hst_taxamt numeric(7,2),
    MODIFY hst_haulprice numeric(9,2)
    commit;

    Alter table tickchange
    modify hst_grosswt numeric(11,2),
    MODIFY Hst_trkgross numeric(8,0),
    MODIFY hst_taxamt numeric(7,2),
    MODIFY hst_haulprice numeric(9,2)
    commit;

    Alter table truck
    modify grosswt numeric(9,0)
    commit;

    --Add publication for tables that need to be included in replication
    ALTER PUBLICATION pub
    add TABLE orders ,
    add table tickhist,
    add table tickchange,
    add table truck
    commit;

    ALTER procedure sp_calc_fsc( ) as . . .

    ALTER procedure sp_calc_fsc_miles() as . . .

    I then restarted replication and ran into a -101 error and could not connect to the database because "Table orders has been altered outside of synchronizaton". Can anyone tell me:

    What I did wrong?
    What is the most efficient way to resync?
    What is the correct process to make changes such as this?

    Thanks,
    Chrys
    Last edited by ChrysW; 08-28-08 at 11:21.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •