The value 'xx' in field 'Leave type' is not found in the related table 'Leave types'

(0) Share

Report

Posted on by Mantas Vysniauskas

Hi All,

I'm facing crazy issue. When I'm trying to select from lookup Leave type from HcmLeaveTypes table. System popup message:

0361.Capture.JPG

The main point this record exist by that RecId. I tried to create a job with simple:

select LeaveType where leaveType.RecId == 5637146076;

But it is also not finding. Sometimes it's working, sometimes it's not. Sometimes helps to clear cache. Sometimes not.

I don't know where could be an issue... But it is cache issue.

Client and Server versions are the same.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Abbas Ithayathullah 175 on at

Like (0)

Report

RE: The value 'xx' in field 'Leave type' is not found in the related table 'Leave types'

Hi Mantas,

Could you share the lookup method code from the form or table?

It will help us to resolve this issue.

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

Like (0)

Report

RE: The value 'xx' in field 'Leave type' is not found in the related table 'Leave types'

Hi Mantas,

Are you able to reproduce this in another (standard)environment? If so, there might be a bug. Then you can search on LCS issue search for a possible known issue. Otherwise it might be caused by a customization or incorrect database synchronization.

Was this reply helpful? Yes No
Mantas Vysniauskas on at

Like (0)

Report

RE: The value 'xx' in field 'Leave type' is not found in the related table 'Leave types'

This issue is not only on lookup. The system is not finding record even from simple job

Was this reply helpful? Yes No
Mantas Vysniauskas on at

Like (0)

Report

RE: The value 'xx' in field 'Leave type' is not found in the related table 'Leave types'

For now it is just for TEST environment. It's looks like a record lock. But not sure.

Was this reply helpful? Yes No
Abbas Ithayathullah 175 on at

Like (0)

Report

RE: The value 'xx' in field 'Leave type' is not found in the related table 'Leave types'

Hi,

Recently if you updated any CU, please do application compilation using AXBuild and then Try to synchronize the DB and do full CIL may work.

Br Abbas

Was this reply helpful? Yes No