Bosch Building Technologies

    cancel
    Showing results for 
    Search instead for 
    Did you mean: 

    Microsoft SQL Database DICENTIS: update, backup, restore and Microsoft .NET Framework related issues

     

    Causes

     

    In some cases it could be necessary that you need to maintain the Microsoft SQL database which DICENTIS is using to save participants, user, seats and settings.

    In the next steps I will explain some of the basics commands.

     

    Solution

     

    Initial

     

    To do a Database update, backup or restore you need to open the Command Prompt. The initial steps will be shown here.

    1. Before you change something with your Database please stop your Dicentis services.

    1 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    2. Please enter via search and go to:

    • C:\Program Files\Bosch\DICENTIS

    2 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    3. Go to File

    3 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    4. And open the Command Prompt as Administrator.

    4 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    5. The DcnmDatabaseConsole.exe  has the following options.

    5 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

     

    Updating a database to the current Version

     

    To update a database to the current version please run this exe.

    • DcnmDatabaseConsole.exe

    This will be needed to execute if you have restored your database from an older database version or a backup.

    6 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

     

    Creating a clean database

     

    If something went wrong in the Database and you need to start all over you can use this command:

    • DcnmDatabaseConsole.exe -n

    But you will lose your Users, Seats, settings , and so on if you do this.

    7 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png8 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png9 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

     

    Deleting a database

     

    Deleting a database will remove the database files as well. The system will not work anymore unless a new database is created or a previous database is restored.

    To create a new database use DcnmDatabaseConsole.exe or to upload and existing database use DcnmDatabaseConsole.exe -b

    This -x  function can be used to delete the database if you need to downgrade to a previous version.

    This is not recommended and only needed for special circumstances.

    • DcnmDatabaseConsole.exe -x

     10 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    The Conference Suite is frozen because the database is missing.

    11 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    After you create a new one or update a backup it will work again.

    • DcnmDatabaseConsole.exe
    • DcnmDatabaseConsole .exe -r
      "
      C:\Program Files\Microsoft SQL Server\MSSQL12.SQLDICENTIS2014\MSSQL\DATA\DcnmBackup\DcnmDatabase_v3.50.bak_20201021-052115.bak"

    12 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

     

    Backup your Database

     

    If you want to backup your database type in the Command prompt "DcnmDatabaseConsole.exe -b" and press enter. If everything is all right you will get a "Success" prompt.

    • DcnmDatabaseConsole.exe -b

    13 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    Next go to
    "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLDICENTIS2014\MSSQL\DATA\DcnmBackup" select the latest file, in this case  "DcnmDatabase_v3.50.bak_20201021-052115.bak" and save it on a save location.

    14 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

     

    Restore a Database

     

    To restore your database type in the Command Prompt the following:

    • DcnmDatabaseConsole.exe -r " where are your .bak files for restoring?"

    For example:

    • DcnmDatabaseConsole .exe -r
      "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLDICENTIS2014\MSSQL\DATA\DcnmBackup\DcnmDatabase_v3.50.bak_20201021-052115.bak"

     

    Note:

    The Dicentis will always create a backup during an Update for example from 3.30 to 3.60 and this can be found here.

    • C:\Program Files\Microsoft SQL Server\MSSQL12.SQLDICENTIS2014\MSSQL\DATA\DcnmBackup

    The restore command does not update the database to the current version! To update it to the current version you have to update you database with the DcnmDatabaseConsole.exe command as already described above.

    Once a while Microsoft is changing the Database like last time from SQL2008 to SQL2014.

    If your backup is in the 
    C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\DcnmBackup directory,
    an error notification will appear because the SQL2014 has no access to this SQL2008 database.

    Here is a work around to fix this. Please copy it to
     C:\temp.

    If everything is working good it will give you a "Success" prompt at the end.

    15 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    Next you have to update you database with the DcnmDatabaseConsole.exe command.

    16 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    After you have backup, restored or updated please don't forget to start the Dicentis services again.

    17 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

     

    Database related Problems (Microsoft .NET Framework)

     

    An important point is that the Windows .NET Framework is up to date so that no mismatch between Dicentis and Windows occurred.

    As example an old version was found in the logs extracted from the DicentisDatabaseBackup which indicates that some important  updates are missing.

    18 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

     

    Microsoft .NET Framework 4.8 online installation

     

    Regular Window Update is explained in this article:

    Please don't to forget to set Advanced options to enable "updates for other Microsoft products…" as well as "Defer feature updates".

    19 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png20 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png21 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

     

    Microsoft .NET Framework 4.8 offline installer for Windows

     

    https://support.microsoft.com/en-us/topic/microsoft-net-framework-4-8-offline-installer-for-windows-...

    Normally you install the Framework with the regular updates. But some circumstances could lead that it has to be update offline.

    You can get the correct version on the Microsoft homepage.

    For this example I will go with this: https://go.microsoft.com/fwlink/?linkid=2088631

    22 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png23 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png24 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png25 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png26 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

     

    Problems during NET. Framework installation

     

    If problems are occurring during NET. Framework manual update or you could not update to the current Framework version automatically it is recommended to recover your Dicentis Server and start with a clean system. This procedure is the fastest, structured and more rational way to get it fixed.

    The following explains some of the alternative problem solution regarding NET. Frame work errors.

    We have seen several reports of people having issues installing SQL on Essentials R2, for example:

     

    September 2018: Latest recommendations I gave for TSEMEA-11950:

    This could be indeed a permissions issue, Though it looks like the permissions are correct.

    In order to make sure:

    1. Go to the MS SQL main folder (the parent of DATA) and right-click Properties

    2. Select Security & Edit

    3. For each user, give them full access permissions

    4. Go back and choose Advanced

    5. Select Replace all child object permissions... & OK

    6. Then run the MS SQL installer first (it's in a separate folder of the Dicentis ISO)

    • Another thing to try if this doesn't help is to completely remove the current SQL install (this may be problematic if it was installed before, but good to try on a new install)

    • Make sure all Windows updates are installed (this may require various reboots and re-checks; they seem to not all install at once unfortunately)

    • Make sure .NET 3.5 is turned on (server feature), make sure .NET 4.7 is installed

    • Re-try the Dicentis installation. Once more, trying the SQL installation separately first and then installing the rest may be practical in this case.

    We have also seen instances where the issue was caused by a faulty Windows profile (even on new installs strangely enough). 

    To fix the user profile that's causing the error, follow the steps listed KB947215.

    The main steps from KB947215 are summarized as follows:-

    • Open regedit

    • Navigate to 
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList

    • Navigate to the SID for the corrupted profile

      To find the SID, click on each SID GUID, review the value for the ProfileImagePath value, and see if it's the correct account. For system accounts, there's a different way to know the SID for the account that failed:
      The main system account SIDs of interest are:

    • SID         
      Name              
      Also Known As
      S-1-5-18 Local System NT AUTHORITY\SYSTEM
      S-1-5-19 LocalService NT AUTHORITY\LOCAL SERVICE
      S-1-5-20 NetworkService     NT AUTHORITY\NETWORK SERVICE

       

    For information on additional SIDs, see Well-known security identifiers in Windows operating systems.

    • If there are two entries (e.g. with a .bak) at the end for the SID in question, or the SID in question ends in .bak, ensure to follow carefully the steps in the KB947215 article.

    • Reset the values for RefCount and State to be 0.

    • Reboot.

    • Retry the SQL Server installation.

     

    Further information that could be helpful if all this fails is found in the following logs:

    • C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log - all logs are useful, but especially SUMMARY.TXT

    • Windows Event Logs: APPLICATION, SECURITY & SYSTEM

    • System info

     

    When there are problems with SQL, the following logs can give insight:

    During installation:

    • C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log - all logs are useful, but especially SUMMARY.TXT

    • Windows Event Logs: APPLICATION, SECURITY & SYSTEM

    • System info

    27 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    During operation:

    • C:\Program Files\Microsoft SQL Server\MSSQL12.SQLDICENTIS2014\MSSQL\LOG - useful logs are the ERRORLOG and ERRORLOG.x where x in a number.

    28 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    • Windows Event Logs: APPLICATION, SECURITY & SYSTEM

    29 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

    • System Info

    30 Microsoft SQL Database DICENTIS update, backup, restore and Microsoft .NET Framework related problems.png

     

    Fix: reset the corrupt user profile

     

    To fix the user profile that's causing the error, follow the steps listed KB947215.

    The main steps from KB947215 are summarized as follows:-

    1. Open regedit

    2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList

    3. Navigate to the SID for the corrupted profile

      To find the SID, click on each SID GUID, review the value for the ProfileImagePath value, and see if it's the correct account. For system accounts, there's a different way to know the SID for the account that failed:

    The main system account SIDs of interest are:

    SID         
    Name              
    Also Known As
    S-1-5-18 Local System NT AUTHORITY\SYSTEM
    S-1-5-19 LocalService NT AUTHORITY\LOCAL SERVICE
    S-1-5-20 NetworkService     NT AUTHORITY\NETWORK SERVICE

     

    For information on additional SIDs, see Well-known security identifiers in Windows operating systems.

    1. If there are two entries (e.g. with a .bak) at the end for the SID in question, or the SID in question ends in .bak, ensure to follow carefully the steps in the KB947215 article.

    2. Reset the values for RefCount and State to be 0.

    3. Reboot.

    4. Retry the SQL Server installation.

    Version history
    Revision #:
    2 of 2
    Last update:
    ‎06-30-2021 09:28 AM
    Updated by:
     
    Labels (5)
    Contributors
    Icon--AD-black-48x48Icon--address-consumer-data-black-48x48Icon--appointment-black-48x48Icon--back-left-black-48x48Icon--calendar-black-48x48Icon--center-alignedIcon--Checkbox-checkIcon--clock-black-48x48Icon--close-black-48x48Icon--compare-black-48x48Icon--confirmation-black-48x48Icon--dealer-details-black-48x48Icon--delete-black-48x48Icon--delivery-black-48x48Icon--down-black-48x48Icon--download-black-48x48Ic-OverlayAlertIcon--externallink-black-48x48Icon-Filledforward-right_adjustedIcon--grid-view-black-48x48IC_gd_Check-Circle170821_Icons_Community170823_Bosch_Icons170823_Bosch_Icons170821_Icons_CommunityIC-logout170821_Icons_Community170825_Bosch_Icons170821_Icons_CommunityIC-shopping-cart2170821_Icons_CommunityIC-upIC_UserIcon--imageIcon--info-i-black-48x48Icon--left-alignedIcon--Less-minimize-black-48x48Icon-FilledIcon--List-Check-grennIcon--List-Check-blackIcon--List-Cross-blackIcon--list-view-mobile-black-48x48Icon--list-view-black-48x48Icon--More-Maximize-black-48x48Icon--my-product-black-48x48Icon--newsletter-black-48x48Icon--payment-black-48x48Icon--print-black-48x48Icon--promotion-black-48x48Icon--registration-black-48x48Icon--Reset-black-48x48Icon--right-alignedshare-circle1Icon--share-black-48x48Icon--shopping-bag-black-48x48Icon-shopping-cartIcon--start-play-black-48x48Icon--store-locator-black-48x48Ic-OverlayAlertIcon--summary-black-48x48tumblrIcon-FilledvineIc-OverlayAlertwhishlist