Hi Ravindra, I have also checked the same and it is set to OFF.
Regards, Harsh On Thu, Mar 22, 2018 at 8:04 PM, Ravindrakumar Rodge <raviru...@gmail.com> wrote: > 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 OFF > > > https://docs.bmc.com/docs/ars91/en/viewing-database- > audit-records-609073965.html > > Regards, > Ravindrakumar > > > On Thu, Mar 22, 2018 at 9:32 AM, Ravindrakumar Rodge <raviru...@gmail.com> > wrote: > >> 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 <chaudhar...@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/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,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 >>> >>> >> >> >> -- >> With Regards, >> Ravindrakumar M Rodge >> 9028792208 <(902)%20879-2208> >> > > > > -- > With Regards, > Ravindrakumar M Rodge > 9028792208 <(902)%20879-2208> > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > -- *Thanks & regards* *“Harsh Chaudhary”* *"Impatience never commanded success**"*
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
