Skip to content


Smartlist Favorites missing

Jothikrishnan Narasimmaraj asked 4 years ago
We have upgraded from GP 2015 R2 to 2016 R2 mid last year, except one company XYZ. Then we upgraded the XYZ in Last month. Interim, we had several SmartList favorites created in XYZ , but they are missing now. I learnt that Smartlist favorites are stored on ASIEXP81 in DYNAMICS. When I looked at the table on Old DYNAMICS DB. I didn’t find it there either. Not sure if your version of SL Builder also stores in there along with Microsoft’s SL version ? If not, can you please advise on how to recover that.
Thanks for your help.
Jothikrishnan Narasimmaraj replied 4 years ago

To add to the above….When we upgraded it was also server migration. We had XYZ still on old sever until migration. When we upgraded we didnt move anything out from DYNAMICS Db.

Patrick Roth Staff replied 4 years ago

“Not sure if your version of SL Builder also stores in there along with Microsoft’s SL version ?”

Neither version does directly- when you create a Favorite in SmartList, that is 100% SmartList and not SLB that is saving the favorite.

So there wouldn’t be any different in where the Favorite data “lives” in either version of GP as that hasn’t changed in SmartList.

if you don’t see the records for the favorites on the ‘old dynamics db’, then that means someone deleted the smartlist in SLB at some point and so SLB would have deleted the smartlist in the ASI tables along with the favorite records that went with it.

My suggestion would have “restore the ASI* tables from the old database” but since they aren’t there currently – you’d have to find an old backup to pull them from.

Jothikrishnan Narasimmaraj replied 4 years ago

Hi Patrick,

Thank you very much for the clarifications. I was able to find it from the old backup and restore.

Best Regards,

Beat Bucher answered 1 year ago
Hi Pat,
What else is required aside of the ASIEXP81 & ASIEXP86 tables to get a ‘Favorite’ SL back again after a server migration.. Somehow during an upgrade & merger of 2 DYNAMICS instances, several Favorites got lost.. The records  are in the table and match the Company ID, but they are not showing up in the SL.. The SLB solutions were all exported and imported back into the new server.. but here we’re talking about regular SmartList Favorites.. 

If you would like to submit an answer or comment, please sign in to the eOne portal.