Also verify the CONCAT_NULL_YIELDS_NULL at the DB level what it is set?Remedy set's it OFF.SET CONCAT_NULL_YIELDS_NULL OFFRegards,RavindrakumarOn Thu, Mar 22, 2018 at 9:32 AM, Ravindrakumar Rodge <ravirup24@gmail.com> wrote:Are there any triggers defined on the database. If so disable those and try.Thanks.Regards,RavindrakumarOn Thu, Mar 22, 2018 at 7:22 AM, Harsh <chaudharyh5@gmail.com> 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/orWe 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-2dfb1a20b56c43dcb13 b1ba0cd4ad72a',C530032500=0,C5 30060100=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
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
--
--
--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist