Fix Version of BioStar 2: v2.9.7 or higher version

 Affected Version of BioStar 2: from v2.9.3 to v2.9.6


If you're using BioStar 2 with the version from v2.9.3 to v2.9.6 and using MSSQL in which the database name includes a hyphen (-), you may encounter the issue that the system backup function does NOT operate normally. Consequently, the backup database will NOT be generated properly.


This issue can be resolved by upgrading BioStar 2 to version 2.9.7 or a higher version. Please upgrade BioStar 2 to v2.9.7 or a higher version, or follow the workaround below. 


To check the details, please find the below contents.


1. Issue Description:


1) Pre-conditions

BioStar 2 version: from v2.9.3 to v2.9.6

Database: MSSQL with a database name includes a hyphen (-)


2) Scenario

If you use SYSTEM BACKUP in Settings, the backup DB file will not be generated normally regardless of whether you use the "Backup Now" function or "Automatic System Backup" function.


Steps to Reproduce


Step 1. 

Go to SYSTEM BACKUP in Settings.


Step 2. 

Use the "Backup Now" functionc or "Automatic System Backup" function.


Step3. 

The backup DB file will NOT be generated properly at C:\Program Files\BioStar 2(x64)\Backup\BioStar_2_Backup_YYYYMMDD.


Version-specific Symptoms: The symptoms differ based on the version used:

1) v2.9.3 ~ v2.9.5: 

  • A folder will be generated, but no zipped backup database file will be created. And, the generated folder will be empty.
  • A "Backup Cancelled" message will be recorded in the acs.log located at C:\Program Files\BioStar 2(x64)\logs.
  • Backup Cancelled message will be recorded in Audit Trail.


2) v2.9.6: 

  • The backup DB file will be generated, and the message "Backup Finished" will appear in the Audit Trail, even if the backup process is not fully complete. And also, the message indicating that the backup has been finished will also appear in asc.log.

<Generated Backup DB>


<Backup Finished in Audit Trail>


<Backup Finished in acs.log>

  • However, there will be an internal problem with the generated backup database, leading to failures when trying to restore it.


<Failure will occur when restoring the generated backup DB>


2. Workaround

To avoid this issue when using BioStar 2 (from v2.9.3 to v2.9.6) with MSSQL, please DO NOT include a hyphen (-) in the database name when creating the database for BioStar 2. 



3. Plan For Fixing

Suprema has addressed this issue in BioStar 2 v2.9.7 with the following solution.