Skip to main content

MicroStrategy 'Read Only Database' error

Recently I ran across the following error while trying to run a report. My "mini" data warehouse is stored in Microsoft Access.

Report: Transactions for Heatmap

 Job: 836

 Status: Execution failed

 Error: SQL Generation Complete
QueryEngine encountered error: Execute Query failed. 
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42000:-1809: on SQLHANDLE] [Microsoft][ODBC Microsoft Access Driver] Cannot modify the design of table 'TTLOR2BS4MD000'. It is in a read-only database. Connection String: DSN=AnkeetFinancials;DBQ=C:\Users\ashah\Documents\AnkeetPersonalTransactions\FinancialTransactions.accdb;DRIVERID=25;FIL=MS Access;MAXBUFFERSIZE=2048;PAGETIMEOUT=5;UID=admin;. SQL Statement: create table TTLOR2BS4MD000 (
Transaction_Category TEXT(255), 
Statement_End_Date TIMESTAMP, 
Account_ID LONG, 
WJXBFS1 LONG, 
WJXBFS2 DOUBLE)
.. 
QueryEngine encountered error: Report [Transactions for Heatmap]: Drop table error: DBInstance = Ankeet FinancialsSQL Statement: drop table TTLOR2BS4MD000. 
Error in Process method of Component: QueryEngineServer, Project Ankeet Financials, Job 836, Error Code= -2147212544.

 Starting Time: 11:55:56

The fix is quite simple! You will need to go to Microsoft ODBC Administrator (Start > Search > ODBC Administrator) and go to the System DSN tab. Open the appropriate ODBC connection by double clicking on it and click on "Options" for additional options. Uncheck the 'Read Only" checkbox.

Back on MicroStrategy, close and reopen project, clear cache and your issues should be resolved!


Labels:

Comments

Unknown said…
Thanks a lot! This blog helps me with the MicroStrategy/Salesforce.com write back problem.
January 16, 2017 at 1:30 PM
Unknown said…
This is Good information about this topic..I like it.. wordpress database errors ..Keep it Up!
December 7, 2019 at 4:10 AM
Lavanya said…
Nice and good article. It is very useful for me to learn and understand easily.Thanks for sharing
Microstrategy Online Course
Microstrategy Certification
January 6, 2022 at 8:38 AM
Post a Comment

The Popular Ones

Using SQL To Calculate XIRR (Internal Rate of Return)

Thanks to binaryworld.net , I was finally able to get a sql way to calculate XIRR. After 2 long hours of search I found this site and the logic as well as the code works perfectly well! XIRR is a function in excel that calculates Internal Rate of Return based on payments/income over a period of time. Without further ado, here is the code (a slightly modified version from BinaryWorld.net. Happy XIRRing! -- First, CREATE XIRR Table to store values CREATE TABLE XIRRTempData( amt float, dt datetime, guid varchar(128) ) go create function dbo.XIRR( @d datetime, @GUID varchar(128) ) returns decimal(18,10) as begin /* USAGE: select @IRR = dbo.xirr(null, guid) select @IRR IRR, @IRR * 100 'IRR %' Note: Leave the first parameter (date) null if you wish to see the XIRR calculated as of the maximum date in the dataset provided else provide a specific date to see the XIRR calculated as the given date. Created By: Ankeet Shah Created On: 7/16/2008 */ IF @d is null SELECT @d = max(d) from Inc...
25 comments
Read more

Alternating Row Background Color For SSRS Matrix (Pivot Table)

I had a tough time to apply alternate row colors to a SSRS Matrix and finally figured out! Without further ado, here it is... Assume you have a matrix with more than 1, lets say 2 row groupings; RG1 and RG2. 1. Right-click on RG2 (innermost row group), and select "Insert Group"; for simplicity call it "RowColorGroup" 2. In the "Group On" section, add some constant value - for example ="" or ="ankeet" etc... you get the idea! 3. Select the newly created group "RowColorGroup" and enter the following in its "Value" property: =iif(RunningValue(Fields!RG1.Value & Fields!RG2.Value,CountDistinct,Nothing) Mod 2, "LightSteelBlue", "White") 4. Select the "BackgroundColor" property of "RowColorGroup" and enter "=Value" 5. Set the width of "RowColorGroup" to 0pt and "CanGrow" to false 6. Select the data cell(s) and set their "BackgroundColor" pro...
5 comments
Read more

cannot create a column accessor for OLE DB provider "ibmdasql" for linked server

I have a linked server from Microsoft SQL 2008 to a DB2 server. Today when I tried to run a SELECT statement based on the linked server, I hit this error, "cannot create a column accessor for OLE DB provider "ibmdasql" for linked server". Earlier in the day, we had restarted the SQL Server Service. Running the following script on the 'affected' sql server should fix the issue. USE [master] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROC [dbo].[usp_enum_oledb_providers] AS exec sp_enum_oledb_providers GO sp_procoption 'usp_enum_oledb_providers', 'startup', 1 Restart the sql server service after running above script.
Post a Comment
Read more