I have a file import, that is working in Stage 1 that we use for Dev Testing, I have moved it to Stage 3 for UAT, but when the File import gets to the insert/update step I am presented with an error that says
This isn't the only one there are several like this with a different ID number.
We have the Auto PK as well as a self identified PK from our data set. This is the way Adobe set up them when we had out implementation.
They also advised us to go into Admin>ACX>Config>SQL Scripts> Mtn Custom Sequence (Mtn is our namespace we have for our custom schema's) The advised that the following would make it so that they do not run out of Primary Key numbers. This one below was set up already for us.