-
Troubleshoot Missing Relationships
In this article we will focus on different types of relationship that would result in an unstable database and should be avoided at all cost. 1. Missing bottom-up relationships: In a Board database where the above hierarchy is true, and you see different down totals when displaying reports with Customer by row as opposed…
-
How to Change the Max Item Number
Max Item Number within an entity can be easily interpreted as the maximum amount of items you can store at each entity. However, it can also be used to reference data that is stored in a cube version. In other words, this attribute can determine how the data is physically stored as well as how it affects performance…
-
Board Procedure Launcher
Functionality The Board Procedure Launcher is a tool available for On-Premise installations of Board. We highly recommend running this type of procedure using REST APIs. The Board Procedure Launcher allows a Board Database procedure to be executed from a Windows command line (CMD), and can therefore be scheduled through…
-
How to Open a Case With the Red Banner Error
Creating a Case Should searching the extensive knowledgebase available here on the community platform not yield the information you require to resolve your issues, a new ticket can be created on the Board Customer Support Portal. The steps below illustrate how this is achieved. Go to https://support.board.com/ Log in using…
-
Getting Started With Board Cloud Connector (Hybrid Data Pipeline)
Abstract Every Board solution relies on connections to external data sources. In this article, we describe step by step how to link Board to an on-premises data source. Context Board Cloud Data Pipeline is a service that allows Board applications to access data from sources that are hosted on a public cloud or on-premises.…
-
Customer Support Portal User Manual
-
How to manage and prevent runaway queries
In the Summer 22 release, we introduced a new functionality to avoid memory consumptions peaks caused by the Board web engine. Those memory peaks are typically generated by huge layout requests generated by the users (most commonly using the quick edit layout function) and sent to the Board platform. In this article we…
-
CLOUD - Restore Backup - All you need to know
FUNCTIONALITY The Cloud Administration Portal, among other activities, allows you to make backups of current databases as well as restore previous databases backups. PREREQUISITES In order to do both these operations, you should have access to the Cloud Administration Portal as well as to an Administrator user in the…
-
Patch release for the Windows Client Version 10.6
A new patch version for the Windows Client Version 10.6 has been released. The updated version contains two fixes: * a fix regarding the GeoMap object. The GeoMap is not supported anymore in the previous versions of the Windows Client. All the previous versions do not support this object anymore.The GeoMap is still…
-
How to query the User List from MS Active Directory
If have several tens if not hundreds of users it's likely you're adopting the Enterprise Security Application to manage their credentials In such situation you need a fast and easy method to get your Users' List into the Application Database, possibly querying your MS Active Directory. It is important to know that…
-
Upload custom corporate identity on the BOARD Cloud
The following article describe how to transport an existing corporate identity customization to Cloud enviroment If you have created a corporate identity for BOARD application and you need to move the customization on the Cloud, you can use the following method. 1) Create a new file group 2) Give the file group the name…
-
Troubleshooting: Garbage Collector is not running in Server mode
Symptom: At the end of BOARD Server installation on Windows Server, the service doesn’t start properly. From Windows Event Viewer, the following error is tracked: Error Tracker BOARD Server is starting Configuration: C:\Program Files\Board\Board Server\server_config_v2.xml Cannot start BOARD Server. Original cause: The…
-
Db empty or unavailable with .NET framework error message in SQL Log
HOW TO FIX: DB EMPTY OR UNAVAILABLE WITH .NET FRAMEWORK ERROR MESSAGE IN SQL LOG Symptoms - Popup message “database empty or unavailable” returned when connecting to a data source via ODBC/OLEDB The following error messages : Error: The 'DbProviderFactories' section can only appear once per config file. Invalid Query:…
-
BOARD Excel Add-in Functions and VBA Integrations.pdf
-
Opening a Capsule from a Command Line
The following article, describes a common approach for deploying BOARD Client applications to non-experienced users. You might want to have a look at the BOARD Procedure Launcher synthax as well to read how to automatically schedule BOARD procedures or to run BOARD procedures using a command line To open a Capsule from a…
-
Dataflow execution methods: high performance in depth
BOARD Dataflow calculation methods The execution time of a single BOARD Data Flow can depend on many factors, like the size of the dataset, selections applied, sparsities etc... However, one very important element to be considered is the type of the algorithm that the BOARD engine adopts to perform the calculation. BOARD…
-
BOARD Server Saving Policy
Starting from BOARD version 8 it has been introduced the possibility to change the way BOARD automatically saves data and metadata (which is in RAM) to disk. BOARD works in-memory, so all users' inputs as well as uploads from external sources (text files, MSSQL...) are performed using the BOARD Server RAM, without…
-
Rare and unintended crashes of the BoardEngine.exe
Since Microsoft .NET Framework 4.5 release, there have been some very rare unintended crashes of the BoardEngine.exe, happening in some specific cases (dataflow execution, large report generation). The issue has been largely investigated and it is related to some changes applied by Microsoft to the memory management in…
-
Speed Test Performance: definition of parameters and BOARD functionalities
The Speed Test functionalities verify the operation performance of the CPU, Disk access times and GPU Type. Through these you can check if any unexpected decrease in performance might be due to hardware. Client Speed Test: CPU: 100 is the speed of our client reference system. Over 100 is a good result. Disk: 100 indicates…
-
Troubleshooting - BOARD Client in Auto Update
In this article we will discuss about some issues related to the Auto Update for the Board Windows (FAT) Client, used until Board 10.x. The Auto-Update is that feature aligning the BOARD Client to the same version as the BOARD Server without the need of installing again the BOARD Client. Please remember that from Board…