I am installing Extender on GP2010, it installs fine, while using utilies to update the company databases, it errors out on table EXT40101: Invalid Column Name 'WINNAME'. I checked the table, there is not column named WINNAME. Can I drop the table and utilies will create new one or can I import the table from Fabrikam?
Thanks,
Meg
*This post is locked for comments
Hi Meg,
I was able to fix the problem... somehow the structure of the tables must have changed over the time and there is a SQL script that has been released by eOne (the builder of Extender) to fix those errors. The script basically recreates all the SP's attached to some of the EXT tables and renames also some columns. Here's an extract of the portion about renaming the columns :
/*Rename Columns in EXT40800 and EXT40801 */
if exists (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'EXT40800' AND COLUMN_NAME = 'PT_Palette_ID')
exec sp_rename 'EXT40800.PT_Palette_ID', 'Extender_Menu_ID', 'COLUMN'
GO
if exists (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'EXT40800' AND COLUMN_NAME = 'PALETNME')
exec sp_rename 'EXT40800.PALETNME', 'Extender_Menu_Name', 'COLUMN'
GO
if exists (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'EXT40801' AND COLUMN_NAME = 'PT_Palette_ID')
exec sp_rename 'EXT40801.PT_Palette_ID', 'Extender_Menu_ID', 'COLUMN'
GO
/*End Rename Columns in EXT40800 and EXT40801 */
Hope this helps other stuck with the GP2010 Extender update.
Hi Meg,
I'm facing a similar problem when upgrading the company DB's from GP10 to GP2010... Extender is installed, but when the GP Utilities runs thru the companies, it fails to upgrade with a table from Extender EXT40801 / PT_Extender_Menu_Items. It gives an SQL error about an invalid column name 'Extender_Menu_item', but that table doesn't even have that field.
Did you ended up to find a solution to your problem ? I remember having had a similar problem with Extender's table EXT40800 & EXT40801 when applying SP5 to GP10 last year, because one company was not gone thru an SP4 , but never managed to fix the problem.
For now I'll try to ignore the error, but not sure if my upgrade process will continue or not.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (