September 3, 2009 at 3:29 pm
In Replication Monitor I'm getting 'Subquery returned more than 1 value' on only one of my subscribers. There are many subscribers to this publication but only one is getting this message.
Is there any way to find out and skip the specific DML that is causing the issue. This is transactional replication.
September 9, 2009 at 12:59 pm
Come to find out - one of the subscribers had been updated so that the REPL command would in fact the subquery became invalid returning multiple rows instead of a single.
September 10, 2009 at 12:24 pm
You do not have primary key set up in the subscriber?
But you found out the problem.... 🙂 I had no idea why you should get it because transactional replication works with primary keys. So there is no chance of getting more than one row returned..
-Roy
September 10, 2009 at 12:37 pm
actually the problem was that the DML was trying to do a subquery that worked on all of the other subscribers because they had not been updated. It didn't have anything to do with the PK. The PK was fine. The column in question was not the PK. Thanks for response though.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply