```target--redshift--shopify | File ".meltano/load...
# troubleshootingm
monika_rajput
08/13/2021, 5:56 PM Copy code
target--redshift--shopify | File ".meltano/loaders/target--redshift--shopify/venv/lib/python3.8/site-packages/target_postgres/postgres.py", line 309, in write_batch target--redshift--shopify | raise PostgresError(message, ex) target--redshift--shopify | target_postgres.exceptions.PostgresError: ('Exception writing records', InternalError_("Load into table 'tmp_190d2350_5b40_416a_a1db_50db8bf50556' failed. Check 'stl_load_errors' system table for details.\n")) meltano | Loading failed (1): target_postgres.exceptions.PostgresError: ('Exception writing records', InternalError_("Load into table 'tmp_190d2350_5b40_416a_a1db_50db8bf50556' failed. Check 'stl_load_errors' system table for details.\n")) meltano | ELT could not be completed: Loader failedf
florian.hines
08/13/2021, 5:59 PMIf you peek at stl_load_errors on your redshift instance, its usually pretty good about telling you why the load failed.
e
edgar_ramirez_mondragon
08/13/2021, 6:00 PMI've seen that before when there is a type mismatch or error, e.g. a string longer than the char limit of the target column admits. Like @florian.hines said, querying
stl_load_errorsf
florian.hines
08/13/2021, 6:00 PMm
monika_rajput
08/24/2021, 5:36 PMHello @florian.hines @edgar_ramirez_mondragon Thank you for replying
monika_rajput
08/24/2021, 5:38 PMIt is saying that string length exceeds, where i have to change to resolve this error
monika_rajput
08/24/2021, 5:49 PM@tom_mcgrail @edward_ryan @kai_yokoyama
e
edward_ryan
08/24/2021, 6:04 PM@monika_rajput I can help with this
edward_ryan
08/24/2021, 6:04 PMyou need to update the table DDL
edward_ryan
08/24/2021, 6:04 PMcurrently the column length is too small
@tom_mcgrail can do this
edward_ryan
08/24/2021, 6:06 PM@monika_rajput you will also need to expand default column width in the redshift target