Cannot Upgrade from v9.20.1.003 to v10.0.0.062

Question

Good Day, 
 Cannot Upgrade from v9.20.1.003 to v10.0.0.062. 
 Getting the following error: 
 Error refreshing all functions! Could not find stored procedure '_espRefreshAllFunctions'. 
 
 Anyone know how to get past the error to successfully upgrade to v10? 
 Thank you. 
 Kobus

Bennie Pienaar · Accepted Answer

Hi Kobus 
 Is this company perhaps part of an Offline Branch Accounting environment? 
 If not, please run the Full Copy Company procedure and then run the upgrade on the newly created company 
 Else, I may be mistaken, but I think the '_espRefreshAllFunctions stored procedure is a foreign SP and that alone may be the reason the upgrade is failing. If that is the case, do the following: 
 1) Restore the backup made before the upgrade started 
 2) Drop the foreign SP in MS SQL Management Studio 
 3) Upgrading the company again 
 
 Kind regards 
 Bennie

Bennie Pienaar · Answer

Hi Kobus 
 Please send me a private message in Sage City in which you specify the following: 
 1) Your Company name and customer number as registered with Sage 
 2) Your e-mail address 
 I have made some progress with investigating your query and want to log this as a new query on our side and send you my feedback 
 
 Kind Regards 
 Bennie

Sage 200 Evolution

Cannot Upgrade from v9.20.1.003 to v10.0.0.062

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING