Avoid duplicate documents

View member feedback to this tip.

Have you ever wondered why the replication and save conflicts get converted to duplicates? Or why one of the duplicates has child(response) documents and the other duplicates do not?

Well, if there are any replication and save conflicts in your database and you have run either @Command([ToolsRefreshAllDocs]) or @Command([ToolsRefreshSelectedDocs]) then all of the replication and save conflicts will get converted into a duplicates and only one of the duplicate records will have the response docs.

So always make sure that you have removed all of replication and save conflicts before you run any refresh agent/code.

MEMBER FEEDBACK TO THIS TIP

I was actually searching all sorts of things to find out the problem of duplicate documents, which was hard to detect. This tip has helped to find the reason and solution for the problem and saved lot of time. Thanks to the tip contibutor and SearchDomino.com.

—Vijay G.

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip exchange by member Anuj Puri. Please let others know how useful it is via the rating scale at the end of the tip. Do you have a useful Notes/Domino tip or code to share? Submit it to our monthly tip contest and you could win a prize and a spot in our Hall of Fame.

Rate this Tip To rate tips, you must be a member of SearchDomino.com. Register now to start rating these tips. Log in if you are already a member. Digg This!     StumbleUpon     Del.icio.us    RELATED CONTENT Other Create a dynamic user-driven navigator for a Notes/Domino application How to apply XSL style sheets to XML views Comparing replicas on clustered Lotus Domino servers Creating a Lotus Notes view column categorized by month Using the XMLHTTP object for integration with Domino or any RDBMS back end Hiding field properties/data from DocProperties box Export a view to Excel without coding Prevent document deletion if there are response documents Switching between test IDs quickly AddParameter to a NotesXSLTransFormer Lotus Notes Domino Replication and Synchronization LotusScript agent automates selective mail file replication Give external users access to workflow-based Notes Domino applications Tivoli Directory Integrator synchronizes Notes Domino 8 directories Use DXL utilities for advanced replication settings in Notes Avoid replication issues when editing Lotus Notes response documents Use LotusScript to create encrypted replicas Lotus Notes Domino replication primer More efficient local Lotus Notes database replication BlackBerry Intellisync error: 'A Lotus Notes error has occurred. Please see log for details.' Setting up local replication of a Lotus Notes database for offline employees RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.