ForceSync not work on AL-GO

[AlexGesSw]

Hi,

when install the app manual in Business Central with Force Sync all fine, i have rename one table and now can't anymore deploy with AL-Go, it's that real?

Error:
"Unexpected error when running action. Error Message: Cannot synchronize the extension XXXX because it is already synchronized. Furthermore, the provided extension has a different set of tables and table extensions than the synchronized extension."

Any Solution for this?

Thx Alex

[aholstrup1]

Did you add SyncMode to your DeployTo setting? https://github.com/microsoft/AL-Go/blob/main/Scenarios/settings.md#deployto
The default SyncMode is 'Add'. If you set it to 'ForceSync', I'd assume it should work.

[AlexGesSw]

thx, but I had already tested

in .github/AL-Go-Settings.json and .AL-GO/settings.json

"DeployToSandbox": {
"EnvironmentName ": "Sandbox",
"continuousDeployment": false,
"SyncMode": "ForceSync"
}

Error: Unexpected error when running action. Error Message: Table 61103 XXXX:: The table 'XXXX' cannot be located. Removing tables is not allowed unless they

Is the Environment name correct for the docker container?

[nickgoddard777]

I've had this, I found we had a PTE for a customer that had been upgraded from NAV. We have a custom table that has 2 fields in the PK, one is a link to the Item Category table the code field in our table is Code[10] whereas in the Item Category table this is Code[20] (not sure if this has increased in size or whoever did our original dev got it wrong). I tried to increase the size but got the similar error although I changed the mode to ForceSync. I also tried obsoleteing the field and creatig a new one but couldn't as this would change the PK.

[aholstrup1]

Try setting skipUpgrade to true
http://aka.ms/algosettings#skipUpgrade

It looks like you've previously created a release in your repo where your table has the old name. By default, AL-Go will try to run an upgrade test on your latest released version. That upgrade seems to be what's failing at the moment.

[AlexGesSw]

Thx

[aholstrup1]

I assume that means it worked? 😄 If not, let us know.