[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Re: Getting error when creating/updating a CI.

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 <ravirup24@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.




Regards,
Ravindrakumar

On Fri, Mar 23, 2018 at 2:34 AM, Harsh <chaudharyh5@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 <ravirup24@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


Regards,
Ravindrakumar


On 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,
Ravindrakumar



On 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/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
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist




--
With Regards,
Ravindrakumar M Rodge
9028792208



--
With Regards,
Ravindrakumar M Rodge
9028792208

--
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




--
Thanks & regards
“Harsh Chaudhary”
"Impatience never commanded success"

Attachment: concat4.log
Description: Binary data