Error while updating table

[Joon]

Hello Team,

I was trying to disregard a pending approval on Hanarule with an enhanced query job.

here's what I put in the job.

SELECT '0' AS HANARULE__SENTFORAPPROVAL, h.hanarulekey as HANARULE__PRIMARYKEY from HANARULE h where h.hanarulekey=418;

and What I got is 

Error while updating table: HANARULE : Data truncation: Data too long for column 'SENTFORAPPROVAL' at row 1

I have checked the data type in the column but I can't find what I did wrong with this.

Could you guys give me any comments one this ?

[rushikeshvartak]

SELECT 0 AS HANARULE__SENTFORAPPROVAL, h.hanarulekey as HANARULE__PRIMARYKEY from HANARULE h where h.hanarulekey=418;

[Joon]

Hello @rushikeshvartak ,

Yes I also tried that, but it's same..

[rushikeshvartak]

Its better you reject request from UI to avoid request remain open in dependent workflow tables 

[Joon]

Got it. Thanks Rushikesh