DB sync fails after creating new data entity

(0) Share

Report

Posted on by maram fraij

the standard Applicant education entity is not public , so I try to create a copy of it and make it pubic the module was build successfully then try to sync the data base the below error is faced , how can I fix this issue ?

5102.Untitled.png

Categories:

Development / Customization / SDK

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report

Did you change data type on entity or table? Error is saying type conversion issue

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Make sure to change the label to something else if you haven't changed it and then try to sync.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (1)

Report

Hi Maram,

Like Sukrut mentioned, the label should be unique. But also the properties 'Public entity name' and 'Public collection name' should have unique values. These last two mentioned properties should differ from each other and should not be used on another data entity. If you have copied it and didn't change them, make them unique.

Was this reply helpful? Yes No
maram fraij on at

Like (0)

Report

I change the label and both 'Public entity name' and 'Public collection name' are already filled with unique values but still face the same issue

Was this reply helpful? Yes No
maram fraij on at

Like (0)

Report

I use the same staging table used in standard entity , Does this have any effect ??

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Try changing name of staging table to something different and then generate staging table again and see if that helps.

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

Create a copy of standard staging table and assign that in your custom entity. And also regenerate staging table by right clicking on the entity and then DB Sync. That should resolve your issue.

Was this reply helpful? Yes No
maram fraij on at

Like (0)

Report

I try to create a copy of staging table but the issue is not resolved.

Also I roll back in all of my work but the issue is not resolved event that the sync was performed successfully before I creating the entity, it there a way to know which object causing this error during the sync ?

Was this reply helpful? Yes No
maram fraij on at

Like (0)

Report

When I review the sync log I found the below errors:

Database synchronization completed (646948 ms). Errors found.

Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'WHSQtyOnLoadView(13531)' Exception: System.FormatException: String was not recognized as a valid DateTime.

The error actually in standards view WHSQtyOnLoadView which never touched and it ddoes not contain a date time field

Does any one have any idea to resolve this issue ?

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

Like (0)

Report

Hi Maram,

Try to first build all models and then perform the database synchronization. In some cases, this might help.

Was this reply helpful? Yes No