Skip to content

Epicor Replication

August 20, 2012

We have just rolled out Epicor Enterprise ERP, it’s a great system and I highly recommend it.

We purchased a tool with it called XL Connect which is a third party product that allows you to view your ERP data in Excel.

The problem we have is that XL Connect requires SQL and SQL Reporting services and we run our Epicor system on Progress. So we had to setup replication between Progress and SQL, which worked fine for a while but then broke.

Here is how I fixed it

  1. Reset replication in Epicor, This clears the tempory replication table and all replication settings including the list of which tables you want replicated so make sure you write these settings down. To Reset go to Sys Mgmt -> Replication -> Replication System Maintenance -> Actions -> Reset.
  2. Shut down the Progress App and Database servers for the epicor instance you are working on.
  3. Record the settings of your Publisher and Subscriber in the Epicor Database Replication console.
  4. Delete your publisher and Subscriber in the Epicor Database Replication Console.
  5. Recreate your publisher and subscriber in the Epicor Database Replication Console.
  6. Start the Progress Database and App Servers
  7. Initialize your subscriber instance tables in Epi DB Rep Console.

Hopefully that should work, if you get errors there might be something wrong with Sonic or the Epi Database Rep Service.

Advertisements

From → Epicor

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: