The logs you posted is client side workflow logs. You would get details in server side API,SQL, logs. As this setting is something related to DB. You will find more information about it in SQL logs. So you should capture API,SQL,FLTR logs at server side and look for the error.
Regards, Ravindrakumar On Fri, Mar 23, 2018 at 5:16 AM, Harsh <chaudhar...@gmail.com> wrote: > Hi Ravindra, > > As this is specific to CI's and we are not getting the same issue while > creating updating incident, problem or change therefore this doesn't seems > to be related with the database. > > I already went through the logs but didn't got much information. > > Regards, > Harsh > > On Fri, Mar 23, 2018 at 3:34 PM, Ravindrakumar Rodge <raviru...@gmail.com> > wrote: > >> 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?sfdc >> id=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-re >>>> cords-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 <(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
