Reports viewer and Report configuration crashes: Related to CNA driver

Modified on 2018/11/22 09:30 by RSk Categorized as QCX BlendExpert Mill V8, QCX Report V8, QCX V8



The problems originates from the CNA driver, which are able to log in samples directly to the sample database, but when doing this it was missing some information and this leads the Report configuration to crash.





To fix:


a) Open the SQL Server Management Studio, and then find the database named “Fls,Qcx.Core.Historian” and the two tables names “'''MasterProcedureList'''” and “'''MasterPreparationList'''”:


[image:{UP(Reports-viewer-and-Report-configuration-crashes-Related-to-CNA-driver)}CNAdriverREportFailure1.png|medium|left|Image #1: The databases that needs to be edited]





























b)

Open these for editing, by right clicking and selecting “Edit Top 200 Rows”:


[image:{UP(Reports-viewer-and-Report-configuration-crashes-Related-to-CNA-driver)}CNAdriverREportFailure2.png|medium|left|Image # 2: How to select the edit of the databases]













c) In the '''MasterProcedureList''' there is a '''MasterProcedureDesignation''' missing for the '''MasterProcedureName '''called “'''Aggregated'''”, and in the '''MasterPreparationList''' there is a '''MasterPreparationDesignation''' missing for a '''MasterPreparationName '''called “'''OnlineExpert'''”.


The Designations can in principle be any unique text, but you can fill in “'''OnlineExpert.Names.Procedure.Aggregated'''” and “'''OnlineExpert.Names.Preparation.OnlineExpert'''”.

Meta Keywords: CNA DRiver, Crash, Report Crashes, SQL
Meta Description:
Change Comment:

FLSmidth QCX wiki

Reports viewer and Report configuration crashes: Related to CNA driver