Synchronization failed after Full build

(0) Share

Report

Posted on by Muthusamy

Hi All,

Its a development environment with the version of D365 10.5 with PU 29.

Environment is loaded with Demo data and having the extension package.

I have put the full build and there is no error. I am getting the error while doing synchronization.

Its Says to extend the string size of WHSDocumentRoutingLine table with 100 char. But, its a standard table has the field name "Printer" with the EDT as "name" with the string size of 60.

Please suggest what needs to be done.

Synch Error:

I have the same question (0)

All responses (10)

Answers (2)

Sukrut Parab 71,699 Moderator on at

Like (0)

Report

RE: Synchronization failed after Full build

Did you create any extension for name EDT and set string size to 100 ?

Was this reply helpful? Yes No
Muthusamy 4 on at

Like (0)

Report

RE: Synchronization failed after Full build

Hi Sukrut,

Yes, EDT Name is extended to the size of 100.

Actually, this extension was done in 8.1 version and it was worked fine. Then, I have applied the environment updates to D365 10.5 with PU29. It was done successfully. Then I have downloaded my code by connecting azure devops (VSTS) and put the full build with all referenced packages.. Build successfully completed. Then, I put the synchronization. i am getting the above mentioned error.

Thanks,

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

Like (0)

Report

RE: Synchronization failed after Full build

Did you try to revert it and then sync . I would revert it do sync and see what happens. After that make change again and do sync.

Was this reply helpful? Yes No
Muthusamy 4 on at

Like (0)

Report

RE: Synchronization failed after Full build

Hi Sukrut,

Yes, I have deleted the EDT extension and then put the full build and synchronization. Synchronization succeeded.

Then, I have created the EDT extension again and then put the full build. Full build done and there is no errors. Then, I put synchronization and it's failed. Again getting the same error.

Thanks,

Was this reply helpful? Yes No
Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report

RE: Synchronization failed after Full build

Hi Muthusamy,

Check the index created on WHSDocumentRoutingLine table, from the error message it looks like index is using the column 'PrinterName'. Try deleting this index, do synchronization and then add the index again.

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

Like (0)

Report

RE: Synchronization failed after Full build

Hi Muthusamy,

Can you try to do the synchronization without records in this table? But also try the suggestion from Vinit. A colleague had the same issue in the past, but I don't know if his field was also part of an index or not.

Was this reply helpful? Yes No
Muthusamy 4 on at

Like (0)

Report

RE: Synchronization failed after Full build

Hi Vinit and Andre,

Its a standard table and there is no records in table. Yes, PrinterName field was added in the index. When I try to delete that printer name field from the index, its asking the location to save. Because, we should not overwrite the standard table.

Do you want me delete through SQL ? or Please let me know, how to delete the index?

Thanks,

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

RE: Synchronization failed after Full build

Hi Muthusamy,

It is far from a normal procedure, but indeed try to delete the index or the field from the index in SQL. As this is a standard index, you can't change it in Visual Studio (models are locked for editing).

You can also try to relax the model restrictions using the documentation: docs.microsoft.com/.../refactoring-over-layering

Note that this last procedure is only allowing you to do overlayering for testing purposes and usually done when migrating overlayering from older versions to extensions in the current versions. It will not allow you deploying customizations containing overlayering to a production environment.

Was this reply helpful? Yes No
Verified answer

vinitgoyal2005 6,332 on at

Like (0)

Report

RE: Synchronization failed after Full build

Hi,

There are two things you can try:

1. delete the data from this table and then you will be able synchronize(hopefully) as suggested by Andre. (If you don't need this data)

2. you can delete the index from SQL and then try sync.

I do remember doing deletion from SQL but it was for custom table in past, theoretically it should work for your case as well.

note: Do not delete field from table because then you still get the error that field doesn't exists at the time of Sync, Because Sync tries to update the column and it doesn't exists.

Was this reply helpful? Yes No
Suggested answer

Muthusamy 4 on at

Like (0)

Report

RE: Synchronization failed after Full build

Hi Vinit & Andre,

Issue is solved by deleting the index directly through SQL and have done the synchronization. Its working fine.

Now, the PrinterName field size changed to 100.

Thanks all for the suggestion.

Also, faced the same issue in new azure environment when deploying the same package. Resolved it like in same way...

Thanks,

Was this reply helpful? Yes No