Anchit Pancholi

Many Thanks Josh for explain it in detail, i will try to implement the same.

use_stream_lobs was enable so i disabled it and run the application again. So this time postgres (corp side ) error is resolved but new error is occuering at store side (MSSQL) org.jumpmind.db.sql.SqlException: Conversion failed when converting from a char acter string to uniqueidentifier. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplat e.java:302) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplat e.java:291)) when i looked in sym_incoming_error table...

I am also having same design for multi-tenant application, and looking for solving same issue. please let me know if you find any solution to deal with this problem.

in my case i am using UUID's as primary key and foreign key.

in my case i am using UUID as primary key and foreign key as well.

Thanks Larry for providing you input on this. you mean to say i need to change implementation of IDdlBuilder of mssql and postgres sql ( for both database ? ). https://github.com/JumpMind/symmetric-ds/blob/b917fde35be0c06bfd1a8fa15fa7767e18f8e772/symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDmlStatement.java change should be part of appendColumnParameter, appendColumnEquals method in above class ? Please help me with further guidance as i will be working in SymmtricDS...

I am trying to replicate MS SQL Server 2014 to Postgres 11 with 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: " " Postgres understand UUID as binary data as SQL...

i have corp and store database, i have setup configuration to replication bi-directional, but when start corp node and then start store node. i am seeing lots of logs , seems like its running in loop. Corp Log :- [corp-1] - ConfigurationChangedDataRouter - About to refresh the cache of nodes because new configuration came through the data router [corp-1] - RouterService - Routed 5 data events in 49 ms [corp-1] - PullUriHandler - 5 data and 3 batches sent during pull request from store:2:2 [corp-1]...