Cannot create a record in Worker (WHSWorker). Worker xxxx xxxx, 14272. The record already exists.

(1) Share

Report

Posted on by renMike

Hello,

In my production environment I am attempting to create a new Warehouse management Worker record but after I select the user name and press the save button I get the reported error. I am able to create other Worker records, it's only this one that seems to be an issue.

By using the Table Browser URL I can see that a record for worker xxxx xxxx exists in the WHSWorker table but that same record is not visible in the corresponding client form. I suspect that the record was created during a previous attempt to create the Worker record but was then not successfully deleted.

From reading other threads on similar subjects I also attempted to check the Number Sequence for this entity but can't find it (don't know what to look for) and so am not able to confirm if this is an issue or not.

How can I create a Warehouse Worker record when an orphaned record already exists?

How can I delete a record from the (production) table if I can't see it in the client?

Thanks,

Mike

I have the same question (0)

All responses (3)

Answers (1)

Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Could it be an inactive worker, that's why you can't see it? check the vaildFrom and validTo fields

Was this reply helpful? Yes No
Verified answer

renMike 65 on at

Like (1)

Report

Thanks for your response to my call for help, but rather embarrassingly I think I now know the answer to my question - partially due to your help.

I went back into my production environment to check the validFrom and validTo fields as you suggest and in doing so I noticed that the worker record I was trying to create did already exist as a record. My earlier statement of "the same record is not visible in the corresponding client form" was inaccurate.

My apologies for wasting your time but you did help me to resolve this issue.

Was this reply helpful? Yes No
Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi renMike,

No worries. I'm glad your issue is fixed now :)

Was this reply helpful? Yes No

Join the conversation

Community site session details

Cannot create a record in Worker (WHSWorker). Worker xxxx xxxx, 14272. The record already exists.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Cannot create a record in Worker (WHSWorker). Worker xxxx xxxx, 14272. The record already exists.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates