I am wondering if maybe dbr.import could be broken after the latest update(s)?
I have the simplest code possible and its not working, while before I have been using dbr.import without any problem.
CREATE PROCEDURE `sp_DBR_TestUpload`()
SELECT 'dbr.import.options', 'format', 'tab';
SELECT 'dbr.import', 'sp_DBR_SerialsScansUpload_do';
CREATE PROCEDURE `sp_DBR_SerialsScansUpload_do`(vLine varchar(50)) BEGIN INSERT INTO ssn.partserialsstagingupload (lineitem) VALUES (vLine); END
My table has only only column named lineitem which is varchar(50).
I upload a single column file (saved as tab delimited from Excel) with the following content:
and the screen message after upload looks like this:
Total rows Errors
Initially I thought indicating tab format of the file is now mandatory in options and added it, but it did not help.