PVC - Capture will not open

Papervision Capture uses SQL to keep track of everything it is doing and if SQL express is being used, there is a 10gb limit. If processing several batches, this will fill up the Maintenance Logs very quickly. If the SQL DB is full, a similar error as the one shown below will be given:

“Error executing [dbo].[PVDM_SESSIONS_1_INSERTWITHLICENSES]5244

Use the following steps to check if this is the same problem is being experienced in your environment and can use the steps to correct the issue:

  1. Open SQL Management Studio

  2. Log into the SQL Server that is being used for PVC

  3. Once connected, locate the “PVDM_SYS_MAINTLOGS”

  4. right-click and select properties

  5. check the size of the table. If it is excessively large, such as 8+ GB large, this will need to be emptied

    1. If that table is not large or is not present, can also check the “PV_SYS_MAINTLOGS” table and check the size of that table

  6. MAKE SURE YOU MAKE A BACKUP OF THE DATABASE BEFORE MAKING ANY CHANGES IN CASE YOU NEED TO ROLLBACK THE CHANGES!

  7. Right-click the large table and select Script Table As → Drop and Create to → New Query Editor Window

     

  8. This will open a new query window with a pre-filled script

  9. Hit F5 and run the script

  10. The table will now be empty

  11. Open PVC and the error should no longer be thrown.

  12. If you continue to get errors, please contact services@caso.com immediately.

 

CASO Knowledge Base