请教版主，Sybase复制的问题

xdd

两段错误日志：

E. 2008/01/05 17:12:08. ERROR #5149 DSI EXEC(135(1) DLGSMSCS01.dlaic_db) - (2947)
        Function 'rs_get_textptr' for 'ZcQySyJbxx' returned no rows.
I. 2008/01/05 17:12:08. The DSI thread for database 'DLGSMSCS01.dlaic_db' is shutdown.
I. 2008/01/05 17:15:43. The DSI thread for database 'DLGSMSCS01.dlaic_db' is started.
E. 2008/01/05 17:15:43. ERROR #5149 DSI EXEC(135(1) DLGSMSCS01.dlaic_db) - (2947)
        Function 'rs_get_textptr' for 'ZcQySyJbxx' returned no rows.
I. 2008/01/05 17:15:43. The DSI thread for database 'DLGSMSCS01.dlaic_db' is shutdown.
I. 2008/01/05 17:15:56. The DSI thread for database 'DLGSMSCS01.dlaic_db' is started.
E. 2008/01/05 17:15:56. ERROR #29066 DSI(135 DLGSMSCS01.dlaic_db) - (675)
        DSI encountered an error when processing an rs_writetext command for object 'ZcQySyBgxx', text column 'bgqnr'. The data 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/05 17:15:56. WARNING #5066 DSI(135 DLGSMSCS01.dlaic_db) - (3470)
        When writing a transaction for database 'DLGSMSCS01.dlaic_db' into the exceptions log, the function string mapping for command '3' failed. No mapped output commands for this source command are logged. See an earlier message for details of the error.
I. 2008/01/05 17:19:08. 'Replication Server/12.5/P/PC Intel/Windows NT 4.0/1/OPT/Mon Apr 8 13:33:39 PDT 2002'
I. 2008/01/05 17:19:08. 'Confidential property of Sybase, Inc.

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

E. 2008/01/05 17:19:17. ERROR #5149 DSI EXEC(135(1) DLGSMSCS01.dlaic_db) - (2947)
        Function 'rs_get_textptr' for 'ZcQySyJbxx' returned no rows.
I. 2008/01/05 17:19:17. The DSI thread for database 'DLGSMSCS01.dlaic_db' is shutdown.
I. 2008/01/05 17:20:00. Replication Agent version (600) for 'DLGSMSCS02.REP1_RSSD' does not match the default LTI version for this Replication Server 400 using version 400.
I. 2008/01/05 17:20:00. Replication Agent for DLGSMSCS02.REP1_RSSD connected in passthru mode.
I. 2008/01/05 17:20:08. Replication Agent version (600) for 'main_sybase.dlaic_db' does not match the default LTI version for this Replication Server 400 using version 400.
I. 2008/01/05 17:20:08. Replication Agent for main_sybase.dlaic_db connected in passthru mode.
I. 2008/01/05 17:20:34. The DSI thread for database 'DLGSMSCS01.dlaic_db' is started.
E. 2008/01/05 17:20:34. ERROR #5149 DSI EXEC(135(1) DLGSMSCS01.dlaic_db) - (2947)
        Function 'rs_get_textptr' for 'ZcQySyJbxx' returned no rows.
I. 2008/01/05 17:20:34. The DSI thread for database 'DLGSMSCS01.dlaic_db' is shutdown.
I. 2008/01/05 17:20:58. The DSI thread for database 'DLGSMSCS01.dlaic_db' is started.
E. 2008/01/05 17:20:58. ERROR #29066 DSI(135 DLGSMSCS01.dlaic_db) - (675)
        DSI encountered an error when processing an rs_writetext command for object 'ZcQySyJbxx', text column 'zyfw'. The data 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/05 17:20:58. WARNING #5066 DSI(135 DLGSMSCS01.dlaic_db) - (3470)
        When writing a transaction for database 'DLGSMSCS01.dlaic_db' into the exceptions log, the function string mapping for command '3' failed. No mapped output commands for this source command are logged. See an earlier message for details of the error.
E. 2008/01/05 17:20:58. ERROR #29066 DSI(135 DLGSMSCS01.dlaic_db) - (675)
        DSI encountered an error when processing an rs_writetext command for object 'ZcQySyJbxx', text column 'zgbm'. The data 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/05 17:20:58. WARNING #5066 DSI(135 DLGSMSCS01.dlaic_db) - (3470)
        When writing a transaction for database 'DLGSMSCS01.dlaic_db' into the exceptions log, the function string mapping for command '4' failed. No mapped output commands for this source command are logged. See an earlier message for details of the error.

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

为什么我每次 resume connection DLGSMSCS01.dlaic_db skip tran 后 rs 就没有响应了呢 ？
这个是什么错误，我该怎样解决啊 版主 无从下手啊 望指点一二

先谢谢了

hobbylu

skip之后没有反应什么意思？

xdd

就是复制死掉了，再输入命令，没有响应

xdd

ding

hobbylu

目前什么状态呢？

xdd

堆栈里有数据，但是每次skip就需要重启rs服务。

BlueAeri

从日志看访问ZcQySyJbxx.zyfw（好像是注册企业基本信息.主营范围，：）猜测）数据列的时候有问题，那是text类型的，看看ASE的errorlog，有无相关错误信息或者dbcc检查ZcQySyJbxx表。

xdd

text字段这块还有什么特殊设置吗

BlueAeri

原帖由 xdd 于 2008-1-9 13:04 发表
text字段这块还有什么特殊设置吗

在创建复制定义的时候，确实需要对text，image数据类型的列特殊处理的，总不至于你还不知道哪个？看看下面的例子：

create replication definition pdb_BM_GZMBKHNR
        with primary at prs.pdb
        with all tables named "BM_GZMBKHNR"
(
        "LBBM"                        int,
        "MBXMBM"                int,
        "KHNRBM"                int,
        "KHNR"                        text null,
        "JBF"                        decimal,
        "YXQSRQ"                        int,
        "YXZZRQ"                        int
)
primary key("LBBM","MBXMBM","KHNRBM")
replicate_if_changed ("KHNR")
replicate minimal columns
go

[ 本帖最后由 BlueAeri 于 2008-1-9 20:53 编辑 ]

xdd

我这边做的是整库复制，如何对所有表text字段进行单独处理？请教楼上