HomeGuides :: AssemblageTroubleshooting Tips and TricksError message - Unable to refresh cache... The SELECT permission was denied on the object tblClientsUnfiltered

10.9. Error message - Unable to refresh cache... The SELECT permission was denied on the object tblClientsUnfiltered

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.

Related Pages
This page was: Helpful | Not Helpful

© 2012 Trumpet, Inc., All Rights Reserved