Avatar

Community Advisor

Yes, it will create a new sequence called NeoCustomId in your sequence table which is XtkNewId.

I'm assuming that you have Schemas created with autopk but not specifying sqlSequence.

 

If you have a recent build (starting from 18.4) of ACC you should be covered.

This feature is implemented through a new API: GenCreateOrUpdateSchemaSequenceDDL.

This API generates the SQL script used to create or update autopk schema sequence:

GenCreateOrUpdateSchemaSequenceDDL(schemaID, newSequenceName, oldSequenceName)

  • schemaID (mandatory): "<nameSpace>:<schemaName>"
  • newSequenceName (mandatory): new sequence name
  • oldSequenceName (optional): old sequence name

 

example: GenCreateOrUpdateSchemaSequenceDDL("cus:contacts", "myContactsSeq", "XtkNewId")

 

In this case, the new sequence will begin from the largest ID of the schema.

 

Also please view webinar - Adobe Campaign Classic - Sequences Exhaustion for more insights

Thanks,

David