10-31-2014 02:37 AM
Hi,
I'm cutting remote DBS on a 7.5.4 -8.1 upgrade, we have lots of views used by external systems but not Saleslogix. However even though these views aren't enabled the database creation attempts to validate them and obvioulsly it fails, usually to do with SQL syntax that the provider doesn't recognise.
Has anybody else found this and know what I can do to avoid?
Thanks
11-05-2014 02:22 PM
I think the problem is that it includes found objects by default. Attached is a screen shot of a view before enabling.
You could try enabling the view and then unchecking 'Sync this table' (this essentially sets the SECTABLEDEFS.OMNIDIRECTIONAL = 'F')
The remote cut routine should then ignore this view. (I think you would only need to do this for views which have problematic syntax for the SLX provider.