Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 621
  • Last Modified:

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

0
rkulp
Asked:
rkulp
  • 5
  • 4
1 Solution
 
CodeCruiserCommented:
I think the ports that Sync services are using are being blocked. Disable Norton and try it again.
0
 
rkulpAuthor Commented:
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?
0
 
CodeCruiserCommented:
Are you using any WCF?
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
rkulpAuthor Commented:
No
0
 
rkulpAuthor Commented:
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.
0
 
CodeCruiserCommented:
Try using the Process Monitor (google it) utility to see what resources (registry, file system, network ports) this program is trying to access.
0
 
rkulpAuthor Commented:
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
0
 
rkulpAuthor Commented:
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.
0
 
CodeCruiserCommented:
Glad to help :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now