The replicated database is suspended, each time that record is added to the database

Hello,

I defined replication definition and subscription to table name rss_user
and each time
the i insert record to this table the replicated database is getting to
suspend and the
following message appear at the replication error log :

"I. 1999/11/03 15:45:20. A grouped transaction of 2 individual
transactions has failed in database 'REPSYB.essdb'. Each transaction in
the group will be executed individually.
E. 1999/11/03 15:45:20. ERROR #1028 DSI EXEC(103(1) REPSYB.essdb) -
dsiqmint.c(2774)
        Message from server: Message: 90102, State 1, Severity 16 --
'UPDATE: Integrity violation on table `rss_user'.
Primary key `(rss_user_name rss_name rss_type)' with value `testrs6
NT-TLV69 WinNT' may not be updated.'.
H. 1999/11/03 15:45:20. THREAD FATAL ERROR #5089 DSI EXEC(103(1)
REPSYB.essdb) - dsiqmint.c(2793)
        The DSI thread for database 'REPSYB.essdb' is being shutdown.
DSI received data server error #90102 which is mapped to
STOP_REPLICATION. See logged data server errors for more information.
The error was caused by line #18 of stored procedure 'TRU_rss_user' on
the data server mapped from input command #2 (or a command before it) of
the failed transaction.
I. 1999/11/03 15:45:20. The DSI thread for database 'REPSYB.essdb' is
shutdown."

Another facts:
1) I looked for more error messages at the data server log but there was
nothing regards it.
2) I did previously the same definition to other tables and it ended
successfully without any error messages.
3) The new record is replicated after the datbase is out of suspended by
using the resume connection command.

Does any one has any idea why this error might occur ?
How can i look at the stored procedure 'TRU_rss_user' to see exactly
what this function include ?

Thanks In Advanced,
Smadar.



0
ofer
11/3/1999 4:17:37 PM
sybase.rep-server 2969 articles. 1 followers. Follow

1 Replies
709 Views

Similar Articles

[PageSpeed] 41
Get it on Google Play
Get it on Apple App Store

As the message says, your replicated transaction contains an UPDATE
statement which tries to set some value which violates a referential
integrity constraint. When an error occurs, the DSI is suspended - this is
normal RepServer behaviour.
You need to find out exactly what's happening; use the RepServer command
"sysadmin log_first_tran" to dump the transaction; check out why it doesn't
work - run sp_helpconstraint onn the updated table. Also takes possible
actions by update triggers into account.

HTH,

Rob

--
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase ASE 11.5 Administrator (Professional)
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:rob@sypron.nl.*No*Spam*Please*
WWW http://www.euronet.nl/~syp_rob
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

ofer Cohen wrote in message <38206021.CF216ABF@telaviv.ndsoft.com>...
>Hello,
>
>I defined replication definition and subscription to table name rss_user
>and each time
>the i insert record to this table the replicated database is getting to
>suspend and the
>following message appear at the replication error log :
>
>"I. 1999/11/03 15:45:20. A grouped transaction of 2 individual
>transactions has failed in database 'REPSYB.essdb'. Each transaction in
>the group will be executed individually.
>E. 1999/11/03 15:45:20. ERROR #1028 DSI EXEC(103(1) REPSYB.essdb) -
>dsiqmint.c(2774)
>        Message from server: Message: 90102, State 1, Severity 16 --
>'UPDATE: Integrity violation on table `rss_user'.
>Primary key `(rss_user_name rss_name rss_type)' with value `testrs6
>NT-TLV69 WinNT' may not be updated.'.
>H. 1999/11/03 15:45:20. THREAD FATAL ERROR #5089 DSI EXEC(103(1)
>REPSYB.essdb) - dsiqmint.c(2793)
>        The DSI thread for database 'REPSYB.essdb' is being shutdown.
>DSI received data server error #90102 which is mapped to
>STOP_REPLICATION. See logged data server errors for more information.
>The error was caused by line #18 of stored procedure 'TRU_rss_user' on
>the data server mapped from input command #2 (or a command before it) of
>the failed transaction.
>I. 1999/11/03 15:45:20. The DSI thread for database 'REPSYB.essdb' is
>shutdown."
>
>Another facts:
>1) I looked for more error messages at the data server log but there was
>nothing regards it.
>2) I did previously the same definition to other tables and it ended
>successfully without any error messages.
>3) The new record is replicated after the datbase is out of suspended by
>using the resume connection command.
>
>Does any one has any idea why this error might occur ?
>How can i look at the stored procedure 'TRU_rss_user' to see exactly
>what this function include ?
>
>Thanks In Advanced,
>Smadar.
>
>
>


0
Rob
11/3/1999 5:50:32 PM
Reply: