FAQ

The frequently asked questions in Dashboard Server

What all are the files and folders will be generated in the installed machine?

Resources

Dashboards, Data Sources, Widgets that are added in the Dashboard Server are maintained here.

Scheduler Service

Exported Dashboards that are to be emailed and schedule configuration are maintained here.

Content

This folder holds profile pictures and application images.

Logs

You can log errors and debug information from the Dashboard Server application for troubleshooting.

SQLCE Database

If you are choosing SQLCE database as the underlying database for the Dashboard Server, then a .SDF database file will be created and maintained.

Will Azure charge for Syncfusion Dashboard Server license?

No. Azure will not charge for Syncfusion Dashboard Server license. However, you will be charged for the Azure resources used by the Syncfusion Dashboard Server.

• Azure App Service - Based on the selected Azure App Service Plan. Default plan is Basic.

• Storage account - If Blob Storage is selected as your storage account.

How to update the credentials of the Oracle database in Dashboard Server ?

The credentials used to connect the Dashboard Server database to the Syncfusion Dashboard Server can be changed at any time.

The Dashboard Server is deployed in the following location, by default.

{Windows_Drive}\Syncfusion\Dashboard Server\DashboardServer.Web\

For example, C:\Syncfusion\Dashboard Server\DashboardServer.Web\

By default, a utility with the Syncfusion Dashboard Server application can be shipped in the following location.

{Windows_Drive}\Syncfusion\Dashboard Server\Utilities\ConnectionStringEditor

Follow the given steps to change the Database Credentials,

Step 1: Stop the Dashboard Server from the Desktop shortcut – “Stop Syncfusion Dashboard Server”.

Step 2: Open the ConnectionStringEditor.exe tool in an installed location.

Step 3: The connection details that are supplied while starting up the Dashboard Server application will be populated in the utility.

The DSN, Username, and the password can be changed for the Oracle database.

Note: This utility cannot be used when SQL CE database is chosen as the Dashboard Server database in the Syncfusion Dashboard Server.

Step 4: This utility allows to change the Username, Password, and Database Password of the Oracle database.

It can be log in with different user accounts. After filling the connection details, proceed to save.

The utility tests the connection to the database with given details. If the connection test passes, the new connection details will be updated in the connection string of the Dashboard Server database.

The tool changes the Database Credentials and returns a “success” message if the process was completed successfully.

How to update the credentials of the PostgreSQL database in Dashboard Server ?

The credentials that are used to connect to the Dashboard Server database in the Syncfusion Dashboard Server can be changed at any time.

The Dashboard Server is deployed in the following location by default.

{Windows_Drive}\Syncfusion\Dashboard Server\DashboardServer.Web\

For example, C:\Syncfusion\Dashboard Server\DashboardServer.Web\

A utility has been shipped with the Syncfusion Dashboard Server application in the following location by default.

{Windows_Drive}\Syncfusion\Dashboard Server\Utilities\ConnectionStringEditor

Follow the given steps to change the Database Credentials:

Step 1: Stop the Dashboard Server through the Desktop shortcut – “Stop Syncfusion Dashboard Server”.

Step 2: Open the ConnectionStringEditor.exe tool in the installed location.

Step 3: Run the utility. The connection details that are supplied while starting up the Dashboard Server application will be populated in the utility. You can change the Authentication Type and Server, and you cannot change the Database name in the utility.

Note: This utility cannot be used when SQL CE database is chosen as the Dashboard Server database in the Syncfusion Dashboard Server.

Step 4: Enter username and password to fill if “SQL Server Authentication” type has been selected. For “Windows Authentication” type, it is not needed. After filling the connection details, proceed to save.

The utility will test the connection to the database with the given details. If the connection test is passed, the new connection details will be updated in the connection string of the Dashboard Server database.

The tool changes the Database Credentials and return a “success” message if the process was completed successfully.

If there is an error occurred in the process, the tool will generate an error log in text format in the following location and will display the error log file name.

Error log file location: %temp%/Syncfusion Dashboard Server/{file_name}

Please create a support incident and attach the error log file for us to check the issue and give a solution.

How to update the credentials of the MSSQL database in Dashboard Server ?

The credentials that are used to connect to the Dashboard Server database in the Syncfusion Dashboard Server can be changed at any time.

The Dashboard Server is deployed in the following location by default.

{Windows_Drive}\Syncfusion\Dashboard Server\DashboardServer.Web\

For example, C:\Syncfusion\Dashboard Server\DashboardServer.Web\

A utility has been shipped with the Syncfusion Dashboard Server application in the following location.

{Windows_Drive}\Syncfusion\Dashboard Server\Utilities\ConnectionStringEditor

Follow the given steps to change the Database Credentials:

