FREQUENTLY ASK QUESTIONS

YOU CAN SEARCH PART OF THE TEXT OR NUMBER.

Instalation Microsoft SQL Server

Installation of Microsoft SQL server for further use with PalstatCAQ quality management system.

CAQservice - scheduler

Set up automated processes by using CAQservice and scheduler settings in System Administration.

Missing records in the MSA module in the reliability tab

License dialog and releasing used licenses

The program displays the message "Illegal program instance" - Releasing used licenses

Subscription of PALSTAT CAQ quality management system licenses

You can now rent the license including service support and updates.

Reporting, zástupce na reporting do Launcher

SQL Network Interfaces, error: 26

Error connecting to MSSQL server during license activation.

CAQservice - System Error 193 has occurred

When installing CAQservice, the system reports error 193 with the addition *** is not a valid Win32 application.

OutOfMemoryException

At start-up or during work, the program reports a lack of memory and it is not possible to continue working.

Configuration error

We use CAQservice and we got a error "Loading of Palstat configuration failed"

Unable to cast COM object of type 'Microsoft.Office.Interop.Word.ApplicationClass'

System.InvalidCastException: Unable to cast COM object of type 'Microsoft.Office.Interop.Word.ApplicationClass' to interface type 'Microsoft.Office.Interop.Word._Application'.

Service contract

The service contract offers users many benefits to ensure the smooth operation of your quality system.

Licence Update

Since version 2022.02.000 it is possible for customers with installed CAQservice to update LICence files online or via CAQadmin.

Architecture mismatch between the Driver and Application

Application startup parameters

The application can be run with several parameters that can be used to influence the subsequent behaviour of the application and make it easier to use.

CAQservice - System.Net.HttpListener.Exception

The user under which you are running CAQservice does not have sufficient rights, open the CAQservice installation menu and look for the "Change the user to run the service" section

Error: Error occurred while the program was running

The program reports an error while running with the option to continue. We will need detailed diagnostic data.

Discontinuing support for Internet Explorer

We are discontinuing Internet Explorer support in all versions for CAQweb and CAQapi modules. Customers are advised to switch to Microsoft Edge, which supports both legacy and modern websites and applications.

CAQserver, deploying

What is CAQserver, what do I need to ensure before deployment.

Codelist - Departments

I don't know where to edit the database of Departments that I see in the program.

Keyboard driver

When using the supplied keyboard driver, it is necessary to run it using the KeyboardDriver.exe program, which can be found in the APL directory

End of support for Windows Vista, Server2008

We are discontinuing support for the outdated Windows Vista and Windows Server2008

New RIBBON menu gradually deployed

Prepare for a change in the look and feel of Palstat as it is gradually deployed.

CAQdesktop operation on VPN

In some cases, it is necessary for users to use Palstat via VPN, but the program is very slow to start.

Verify system configuration and .NET Framework

In case of system operation problems, use the following command to verify the status and configuration of the system. You can send us the script output.

Display of documents in the web version of the managed documentation module

Managed QSD documents, in the web version display only documents in the Comments Pending status and the last valid change in the Released status

Connecting your own gauge, RS232, TCP/IP

If you have your own measuring system and wish transfer and load data to Palstat CAQ.

SPC, recovery deleted part

We managed to delete the measured data for a whole part or a group of parts due to an error in the program control.

Connecting to the DEMO server

If you are interested in testing our system, it is possible to request and create an account on our Demo server. The application can be remotely tested here using RDP for a limited time. There is no requirement to install any special applications on your PC.

Create training MSSQL databases and edit configuration file

This script helps in the setting up a training MSSQL database to existing live production data.

How to connect to ONLINE training

Information on ways how to connect to the PalstatCAQ system ONLINE training.

Barcode reader for authorization, RFID

Log in to the Palstat system using RFID tokens and make it more user-friendly.

Manage Local settings management

If a user experiences unexpected system behavior, local settings can be deleted.

License agreement

If you are unsure of how to properly use your purchased LICENSE or simply want to ensure that the purchased license is correct

