Are there any triggers defined on the database. If so disable those and try.
https://communities.bmc.com/docs/DOC-88206 https://communities.bmc.com/docs/DOC-80610 Thanks. Regards, Ravindrakumar On Thu, Mar 22, 2018 at 7:22 AM, Harsh <[email protected]> wrote: > Hi Guys, > > We are getting SQL error while creating/updating any ci record in Remedy > 8.1 sp2. > > ARERR [552] The SQL database operation failed. : UPDATE failed because the > following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL'. > 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 > > We checked the filter and sql log but didn't find any relevant workflow > which can cause this error. > > */UPDATE T564 SET C8=N'Unigy360_Offering_excel1',C179=N'OI- > 2dfb1a20b56c43dcb13b1ba0cd4ad72a',C530032500=0,C530060100= > 40,C112=N';1000292803;1000000000;',C5=N'chaudhah',C6=1521714379 WHERE C1 > = N'000000004149295' AND ((C6 <= 1521714326) OR (C5 = N'chaudhah')) > <SQL > <TID: 0000000524> <RPC ID: 0000007657> <Queue: Fast > > <Client-RPC: 390620 > <USER: chaudhah > > <Overlay-Group: 1 > /* Thu Mar 22 2018 10:26:19.7740 */*** ERROR > *** UPDATE failed because the following SET options have incorrect > settings: 'CONCAT_NULL_YIELDS_NULL'. 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 > <SQL > <TID: 0000000524> <RPC ID: 0000007657> <Queue: Fast > > <Client-RPC: 390620 > <USER: chaudhah > > <Overlay-Group: 1 > /* Thu Mar 22 2018 10:26:19.7740 */ROLLBACK > TRANSACTION > > > -- > *Thanks & regards* > *“Harsh Chaudhary”* > *"Impatience never commanded success**"* > > > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > > -- With Regards, Ravindrakumar M Rodge 9028792208
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
