Knowledgebase
Knowledgebase : PaperCut > Databases
When upsizing to Microsoft SQL server you may encounter the following error message with some configurations. SQL state [HY000]; error code [1598]; Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog...
PaperCut NG and PaperCut MF share a common database schema. Organizations running PaperCut on an external database system such as Microsoft SQL Server, PostgreSQL, or Oracle may find the following schema diagrams useful when designing custom SQL queries a...
IMPORTANT: PAPERCUT’S DEFAULT DATABASE SETTINGS ARE SUITABLE FOR CUSTOMERS OF ALL SIZES. TUNING THESE SETTINGS IS NOT TYPICALLY REQUIRED. IF YOU ARE EXPERIENCE DATABASE CONNECTION ISSUES, PLEASE CONTACT SUPPORT BEFORE EXPERIMENTING WITH THESE SETTINGS. ...
_“Help! We attempted to upgrade our PaperCut NG/MF server, but in the process we saw an error page in the browser that said “Database upgrade error”. What does this mean and how can we fix it?”_ You may have stumbled across this error page while upgradin...
_Note: This article covers the ‘hidden’ database upgrade process that happens when you upgrade your Application Server from e.g. version 19.x to version 20.x._ _If you’re looking for more information on upgrading the PaperCut Application Server, Secondar...
This article discusses the problems associated with a corrupted PaperCut database. It is designed to help you understand what may cause corruption, and how to reduce the risks associated with experiencing corruption. SYMPTOMS OF DATABASE CORRUPTION * ...
On some Mac systems, PaperCut 13.3 and older may generate an error and fail when attempting to use db-tools as part of restoring a database, a required activity when migrating a Primary Server installation of PaperCut. The applicable error message is:  ...
EXAMPLE SQL QUERIES (WHEN RUNNING ON AN EXTERNAL DATABASE) When running PaperCut on one of the supported external databases [http://www.apms.com.hk/product/papercut-ng/manual/ch-ext-db.html] SQL queries may be run to find specific data or produce reports...
WHAT IS AN EXTERNAL DATABASE? An external database is defined as any database other than the built-in Derby database that is packaged with PaperCut as standard. HOW DO I USE AN EXTERNAL DATABASE WITH PAPERCUT? If you’d like to run PaperCut from an exte...
By default PaperCut uses an internal embedded database called Apache Derby which was initially developed by IBM and sold as Cloudspace DB. PaperCut can also be run on external databases like Microsoft SQL Server. Some PaperCut customers may wish to utili...
The PaperCut Support team recently came across this error when a customer was Up Sizing [https://www.apms.com.hk/product/ng-mf/manual/common/topics/ext-db.html] their PaperCut installation to use an external Microsoft SQL database [https://www.apms.com.hk...
_“I need to move my PaperCut database to a different server - how do I do that?”_ If you’re running PaperCut on an external database [https://www.apms.com.hk/product/ng-mf/manual/common/topics/ext-db.html] like Microsoft SQL, PostgreSQL, MySQL or Oracle,...
If it’s been a good while between PaperCut upgrades and you are making a significant jump between versions, our install-over-the-top will handily fill in the gaps so you can jump from “old and dusty” to “new and shiny” with ease! That being said, in thes...
By default PaperCut uses an internal embedded database called Apache Derby which was initially developed by IBM and sold as Cloudspace DB. PaperCut can also be run on external databases like Microsoft SQL Server (including the free Express Edition), Postg...
Scripts to fetch information from PaperCut This page contains a collection of user-contributed scripts for fetching information from PaperCut. PaperCut provides many methods for retrieving information about the data it stores, including: Scheduled...
PaperCut can run on an external database like SQL Server. The setup process is described in the manual here: https://www.apms.com.hk/product/ng-mf/manual/common/topics/ext-db.html If you receive errors like the following when you try to connect to the SQ...
The log file is maintained by SQL server, and managing its size is a SQL Server administration issue. The LDF file is the transaction log that allows you to perform “point in time” restores if you have system failures. The way it works is that you can res...
By default PaperCut can use SQL authentication by configuring the database username and password in the PaperCut server.properties file. This is discussed in the manual here [https://www.apms.com.hk/product/ng-mf/manual/common/topics/ext-db-upsizing.html]...
The internal Derby database that comes as standard with PaperCut is stable, scalable, self-maintaining and provides efficient performance. For this reason most organizations do not need to run PaperCut on an external database system. That being said, ther...
PaperCut uses a database to store all of its configuration and print log data. By default, PaperCut uses an internal embedded database called Apache Derby as its database. This database is used on 10,000’s of our customers PaperCut installations and has p...