With version 2.15.5, the following improvements to the CyberStore installation program were released.
When upgrading CyberStore, the application installer performs backups of your CyberStore Microsoft SQL Databases in order to ensure that you can restore back to the previous version should you need to do so.
In some cases, the installer-spawned backup may fail even though a manual backup may be able to be performed. In these situations, the installer application will now present a warning to the user including information about the event and providing them with the option to continue along or cancel the process.
The sample message box below is what will be presented to the user installing the upgrade.
When Yes is selected the installer continues along to the next steps as usual ignoring the fact that the database was not backed up successfully.
When No is selected the installer is aborted.
Important Note:
It is highly recommended that before continuing, you ensure that a recent or manual backup has completed successfully to ensure your fallback ability.
During some upgrades of prior versions and the installer fails it would be helpful to be able to run the Dovetail.Installer.DB application at the command line and see SQL errors that are being encountered.
The database command can be run from command line at any time prior to clicking Ok on the last installation screen by running the following command line from the Install directory.
> Dovetail.Installer.DB\Dovetail.Installer.DB.exe -n=SERVERNAME -d=DATABASENAME -f=BACKUP
Substituting the SERVERNAME and DATABASENAME strings with the name of your SQL Server and database and running the BACKUP function will attempt a SQL backup.
When successful the following will be displayed.
Dovetail Database Installer (2.15.5.7837)
===========================================================================
(c) 2018 Dovetail Internet Technologies, LLC - All Rights Reserved
Function: BACKUP
SQL Server: (local)
SQL Database Name: CyberStoreForSYSPROConsole
SUCCESS
Alternatively, if an error is returned from the backup attempt, the following is a sample error output.
Dovetail Database Installer (2.15.5.7837)
===========================================================================
(c) 2018 Dovetail Internet Technologies, LLC - All Rights Reserved
Function: BACKUP
SQL Server: (local)
SQL Database Name: CyberStoreForSYSPROConsole
Code 188: Error during SQL Backup of CyberStoreForSYSPROConsole - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
The following bugs have been repaired as of Version 2.15.5:
CHECKOUT: Shipping Methods - Customer On Hold Message Not Displaying (#9951)
PERSONALIZATION: Personalization - Add PersonalizationReview to SitePages in Compass Theme (#9949)
CONSOLE: On Credit Hold (SYSPRO) missing from Customer Maintenance (#9954)
CONSOLE: Operation Center - Populate price cache missing from Command Enumeration (#9964)SYSTEM: Incorrect SQL Collation on Some Table Columns (#9959)