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

Hi Bennie,

Thanks for the feedback.

No, it isn't an offline branch environment.

The _espRefreshAllFunctions doesn't exist pre-upgrade.  I've done the full copy company and upgraded. Didn't check to see if the _espRefreshAllFunctions  stored procedure showed after the full company copy, but after the upgrade the _espRefreshAllFunctions is listed as a stored procedure for the database.

Only problem now, is that I have about 10 companies which I need to go through this whole process to get them updated.

Is there a way to create the _espRefreshAllFunctions stored procedure to see if the upgrade completes successfully, without having to do the Full company copy process?

Hi Kobus

Sorry for the late feedback

Please note I'm working on a solution and should soon get back to you with an answer

Kind Regards

Bennie 

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 

Hi Bennie,

I've send you the PM with the details.

Yip, I received it and sent you my response in return per mail today 

Thanks Kobus 

Blessings

Bennie