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
select count(*) from sysreferences where frgndbname ='db3'
delete from sysreferences where frgndbname ='db3'

Now, resume the replication connection.

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.