000026754 - RSA Archer: DB jobs fails with an error 1934

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000026754
Applies ToRSA Archer
Microsoft SQL Server version 2008 and 2012
IssueWhile creating a DB job to delete a table, the job fails with the error 1934 shown in the job history. The complete error will be as follows

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] (Error 1934).  The step failed.
This can happen to any delete script.
Example: delete tblIVCalcErrorData
If we run the same query, instead of the job, it works fine
 
ResolutionTo fix this, modify the job to contain the following commands:

SET QUOTED_IDENTIFIER ON
Delete tblIVCalcErrorData
           GO
SET QUOTED_IDENTIFIER OFF
NotesFor more information on QUOTED_IDENTIFIER http://msdn.microsoft.com/en-IN/library/ms174393.aspx
Legacy Article IDa67717

Attachments

    Outcomes