'SymmetricDS and Postgres with UUID primary key failed (invalid input syntax for type uuid)

I am using Postgres 11 and SymmetricDS 3.9.14.

I have a database table with primary key of UUID type. It seems like SymmetricDS is not able to cast 'UUID' correctly. One of SymmetricDS replication query is failing with the below error 

JdbcSqlTemplate - SQL caused exception: [select "id" from "dbo"."groups" where "id"=?] 
sql args: [ ] 

org.postgresql.util.PSQLException: ERROR: invalid input syntax for type uuid: " "

my insert statement :- 

INSERT INTO dbo.groups(
    id, sortorder, name, hidden, sessionid, creationtime, modificationtime, regionid)
    VALUES ('5A171D3F-F6A6-4D09-AE89-73B5793DA171', 1, 'abc', false, null,'2018-11-20 20:25:49.663', null, null);

my database table is :- 

CREATE TABLE dbo.groups
(
    id uuid NOT NULL,
    sortorder integer NOT NULL DEFAULT 0,
    name character varying(80) COLLATE pg_catalog."default",
    hidden boolean NOT NULL DEFAULT false,
    sessionid uuid,
    creationtime timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    modificationtime timestamp without time zone,
    regionid uuid,
    CONSTRAINT "PK_dbo.Groups" PRIMARY KEY (id)
)

EDIT:

My source database is MS SQL Server and target database is Postgres

postgresqlsymmetricds


Solution 1:[1]

The value of UUID in this case is a space or tab as it could be seen from the error message

invalid input syntax for type uuid: " "

Try finding why instead of the concrete UUID value this space/tab value is passed

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Boris Pavlović

Related Questions