Sybase replication thread down due to cross-database referential constraint

9 Aug, 2020

Sybase replication thread down due to cross-database referential constraint

Error Description:

    Message from server: Message: 435, State 1, Severity 16 -- 'Database 'db3' is not available.  The 'delete' statement will not be executed because the cross-database referential constraint on table 'table1' cannot be enforced. Contact your System Administrator about.

Steps to be followed for fixing this issue.

we need to delete sysreferences for that particular database to resume the thread.
login to target database ASE2.db2

use db2
go
select count(*) from sysreferences where frgndbname ='db3'
go
delete from sysreferences where frgndbname ='db3'
go

Now, resume the replication connection.