Re: Putdatabase Record - Value too large for column
Hi Mike, I do the same during the failures but it is hard to know which Column it is. We have around 90 columns and this error can occur to any of those fields. If the error message mentions about the column that would be really helpful to expand our size. Thanks, Asmath Sent from my iPhone > On Oct 26, 2020, at 7:32 AM, Mike Thomsen wrote: > > One way you might be able to get there would be to add a SplitRecord > on the failure relationship of the processor and have it loop its > output back to the processor so you can narrow down which record was > failing. > >> On Sun, Oct 25, 2020 at 1:58 PM KhajaAsmath Mohammed >> wrote: >> >> Hi, >> >> I am using putddabase record with json tree reader to insert data into >> database. This works great but is there a possibility to get column name in >> the error? I need to open the file and see the text to find out the column. >> >> putdatabaserecord.error >> SAP DBTech JDBC: Value too large for column: >> >> Displaying column name will be really helpful. Any suggestions? >> >> Thanks, >> Asmath >>
Re: Putdatabase Record - Value too large for column
One way you might be able to get there would be to add a SplitRecord on the failure relationship of the processor and have it loop its output back to the processor so you can narrow down which record was failing. On Sun, Oct 25, 2020 at 1:58 PM KhajaAsmath Mohammed wrote: > > Hi, > > I am using putddabase record with json tree reader to insert data into > database. This works great but is there a possibility to get column name in > the error? I need to open the file and see the text to find out the column. > > putdatabaserecord.error > SAP DBTech JDBC: Value too large for column: > > Displaying column name will be really helpful. Any suggestions? > > Thanks, > Asmath >
Putdatabase Record - Value too large for column
Hi, I am using putddabase record with json tree reader to insert data into database. This works great but is there a possibility to get column name in the error? I need to open the file and see the text to find out the column. putdatabaserecord.error SAP DBTech JDBC: Value too large for column: Displaying column name will be really helpful. Any suggestions? Thanks, Asmath