Error with SQLDelta syncing

[Ghislain Hachey]

The view AccreditationAuthorityGovtR fails

‌

[Brian Lewis]

I think the solution may be simply:

1. sync; ignore any errors
2. run common.afterschemaupgrade in the target database. this will recompile every view; so cached fields collections are updated
3. Sync Again

‌

Please resolve if this works for you

[Ghislain Hachey]

@Brian Lewis It does not.

It’s the space in column names causing issue. I’m even wondering how it works with you?! Maybe you have some sort of ignore space setting?

‌

[Ghislain Hachey]

I got it working by no ignoring spaces in my SQLDelta config as shown below.

‌