locked
Erro com replicação no SLQ 2000 8.00.2039 RRS feed

  • Pergunta

  • Tenho uma publicação funcionando com 1 assinante perfeitamente, mas no segundo está apresentando o seguinte erro:

      Category:COMMAND
    Source:  Failed Command
    Number:  0
    Message: {call sp_MSgetmetadatabatch(?,?,?)}

      Já reindexei, aumentei o timeout mas o problema persiste, não encontei nenhum tópico com esse problema.

     

       Se alguem puder ajudar, já agradeço

    sexta-feira, 16 de setembro de 2011 17:03

Todas as Respostas

  • Capelo,

    Cara você esta tendo problemas com a sua replicação, você consegui através do histórico pegar o comando que esta gerando a falha?


    Pedro Antonio Galvão Junior [MVP | Microsoft Evangelist | Microsoft Partner | Engenheiro de Softwares | Especialista em Banco de Dados | SorBR.Net | Professor Universitário | MSIT.com]
    domingo, 18 de setembro de 2011 01:52
    Moderador
  •  

      Esse comando eu peguei pelo histório do job de merge com verbose = 3 , tem jeito de pegar com mais detalhe ?

    segunda-feira, 19 de setembro de 2011 13:45
  • Capelo,

    Tente através do histórico de execução dos jobs envolvidos na replicação obter mais detalhes.

    Você esta trabalhando com replicação transacional ou merge? Se estiver utilizando o merge e deseja aplicar mais um assinante é necessário fazer algumas análises para evitar possíveis problemas de integridade referencial.


    Pedro Antonio Galvão Junior [MVP | Microsoft Evangelist | Microsoft Partner | Engenheiro de Softwares | Especialista em Banco de Dados | SorBR.Net | Professor Universitário | MSIT.com]
    quarta-feira, 21 de setembro de 2011 18:33
    Moderador
  •  

      Bom, já removi o sql do subscriber e instalei novamente, criei nova publicação, novo snapshot, importei os dados que foram perdidos desde o snapshot e o erro persiste.....  sempre que chega na tabela nota_fiscal.. segue o log.

     

    Server: SERVMATEOBEI
    DBMS: Microsoft SQL Server
    Version: 08.00.2039
    user name: dbo
    API conformance: 2
    SQL conformance: 1
    transaction capable: 2
    read only: N
    identifier quote char: "
    non_nullable_columns: 1
    owner usage: 31
    max table name len: 128
    max column name len: 128
    need long data len: Y
    max columns in table: 1024
    max columns in index: 16
    max char literal len: 524288
    max statement len: 524288
    max row size: 524288

    [28/9/2011 17:26:07]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSgetversion }
    Connecting to Publisher 'CENTRAL\FENIX.dbLingerieCentral'

    Server: CENTRAL\FENIX
    DBMS: Microsoft SQL Server
    Version: 08.00.2039
    user name: dbo
    API conformance: 2
    SQL conformance: 1
    transaction capable: 2
    read only: N
    identifier quote char: "
    non_nullable_columns: 1
    owner usage: 31
    max table name len: 128
    max column name len: 128
    need long data len: Y
    max columns in table: 1024
    max columns in index: 16
    max char literal len: 524288
    max statement len: 524288
    max row size: 524288

    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSgetversion }
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumdeletesmetadata(?,?,?,?,?,?,0,?,?)}
    Percent Complete: 5
    Processing article 'Licenca_Estacao'
    Repl Agent Status: 3
    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSgetmetadatabatch(?,?,?)}
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Estacao'
    Repl Agent Status: 3
    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {?=call [sp_ins_74D615FAC8BC466D84A8EF0B4A12435C] (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Ajusta_Aut_Exclusao'
    Repl Agent Status: 3
    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5:
    Percent Complete: 5
    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSgetmetadatabatch(?,?,?)}
    Processing article 'Transacao_Reserva'
    Repl Agent Status: 3
    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSgetmetadatabatch(?,?,?)}
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Registro60_Mestre'
    Repl Agent Status: 3
    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:08]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Movimentacao_Conta'
    Repl Agent Status: 3
    [28/9/2011 17:26:08]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:09]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSgetmetadatabatch(?,?,?)}
    [28/9/2011 17:26:09]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Mov_Operador'
    Repl Agent Status: 3
    [28/9/2011 17:26:09]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:09]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:09]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:09]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSgetmetadatabatch(?,?,?)}
    Percent Complete: 5
    Processing article 'LMC'
    Repl Agent Status: 3
    [28/9/2011 17:26:09]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:09]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Item_Venda'
    Repl Agent Status: 3
    [28/9/2011 17:26:09]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:09]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:09]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Item_Reserva_Cliente'
    Repl Agent Status: 3
    [28/9/2011 17:26:09]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:09]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSgetmetadatabatch(?,?,?)}
    [28/9/2011 17:26:09]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:09]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Dados_Fornecedor_Merc'
    Repl Agent Status: 3
    [28/9/2011 17:26:09]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:09]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Contas_Receber_E_Recebidas'
    Repl Agent Status: 3
    [28/9/2011 17:26:09]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:10]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:10]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Contas_Pagar_E_Pagas'
    Repl Agent Status: 3
    [28/9/2011 17:26:10]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:10]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Caixa'
    Repl Agent Status: 3
    [28/9/2011 17:26:10]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:10]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:10]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Transformacao'
    Repl Agent Status: 3
    [28/9/2011 17:26:10]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:10]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Transferencia'
    Repl Agent Status: 3
    [28/9/2011 17:26:10]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:10]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Suprimento'
    Repl Agent Status: 3
    [28/9/2011 17:26:10]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:10]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Sangria'
    Repl Agent Status: 3
    [28/9/2011 17:26:10]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:10]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Saida_Merc'
    Repl Agent Status: 3
    [28/9/2011 17:26:10]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:11]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Reserva_Estoque'
    Repl Agent Status: 3
    [28/9/2011 17:26:11]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:11]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Requisicao'
    Repl Agent Status: 3
    [28/9/2011 17:26:11]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:11]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Relacao'
    Repl Agent Status: 3
    [28/9/2011 17:26:11]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:11]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Pedido'
    Repl Agent Status: 3
    [28/9/2011 17:26:11]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:11]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Cotacao'
    Repl Agent Status: 3
    [28/9/2011 17:26:11]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:11]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Cheque'
    Repl Agent Status: 3
    [28/9/2011 17:26:11]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:11]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Boletim_Pgto'
    Repl Agent Status: 3
    [28/9/2011 17:26:11]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:11]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Bico'
    Repl Agent Status: 3
    [28/9/2011 17:26:11]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:11]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Troca'
    Repl Agent Status: 3
    [28/9/2011 17:26:12]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:12]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Bloqueto'
    Repl Agent Status: 3
    [28/9/2011 17:26:12]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:12]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Dados_Merc_Loja'
    Repl Agent Status: 3
    [28/9/2011 17:26:12]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:12]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:12]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Proposta_Cliente'
    Repl Agent Status: 3
    [28/9/2011 17:26:12]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:12]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Pedido_Cliente'
    Repl Agent Status: 3
    [28/9/2011 17:26:12]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:12]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Dados_Merc_Var_Loja'
    Repl Agent Status: 3
    [28/9/2011 17:26:12]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:12]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:14]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Reserva_Cliente'
    Repl Agent Status: 3
    [28/9/2011 17:26:14]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:14]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:14]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Venda'
    Repl Agent Status: 3
    [28/9/2011 17:26:14]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:14]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:26:15]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Receb_Merc'
    Repl Agent Status: 3
    [28/9/2011 17:26:15]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:15]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Cab_Processo'
    Repl Agent Status: 3
    [28/9/2011 17:26:15]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:15]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 5
    Processing article 'Nota_Fiscal'
    Repl Agent Status: 3
    [28/9/2011 17:26:15]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSenumcolumns (?,?)}
    [28/9/2011 17:26:15]SERVMATEOBEI.dbLingerieLoja5: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    [28/9/2011 17:31:14]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSgetmetadatabatch(?,?,?)}
    [28/9/2011 17:31:37]CENTRAL\FENIX.dbLingerieCentral: {call sp_MSgetmetadatabatch(?,?,?)}
    The process could not query row metadata at the 'Publisher'.
    The merge process encountered an unexpected network error. The connection to Publisher 'CENTRAL\FENIX' is no longer available.
    Percent Complete: 0
    The process could not query row metadata at the 'Publisher'.
    Repl Agent Status: 6
    Percent Complete: 0
    Category:NULL
    Source:  Merge Replication Provider
    Number:  -2147200996
    Message: The process could not query row metadata at the 'Publisher'.
    Repl Agent Status: 3
    Percent Complete: 0
    Category:COMMAND
    Source:  Failed Command
    Number:  0
    Message: {call sp_MSgetmetadatabatch(?,?,?)}
    Repl Agent Status: 3
    Percent Complete: 0
    Category:SQLSERVER
    Source:  CENTRAL\FENIX
    Number:  11
    Message: Erro geral de rede. Verifique a documentação da rede.
    Repl Agent Status: 3
    Percent Complete: 0
    Category:NULL
    Source:  Merge Process
    Number:  -2147199469
    Message: The merge process encountered an unexpected network error. The connection to Publisher 'CENTRAL\FENIX' is no longer available.
    Repl Agent Status: 3
    Disconnecting from Subscriber 'SERVMATEOBEI'
    Disconnecting from Publisher 'CENTRAL\FENIX'
    Disconnecting from Subscriber 'SERVMATEOBEI'
    Disconnecting from Publisher 'CENTRAL\FENIX'
    Disconnecting from Publisher 'CENTRAL\FENIX'
    Disconnecting from Distributor 'CENTRAL\FENIX'

     

    quarta-feira, 28 de setembro de 2011 20:46
  • Capelo,

    Cara então o problema deve estar relacionado a alguma propriedade ou registro existente na sua tabela de Notas Fiscais, deixando esta tabela fora da replicação você encontrou mais algum outro problema?

    Este tabela possui algum trigger? Qual tipo de dados você esta utilizando nas colunas que compõem a tabela?


    Pedro Antonio Galvão Junior [MVP | Microsoft Evangelist | Microsoft Partner | Engenheiro de Softwares | Especialista em Banco de Dados | SorBR.Net | Professor Universitário | MSIT.com]
    sábado, 1 de outubro de 2011 18:05
    Moderador