Extract of data to own database has stopped working

If your Printix Home is from before 2019-10-07 you may have experienced that no data is extracted since that date. A data extract that fails can be seen as follows:

• On the Analytics tab on the Settings page the Last data extract will for ever show Working on it.
• Open History, select System to filter on these events, and then as you browse through the events you will see: Data extract started by Printix System - Failed.

On 2019-10-07 Printix started to record Azure AD users’ Department, so this can be used to post process data for subsequent departmental billing. The Users - Overview page in the Power BI Report version 1.3.1 has been updated to show department. See also: Version 1.3.1 release note on Github.

The reason the data extract fails is most likely a lack of permissions for the database user. Please ensure the user has ALTER TABLE permission on the Users table.

RESOLUTION:

• Adjust the permissions of the database user to allow ALTER TABLE.
• Alternatively you can add the Department column manually.