Post reply

Transactional Replication

  • March 10, 2015 at 9:25 pm

    #301946

    Hi master ... I have configured transactional replication between SQL 2012 to Oracle 11g include insert, update and delete statement, everything is running smoothly

    But some values are didn't updated on subscribers

    Example : I've been updated 1,7 million row on table

    ( update table set column = 100 ) all row updated on publisher, but only 1,1 million updated on subscriber and there is no error messages being process till finish

    Where I should start analyse and troubleshoot this problem ... really need help please : )

  • March 11, 2015 at 6:44 am

    #1783248

    check if the log reader & distribution agents are running fine.. Also verify the t-log space of distribution db

  • March 11, 2015 at 7:42 am

    #1783279

    Thanks for your attention Mr. Bugatha I have been check Log reader agents that running continously, distributon agent running on demand and there are no failed history reported, and about the t-log space we have much free space 252 GB :crying:

  • March 11, 2015 at 7:50 am

    #1783286

    Is the job really running? It might look as if it is running sometimes, can you run sp_who2 for that spid and check?

  • March 11, 2015 at 9:18 am

    #1783332

    This is the process sir is there something wrong with this or there is more information that you need sir 🙂

    570MISCELLANEOUS 72015-02-06 06:39:26.320AWAITING COMMANDsleeping Repl-LogReader-0-ETPEASV55-7

    580MISCELLANEOUS 92015-02-06 06:39:26.327AWAITING COMMANDsleeping Repl-LogReader-0-ETPEASV55-7

  • March 11, 2015 at 10:34 am

    #1783386

    You won't believe this sir all command was delivered successed without error messages but the result is none

    See attached sir I've been update 1,7 million row with this command update table set column = 99

    Then i replicated that update command but none row updated on subscriber

    Is that possible cause data type sir, here I give the Data Type for each Table

    SQL Tables :

    CREATE TABLE [ProductLocationBalance_234](

    [Company] [smallint] NOT NULL,

    [Warehouse] [nvarchar](5) NOT NULL,

    [ItemNumber] [nvarchar](30) NOT NULL,

    [Location] [nvarchar](15) NOT NULL,

    [LotNumber] [nvarchar](20) NOT NULL,

    [Container] [nvarchar](12) NOT NULL,

    [Facility] [nvarchar](3) NOT NULL,

    [LocationType] [nvarchar](2) NOT NULL,

    [BalanceApproved] [numeric](15, 6) NOT NULL,

    [AllocatedQuantityBUOM] [numeric](15, 6) NOT NULL,

    [PickingListQuantity] [numeric](15, 6) NOT NULL,

    [Allocatable] [tinyint] NOT NULL,

    [PutAwayPossible] [tinyint] NOT NULL,

    [BalanceIdStatus] [nvarchar](1) NOT NULL,

    [ReceivingNumber] [bigint] NOT NULL,

    [LastReceiptDate] [int] NOT NULL,

    [LastIssueDate] [int] NOT NULL,

    [LastPhyInvDate] [int] NOT NULL,

    [PhyInventoryProgress] [tinyint] NOT NULL,

    [LotReference1] [nvarchar](12) NOT NULL,

    [LotReference2] [nvarchar](12) NOT NULL,

    [Remark] [nvarchar](20) NOT NULL,

    [StockQone] [nvarchar](2) NOT NULL,

    [Packaging] [nvarchar](6) NOT NULL,

    [ReclassificationDate] [int] NOT NULL,

    [ReclassificationNo] [int] NOT NULL,

    [ReplicationStatus] [numeric](5, 0) NULL,

    [CreateDate] [int] NOT NULL,

    [CreateTime] [int] NOT NULL,

    [ChangeNo] [smallint] NOT NULL,

    [ChangedBy] [nvarchar](10) NOT NULL,

    [StoreTimeStamp] [bigint] NULL,

    [EASTimeStamp] [bigint] NULL,

    [BatchNumber] [nvarchar](10) NULL

    )

    Oracle Tables :

    CREATE TABLE ETP55.PRODUCTLOCATIONBALANCE_234

    (

    COMPANY NUMBER(5) NOT NULL,

    WAREHOUSE NVARCHAR2(5) NOT NULL,

    ITEMNUMBER NVARCHAR2(30) NOT NULL,

    LOCATION NVARCHAR2(15) NOT NULL,

    LOTNUMBER NVARCHAR2(20) NOT NULL,

    CONTAINER NVARCHAR2(12) NOT NULL,

    FACILITY NVARCHAR2(3) NOT NULL,

    LOCATIONTYPE NVARCHAR2(2) NOT NULL,

    BALANCEAPPROVED NUMBER(15,6) NOT NULL,

    ALLOCATEDQUANTITYBUOM NUMBER(15,6) NOT NULL,

    PICKINGLISTQUANTITY NUMBER(15,6) NOT NULL,

    ALLOCATABLE NUMBER(3) NOT NULL,

    PUTAWAYPOSSIBLE NUMBER(3) NOT NULL,

    BALANCEIDSTATUS NVARCHAR2(1) NOT NULL,

    RECEIVINGNUMBER NUMBER(19) NOT NULL,

    LASTRECEIPTDATE NUMBER(10) NOT NULL,

    LASTISSUEDATE NUMBER(10) NOT NULL,

    LASTPHYINVDATE NUMBER(10) NOT NULL,

    PHYINVENTORYPROGRESS NUMBER(3) NOT NULL,

    LOTREFERENCE1 NVARCHAR2(12) NOT NULL,

    LOTREFERENCE2 NVARCHAR2(12) NOT NULL,

    REMARK NVARCHAR2(20) NOT NULL,

    STOCKQONE NVARCHAR2(2) NOT NULL,

    PACKAGING NVARCHAR2(6) NOT NULL,

    RECLASSIFICATIONDATE NUMBER(10) NOT NULL,

    RECLASSIFICATIONNO NUMBER(10) NOT NULL,

    REPLICATIONSTATUS NUMBER(5),

    CREATEDATE NUMBER(10) NOT NULL,

    CREATETIME NUMBER(10) NOT NULL,

    CHANGENO NUMBER(5) NOT NULL,

    CHANGEDBY NVARCHAR2(10) NOT NULL,

    STORETIMESTAMP NUMBER(19),

    EASTIMESTAMP NUMBER(19),

    BATCHNUMBER NVARCHAR2(10)

    )

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply