List Index

Kanishq17
Community Boss

List Index

Hi  Community , 

 

Wanted to ask if anyone encountered a case of list index exceeding limit of 1 billion for a numbered list which lead to items not adding to the list due to that and what is the workaround for it

Kanishq17_0-1621607865053.png

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: List Index

@Kanishq17 

 

1 billion mark is not only for Numbered list - that holds true for General List as well.

 

Having said that, Right now you are at 5.25 million which means if you are deleting the list and then reloading it all over again on a daily basis it will reach 1 billion in around 200 days. You should NEVER delete the list and reload it, there are other ways to deal with it if there is a need to wipe out the data.

 

Solution: Once you are close to the billion mark RESET button next to "Item Index" gets activated. You can use that to force Anaplan to reset the numbering.

 

Misbah

View solution in original post

5 REPLIES 5
abhay.kanik
Regular Contributor

Re: List Index

@Kanishq17 

Index is just an ID for the items in numbered list, the items in list should not exceed a billion.  Only case where I can see this limit is getting reached is uploading a lots of transactional data. I recommend to delete old data which might be not required. or else there is only option to create another list.

In short - Don't worry about index, keep number of item in list less than a billion

 

Thanks

Abhay

Kanishq17
Community Boss

Re: List Index

hi @abhay.kanik 

 

Tried that but new items are added in numbered list from the next index even if items are deleted 

 

abhay.kanik
Regular Contributor

Re: List Index

@Kanishq17 

Index number can go more than a billion, The numbers of items i.e. Item count should be less than a billion.

Misbah
Moderator

Re: List Index

@Kanishq17 

 

1 billion mark is not only for Numbered list - that holds true for General List as well.

 

Having said that, Right now you are at 5.25 million which means if you are deleting the list and then reloading it all over again on a daily basis it will reach 1 billion in around 200 days. You should NEVER delete the list and reload it, there are other ways to deal with it if there is a need to wipe out the data.

 

Solution: Once you are close to the billion mark RESET button next to "Item Index" gets activated. You can use that to force Anaplan to reset the numbering.

 

Misbah

View solution in original post

Kanishq17
Community Boss

Re: List Index

Thanks Misbah for this