Code lists and auxiliary database in the System Administration module

Where to find new auxiliary databases and code lists?

Global setup file by config.xml

The special configuration file CONFIG / config.xml allows you to set the behavior of the program for special cases or as an optimization for the environment of each customer / user.

License activation of Palstat CAQ

We recommend all customers to activate their license and extend the functionality with CAQserver.

SPC data collection in operation

When collecting data from an operational SPC, it is possible to use the Palstat supplied SPCPAD, which by LED immediately visualizes an exceeded limit after measurement, with the possibility of quick control by means of buttons and identification of the worker by RFID card.

CAQmobile, mobile applications

The system offers the possibility of communication with the database via API directly from the mobile device, scan the QR code and monitor the status of the loaded machine. Simply search the system and display all data. Support for Android and iOS.

Programming in Print Report

This is an advanced technique where it is possible to add C# scripts that can adapt output to special requirements, to any Palstat system assembly.

Information display and mobile devices

Automatic updating of E-INK information displays directly in production with long-life battery operation and minimal consumption. Depreciation of maintenance directly at the workstation from a mobile phone or terminal. Quick and easy due to QR codes.

Automation of data loading, batch

Most of the drivers you use to load data into Palstat can be automated and imported into Palstat at a set interval.

QualityPortal, CAQportal, manual

QualityPortal is a cloud service that enables secure online communication between Palstat CAQ and quality management systems of the users and their suppliers.

Exporting to EXCEL

Recommendations for exporting data from the Palstat system to Excel.

Encrypted connection SSL for MSSQL

Palstat CAQ from versions 2017.01.000 supports the possibility of encrypted connection between client and SQL server.We enclose a short general guide for setting it up on the SQL server.

Connection via ActiveDirectory - SSO

If you would like to make it easier for users to access Palstat CAQ, SSO single sign-on can be used and a password will not be required at startup. Windows login will be used.

CAQapi, API, Swagger

As of the 2019 version, we offer the option of accessing Palstat system data via the WebAPI interface, with which you can easily read system data and register input values.

Add Multiple field for control sheet

2017.02.000 Add Multiple field to control sheet. Active only for module Inprocess inspection

PalstatCAQ - update

If you need to update the PALSTAT CAQ quality management system.

SYSTEM REQUIREMENTS

Check system requirements before deploying a quality management system.

The application crashes only on one PC, local setting

The application started reporting an error or crashes without a message and only occurs on one PC. Or a part of the program has disappeared from the station. Local settings.

Exporting reporting enquiry files

Exporting a reporting enquiry to a file for further processing.

Loading (Import) of a reporting query

Loading a delivered reporting query into the database for further use in a specified part of the system.

Print report manager

Print report editor, with which program outputs can be adjusted according to your needs.

Reporting - sending emails by CAQservice

If you have a LICense of the Reporting module or CAQserver, it is possible to set the sending of some reports to email.

DBBM, import/export data to mobile SQLite file

If you need to extract or upload data from Palstat databases.

Import print reports for QSD

Find out size of MSSQL tables

If it needs to find out which tables are the largest in the database. Suitable for solving some situations on MSSQL Express.

MS SQL diagnostic queries

If the programs slow down, it is possible to diagnose whether the MSSQL server is not overloaded and choose a suitable solution accordingly.

PalstatCAQ - migrate

How to easily migrate the PALSTAT CAQ system

Create MSSQL databases for Palstat

This script will help you to create MSSQL databases and user of the Palstat CAQ system.

Other MSSQL commands

Minor commands for system administration

Sample database file + encrypt the file

Sample default configuration file as sent in the default installation. Instructions on how to encrypt a file and hide the name and password in the database.

SQL Reindex

One way to speed up the system.

Incompatible databases found

The Palstat system does not support MSSQL 2005. Install at least MSSQL 2008 or newer.

PalstatCAQ - instalation

Help with the administration and installation of the PALSTAT CAQ system.

New fields Workshop and Position added

