An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.

by XDK 15. March 2016 09:50

Exception:

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. For more information about this error navigate to the report server on the local server machine, or enable remote errors

Workaround:

Changing the data files 'auto growth' property from restricted to unrestricted resolved the issue.

  • Connected to the database server thru Microsoft SQL Server Management Studio
  • Right click on the database
  • Select properties
  • Select files
  • Click on ellipses buttons
  • Select "unrestricted File Growth"
  • Click OK

 

Tags:

SQL Server | SQL Analysis Services | SQL Reporting Services

Not able to connect to TFS cube (Tfs_Analysis - SSAS)

by XDK 13. November 2014 09:20

Exception:

Login failed for user XXX

Explanation:

I am not able to connect to TFS cube even though, I am in Tfs_Analysis --> TfsWarehouseDataReader's role. 

Solution:

Make sure that you have enabled the "Read definition" database permission for TfsWarehouseDataReader role

 

Tags: , ,

SQL Analysis Services | TFS 2012 | TFS 2013

TF221122: Error While Processing TFS OLAP Cube

by XDK 1. October 2014 11:44

Exception:

After upgrading to TFS 2013, the TFS OLAP Cube fails processing with one of the following messages:

Invalid column name ‘System_AssignedTo__Name’.; 42S22;

Invalid column name ‘System_AssignedTo__SID’.; 42S22

Query execution failed for dataset ‘ds[Whatever]‘

Solution:

  • In TFS Admin Console, look up the account under “Account for accessing data sources” under the “Analysis Services” tab (Reporting » Edit).
  • In SQL Server, add that account to the Tfs_Warehouse database, to the TFSEXECROLE role.

Tags:

SQL Analysis Services | TFS 2013

About the author

My name is Xavier Dilip Kumar Jayaraj having 16+ years of IT experience which includes solid experience and depth Knowledge in Application Life Cycle Management, Configuration Management, Implementation and Support using TFS on-premises and Azure DevOps. I have invested in gaining DevOps knowledege to expertise with Cloud Computing providers namely Microsoft Azure and Amazon Web Services in recent years. I am very positive to learn and adapt emerging technologies to client’s environment.

Microsoft Certified: Azure Administrator Associate

Microsoft Certified: Azure DevOps Engineer Expert

DevOps Engineer Certificate Program | Transcript 

OTP-AWSD5: AWS IoT: Developing and Deploying an Internet of Things

[PCEP-30-01] PCEP – Certified Entry-Level Python Programmer

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

CategoryList

Disclaimer

The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.