Bosch Building Technologies

    cancel
    Showing results for 
    Search instead for 
    Did you mean: 

    How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat?

    If you are facing unknown problems with your DICENTIS wired system and you need advice from the technical support on that we will ask for log files and other information to start our analysis.

    For that reason this little program was created to make the extraction of all needed log files, system settings and other data more easily to extract. In future it is planed to integrate this in our software.

     

    Step-by-step guide:

     

    Activation of the DicentisDatabaseBackup0_96.bat

     

    1. Please copy this DicentisDatabaseBackup0_96.bat to your DICENTIS Server were the DICENTIS software is installed on and "Run it as administrator".

    It is also possible to run it on a client PC to get some limited client specified log files with and reduced data set for example without the important server log files.

    If the system is off it will only capture then it was the last time switched on and had created log files.

    Central_Support_0-1708935801029.png

    2. Please press "Y" and enter so that all information will be collected.

    Central_Support_1-1708935838674.png

    Program will run on it's own and collect all relevant data.

    Central_Support_2-1708935869474.png

    But it could take some minutes (2-3) to collect all data.

    Central_Support_3-1708935897273.png

    Central_Support_4-1708935914941.png

    3. You can find this files in: C:\DicentisBackup

    Please copy this zipp file and send it to the Technical support at best with data share link since the program logs will have more than 10MB up to 100MB and E-mail is no longer suitable for this data size.

    Central_Support_5-1708935952995.png

     

    Troubleshoot

     

    The zip file is missing

     

    The .zip file may be missing within Windows Server 2012 

    Sometimes it is stored in: C:\InstTemp 

    If you have problems to send this .bat program via Mail due to security reasons you can as well send it as text and copy it later in text file to create a .bat out of it.

    Central_Support_6-1708935996894.png

    Name it .bat at the end like "DicentisDatabaseBackup0_96.bat"

    Central_Support_7-1708936018578.png

    If you use WordPad you have to save it as MS-DOS Format.

    Central_Support_8-1708936050661.png

     

    // copy this in the text file

     

    cls
    @echo off
    rem The destination path can be defined here:
    set copypath=C:\DicentisBackup
    rem This is the location of a temporary folder, this will be automatically deleted: 
    set TEMPDIR=C:\DICENTIStemp
    FOR /f %%a IN ('WMIC OS GET LocalDateTime ^| find "."') do set DTS=%%a
    set DateTime=%DTS:~0,4%%DTS:~4,2%%DTS:~6,2%_%DTS:~8,2%%DTS:~10,2%%DTS:~12,2%
    set FileVersion=0.96
    rem update 0.95(Date 01-02-2024): -added Logdump.exe to generate a logfile i.s.o. creating a backup with the SQL commandline. 
    rem                             : -added WMIC PRODUCT, to generate a list of installed software + version + install date
    rem update 0.96(Date 21-02-2024 : -added backup of MediaGateway Config 
    rem                                  -added backup of %programdata%/Bosch/DICENTIS/*.*
    c:
    cd\
    IF exist C:\DicentisBackup ( echo. ) ELSE ( mkdir %copypath% )
    color 1a

    rem ClS
    ECHO.
    ECHO. 
    ECHO         This tool will make a backup of the current
    ECHO.                      
    ECHO                       DICENTIS Database 
    ECHO.                              
    echo                              and
    echo. 
    ECHO                        Synoptic Layout
    ECHO.
    ECHO.
    ECHO         Optionally it can copy information from the 
    ECHO            system for technical support purposes
    ECHO. 
    ECHO.      
    ECHO.
    ECHO.
    ECHO               Run the script as Administrator!
    echo.
    echo.
    echo.
    echo.
    ECHO       Version %FileVersion%, press any key to continue
    ECHO.
    pause>nul
    echo off
    cls
    ECHO.
    echo Optional:
    echo.
    echo Do you want to make a backup of the logging database and installation log files for
    echo diagnostics?
    echo.
    SET INPUT=
    SET /P INPUT=(Y/N):
    CLS
    IF /I '%INPUT%'=='Y' GOTO DiagData1
    IF /I '%INPUT%'=='N' GOTO BackupData

     

    :PrepareZipData
    c:
    cd\
    cd data\tools
    @echo off
    rmdir %TEMPDIR% /s /q 
    mkdir %TEMPDIR%
    cd "C:\Program Files\Bosch\DICENTIS"
    cls
    echo backup database serverconsole
    DcnmDatabaseConsole.exe -b "%copypath%\DbBackup_%DateTime%.bak" 
    mkdir %TEMPDIR%\Data
    xcopy C:\inetpub\wwwroot\DcnmSynopticControl\Data %TEMPDIR%\Data /S /E
    echo .zip > %TEMPDIR%\zip.txt
    echo off
    xcopy /s %copypath% %TEMPDIR% /exclude:%TEMPDIR%\zip.txt
    xcopy /s %copypath%/Data %TEMPDIR%/Data
    echo Version_%FileVersion% > %TEMPDIR%\Tool_Version_%FileVersion%.txt
    del /q %TEMPDIR%\zip.txt
    del /q %copypath%\*.log
    del /q %copypath%\*.bak
    del /q %copypath%\*.txt
    del /q %copypath%\*.htm
    del /q %copypath%\*.html
    del /q %copypath%\*.evtx
    del /q %copypath%\*.json*
    rd /s /q %copypath%\ProgramData
    goto zip

    :zip
    cls
    powershell Compress-Archive -path %TEMPDIR%\* %copypath%\%DateTime%.zip
    rmdir /s /q %TEMPDIR%
    goto quit

    :DiagData1
    CLS
    @echo off
    cd /D %Temp%
    set lastChar=%TEMP:~-4%
    if not %lastChar% == Temp cd..
    copy Bosch_DICENTIS* %copypath%
    copy OMNEO* %copypath%
    copy Dante* %copypath%
    copy Network* %copypath%
    copy "C:\Program Files (x86)\Bosch\DICENTIS Hybrid\MediaGateway\MediaGatewaySettings.jsonc" %copypath%
    CLS
    systeminfo > %copypath%\SystemInfo_%Computername%.txt
    ipconfig /all > %copypath%\IpConfig_%Computername%.txt
    route print > %copypath%\RoutePrint_%Computername%.txt
    set > %copypath%\EnvironmentVariables_%Computername%.txt
    wevtutil epl Application %copypath%\Application_log_%Computername%.evtx
    wevtutil epl System %copypath%\System_log_%Computername%.evtx
    xcopy /S /E /Q %ProgramData%\Bosch\DICENTIS %copypath%\ProgramData\
    del %copypath%\ProgramData\*.x*
    del %copypath%\ProgramData\*.txt
    CLS
    ECHO.
    ECHO.
    ECHO Generating a software list, this takes time. 
    ECHO.
    ECHO Please be patient, the tool did not stop.
    wmic /output:"%copypath%\InstalledSW_%Computername%.txt" product get name,version,installdate
    CLS
    if exist "C:\Program Files\BOSCH\DICENTIS\Logdump.exe" (goto Logdump)
    else (goto SQL2014)


    :SQL2014
    rem For DICENTIS versions <3.60
    SqlCmd -E -S .\SQLDICENTIS2014 -Q "BACKUP DATABASE [DcnmloggingDatabase] TO DISK='%copypath%\LoggingDbBackup_%DateTime%.bak'"
    goto PrepareZipData

    :Logdump
    "C:\Program Files\BOSCH\DICENTIS\Logdump.exe" %copypath%\Logdump_%Computername%.txt
    goto PrepareZipData

    :quit
    cls
    ECHO. 
    ECHO. 
    ECHO. 
    ECHO. 
    ECHO. 
    ECHO. 
    ECHO. 
    ECHO. 
    ECHO ===============================Finished===================================
    ECHO. 
    ECHO             The backup(s) can be found in %copypath%
    ECHO.
    ECHO =========================PRESS ANY KEY TO CONTINUE======================== 
    PAUSE>NUL
    exit

     

    Version history
    Last update:
    3 weeks ago
    Updated by:
    Attachments
    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