FREQUENTLY ASK QUESTIONS

  

The application stores analytical data (logging) during runtime, which can be evaluated in case of need to find an error or unexpected behavior of the application. These tables are automatically deleted by the system, but in certain cases it is possible that the size of the tables increases disproportionately and then manual intervention is necessary.

Logging tables

• PALEVENTLOG - error and warning logging
• PALSCHRESULTS - scheduled task logging
• PALSVCLOG - CAQservice logging
• PALOPERLOG - event logging

 

Solution

Manual intervention

Run the command below + perform Shrink database on the *data* database.

truncate table PALEVENTLOG;
truncate table PALSCHRESULTS;
truncate table PALSVCLOG;
truncate table PALOPERLOG;

 

Permanent solution

• Install our system service CAQservice.
• In the System Administration module, under the Scheduler -> Database Maintenance tab, activate CleanLogs