Bulkloader error message loading to S3

Question

Hi,

Using the bulkloader, I'm trying to update a Redshift table...but get the following error:

Any ideas?

Output Data (23) The COPY failed with error: [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR:  Load into table 'subscriptionattributiontl' failed.  Check 'stl_load_errors' system table for details.¶  Last entry in stl_load_errors: 1207, Invalid digit, Value 'e', Pos 0, Type: Double

Thanks,

John

JohnBell · Answer

@MichaelF 
@BrandonF

Thanks guys!

To follow up...Brandon had mentioned that it might be a "permission issue", and I did notice that I didn't have access to the table that this query was pulling from.  I was helping the owner out and updated the S3 Access/secret keys with the new keys without any issue.  The scheduled workflow was running fine. But, for some reason later in the week I got the above error.

Bottom line, the owner went ahead and updated the workflow with new keys and the workflow has been running fine since.

Thanks again,

John

MichaelF · Answer

Hi @JohnBell

At first glance, the error message seems to be referencing record 1207, with perhaps some improper characters. I would investigate around that area in your data and try uploading just single rows to see if you can narrow down exactly what's causing the issue.

Cheers,

Mike