有誰精通SYBASE復(fù)制的，幫幫忙，老是報同樣的錯

happyfei

是做的整庫復(fù)制，
1、開始一直報以下錯誤，但把復(fù)制端的鏈接重新添加一次就好了，但為什么經(jīng)常出現(xiàn)報sa無法登陸復(fù)制庫
2008/01/23 18:19:33. ERROR #1028 DSI EXEC(104(1) SYBREP.ecourt) - seful/cm.c(
3459)
        Message from server: Message: 4002, State 1, Severity 14 -- 'Login faile
d.
'.
E. 2008/01/23 18:19:34. ERROR #1027 DSI EXEC(104(1) SYBREP.dbname) - seful/cm.c(
3459)
        Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_con
nect(): protocol specific layer: external error: The attempt to connect to the s
erver failed.'.
E. 2008/01/23 18:19:34. ERROR #13045 DSI EXEC(104(1) SYBREP.dbname) - seful/cm.c
(3463)
        Failed to connect to server 'SYBREP' as user 'sa'. See CT-Lib and/or ser
ver error messages for more information.
I. 2008/01/23 18:19:34. The DSI thread for database 'SYBREP.dbname' is shutdown.

happyfei

2、復(fù)制服務(wù)器總會有寫字段復(fù)制不過去，報以下錯
ata row associated with the rs_writetext is missing. The data row is needed for the DSI to generate the rs_get_textptr command.
W. 2008/01/24 09:22:08. WARNING #5066 DSI(106 SYBREP.dbname) - /dsiutil.c(3641)
        When writing a transaction for database 'SYBREP.ecourt' into the exceptions log, the function string mapping for command '23' failed. No mapped output commands for this source command are logged. See an earlier message for details of the error.
I. 2008/01/24 09:22:09. The first transaction for database 'SYBREP.dbname' has been logged into the exceptions log and skipped.
E. 2008/01/24 09:25:30. ERROR #5149 DSI EXEC(106(1) SYBREP.dbname) - /dsiexec.c(3673)
        Function 'rs_get_textptr' for 'JZ' returned no rows.
I. 2008/01/24 09:25:30. The DSI thread for database 'SYBREP.dbname' is shutdown.

happyfei

應(yīng)該是TEXT，image等大字段復(fù)制出現(xiàn)的問題，有沒有能徹底解決的好方法啊

hobbylu

首先同步兩邊的數(shù)據(jù)

happyfei

數(shù)據(jù)是同步的，用了幾天都是好的，突然這樣，以前也是經(jīng)常這樣

BlueAeri

原帖由 happyfei 于 2008-1-24 19:15 發(fā)表
數(shù)據(jù)是同步的，用了幾天都是好的，突然這樣，以前也是經(jīng)常這樣

數(shù)據(jù)應(yīng)該是有差異的。。。你仔細查查，不要想當(dāng)然。

Eisen

問題1你最好看看rssd庫中的rs_users表,然后對比一下你在ase中有無對應(yīng)的用戶名密碼的login，以及該用戶在復(fù)制庫上的權(quán)限
問題2請參看版主hobbylu的建議

happyfei

同步一次好麻煩啊，160G數(shù)據(jù)，整個dump，load要五六個小時