Hi Chetan, If you are also trying to put some special character in the name or somewhere in SLA it also fails sometime. Check that as well.
I hope this will help. Regards, SS On Thu, May 11, 2017 at 5:07 PM, Ben Cantatore <[email protected]> wrote: > ** Chetan, > > The issue seems to be due to too much being pushed into too small a > field. If you really need all those assignee groups, then edit the SYS: > ViewSelectionCompanyRoleMapping and modify the database field so the > input value of 255 is increased a bit more to support what's being pushed > in. > > > > > From: Chetan <[email protected]> > To: [email protected], > Date: 05/11/2017 10:49 AM > Subject: Error message while building SLAs. "The statement has > been terminated.String or binary data would be truncated. (SQL Server 8152)" > Sent by: "Action Request System discussion list(ARSList)" < > [email protected]> > ------------------------------ > > > > I am trying to create a SLA and which I have created successfully but when > I am clicking on built button I am getting error message "The statement has > been terminated.String or binary data would be truncated. (SQL Server > 8152)". > > I tried investigating the logs and found that some data is getting > truncated by SQL and which is throwing a warning, but ARS is picking that > warning as a error message. > > The SQL+FLTR+API logs are as : > > */ Start filter processing (phase 1) -- Operation - GET on Application > Pending - 000000017548728 > <FLTR> <TID: 0000009624> <RPC ID: 0002002040> <Queue: Admin > > <Client-RPC: 390600 > <USER: Remedy Application Service > > /* Wed May 10 2017 14:17:51.3450 */ End of filter processing (phase > 1) -- Operation - GET on Application Pending - 000000017548728 > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3450 */OK > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3450 */UPDATE T1202 SET > C500012800=0,C5='test.user',C6=1494422271 WHERE C1 = '000000000002335' > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3450 */OK > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3450 */UPDATE T1202 SET > C500048900=0,C5='test.user',C6=1494422271 WHERE C1 = '000000000002335' > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3450 */OK > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3450 */UPDATE T1204 SET > C500070700=0,C500070400=0,C500070300=0,C500048200='Data > Event',C500048100='Event',C500047400='',C490021100='HPD:Help > Desk',C490000400='SLM01417_MeasReqAssoc_DE_SubmitModifyMerge',C2=' > appadmin',C5='test.user',C6=1494422271 WHERE C1 = '000000000002258' > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3450 */OK > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3450 */UPDATE T1267 SET C300543500=0,C60990='; > 1000001324;410;1000001338;410;1000001431;410;1000001516;410; > 1000001518;410;1000001536;410;1000001339;410;1000001710;410; > 1000001713;410;1000001665;410;1000001729;410;1000001752;410; > 1000001777;410;1000001787;410;1000001817;410;1000001818;410; > 1000001814;410;',C112=';1000001324;410;1000001338;410; > 1000001431;410;1000001516;410;1000001518;410;1000001536;410; > 1000001339;410;1000001710;410;1000001713;410;1000001665;410; > 1000001729;410;1000001752;410;1000001777;410;1000001787;410; > 1000001817;410;1000001818;410;1000001814;410;;410;',C301450300='HPD:Help > Desk',C301387400=NULL,C301362600=NULL,C301270100='1000000560',C300375300=' > AG001A4BF124C8MJnWUw9zMCAA3oYA',C5='test.user',C6=1494422271 WHERE C1 = > '000000000001283' > <SQL > <TID: 0000009624> <RPC ID: 0002002041> <Queue: Admin > > <Client-RPC: 390600 > <USER: Remedy Application Service > > /* Wed May 10 2017 14:17:51.3600 */SELECT C1,C2,C3,C4,C5,C6,C7,C8,0, > C501,C502,C503,C504,C505,C506,C507,C508,C509 FROM T8 WHERE C1 = > '000000017549614' > <SQL > <TID: 0000009624> <RPC ID: 0002002041> <Queue: Admin > > <Client-RPC: 390600 > <USER: Remedy Application Service > > /* Wed May 10 2017 14:17:51.3600 */OK > <SQL > <TID: 0000009624> <RPC ID: 0002002041> <Queue: Admin > > <Client-RPC: 390600 > <USER: Remedy Application Service > > /* Wed May 10 2017 14:17:51.3600 */SELECT entryId,T0,U0,T1,U1,T2,U2,T3,U3 > FROM H8 WHERE entryId = '000000017549614' > <SQL > <TID: 0000009624> <RPC ID: 0002002041> <Queue: Admin > > <Client-RPC: 390600 > <USER: Remedy Application Service > > /* Wed May 10 2017 14:17:51.3600 */OK > <FLTR> <TID: 0000009624> <RPC ID: 0002002041> <Queue: Admin > > <Client-RPC: 390600 > <USER: Remedy Application Service > > /* Wed May 10 2017 14:17:51.3600 */ Start filter processing (phase 1) > -- Operation - GET on Application Pending - 000000017549614 > <FLTR> <TID: 0000009624> <RPC ID: 0002002041> <Queue: Admin > > <Client-RPC: 390600 > <USER: Remedy Application Service > > /* Wed May 10 2017 14:17:51.3600 */ End of filter processing (phase > 1) -- Operation - GET on Application Pending - 000000017549614 > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3600 */* WARNING * The statement has been > terminated.String or binary data would be truncated. (SQL Server 8152) > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3600 */ROLLBACK TRANSACTION > <SQL > <TID: 0000007660> <RPC ID: 0002001931> <Queue: Fast > > <Client-RPC: 390620 > <USER: test.user > /* > Wed May 10 2017 14:17:51.3600 */OK > > It looks like it is trying to update the table T1267 which is "SYS: > ViewSelectionCompanyRoleMapping" and on this form there are 2 fields > which are exceeding the length limit and which are causing the issue. 1st > field is 60990 and second one is 112 (Assignee Groups). > > The question is Am I correct and if yes, how I can resolve the issue as > from the logs it looks like it is a part of creating SLA filters which is > backend activity and I think I can not do anything with that. > > Please suggest. > > ____________________________________________________________ > ___________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > > "------------------------------------------------------ CONFIDENTIALITY > NOTICE: This e-mail, and any attachments thereto, is intended only for use > by the addressee(s) named herein and may contain confidential information. > If you are not the intended recipient of this e-mail, you are hereby > notified that any dissemination, distribution or copying of this e-mail, > and any attachments thereto, is strictly prohibited. If you have received > this e-mail in error, please permanently delete the original and any copy > of any e-mail and any printout thereof. Thank you for your compliance." > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
