We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK 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 the 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 the 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