x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 241 subscribers
  • Views 1566 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
17
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
WarrenH

SQL Replicator Missing Data until I stop and start

SUGGESTED
Posted By

Hi,

I've often noticed while running reports that data is missing on my SQL Server reports (through SQL Replicator). I start and stop the replicator (which appears to be running fine), and a short time later the data shows up. The data is sometimes several days old. Has anyone else run into this? To make sure I have everything, I almost have to stop and start it on a regular basis just to be safe.

Thanks,

Warren

Parents
  • 0
    SUGGESTED

    Warren - this was an issue for me as well.  The fix was to turn off LIVE replication and move to scheduled.  This results in "Near Realtime" data replication without the missing data points.

    Note that Sage Support can assist with this setup.  Pay attention to the size of your database and time necessary for replication. The setup documenation for the Task Scheduler will state that you terminate the task if lasting longer than 1 hour.  For me, that was not enough time.  You will want to monitor to ensure that the full database replication is completing prior to task temination.

    Hope this is helpful!

  • 0 in reply to Nathan Weise

    Excellent, thanks!

Reply Children

*Community Hub is the new name for Sage City