Skip to main content
shikhat
shikhat
September 25, 2023
Question

Facing Issue in Record Sync-Unable to sync due to error in data source

  • September 25, 2023
  • 9 replies
  • 0 views

Hi All,

I am facing issue with record sync while writing dataset to the database table using write records.
This works fine if we sync record manually , data is inserted , we get the primary key back to the process. The record is a simple record with no relationship defined. Going through the community posts , this issue comes when we have BIGINT type of datatypes defined in the table. 
So need to verify how to solve this issue without changing primary key column from int8/BIGINT to INT, as we need to store the values greater than int4 range in the database. Is there any way to make this sync work?
Kindly guide.
Attaching the screenshot.

Thanks


9 replies

stefanhelzle0001
stefanhelzle0001
Brainy
September 25, 2023

Appian does not support integers with more than 4 bytes as of now. Making your fields larger will not help.

Maybe you can elaborate on your use case and we can support you in finding a solution.

peter.lewis
peter.lewis
Employee
September 25, 2023

Do you truly need it to be a BIGINT? That will mean you have more than 2 Billion rows you expect to store in the table. Like Stefan, I'm curious what your use case is.

If you truly need to use values that large, I would recommend using a text field instead of a BIGINT, since you could easily store much larger numbers in a text field.

shikhat
shikhatAuthor
September 26, 2023

Hi Peter,

We are dealing with an external Database where workflow information of multiple applications is being stored in one single common table, the data volume is expected to go beyond the int4 range , that is why the primary key is configured as int8 in database.  

Terms & ConditionsAccessibility statement