复制服务器返回10050错误，紧急求助

XMDT

ion: default)
I. 03/28 11:27:50. <1.5> [ml_user]: ODBC isolation set to: Read Committed
I. 03/28 11:27:50. <1.5> [ml_user]: COMMIT Transaction: begin_connection
I. 03/28 11:27:50. <1.5> [ml_user]: COMMIT Transaction: begin_synchronization
I. 03/28 11:27:50. <1.5> [ml_user]: COMMIT Transaction: end_upload
E. 03/28 11:27:50. <1.5> [ml_user]: Error: [-10050] First
I. 03/28 11:27:50. <1.5> [ml_user]: Error Context:
I. 03/28 11:27:50. <1.5> [ml_user]: User Name: ml_user
I. 03/28 11:27:50. <1.5> [ml_user]: Modified User Name: ml_user
I. 03/28 11:27:50. <1.5> [ml_user]: Transaction: download
I. 03/28 11:27:50. <1.5> [ml_user]: Table Name: tttt
I. 03/28 11:27:50. <1.5> [ml_user]: Script Version: default
I. 03/28 11:27:50. <1.5> [ml_user]: Script: SELECT DEVICEID,DEVICETYPE FROM tttt_DELETED
                    WHERE last_modified >= ?
I. 03/28 11:27:50. <1.5> [ml_user]: End of Error Context
W. 03/28 11:27:50. <1.5> [ml_user]: Warning: [10010] No handle_error script is defined.  The default action code (3000) will decide the error behavior
I. 03/28 11:27:50. <1.5> [ml_user]: ROLLBACK Transaction: end_download
I. 03/28 11:27:50. <1.5> [ml_user]: COMMIT Transaction: end_connection
I. 03/28 11:27:50. <1.5> [ml_user]: Disconnected from consolidated database
I. 03/28 11:27:50. <1.5> [ml_user]: Synchronization failed




tttt表
CREATE TABLE tttt
(
        ID INTEGER DEFAULT GLOBAL AUTOINCREMENT(100000000) NOT NULL,
        DEVICEID VARCHAR(256) PRIMARY KEY ,
        DEVICETYPE INTEGER DEFAULT 0  

)





中心服务器添加的脚本如下：

//tttt资源与设备类型匹配表 32
//download_delete_cursor
call ml_add_table_script( 'default', 'tttt',
'download_delete_cursor',
'SELECT DEVICEID,DEVICETYPE FROM tttt_DELETED
WHERE last_modified >= ?' )
;

//end_download_deletes
call ml_add_table_script( 'default', 'tttt',
'end_download_deletes',
'delete FROM tttt_DELETED' )
;

//upload_update
call ml_add_table_script( 'default', 'tttt',
'upload_update',
'SELECT DEVICEID,DEVICETYPE FROM tttt
WHERE DEVICEID=? and DEVICETYPE=?' )
;

//download_cursor
call ml_add_table_script( 'default', 'tttt',
'download_cursor',
'SELECT DEVICEID,DEVICETYPE
  FROM tttt' )
;

//upload_insert
call ml_add_table_script( 'default', 'tttt',
'upload_insert',
'INSERT
  INTO tttt( DEVICEID,DEVICETYPE )
VALUES( ?, ? )' )
;

//upload_delete
call ml_add_table_script( 'default', 'tttt',
'upload_delete',
'DELETE  FROM tttt
WHERE DEVICEID=?,DEVICETYPE=?' )
;



//tttt资源与设备类型匹配表 32
CREATE TABLE tttt_DELETED (
        DEVICEID integer,
        DEVICETYPE integer,
        last_modified DATETIME DEFAULT TIMESTAMP
);

CREATE TRIGGER b_d_tttt
  BEFORE DELETE ON tttt
  REFERENCING OLD AS oldrow
  FOR EACH ROW
BEGIN
INSERT INTO tttt_DELETED ( DEVICEID,DEVICETYPE )
VALUES( oldrow.DEVICEID,oldrow.DEVICETYPE );
END
;

[ 本帖最后由 XMDT 于 2008-3-28 10:27 编辑 ]