Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Problem with indexed views and SF_RefreshIAD

We are having issue when trying to refresh from salesforce when we create an indexed view from our replicated tables.. error is below... we have 'QUOTED_IDENTIFIER' set to on in our view scripts and we are using the current version of dbamp.. This was not an issue before we upgraded to the current version of dbamp. Any ideas? Thanks

--- Ending SF_RefreshIAD. Operation successful. [SQLSTATE 01000]
Msg 1934, Sev 16, State 1, Line 1 : DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. [SQLSTATE 42000]
Msg 0, Sev 16, State 1, Line 27 : --- Starting SF_RefreshIAD for Contact V3.5.1 [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 210 : 21:06:02: Using last run time of 2017-09-19 20:02:00 [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 274 : 21:06:02: Identified 2 updated/inserted rows. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 417 : 21:06:02: Adding updated/inserted rows into Contact [SQLSTATE 01000]
Msg 50000, Sev 16, State 1, Line 507 : --- Ending SF_RefreshIAD. Operation FAILED. [SQLSTATE 42000]
Msg 0, Sev 16, State 1, Line 504 : --- Ending SF_RefreshIAD. Operation FAILED. [SQLSTATE 01000]
1 person has
this question
+1
Reply