有谁精通SYBASE复制的，帮帮忙，老是报同样的错

happyfei

是做的整库复制，
1、开始一直报以下错误，但把复制端的链接重新添加一次就好了，但为什么经常出现报sa无法登陆复制库
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、复制服务器总会有写字段复制不过去，报以下错
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

应该是TEXT，image等大字段复制出现的问题，有没有能彻底解决的好方法啊

hobbylu

首先同步两边的数据

happyfei

数据是同步的，用了几天都是好的，突然这样，以前也是经常这样

BlueAeri

原帖由 happyfei 于 2008-1-24 19:15 发表
数据是同步的，用了几天都是好的，突然这样，以前也是经常这样

数据应该是有差异的。。。你仔细查查，不要想当然。

Eisen

问题1你最好看看rssd库中的rs_users表,然后对比一下你在ase中有无对应的用户名密码的login，以及该用户在复制库上的权限
问题2请参看版主hobbylu的建议

happyfei

同步一次好麻烦啊，160G数据，整个dump，load要五六个小时