Symptoms

After upgrading Junxure, attempts to load Assemblage configurations result in the following error message:

Error message - Unable to refresh cache Unable to interact with database [Microsoft][ODBC SQL Server Driver][SQL Server] The SELECT permission was denied on the object tblClientsUnfiltered, database Junxure, schema dbo

Background

In a recent upgrade, Junxure changed permissions on certain tables in their database.  We have added special handling to the Assemblage database handler to detect this situation and automatically work around it.

Procedure

Upgrade Assemblage to version 1.0.352 or higher.  Please see Update Instructions for details on how to do this.  If you need a download link, please send a request to support@trumpetinc.com and include "Need Assemblage upgrade to fix Junxure issue" in the subject line.