Hello,
E9.04.507A
I'm using replication server to copy the data in all of the Epicor
tables to SQL Server.
I'm using UD14 to store the individual sales reps that are listed on a
sales order.
UD14 gets a lot of rows written and deleted.
When I look at this table in the management console, it regularly has
rejected rows and/or errors stating that it could not insert rows with
duplicate keys.
It seems like once there is an issue, the replicated table is no longer
in sync with the Epicor table.
If I query the Epicor table, all the data is there.
I'm force to regularly initialize UD14 to get all the records to
replicate.
Has anyone else encounter this?
It makes me wonder if I have other tables with this problem.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
E9.04.507A
I'm using replication server to copy the data in all of the Epicor
tables to SQL Server.
I'm using UD14 to store the individual sales reps that are listed on a
sales order.
UD14 gets a lot of rows written and deleted.
When I look at this table in the management console, it regularly has
rejected rows and/or errors stating that it could not insert rows with
duplicate keys.
It seems like once there is an issue, the replicated table is no longer
in sync with the Epicor table.
If I query the Epicor table, all the data is there.
I'm force to regularly initialize UD14 to get all the records to
replicate.
Has anyone else encounter this?
It makes me wonder if I have other tables with this problem.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]