'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Resolve OLAP Database Errors in Microsoft Project Server
Question details
Users are experiencing queue job failures in Microsoft Project Server due to OLAP database connection errors.
- Product
- Microsoft Project Server
- Device & OS
- not provided
- Scenario
- Processing Microsoft Project Server queue jobs that require a connection to SQL Server Analysis Services.
- Observed behavior
- Queue jobs repeatedly fail with OLAP database and GeneralQueueJobFailed errors, indicating that the connection to the SQL Server Analysis Services server has failed.
Ensure you have farm administrator privileges in Microsoft Project Server and administrative access to the SQL Server Analysis Services (SSAS) instance before attempting to troubleshoot server connections.
Verify SQL Server Analysis Services Status and Permissions
Check the SQL Server Analysis Services instance to ensure it is running, accessible, and that the Project Server accounts have the correct permissions.
The GeneralQueueJobFailed error typically occurs when Project Server is unable to communicate with the OLAP cube backend. Ensuring the SSAS service is running and properly configured is the first step in resolving this issue.
Access the server hosting your SQL Server Analysis Services instance via Remote Desktop.
Open SQL Server Management Studio (SSMS) and attempt to connect to the Analysis Services instance to ensure it is actively accepting connections.
If you are using a named instance for SSAS, open 'services.msc' and verify that the SQL Server Browser service is running.
In SSMS, verify that the Project Server application pool service account has been granted administrative permissions on the SSAS instance.
Consult the Official Microsoft Q&A Community
Since Project Server queue and OLAP errors often require deep architectural troubleshooting, Microsoft specialists can provide targeted assistance.
Looking for a Lightweight Alternative to Microsoft Office?
While enterprise server errors like OLAP database failures require specialized IT support, your daily document, spreadsheet, and presentation tasks don't have to be complicated. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office, designed to keep your daily workflows running smoothly without server headaches.
- 1. Download WPS Office: Visit the official WPS website and click the free download button for your operating system.
- 2. Install the Suite: Run the downloaded installer and follow the quick on-screen instructions.
- 3. Open Your Files: Launch WPS Office to seamlessly open, edit, and save your existing Office documents.
Frequently Asked Questions
What causes the GeneralQueueJobFailed error in Project Server?
This error typically occurs when the Project Server queue service cannot communicate with backend services. It is most often caused by a timed-out SQL Server Analysis Services connection, network interruptions, or incorrect service account permissions.
How do I restart the Project Server Queue Service?
Open the Services console (services.msc) on your Project Server application server, locate 'Microsoft Project Server Queue Service', right-click it, and select 'Restart'. This can sometimes resolve temporary queue hangs.
Does WPS Office integrate directly with Microsoft Project Server?
No, WPS Office is an independent suite designed as a lightweight alternative to Microsoft Office desktop applications. It handles standard documents, spreadsheets, and presentations, but does not natively connect to Microsoft Project Server's enterprise OLAP cubes.
