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

Re: Error message while building SLAs. "The statement has been terminated.String or binary data would be truncated. (SQL Server 8152)"



** 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 <chetan.wagh@VYOMLABS.COM>
To:        arslist@ARSLIST.ORG,
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)" <arslist@ARSLIST.ORG>




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_