Skip to content
+1-888-319-3663

COMMUNITY FORUM

Migrating GP extender to Extender Enterprise

rtaljaard asked 9 years ago
Hi                                                                                                                                   Please could you check what we did below and let us know if we missed anything?
 
This is the process we followed so far
 
1.We uninstalled GP Extender from GP.
2.We installed the Extender Enterprise.
3.We logged in as sa and let it create the new tables in each DB.
4.We ran the script (convert Microsoft eXtender tables back to eOne.sql) to drop and recreate sql objects.
 
When we log into GP we get no errors everything seems fine. When we try access existing forms and save or delete data, we get these messages…
 
1.Error 1: I can create a record using a detail form but when I delete it I get this error (Note the record does get deleted)

A get/change operation on table 'PT_MC_Exchange_Rates' failed accessing SQL data.
 
Number of results columns doesnt match table definition.
 
Number of results columns doesnt match table definition.
 
Number of results columns doesnt match table definition.
 
2.Error 2: I cant create or delete records when using a normal form.

A remove range  operation on table 'PT_Extender_Form_Field_Strings' failed accessing SQL data.
 
Number of results columns doesnt match table definition.
Lorren replied 9 years ago

Try the steps in the following KB article. http://eonesolutions.com/Support/Knowledge-Base/Knowledge-Base-Article.aspx?articleid=198.   Be sure you have a backup before doing so.   Lorren

dmorgan replied 7 years ago

Working on an upgrade for a customer currently on GP 2010 SP1.  Looking for help with the upgrade process, but the link in this thread is broken.  I'm trying to find the SQL Script: (convert Microsoft eXtender tables back to eOne.sql) with no luck so far.  

dmorgan310 replied 7 years ago

Working on an upgrade for a customer currently on GP 2010 SP1.  Looking for help with the upgrade process, but the link in this thread is broken.  I'm trying to find the SQL Script: (convert Microsoft eXtender tables back to eOne.sql) with no luck so far.  

Nicole replied 7 years ago

Sorry about the link. We have fixed the Knowledge Base (KBA-01179-T9X9S9) to have the correct link for the sql file.

On a side note, are you switching from Extender Standard to Extender Enterprise just for the update? The update will update Extender Standard to 2013, so you wouldn’t want to switch if you are truly using Standard and not registered for Enterprise.


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