Skip to Content
0

data upload error [#1, SQL-403] internal error

Jul 17, 2017 at 04:32 PM

24

avatar image

Good day,

When I try to upload a large csv file from the front end it does not complete however the data is uploaded into the table.

I purged the same table, transferred the file to the server then ran the import command(IMPORT FROM '/upload/test.ctl';).

The back end process fails each with the error [#1, SQL-403] internal error.

below is the content of the control file

import data into table "SCHEMA"."table" from 'test.csv' record delimited by '\n' field delimited by ',' optionally enclosed by '"'

both files are in the same directory.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers