EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB36213: "Operation must use an updateable query" error message appears when configuring Intelligence Server against Access Metadata in MicroStrategy Configuration Wizard 9.x and newer

Community Admin

• Strategy

SYMPTOM:
When configuring Intelligence Server to connect to an Microsoft Access metadata in Strategy Configuration Wizard 9.x and newer, following error message appears:
 

ka04W000000OhnKQAS_0EM440000002HRV.jpeg

 


Server Definition manipulations error:(Database error <>:Execute Query failed.
Database error <>: Execute query failed.
Error type: Odbc error. Odbc operation attempted: SQLEXECDIRECT. Operation must use an updateable query.)

CAUSE:
In this particular scenario the Microsoft Access metadata database file was marked as read only.
 
ACTION:
Modify the Access metadata file properties so that it is not read only.
 

Comment

0 comments

Details

Knowledge Article

Published:

April 13, 2017

Last Updated:

April 13, 2017