Cannot create a record in Hierarchies (Hierarchy). Hierarchy ID: XXXXXX The record already exists.

(0) Share

Report

Posted on by Rony.rivero

Hi all,

I'm trying to copy projects between legal entities, and I can't copy one in particular. I receive this error: Cannot create a record in Hierarchies (Hierarchy). Hierarchy ID: XXXXXX The record already exists.

Any idea what could it be?

Thanks in advance

I have the same question (0)

All responses (8)

Answers (0)

André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (0)

Report

RE: Cannot create a record in Hierarchies (Hierarchy). Hierarchy ID: XXXXXX The record already exists.

Hi Rony,

What exact procedure/functionality are you using to copy the projects?

Was this reply helpful? Yes No
Rony.rivero 67 on at

Like (0)

Report

RE: Cannot create a record in Hierarchies (Hierarchy). Hierarchy ID: XXXXXX The record already exists.

Hi André,

I'm using the "Copy into legal entity" functionality".

Thanks

Was this reply helpful? Yes No
André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (0)

Report

RE: Cannot create a record in Hierarchies (Hierarchy). Hierarchy ID: XXXXXX The record already exists.

Hi Rony,

I'm missing the information which exact data entity or entities you are using and if you copy into one or multiple legal entities at once.

Is it only failing for one particular project or several or all projects?

Was this reply helpful? Yes No
Rony.rivero 67 on at

Like (0)

Report

RE: Cannot create a record in Hierarchies (Hierarchy). Hierarchy ID: XXXXXX The record already exists.

Hi André, it happens only with a project... I was trying to copy Projects entity to one legal entity.

Was this reply helpful? Yes No
Gaurangkumar Jani 4,514 User Group Leader on at

Like (0)

Report

RE: Cannot create a record in Hierarchies (Hierarchy). Hierarchy ID: XXXXXX The record already exists.

Hi Rony,

Do you have any workflow with Hierarchy in Project?

Thanks,

Was this reply helpful? Yes No
Rony.rivero 67 on at

Like (1)

Report

RE: Cannot create a record in Hierarchies (Hierarchy). Hierarchy ID: XXXXXX The record already exists.

Hi Jani, not at all.

Was this reply helpful? Yes No
Cole Anderson 10 on at

Like (0)

Report

RE: Cannot create a record in Hierarchies (Hierarchy). Hierarchy ID: XXXXXX The record already exists.

Did you ever find the solution to this? It seems like the system keeps trying to use the same Hierarchy ID number sequence while increasing the project ID number sequence. I've tried resetting/editing the number sequence to no avail.

Was this reply helpful? Yes No
YuriiRask 7 on at

Like (0)

Report

RE: Cannot create a record in Hierarchies (Hierarchy). Hierarchy ID: XXXXXX The record already exists.

yes its a number sequence issue - resetting pre-allocation (on/off) resolves this problem for any load scenario

Was this reply helpful? Yes No