Issue with DSO - PostgreSQL Unique ID Field

DaveDave 💎
edited June 23, 2020 in Questions
HI

Version 12.2.19

We have a DSO with our PostgreSQL DB, and in one of the tables (named transactions) a field named Transaction_Id (integer) which is 19 Characters and is completely unique in the DB.

When it gets to SF through the DSO this id's last 3 digits are always rounded to 000 but in DB they are ending in 001, 002, 003

If I reduce field to be 17 or less Digits all work fine. 

And the problem is now that skuid sees those are not unique, it kind of skips transactions and creates me all other sort of data issues

I had first spoken to Rob about this, and he's the one that explained the duplicate issue. But been investigating since, and found the culprit!

Can anyone please help with this very weird issue?

Thank you

Comments

  • Hi David, sorry for the delay here.

    It sounds like you're using Skuid's data source object to handle the Postgres-Salesforce connection, correct?

    I'm working on reproducing this scenario in one of our environments and will let you know what I discover.

  • Hey Anna,

    No worries, in the mean time we changed that field to use a mix of letter and numbers and reduces length and now works fine.

    But yes we use SKUID DSO to handle connections with our DB on PostgreSQL

    But a fix may be nice for other users or possibly other future use for us

    Thank you for following up

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!