1. 对比源端、目标端表结构;

   desc &table_name

2. 修改目标端不一致表结构;

   添加字段

   alter table [tablename] add  [column name] [column data type];

   修改字段

   alter table [tablename] modify [column name] [column data type];
   

3. 启动目标端应用进程。

   start [process]

2019-03-15 10:29:25  INFO    OGG-06511  Using following columns in default map by name: ID, SampleCode, SampleName, Mnemonics, UnitID, SampleClothingNo, DropPrice, SettleAccountsPrice, StandardPrice, OrderingMeetingID, IsStop, IsDeleteParagraph, IsSpecialOffer, DefaultDelivery, Remark, Years, BrandMarkID, StyleID, StyleMinutiae, SeasonID, BaisonCategoryID, ProjectID, EditionID, CollarTypeID, SleeveStyleID, SupplierID, UpperAndLowerID, CompanyID, BrandID, GroupID, BigCategoryID, MiddleCategoryID, SmallCategoryID, PriceBandID, BandID, SeriesID, AgesID, SalesMonth, IsMastOrder, IsOnlineShopping, IsRecommend, PatternID, SystemTypeID, DiscountType, ProductCode, Ingredient, OrderQuantity, SizeDistribution, SizeOfFiles, DefaultPacking, OriginalArticle, Summary, AddTime, CreateUser, CreateUserName, IsDel, ModifyTime, ModifyUser, ModifyUserName, Amount, Video, ThreeD, Character, NurseMethod, Sales, Series, QuickCodes, Sponsors, SponsorsDate, PrepaidDate, Garderobe, FunctionalLabel, fushi, IsConvert, UDAYARNDensity, UDABreadth, UDAGramWeight, UDAAccessoriesSupplierNum, UDASupplierColorNum, UDAAccessoriesSpec, UDAAccessoriesQuality, UDAAccessoriesCategoryId, UDAFurnitureItemsCategoryId, UDAFabricName, SurfaceMaterialsColor, FabricCompositionDesc, MdsId, BatchNO, Yarn, Density, WoolTops, ThemesId, tempzd, MobileSync, Note, FlowerType, DNA, Technics, LegOpening, PlusMaterial.

2019-03-15 10:29:25  INFO    OGG-06510  Using the following key columns for target table dbo.sample: ID.

Source Context :

  SourceModule            : [ggstd.conv.endian]

  SourceID                : [../gglib/ggstd/lecnv.c]

  SourceFunction          : [convCompSQL]

  SourceLine              : [575]

  ThreadBacktrace         : [13] elements

                          : [D:\153\ggsok\gglog.dll(?CreateMessage@CMessageFactory@@QEAAPEAVCMessage@@PEAVCSourceContext@@IZZ+0x8d8) [0x00007FFF506F9258]]

                          : [D:\153\ggsok\gglog.dll(?_MSG_ERR_MAP_COL_INDEX_UNEXPECTED@@YAPEAVCMessage@@PEAVCSourceContext@@AEBV?$CQualDBObjName@$00@ggapp@gglib@ggs@@HHW4MessageDisposition@CMessageFactory@@@Z+0x6c) [0x00007FFF506B081C]]

                          : [D:\153\ggsok\replicat.exe(_ggTryDebugHook+0x9226) [0x00007FF6FFE999B6]]

                          : [D:\153\ggsok\replicat.exe(_ggTryDebugHook+0x973e) [0x00007FF6FFE99ECE]]

                          : [D:\153\ggsok\replicat.exe(ERCALLBACK+0x3e2ee) [0x00007FF6FFDCBE3E]]

                          : [D:\153\ggsok\replicat.exe(ERCALLBACK+0x63718) [0x00007FF6FFDF1268]]

                          : [D:\153\ggsok\replicat.exe(_ggTryDebugHook+0xe103) [0x00007FF6FFE9E893]]

                          : [D:\153\ggsok\replicat.exe(_ggTryDebugHook+0xd6e0) [0x00007FF6FFE9DE70]]

                          : [D:\153\ggsok\replicat.exe(_ggTryDebugHook+0xdfad) [0x00007FF6FFE9E73D]]

                          : [D:\153\ggsok\replicat.exe(ERCALLBACK+0x63799) [0x00007FF6FFDF12E9]]

                          : [D:\153\ggsok\replicat.exe(CommonLexerNewSSD+0xbb12) [0x00007FF6FFF31D62]]

                          : [C:\Windows\system32\KERNEL32.DLL(BaseThreadInitThunk+0xd) [0x00007FFF5E01168D]]

                          : [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x34) [0x00007FFF606554F4]]

2019-03-15 10:29:25  ERROR   OGG-01164  Column index (0) out of sequence for table dbo.sample, last column index = 68.

***********************************************************************

*                   ** Run Time Statistics **                         *

***********************************************************************

Reading ./dirdat/ps001251, current RBA 46311636, 26 records

Report at 2019-03-15 10:29:25 (activity since 2019-03-15 10:29:25)

From Table dbo.userstate to dbo.userstate:

       #                   inserts:         0

       #                   updates:         1

       #                   deletes:         0

       #                  discards:         0

From Table dbo.samplephoto to dbo.samplephoto:

       #                   inserts:         1

       #                   updates:         0

       #                   deletes:         0

       #                  discards:         0

From Table dbo.samplesize to dbo.samplesize:

       #                   inserts:         8

       #                   updates:         0

       #                   deletes:         8

       #                  discards:         0

From Table dbo.his_samplesize to dbo.his_samplesize:

       #                   inserts:         8

       #                   updates:         0

       #                   deletes:         0

       #                  discards:         0

       #         insert collisions:         8

Last log location read:

我重新复制了表，这张sample表结 构有变化，我重新复制了，还需要什么其它步操作吗

REPLICAT repl9

dboptions USEODBC

targetdb  ggs, USERID ggs, PASSWORD ggs@321

HANDLECOLLISIONS

ASSUMETARGETDEFS

DISCARDFILE .\dirrpt\rep.txt, append, MEGABYTES 100

WILDCARDRESOLVE DYNAMIC

gettruncates

MAPEXCLUDE dbo.tempordersdetailbak

MAPEXCLUDE dbo.tempordersbak

MAPEXCLUDE dbo.tempzy

MAPEXCLUDE dbo.zljj_sku

MAPEXCLUDE        dbo.tablechangerecord ;

MAPEXCLUDE        dbo.syncrecord  ;

--MAPEXCLUDE        dbo.sample ;

MAPEXCLUDE dbo.channeldiscount;

MAPEXCLUDE   dbo.his_ordersdetail;

Map      dbo.*,     TARGET dbo.*;

请上传完整日志，并描述问题。问题中的复制是重新初始化操作吗？