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.

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.

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'.

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.

End of support for Windows Vista, Server2008

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

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.

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.

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

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.

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.

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.

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.

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.

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"

License dialogue about using the program

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

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.

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.

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.

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/