ERROR on CONVERT([datetime],'1753-1-1',0) - converting from SQL Express

[abrahambruck]

• [ ] pgloader --version

pgloader version "3.6.3~devel" compiled with SBCL 2.1.11.debian ```

• [ ] did you test a fresh compile from the source tree? Yes

• [ ] did you search for other similar issues? Yes

• [ ] how can I reproduce the bug?

  Incude a self-contained pgloader command file.

  If you're loading from a database, consider attaching a database dump to your issue. For MySQL, use mysqldump. For SQLite, just send over your source file, that's easy. Maybe be the one with your production data, of course, the one with just the sample of data that allows me to reproduce your bug.

  When using a proprietary database system as a source, consider creating a sample database on some Cloud service or somewhere you can then give me access to, and see my email address on my GitHub profile to send me the credentials. Still open a public issue for tracking and as documentation for other users.

--
-- EDIT THIS FILE TO MATCH YOUR BUG REPORT
--

LOAD DATABASE
FROM mssql://User:<pwd>@172.21.240.1:1433/Braway
INTO postgresql://postgres:<pwd>@host.docker.internal:49153/postgres
 with include drop, create tables, create indexes, reset sequences,
      workers = 2
set work_mem to '16MB', maintenance_work_mem to '512 MB';

• [ ] pgloader output you obtain

![image](https://user-images.githubusercontent.com/30836926/182044534-b3a6f6d4-bd86-42de-8290-b4929004e2c6.png)

• [ ] data that is being loaded, if relevant

PASTE HERE THE DATA THAT HAS BEEN LOADED

• [ ] How the data is different from what you expected, if relevant

[abrahambruck]

the result of this: $ pgloader --debug config > pg_loader_debug_config.log is attached. But it also, showed this on the screen:

abruck@CONL-MP26AJRX:~$ pgloader --debug config > pg_loader_debug_config.log 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 KABOOM! FATAL error: The value #.(SB-SYS:INT-SAP #X7F00680219E0) is not of type VECTOR Date/time: 2022-07-31-17:03! An unhandled error condition has been signalled: The value #.(SB-SYS:INT-SAP #X7F00680219E0) is not of type VECTOR

Backtrace for: #<SB-THREAD:THREAD "main thread" RUNNING {1000DD4103}> 0: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE-TO-STREAM #<SB-IMPL::STRING-OUTPUT-STREAM {1007560003}>) 1: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE #<TYPE-ERROR expected-type: VECTOR datum: #.(SB-SYS:INT-SAP #X7F00680219E0)> :OUTPUT NIL :IF-EXISTS :APPEND :VERBOSE NIL) 2: ((FLET "H0" :IN PGLOADER::MAIN) #<TYPE-ERROR expected-type: VECTOR datum: #.(SB-SYS:INT-SAP #X7F00680219E0)>) 3: (SB-KERNEL::%SIGNAL #<TYPE-ERROR expected-type: VECTOR datum: #.(SB-SYS:INT-SAP #X7F00680219E0)>) 4: (ERROR #<TYPE-ERROR expected-type: VECTOR datum: #.(SB-SYS:INT-SAP #X7F00680219E0)>) 5: (LPARALLEL.KERNEL::UNWRAP-RESULT #) 6: ((:METHOD PGLOADER.LOAD:COPY-DATABASE (PGLOADER.SOURCES:DB-COPY)) #<PGLOADER.SOURCE.MSSQL:COPY-MSSQL {100923E813}> :ON-ERROR-STOP T :WORKER-COUNT 2 :CONCURRENCY 1 :MULTIPLE-READERS NIL :MAX-PARALLEL-CREATE-INDEX NIL :TRUNCATE NIL :DISABLE-TRIGGERS NIL :DATA-ONLY NIL :SCHEMA-ONLY NIL :CREATE-SCHEMAS T :CREATE-TABLES T :INCLUDE-DROP T :DROP-SCHEMA NIL :CREATE-INDEXES T :INDEX-NAMES :UNIQUIFY :RESET-SEQUENCES T :FOREIGN-KEYS T :REINDEX NIL :AFTER-SCHEMA NIL :DISTRIBUTE NIL :INCLUDING NIL :EXCLUDING NIL :SET-TABLE-OIDS T :ALTER-TABLE NIL :ALTER-SCHEMA NIL :MATERIALIZE-VIEWS NIL) [fast-method] 7: ((LAMBDA ())) 8: (PGLOADER:RUN-COMMANDS #P"/home/abruck/config" :START-LOGGER NIL :FLUSH-SUMMARY T :SUMMARY NIL :LOG-FILENAME NIL :LOG-MIN-MESSAGES NIL :CLIENT-MIN-MESSAGES NIL) 9: (PGLOADER::PROCESS-COMMAND-FILE ("config") :FLUSH-SUMMARY T) 10: (PGLOADER.MONITOR::CALL-WITH-MONITOR #<FUNCTION (LAMBDA NIL :IN PGLOADER::MAIN) {1006F114BB}>) 11: (PGLOADER::MAIN ("pgloader" "--debug" "config")) 12: ((LAMBDA NIL :IN "/build/pgloader-84qaOu/pgloader-3.6.3/dumper-2SKVI5f7.lisp")) 13: ((FLET SB-UNIX::BODY :IN SB-IMPL::START-LISP)) 14: ((FLET "WITHOUT-INTERRUPTS-BODY-3" :IN SB-IMPL::START-LISP)) 15: (SB-IMPL::START-LISP)

Max connections reached, increase value of TDS_MAX_CONN

What I am doing here?

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

abruck@CONL-MP26AJRX:~ pg_loader_debug_config.log $