- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
You can use pkSequence for new schemas but you cannot use the API to switch from an old sequence to a new sequence.
This start only from 18.4 (build 8931). You will be able to use the API only after a build upgrade.
That being said, negative sequence should not be and issue. You may need to check your retention period in deployment wizard.
Adobe Campaign uses an ID sequence that has to be consumed accordingly: xtkNewId . If the sequence is consumed very quickly (i.e. from 100,000 per day), you must verify that it is consistent with your business requirements, such as sending millions of emails per day. It is possible to define a dedicated sequence for particular tables. You can also setup a workflow to monitor ID usage.
When the sequence reaches more than 2 billion (2,147,483,648 is the exact number), it goes back to zero. It must be avoided and creates issues, which is why this sequence must be monitored.
To prevent this with large tables, consider using a specific sequence. This can be done with the pkSequence attribute in the schema.
High-frequency workflows that create a lot of logs will consume a lot of IDs. So it is highly recommended to avoid too many logs and high frequencies in workflows.
If the sequence has already cycled, the best solution is to switch to negative IDs, starting from -2,147,483,648.
Thanks,
David
Views
Replies
Total Likes