NM: Replica comparison results in -1 V1Status field is “Migration Date is Blank” (4316802)

Issue

When creating a replica using Note Migrator,  and the replication formula option in the settings document has “specify your own replication formula” checked and a replication formula is supplied. The administrator is never prompted to supply a date when creating the replicas.   When a replication comparison is run the results are all -1’s in the view columns. The replication process has happened and created the  replica.  When the document properties are view, the value of the V1Status field is “Migration Date is Blank” or "No migration date".

Solution

This limitation has been resolved in version 5.1

To resolve the following Replica Comparison Agent issue; "Migration date is blank".

We have updated code to place in the initialize part of the lotus script.

    Select Case settingsDoc.FormulaOption(0)
    Case "Specify My Own Formula":
        buildFormula = False
        If settingsDoc.RepFormula(0) = "" Then
            msg = Msgbox( "You have specified that you wish to use your own replication formula but a replication formula was not supplied in the settings document!", 0+48, "Exiting" )
            Exit Sub
           
        End If

1. Open the Notes Migrator.nsf database in Designer view.
2. Open Agents
3. You will need to update the following two agents;  2. Replication\1.Create Replicas & 2. Replication\7. Create R&R Replicas
4. Open the agent.
5. The following code fix will be placed in this agent.

' 16819 Prompt for a date

                  Set dialogDoc = New NotesDocument( db )

                  tmp = w.DialogBox("selectDate", True, True, False, False, False, False,"Select the Migration Date to use in the replication formula.",dialogDoc,True,False, True)        

                  'Make sure that cancel was not hit

                  If Not tmp Then Exit Sub   

                  Set migrationDate = New NotesDateTime( dialogDoc.StartDate(0) )

                  Set dialogDoc = Nothing

'16819 End

The code will be placed here on line 50(see the attached DE5039.png)

6. Save and close
7. Test Agent

We also found another issue with an alias name being the same, if you sort by alias you will see this, a simple rename of this alias is fine.  (see the attached screenshot “Alias.png”