Regarding ID field in servicenow table with default value

[keerthikonduru]

We have  a table in servicenow , In which a column Id is present and whose default value is Get Next Number. can i know the reason why this field is getting duplicates in table even after taking next number?

[Mark Manders]

Not without telling us more.

Is the value set to be unique? Is the next number really the next number (check 'number maintenance'). If, for instance, you already have (old) record in the 10000 range and your 'number maintenance' states that the next number is 7658, you will get the same numbers once you reach that.
Also, importing records from other instances through xml import will just generate duplicates. But we don't know what is happening or what kind of tables you are talking about.

[keerthikonduru]

[keerthikonduru]