Hi Ravindra, We don't have any triggers written on database. Also we also checked the form definition and it is also accurate.
Regards, Harsh On Thu, Mar 22, 2018 at 8:02 PM, Ravindrakumar Rodge <[email protected]> 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 <[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 <(902)%20879-2208> > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > > -- *Thanks & regards* *“Harsh Chaudhary”* *"Impatience never commanded success**"*
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
