FREQUENTLY ASK QUESTIONS

YOU CAN SEARCH PART OF THE TEXT OR NUMBER.

Incompatible databases found

The Palstat system does not support MSSQL 2008R2. Read SYSTEM REQUIREMENTS!

Log tables are huge

The database contains tables named LOG that are disproportionately large. You need to perform system logging maintenance and reduce the overall size of the database.

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

Connection to the information system

The PalstatCAQ database can be loaded from any ERP system and thus the databases of multiple systems can be synchronized online. Link your Contacts, Parts, Workers and more.

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.

License Update

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

Architecture mismatch between the Driver and Application

The error concerns the functioning of the CAQservice module and the associated driver (ODBC), where the service runs as a 64-bit process and expects the use of 64-bit drivers.

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.

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.

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.

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.

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.

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.

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.

Import print reports for QSD

DBBM, import/export data to mobile SQLite file

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

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.

PalstatCAQ - migrate

How to easily migrate the PALSTAT CAQ system

SQL Reindex

One way to speed up the system.

Other MSSQL commands

Minor commands for system administration

Create MSSQL databases for Palstat

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

PalstatCAQ - instalation

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

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.

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.

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.

SPC Station – Driver Setting

Driver assignment for SPC station and measuring plan

Print reports logo

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

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

Open file - warning about security

WINDOWS security messages must be cleared when running PALSTAT applications

How run the program on phone or tablet

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

https://www.palstat.cz/