Cannot create a record in Employment (HcmEmployment).

(0) Share

Report

Posted on by Community Member

Whenever I am trying to insert a record in HcmEmployment table through a .csv file, it is giving following error in infolog.

Cannot create a record in Employment (HcmEmployment). Invalid value specified for 'Employment end date'. It cannot be greater than or equal to the 'Employment end date' of the first record.

I finally deleted all the records from HcmEmployment table and only tried to insert one record, but it is stikll showing the above error.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (0)

Suggested answer

Jesus R. ABASCAL 1,450 on at

Like (1)

Report

I think the trouble is in End Date field. Are you check the convertion is OK? Debug and check if value of date is correct.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Okay I will ask my colleague to check.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We are using following function

public static date convDate(str _date)

{

Date ret;

;

ret = str2date(_date, 213);

return ret;

}

Was this reply helpful? Yes No
Suggested answer

Jesus R. ABASCAL 1,450 on at

Like (0)

Report

If you have no records in the table, I think the date value can be wrong. So, you should set a breakpoint into the convDate function and check the return value (ret) is a correct date.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Okay Abascal I will check it.

Was this reply helpful? Yes No
Suggested answer

syed baber 11,633 on at

Like (0)

Report

Hi Mahesh,

In HcmEmployment table, there is a unique index on the following fields:

Worker, LegalEntity, ValidFrom and ValidTo. So while inserting records, make sure that you are not violating this index. Furthermore, this is a date effective table, so you need to make sure that ValidFrom and ValidTo dates doesn't overlap between two records. I think the date effective framework so some adjustments automatically and change ValidTo of new records based on the new value, but do verify after the records are inserted successfully.

Thanks,

Baber.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Baber. Do you have any code to import Employee data into dynamics using X++ like HCMWoker and so on.

The links we have in Google are very less like Krishnablogspot and all.

If possible please help.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

although focus should be to resolve original problem, despite here goes the code to create employee

community.dynamics.com/.../155550

you can extend it as per your need

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Sohaib I will check it. I don't know why Google is not displaying this search result .

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report

Hi Mahesh,

Why are you not using Data import export framework to import records into HcmWorker? The DIXF framework will take care of all validations.

Please let me know if you need any help related to that.

Thanks,

Baber.

Was this reply helpful? Yes No