MSSQL to PostgreSQL : Error mapping Numeric

[EricPawlik]

Hello !

Airbyte throws an exception trying to map Decimal(24,6) values from MSSQL Server to a PostgreSQL database.

Stack Trace: org.postgresql.util.PSQLException: ERROR: invalid input syntax for type numeric: ""24.700000"" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:335) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:321) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:292) at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) at io.airbyte.cdk.db.jdbc.JdbcDatabase.lambda$executeWithinTransaction$1(JdbcDatabase.java:57) at io.airbyte.cdk.db.jdbc.DefaultJdbcDatabase.execute(DefaultJdbcDatabase.java:47) at io.airbyte.cdk.db.jdbc.JdbcDatabase.executeWithinTransaction(JdbcDatabase.java:54) at io.airbyte.cdk.integrations.destination.jdbc.typing_deduping.JdbcDestinationHandler.execute(JdbcDestinationHandler.java:141) at io.airbyte.integrations.base.destination.typing_deduping.TypeAndDedupeTransaction.executeTypeAndDedupe(TypeAndDedupeTransaction.java:39) at io.airbyte.integrations.base.destination.typing_deduping.DefaultTyperDeduper.lambda$typeAndDedupeTask$2(DefaultTyperDeduper.java:256) at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) at java.base/java.lang.Thread.run(Thread.java:1583)

Source : latest Microsoft SQL Server (MSSQL) v3.6.1 community
Destination : latest Postgres v2.0.1 community

How can I avoid this error, do I have to make my custom mapper/connector to control type conversion ?
Thank you so much for your help ;)

Best regards,
Eric

[EricPawlik]

It is fixed by upgrading Airbyte and connectors 👍
AirByte 0.57.2
source : Microsoft SQL Server (MSSQL) v4.0.9
destination : Postgres v2.0.9