Can someone please remind me how to remove all the duplicate SmartList entries. Every single one is duplicated and if I add new favorite it appears twice. GP 2010.
*This post is locked for comments
Yes they are duplicated in that table. I will remove the duplicates. Thanks.
Hi Richard,
This is held in the ASIEXP81. If you query this table do you see duplicate records?
This is not the results of something returned by SmartList, this is the list of SmartList itself.
Hi Richard,
Does this happen on all Smartlist object or just BBF transactions?
Hi Richard,
What you are seeing indicates that there are "old" records in the table still that should have been removed by a previous update. When you look at the table, you will see two "master" records for each SmartList instead of just one. Generally one has a name and one has a number. You can use the following script to see it.
select * from DYNAMICS..ASIEXP81 where ASI_Favorite_Save_Level=0 and ASI_Favorite_Dict_ID=0 order by ASI_Favorite_Type
With the results from this, the valid records for 2010 would be the ones with the 280xx numbers in the ASI_Favorite_Name column. The others are invalid.
You can compare it to a new install of GP 2010 as well to see how they match up. After you figure out which ones are "invalid", you can certainly remove them. Just be sure you have a valid backup of the database before doing so.
This should take care of the duplicates.
Did you resolve this? We are having the same problem, but only on one workstation.
I had a similar situation with some Mfg smartlists a couple of years ago. It was only a dozen or 2 so I just manually edited the tables. I believe it was the ASIEXP81 table. If all are duplicated, I would probably contact Microsoft. It is an incident. but probably the quickest way to a solution.
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
Barb, I mean the entire folder structure is doubled. So under Inventory-Items for every Smartlist there is a double. When you run them they are the same Samrtlist.
Richard, do you mean that you are gettin duplicate entries within a smartlist? I am having trouble with that also.
Share
Report
75,848
All responses (
Answers (
