Sage Construction & Real Estate

I had a KB that described the process of deleting the replicated database(s) from the SQL server (compnaydata, izenda, etc) to start from a clean slate, can anyone point me to this KB. Thanks V

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…

I have several clients that use Sage 300 CRE and I need to help them install and set up the Sage 300 SQL Replicator. If you are an independent consultant with experience installing the replicator, please contact me as soon as possible.

We just installed SQL Replicator and previously used Anterra Datacenter. The table PRM_MASTER__EMPLOYEE_TAX has a field called Tax_ID that, when using Anterra, held Tax ID's like FED, MED, MED_E, etc. Now, using SQL Replicator, that has changed to a long…

Hey everyone, First time poster here because we are in desperate need for assistance. Here's the rundown... - We had been using Sage 17.1 for 2 years until Nov. 2019. With it, we have the SQL Replicator running all the time, and though "Scheduled…

So I am trying to switch over to using System Administrator to do the backups (we just started using SQL Replicator) and the first back up failed because someone left Sage open at their desktop and I got an error about Master.qlm being open. This will…

Hello, I am being asked about the viability of using Sage SQL Replicator to push out a SQL copy of our Sage 300 CRE data to a SQL Server hosted in a different part of the country over a VPN. I know Sage is very anti-VPN when it comes to Sage 300CRE…

We found an issue re: Windows Tasks not running on Server 2016, but the solution provided does not seem to fix this issue. The article is https://social.technet.microsoft.com/Forums/windowsserver/en-US/fb7dd1b0-f7dd-40fb-839d-2e58816c1e68/server-2016…

I am having an issue with a Crystal Report that I have pulling the data from the SQL replicated data. The data pulls when I run the report in both Crystal Reports and also when I run from within Sage from any of our companies. Upon having a user try and…

I am seeing very high CPU usage for the SQL Replicator. I'm only replicating 5 of my databases and it is causing over 80-90% CPU usage. The SQL Server in on a different server and is running ok. The Sage VM has 4 processors and 32 GB of RAM. There is…