Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Tuned Listener
Posts: 50
Registered: ‎02-09-2010

Remote DBS Views

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    

Copper Elite Contributor
Posts: 40
Registered: ‎03-31-2010

Re: Remote DBS Views

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.

 

 

 

James Sutton