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"
