Duplicated records when duplicating a company in Ax2009

Discussion:

(too old to reply)

Mark Furrer

2009-05-25 09:21:01 UTC

Dear all,

Two of our customers with an Ax2009 installation (without service packs,
without any hotfixes installed) have independently encountered the same
problem:

They used the standard function to duplicate an existing company via menu
item "Administration" --> "Company Accounts", function "Duplicate". After
that, the duplication process started and took a long time to finish. The
result of the duplication function was very unexpected. Following had happend:

- There was _no_ new company created
- Instead, the origin company, which should have been duplicated, contained
duplicated records in any of theses tables:
-- tables with _no_ unique index
-- tables with unique indeces that contain the RecId as a part of the
index (e.g. PriceDiscTable)
I'm saying that each record in these tables has been duplicated but a new
RecId for the duplicated record was generated.

We had to roll back the database to a place before the duplication process
had been started. In both cases this led to a significant outfall of the
productive system of the customer.

Unfortunately we were not able to reproduce this issue in a dedicated test
environment.

We have reported this issue to Microsoft. The answer we've got is like this:
- Duplication process has significantly changed in Ax2009
- This issue has not been reported by any other Ax partners
- There is no solution at the moment to fix that problem.

I can hardly imagine that this happend only to our customers so I would like
to know if any of you has expired the same problem and/or has any more
information regarding this.

I would be glad if you would share your experiences with me. Thanks alot.

Best regards,
Mark

PS: Our customers do not use any virtual tables, so this is a different
situation than described in KB 958261.

unknown

2009-09-16 17:55:01 UTC

Permalink

I have the same behavior at a customer location. A few tables has duplicate
data now ever since a duplicate of the company was made. (However, duplicates
from that company were successfully made before...)

We are running AX 2009 w/ SP1. We are also not using any virtual companies.

I'm still investigating and will try to reproduce the behavior.
--
Mathieu Vaillancourt
http://vaillancourtm.blogspot.com

Post by Mark Furrer
Dear all,
Two of our customers with an Ax2009 installation (without service packs,
without any hotfixes installed) have independently encountered the same
They used the standard function to duplicate an existing company via menu
item "Administration" --> "Company Accounts", function "Duplicate". After
that, the duplication process started and took a long time to finish. The
- There was _no_ new company created
- Instead, the origin company, which should have been duplicated, contained
-- tables with _no_ unique index
-- tables with unique indeces that contain the RecId as a part of the
index (e.g. PriceDiscTable)
I'm saying that each record in these tables has been duplicated but a new
RecId for the duplicated record was generated.
We had to roll back the database to a place before the duplication process
had been started. In both cases this led to a significant outfall of the
productive system of the customer.
Unfortunately we were not able to reproduce this issue in a dedicated test
environment.
- Duplication process has significantly changed in Ax2009
- This issue has not been reported by any other Ax partners
- There is no solution at the moment to fix that problem.
I can hardly imagine that this happend only to our customers so I would like
to know if any of you has expired the same problem and/or has any more
information regarding this.
I would be glad if you would share your experiences with me. Thanks alot.
Best regards,
Mark
PS: Our customers do not use any virtual tables, so this is a different
situation than described in KB 958261.

Ronny in Norway

2010-01-05 11:05:04 UTC

Permalink

Hi Mark,

Yes, we have exactly the same issue with a customer that did go live
December 2009. In fact, I could just paste in the reply from Mathieu above,
as we have experienced the exact same issue with AX 2009 SP1 without virtual
companies.

Additional notes:
- Some tables have 4 duplicates, others only 2. Possibly because the
'Duplicate' function have been run multiple times from the same source
company account..?
- We're still investigating, but so far it seems that duplicates are spread
over tables with very different TableIDs, and in those tables that have
duplicates not all records are necessarily duplicated (table content is only
partly duplicated).
- We thought that the problem was related to a termination of the
'Duplicate' function (as it took too many hours without completion given the
size of the company account being duplicated), but from the posts above I'm
no longer sure...

Our customer is experiencing severe problems now due to this.

pic8picard

2010-01-15 19:08:01 UTC

Permalink

We had the same problem when we went live at the end of November. For us it
was mostly the inventory transaction tables. Microsoft was no help at all
and denied there was a problem.

I've talked with one of the techies at our partner and he confirmed that he
had seen it in the field as well.

For us, it was basically left to me to find all the tables and I wrote
scripts to go in and clean out all the duplicates because were were already
live for days before it was discovered.

Paul

Post by Ronny in Norway
Hi Mark,
Yes, we have exactly the same issue with a customer that did go live
December 2009. In fact, I could just paste in the reply from Mathieu above,
as we have experienced the exact same issue with AX 2009 SP1 without virtual
companies.
- Some tables have 4 duplicates, others only 2. Possibly because the
'Duplicate' function have been run multiple times from the same source
company account..?
- We're still investigating, but so far it seems that duplicates are spread
over tables with very different TableIDs, and in those tables that have
duplicates not all records are necessarily duplicated (table content is only
partly duplicated).
- We thought that the problem was related to a termination of the
'Duplicate' function (as it took too many hours without completion given the
size of the company account being duplicated), but from the posts above I'm
no longer sure...
Our customer is experiencing severe problems now due to this.

Hellerup

2010-02-23 09:34:01 UTC

Permalink

Hi

We have experienced the exact same thing. We havent been able to reproduce
it though, but the user says the duplicationprocess failed.

/Martin

Post by pic8picard
We had the same problem when we went live at the end of November. For us it
was mostly the inventory transaction tables. Microsoft was no help at all
and denied there was a problem.
I've talked with one of the techies at our partner and he confirmed that he
had seen it in the field as well.
scripts to go in and clean out all the duplicates because were were already
live for days before it was discovered.
Paul

emad

2010-10-10 09:48:03 UTC

Permalink

Hi there everyone

i have exactly the same issue it turned to be a disaster as the latest
backup was taken a week before this duplicates and that means week work is
gone !!!!!!!!!!
i dont know why such behaviour happened !!!!!!!
i am doing a scripts to remove the duplicates from some tables but i know
thats not the solution please if any other solution exist inform me asap

thanks and regards