Nectari Ideas

Suggest an idea
Suggest an idea What would make Nectari Software more useful to you?
upload_file Add image
8
Datasync partition options
datasync
Under review April 25, 2025

We are using the partition feature of DataSync on the X3 table GACCENTRYA. The partition is based on CREDATTIM_0 field which is the creation datetime of the line. We recently discovered that when modifying a journal entry in X3, lines in GACCENTRYA are not updated but they are deleted and created again with a new CREDATTIM_0. This lead to have duplicate lines in GACCENTRYA on the replicated database for lines where the old CREDATTIM_0 and the new one are in different partitions. We have 2 problems : 1) The data in this case are duplicated therefore wrong info in the reports based on this table 2) An error in the process deleted records of the table because of duplicate keys. We suggest one of the following options : 1) Add a feature to use a partition on fields other than datetime fields, for example partition by company. 2) Add an option to set the partition for ranges of dates (between 2 values) instead of number of days.

2 Comments
Thanks for your feedback
lightbulbSuggest a new feature
News Ideas