2016 Install error: Get/Change on EXT_Table_Cache: Invalid object name DYNAMICS.dbo.EXT90106
A get/change operation on table EXT_Table_Cache cannot find the table
In More Info:
Invalid object name ‘DYNAMICS.dbo.EXT90106’.
In SQL Profiler, I see two statements:
exec DYNAMICS.dbo.zDP_EXT90106SS_2 3107,’EXT_Extender_Forms’
SELECT TOP 25 PRODID,Series_Number,TABLTECH,TABLDESC,DEX_ROW_ID FROM DYNAMICS.dbo.EXT90106 WHERE PRODID = 3107 AND TABLTECH = ‘EXT_Extender_Forms’ ORDER BY PRODID ASC ,TABLTECH ASC
I’ve tried removing Extender from the SET file and reinstalling, but I get the same results.
Here is a screen shot:
Extender 2016 Install Error
Is there a different GP 2016 release that installs properly?
I found a copy of the table on an old GP 2013 server, scripted it out in SSMS, and created the table on my GP 2016 machine. With the EXT90106 table created, the Extender installation process in GP appears to have completed without error.
I’ll be importing the client’s Extender export file and will see if it works okay.
Your solution is good – otherwise when you got logged into GP (assuming the process doesn’t just halt here) you could use SQL Maintenance to create the extender tables (all but the v11-xXXX ones which are the old ones we don’t care about)
I have been able to bypass this error by manually creating the autoproc and table for that specific table ‘Dyanmics GP Table Cache’ using GP SQL Maintenance: MS Dyanmics GP>>Maintenance>>SQL: choose Dynamics as the DB and Extender as the product. Find the table and recreate the auto proc and table. You can then exit and renter GP to build the rest.
If you would like to submit an answer or comment, please sign in to the eOne portal.