2018.03.000 New fields Workshop and Position were added instead of original Place and Place sign fields, which were moved to the new Owner tab. Field Workshop value is selected from edit list.

The application often reports an error - execution timed out

The user under which you are running CAQservice does not have sufficient rights, open the CAQservice installation manual and look for the section "Changing the user to run the service"

Sending an email from Document Management when a document is changed

How to set up email distribution from Document Management when documents are changed to persons from the distribution list. The email will be sent at several different states of the modified document.

License dialogue about using the program

After launching the application, it reports that the LICence is used, although I am sure it is not.

Required field Calibration method on Calibrations page

2018.02.000 Significant program change since version 2018.02.000 in module Měřidla

New data filtering options in filter row

2018.01.000 Significant program change since version 2018.01.000 in module Systém Palstat CAQ

QSD, recovery deleted QSD document

If you need to recover a document deleted from the QSD module (managed documentation)

How to upload data to our FTP server

In some cases, it is necessary to send your data to our FTP server for more accurate analysis or for editing or conversion.

Control chart color changes

2017.02.000 Control chart is now always displayed with light background and control / specification limits drawn as lines.

Data preview on control chart

2017.02.000 Sample values are shown when hovering over the chart point with mouse cursor.

Measuring station - user logout

2017.02.000 User can logout from SPC Measuring station without terminating the program. Measuring station is still running and displaying measuring plans after logout. Same or another user has to login before next measurement.

Cp, Cpk results

2017.02.000 As confidence intervals are shown, minimal value amount for starting Cp and Cpk calculation has been lowered to 25.

Weibull distribution

2017.02.000 Webull distribution is now supported when inserting new dimension. Pp and Ppk results are calculated for this distribution. When distribution parameters cannot be estimated for given data, normal distribution is used for calculation.

Rayleigh distribution

2017.02.000 Rayleigh distribution is now supported when inserting new dimension. Pp and Ppk results are calculated for this distribution. Lower specification limit for dimensions in this distribution should be set to zero for reliable results.

Lognormal distribution

2017.02.000 Pp and Ppk indices calculation has been changed so that it uses ISO 21747 M4 method.

Distribution tests

2017.02.000 Several new tests added to Distribution tests page. Each test is now displayed with its result and P-value.

Measuring station - control chart

2017.02.000 Control chart in SPC Measuring station shows last 25 samples even if these are present on more cards.

Measuring station - chart analysis

2017.02.000 Control chart in SPC Measuring station now displays chart analysis results, such as trends, runs etc.

New appearance

2017.02.000 Significant program change since version 2017.02.000 in module Launcher

New Launcher from version 2017.02.000

The new Launcher brings a number of improvements that have long been demanded. It offers customization of homepages to individual requirements and the addition of links to other applications outside the Palstat CAQ system. See the video manual for further information.

Measuring instruments, change of gauge status is not possible

It is not possible to change the status of the gauge at all. The program reports "Cannot change gauge status from XXXX to YYY"

MSA, formulas for the print report

The formulas in the MSA print report are unreadable or poorly rendered.

Measuring instruments, status is English

After performing UPGRADE, the meter state changed to English.

When exporting to EXCEL, the columns contain characters

When exporting data to EXCEL, there are keys in some columns, eg (QXpZdh+AEVoBABkA,R3NKYdFgEVoBABQA, etc.)

PALSTAT has started to slow, how to speed it up

Palstat CAQ has begun to slow after some time and is hold up work. Or, optimizing application speed. System diagnostics.

Instalation of the INTERFACE driver for Windows

Newer versions of Windows require a digital signature to install the driver.

Print reports logo

Manual for multiple logo changes for all reports in Palstat CAQ system.

SPC Station – Driver Setting

Driver assignment for SPC station and measuring plan

How run the program on phone or tablet

Palstat CAQ operates as a desktop application on Windows.Phone and tablet over RDP

Jednorázové plnění PALSTAT CAQ z Excel

Open file - warning about security

WINDOWS security messages must be cleared when running PALSTAT applications

https://www.palstat.cz/