Can you capture API,SQL,FLTR logs and reproduce the issue. Did you also check with restarting of DB services once? What is the DB configuration set. SNAPSHOT ISOLATION & IS_READ_COMMITTED_ON at DB level.
https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=kA214000000d6dhCAA&type=Solution Regards, Ravindrakumar On Fri, Mar 23, 2018 at 2:34 AM, Harsh <chaudhar...@gmail.com> wrote: > 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 > > -- With Regards, Ravindrakumar M Rodge 9028792208
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist