CSV append failed due to data being "out of range"
A user tried to upload data to Yellowfin with the csv uploader. When they uploaded the file they got a generic useless "Oh no! An error has occurred during processing, please try again later".
When I looked into the logs I found that the real error was "Error: java.sql.BatchUpdateException: Data truncation: Out of range value for column" and when I checked the table, the column was decimal(5,0) when the data in the newer file was (8,2). Is there a way to enable Yellowfin to dynamically change the column size during append or is the Yellowfin .csv import useless for files with variable field sizes?
|Operating System:||Windows Server 2012 R2 6.3 (amd64)|