Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Tuned Listener
Tuned Listener
nvosper
Posts: 50
Registered: ‎02-09-2010

Remote DBS Views

‎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    

Report Inappropriate Content
Message 1 of 2 (2,039 Views)
0 Kudos
Highlighted
Copper Elite Contributor
Copper Elite Contributor
jameswsutton
Posts: 40
Registered: ‎03-31-2010

Re: Remote DBS Views

‎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.

 

 

 

James Sutton
Report Inappropriate Content
Message 2 of 2 (2,012 Views)