+11We are in the middle of upgrading our second business unit from 12.5 to 15.2. All seems fine until I try to open Dispatch Console (which works on profile already upgraded). The client trows the following error:
In the server event log I find these errors:
Both profiles run on the same server, so the environment is fine.
Best answer by Phil Seifert
Hi Bjørn,
You had this problem before, if I recall. Can you add this column with the following script which is sourced from the HF1 database scripts?
if exists (select 'x' from sysobjects,syscolumns where sysobjects.type='U' and sysobjects.id = syscolumns.id and
sysobjects.name ='dc_general_settings' and syscolumns.name = 'assisted_dispatch_hours_ahead')
ALTER TABLE dc_general_settings drop column assisted_dispatch_hours_ahead
GO
Otherwise, I think you should run the HF1 upgrade installer with the option dbupgrade.txt and point it to your new database you migrated. This is because your database from DK was not upgraded after connecting it. Anytime you are connecting a new database, it needs to have the same database scripts run against it for the 15 SP2 and also HF1.
+15Take a quick peek at the dc_general_settings table in each of these two databases, see if you see an entry in there for the assisted_disp_hours_ahead field (if it exists in one database but not the other then try rerunning the database upgrade scripts or check the log files to see if there was an error during the upgrade script execution):
+11Thanks, Reid. As you suspect, that field is missing for the new profile. Have run the upgrade twice… Can I jsut add it manually?
+15Are there any errors in the DB upgrade scripts log file? You could probably add it manually but I would be worried that there are many other fields that weren’t created that should have been as well which could cause other problems later on in your testing.
+23Hi Bjørn,
You had this problem before, if I recall. Can you add this column with the following script which is sourced from the HF1 database scripts?
if exists (select 'x' from sysobjects,syscolumns where sysobjects.type='U' and sysobjects.id = syscolumns.id and
sysobjects.name ='dc_general_settings' and syscolumns.name = 'assisted_dispatch_hours_ahead')
ALTER TABLE dc_general_settings drop column assisted_dispatch_hours_ahead
GO
Otherwise, I think you should run the HF1 upgrade installer with the option dbupgrade.txt and point it to your new database you migrated. This is because your database from DK was not upgraded after connecting it. Anytime you are connecting a new database, it needs to have the same database scripts run against it for the 15 SP2 and also HF1.
+11Ran the HF1 upgrade - problem solved.
Thanks guys!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.