You’re offline. This is a read only version of the page.
715
Hi,
I have tried recently to upgrade GP2013 to GP2016 in my production environment. However, after upgrading conversion of DYNAMICS file, i am getting this error. any help on this.
Regards
*This post is locked for comments
Before rebuilding the table try to set the "Synchronize=TRUE" flag in your DEX.ini file, then rerun GP Utilities. In all the cases I've seen this will resolve it. However if it still fails, then rebuild the table.
Thank you Leslie, You made my day......
Cheers
This has come up before. The answer was to recreate the table and repopulate. Here's Vady's answer:
There were couple of exceptions related to GP2015 R2 that I wished to share here. One would be discussed here and other one on the next post. After upgrading to GP2015 R2, while doing a routine testing, following error message was thrown while trying to open Smartlist: Full message as follows: Unhandled database exception: A get/change operation on table ‘ASI_MSTR_Explorer_Favorites’ failed accessing SQL data. Number of results columns doesnt match table definition. Number of results columns doesnt match table definition. EXCEPTION_CLASS_DB DB_ERR_SQL_DATA_ACCESS_ERR Debugging this error took me to the table Smartlist Favorites Master (ASIEXP81). Strange, however, that number of columns indeed matched. I remembered this issue happening in GP 10 and GP 2010. Suggested solutions were to run GRANT.SQL on all databases and changing ODBC provider to SQL Native Client . However, in my case, both were already done and confirmed. To avoid any further delay or issue(s), I decided to backup the records from ASIEXP81, recreate the table using GP SQL Maintenance and push the records back from the backup table. Resolution : Drop and create the table Smartlist Favorites Master (ASI_MSTR_Explorer_Favorites, ASIEXP81) using GP SQL Maintenance. Only that, I did not have to reinsert the records. When I opened the Smartlist after recreating the table, it automatically populated all records. Strange, again. But it worked. Word of caution : Always take backup before you do anything with the data. VAIDY Filed under: Uncategorized
08/01/15--22:31: Blog Post: GP2015 R2 Upgrade – “ASI_MSTR_Explorer_Favorites: Number of results columns doesn’t match table definition”
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (