Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Error while updating table

Joon
Regular Contributor II
Regular Contributor II

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.

Joon_0-1700535808539.png

Could you guys give me any comments one this ?

4 REPLIES 4

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

Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Joon
Regular Contributor II
Regular Contributor II

Hello @rushikeshvartak ,

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

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


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Joon
Regular Contributor II
Regular Contributor II

Got it. Thanks Rushikesh