Step 1: Stop the Dashboard Server through the Desktop shortcut – “Stop Syncfusion Dashboard Server”.

Step 2: Open the ConnectionStringEditor.exe tool in the installed location.

Step 3: Run the utility. The connection details that are supplied while starting up the Dashboard Server application will be populated in the utility. You can change the Authentication Type and the Server, and you cannot change the Database name in the utility.

Note: This utility cannot be used when SQL CE database is chosen as the Dashboard Server database in the Syncfusion Dashboard Server.

Step 4: Enter username and password to fill if “SQL Server Authentication” type has been selected. For “Windows Authentication” type, it is not needed. After filling the connection details, proceed to save.

The utility tests the connection to the database with the given details. If the connection test is passed, the new connection details will be updated in the connection string of the Dashboard Server database.

The tool changes the Database Credentials and returns a “success” message if the process was completed successfully.

If there is an error occurred in the process, the tool will generate an error log in text format in the following location and display the error log file name.

Error log file location: %temp%/Syncfusion Dashboard Server/{file_name}

Please create a support incident and attach the error log file for us to check the issue and give a solution.

How to update the credentials of the MySQL database in Dashboard Server ?

The credentials that are used to connect to the Dashboard Server database in the Syncfusion Dashboard Server can be changed at any time.

The Dashboard Server is deployed in the following location by default.

{Windows_Drive}\Syncfusion\Dashboard Server\DashboardServer.Web\

For example, C:\Syncfusion\Dashboard Server\DashboardServer.Web\

A utility has been shipped with the Syncfusion Dashboard Server application in the following location.

{Windows_Drive}\Syncfusion\Dashboard Server\Utilities\ConnectionStringEditor

Follow the given steps to change the Database Credentials:

Step 1: Stop the Dashboard Server through the Desktop shortcut – “Stop Syncfusion Dashboard Server”.

Step 2: Open the ConnectionStringEditor.exe tool in the installed location.

Step 3: Run the utility. The connection details that are supplied while starting up the Dashboard Server application will be populated in the utility.

The DSN, Username, and Password can be changed for the MySQL database.

Note: This utility cannot be used when SQL CE database is chosen as the Dashboard Server database in the Syncfusion Dashboard Server.

If the Username and Password for the database has already been given in the ODBC driver, no need to fill it in this utility.

In this case, leave the Username and Password field as empty and directly save the connection details.

If the login credentials are not given in the ODBC driver, this utility needs a Username and Password field to fill.

The utility tests the connection to the database with the given details. If the connection test is passed, the new connection details will be updated in the connection string of the Dashboard Server database.

The tool changes the Database Credentials and returns a “success” message if the process was completed successfully.

If there is an error occurred in the process, the tool will generate an error log in text format in the below location and display the error log file name.

Error log file location: %temp%/Syncfusion Dashboard Server/{file_name}

Please create a support incident and attach the error log file for us to check the issue and give a solution.

How to grant access to all users for Dashboard Server?

If you going to add a new application and want grant access to all users means enable “Allow access to all users” button in Add Application dialog box of User Management Server.
Go to Application Management -> Add Application -> Enable “Allow access to all users”.

If you want to grant access to all users for the existing applications.
Go to Application Management -> Choose your application -> Choose edit option in the context menu of Actions button -> Enable “Allow access to all users”.

Blank page appears after deleting App Data of Dashboard Server and reconfigured. How to resolve this?

This occurs due to the Dashboard Server trying to create a same group name at the time of server configuration. To resolve follow the below steps.

1. Go to Groups page in User Management Server.
2. Delete the Admin group of respective application.

How to find the current User Management Server details in Dashboard Server?

You can find the currently pointing User Management Server URL and Client ID inside Settings -> User Directory settings.

How to change UMS URL, Client Id and Client Secret in Dashboard Server?

You can change the UMS URL, Client Id and Client Secret in config.xml files of Dashboard Server.
Before adding credentials in config file, you can test the connections in the Settings -> User Directory settings page.

For adding credentials follow below steps.

1. Find the Dashboard Server config files in below locations,
   • C:\Syncfusion\Dashboard Server\DashboardServer.Web\Configuration\Config.xml
   • C:\Syncfusion\Dashboard Server\DashboardServer.Web\App_Data\Configuration\Config.xml
2. Open Config.xml files from above locations and find the ClientId, ClientSecret and UmsUrl nodes.
3. Update the nodes with valid credentials. Now login in to Dashboard Server, It will update the latest values from config file to Dashboard Server Database if the connection is valid one.

How the Group conflicts in Data Migration is handled programmatically?

While upgrading the Dashboard Server to v3.2, The Server simply updates the group name with application name if any group conflicts occurs among User Management Server and Dashboard Server.