asked on

Microsoft Sync Framework Hangs

I have a program that synchronizes SQL Server CE with a SQL Server Express 2008 R2 database. It works fine on the Windows 7 computers and all but one Windows XP computer. On that computer, it hangs and I have no clue how to figure out what is causing the problem. The computer has Norton Internet Security on it. That may be the problem. We turned off the firewall and included the program in the "Allow" list but that did not help. The relevant code is attached. Suggestions on how to proceed will be greatly appreciated.

'Some setup

Partial Public Class LCCRMSSyncAgent
    
    Private Sub OnInitialized()
        LionsClubContacts.SyncDirection = Microsoft.Synchronization.Data.SyncDirection.Bidirectional
        Provider.SyncDirection = Microsoft.Synchronization.Data.SyncDirection.Bidirectional
        RecipientInformation.SyncDirection = Microsoft.Synchronization.Data.SyncDirection.Bidirectional
        Services.SyncDirection = Microsoft.Synchronization.Data.SyncDirection.Bidirectional
        ServicesRendered.SyncDirection = Microsoft.Synchronization.Data.SyncDirection.Bidirectional
        UDFCategories.SyncDirection = Microsoft.Synchronization.Data.SyncDirection.Bidirectional
        Users.SyncDirection = Microsoft.Synchronization.Data.SyncDirection.Bidirectional

    End Sub
End Class

'Lines that call the synchronization

     Dim LCCRMSSyncAgent As New LCCRMSSyncAgent
     Dim LCCRMSSyncStat As Microsoft.Synchronization.Data.SyncStatistics = LCCRMSSyncAgent.Synchronize()

Open in new window

Nasir Razzaq

I think the ports that Sync services are using are being blocked. Disable Norton and try it again.

rkulp

ASKER

CodeCruiser,

I agree and will have the user turn off Norton for testing. However, it cannot be turned off indefinitely. I have been unable to find which ports the framework uses. I will try with 1433. Do you know which ports are used?

Nasir Razzaq

Are you using any WCF?

rkulp

ASKER

rkulp

ASKER

We removed Norton Internet Security and the program still hangs when trying to synchronize. I'll be trying it on other XP computers to see if they hand also. At least one other XP computer worked fine.

ASKER CERTIFIED SOLUTION

Nasir Razzaq

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rkulp

ASKER

I used Process Monitor on the program. The results are in the attached file. In watching the procmon file, it turned out that I terminated the program too soon. It actually accomplished the synchronization in about 20 minutes, whereas on other computers, including XP computers, the process takes about 10 - 15 seconds. This computer is connected to the Internet via Hughes.Net satellite. We will take the computer to a cable hookup sometime next week as schedule permits and try again. Logfile.xls

rkulp

ASKER

Monitoring the process as it was running led us to the correct solution. Testing on a cable internet connection proved that the problem lay in the Hughes.net satellite not the program. Thanks for your help.

Nasir Razzaq

Glad to help :-)