VERIFIED SOLUTION i

Resolve error when creating report 'Cannot open database 'AUXXX' at geolevel 'XX'.' in AnySite

Products affected: AnySite™

Issue

Unable to produce a report in AnySite. Error message encountered below.
"Cannot open database 'AUxxx' at geolevel 'S1'."


User-added image

Cause

The specific variable (AUI05) which is being referenced in this particular report is not available at the ‘Statistical Area Level 1’ geography boundary..

Resolution

UPDATED: September 19, 2017

The user will need to edit the report by accessing the Configurator > Reports > double click on the problematic report and either remove the specific variables ('I05' in the example below) from the report or select a different report geography via accessing the 'Report Information' tab 'Report Geographies' drop-down list

User-added image