SmartList Capability table must built erro

(0) Share

Report

Posted on by Community Member

Upgraded GP 2010 TP GP2013 during GP launch ask to run smartlist and gets error "A get\change first operation ontable. 'ASI_MSTR_Explorer_Favorites' failed accessing SQL data. Number if results columns doesn't match table definition

*This post is locked for comments

All responses (2)

Answers (0)

Community Member on at

Like (0)

Report

RE: SmartList Capability table must built erro

I've ran into this once before and it was fixed by going to Microsoft Dynamics GP>>Maintenance>>SQL. Set your Product to SmartList, select all objects, and check the Drop Auto Procedure and Create Auto Procedure and click process.
Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

RE: SmartList Capability table must built erro

Do you have custom written SmartLists (ie SmartList Builder) that are structured against a view? If so, you may need to edit these custom views to match the new database.