Can you please check the users and issuewatchers tables for duplicates?

Hi Mark,

No duplicates in the Users table, but there is no issuewatchers table??!?

I have actually been through all existing tables looking for duplicates, but didn't find any.

Cheers,

Julian

Sorry, reverse the name: watchissue table.

To get the email addresses we use the gemini_getusersforissuealert stored procedure, it might worth running it passing in a project and issue ids.

OK, run some tests......

No duplicates in watchissue table, however I am getting multiples coming out of the stored procedure.

If I run it against the database for one issuse and I get 1444 results for myself (watchcode 959).  On another issue I get 64 results for one person and then one result for another (both watch code 1024).

We only have 308 items in the WatchIssue table and 10 users.

Stepping through the stored procedure geminigetusersforissuealert, it is all apparently working fine until we get to the final part of the querying:

    select a.userid,a.watchcode,a.emailaddress,isnull(b.svalue,N'H') as emailformat,isnull(c.svalue,N'Y') as emailmyself
        from #temp3 a
        left outer join (select userid,svalue from usersettings where sname=N'emailformat') b on b.userid=a.userid
        left outer join (select userid,svalue from usersettings where sname=N'email_myself') c on c.userid=a.userid

Changing it to select DISTINCT seems to resolve the problem.

Does that make any sense?

Cheers,

Julian

Have you got duplicates in the usersettings table?

Possibly, I can't tell what is in the tstamp column.  Looking at the other columns there are a number of entries that match.

You can ignore the timestamp column. Due have duplicates?

Yes, a few.

In the end I have deleted them all out and got the users to reset their preferences, this seems to have resolved the problem.

Thanks.