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

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



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"