How to Delete the YSoft SafeQ Spooler Controller Cache

What Is the YSoft SafeQ Spooler Controller Cache?

The YSoft SafeQ Spooler Controller cache is the persistent storage on the YSoft SafeQ Spooler Controller server. YSoft SafeQ Spooler Controller saves all necessary data to the cache so that it can run in offline mode (without connection to YSoft SafeQ Management Server) and optimize the data flow between YSoft SafeQ Spooler Controller and YSoft SafeQ Management Server. The cache contains, for example, the print job metadata, billing codes, users, devices, and so on. Most of the entities stored in the cache are downloaded from YSoft SafeQ Management Server during the YSoft SafeQ Spooler Controller's startup. The others (e.g., users) are downloaded when needed.

About YSoft SafeQ Spooler Controller Cache Deletion

Deleting the YSoft SafeQ Spooler Controller cache is, in specific cases, the only way to restore proper YSoft SafeQ Spooler Controller functionality.

When the cache is deleted, the particular YSoft SafeQ Spooler Controller will lose all information about users, cards, jobs, billing codes, and printers etc.

  • All necessary information about printers, users rights, and billing codes are synchronized again to the YSoft SafeQ Spooler Controller (from YSoft SafeQ Management Server) during the first synchronization (after the restart of YSoft SafeQ Spooler Controller services).

  • Information about print jobs is synchronized as part of the cache recovery mechanism, where YSoft SafeQ Spooler Controller downloads all its jobs from YSoft SafeQ Management Server and saves them to the cache.

  • The user's data will be synchronized to YSoft SafeQ Spooler Controller (from YSoft SafeQ Management Server) during the first authentication of the user or when the user sends a print job to YSoft SafeQ that will be accepted by a particular YSoft SafeQ Spooler Controller.

WARNING

The YSoft SafeQ Spooler Controller cache is almost equal to the YSoft SafeQ Management Server database. The request for the deletion of the YSoft SafeQ Spooler Controller cache will be performed only when requested by Y Soft or when it is explicitly defined in the manual.

How to delete the YSoft SafeQ Spooler Controller Cache

Verify the YSoft SafeQ Spooler Controller cache recovery settings

Go to YSoft SafeQ management interface > System > Configuration on and set orsCacheRecovery property to enabled.

In case of YSoft SafeQ Spooler Controller cache data corruption, cache can be manually deleted and all job-related metadata will be recovered from YSoft SafeQ Management Server.

If you omit this step, all jobs stored on the YSoft SafeQ Spooler Controller might be lost after the end of procedure.


Stop YSoft SafeQ Spooler Controller services

Open the Services window (e.g.Start > Run > services.msc) and stop the following services:

  1. YSoft SafeQ Spooler Controller service

  2. YSoft SafeQ Spooler Controller Group Service service

  3. YSoft SafeQ Terminal Server service

  4. and, optionally, stop:

    1. YSoft Infrastructure Service Proxy service

    2. YSoft SafeQ End User Interface service

    3. YSoft SafeQ FlexiSpooler service

    4. YSoft SafeQ Mobile print service

Delete the YSoft SafeQ Spooler Controller Cache Directory

Delete the YSoft SafeQ Spooler Controller cache by deleting the entire folder <install_dir>\SPOC\SpoolCache (e.g., c:\SafeQ6\SPOC\SpoolCache)

Start YSoft SafeQ Spooler Controller services

Open the Services window (e.g., Start > Run > services.msc) and start the following services:

Do not start YSoft SafeQ Spooler Controller Group Service service. It will be started by YSoft SafeQ Spooler Controller service when proper configuration is ready.

  1. YSoft SafeQ Spooler Controller service

  2. YSoft SafeQ Terminal Server service

  3. and start other YSoft SafeQ services if they are not running:

    1. YSoft Infrastructure Service Proxy service

    2. YSoft SafeQ End User Interface service

    3. YSoft SafeQ FlexiSpooler service

    4. YSoft SafeQ Mobile print service

The YSoft SafeQ Spooler Controller cache recovery mechanism on a standalone SPOC with the recommended hardware is processing on average 3000 jobs per minute. That means with 60 000 jobs the recovery will take about 20 minutes. SPOC is not fully functional until the recovery is finished. To see how many jobs is going to be recovered use the following SQL query:

-- query to be launched on SQDB6 database
-- use proper tenant prefix at smartq_jobs table
-- use proper server_guid, SPOC guid can be found on YSoft SafeQ management interface -> tab Spooler Controller groups
SELECT count(1) FROM tenant_1.smartq_jobs where server_guid = 'j1dvczklt5l5hm69' and cur_status in (1,2,4,8,16,32,64,128,256,512)


Verify the correct YSoft SafeQ Spooler Controller functionality

Once the YSoft SafeQ Spooler Controller cache is deleted and YSoft SafeQ Spooler Controller services are running, verify the correct YSoft SafeQ Spooler Controller functionality according to the article YSoft SafeQ Spooler Controller Health Check.