error migrate from ms sql to postgres

Hi, Dmitriy!

i am trying to convert from MS SQL to Postgres, and I get the following errors:

22: ((LAMBDA NIL :IN LPARALLEL.KERNEL::MAKE-WORKER-THREAD))
23: ((LAMBDA NIL :IN BORDEAUX-THREADS::BINDING-DEFAULT-SPECIALS))
24: ((FLET SB-UNIX::BODY :IN SB-THREAD::RUN))
25: ((FLET "WITHOUT-INTERRUPTS-BODY-11" :IN SB-THREAD::RUN))
26: ((FLET SB-UNIX::BODY :IN SB-THREAD::RUN))
27: ((FLET "WITHOUT-INTERRUPTS-BODY-4" :IN SB-THREAD::RUN))
28: (SB-THREAD::RUN)
29: ("foreign function: call_into_lisp_")
30: ("foreign function: funcall1")

2023-07-24T10:38:40.259393Z NOTICE COPY adress.settlement_type with 0 rows estimated [3/4]
2023-07-24T10:38:40.259660Z DEBUG Reader started for adress.settlement_type
2023-07-24T10:38:40.260177Z DEBUG start adress.settlement_type   15569096
2023-07-24T10:38:40.260311Z INFO Stopping monitor

What I am doing here?

The value
  #.(SB-SYS:INT-SAP #X7F4FF801C898)
is not of type
  VECTOR

Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN

the error always happens on the table Adress.SettlementType (what is remarkable - this table contains only 9 rows)

my config file:

LOAD DATABASE
    FROM mssql://***
    INTO pgsql://***

WITH snake_case identifiers, create tables, create indexes, create schemas, include drop, foreign keys, reset sequences, batch rows = 500

SET work_mem to '256MB', maintenance_work_mem to '512 MB'

BEFORE LOAD DO
    $$ CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; $$
;

my freedts config file:


[global]
    tds version = 7.4
    client charset = UTF-8

full log: pgloader.zip

what am I doing wrong?

dimitri / pgloader

error migrate from ms sql to postgres #1512