none
Errors in the OLAP storage engine: An error occurred while the 'Status Date' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. RRS feed

  • Question

  • Hi All,

    Recently we started building cube for one of the Project server 2013 site with SharePoint 2013 Plaftform. But getting into below error. Please suggest

    Error is: CBSOlapProcessingFailure. Details: CBS message processor failed Attributes:  Setting UID=8021bb6a-cdde-e611-94c5-0050561007dc ASServerName=ONSQLSHA.LOGON.DS.COM ASDBName=SP2013_Projects_DB_Cube ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=01/20/2017 08:00:00 ToDate=01/20/2017 08:00:00 HighPriority=True  Failed to process the Analysis Services database SP2013_Projects_DB_Cube on the ONSQLSH.LOGON.DS.COM server. Error: Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task Is Milestone', Name of 'Task Is Milestone' was being processed. Server: The current operation was cancelled because another operation in the transaction failed. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Timesheet Task List', Name of 'Timesheet Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Timesheet Task List attribute' attribute of the 'Timesheet Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Assignment Owner', Name of 'Assignment Owner' was being processed. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Issue Category', Name of 'Issue Category' was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Calendar Duration' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Deliverable Created Date', Name of 'Deliverable Created Date' was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Percent Completed' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Created Date' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Task Is Manually Scheduled' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Fixed Cost' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Duration' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Finish Date' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Actual Duration' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Resource Plan Date' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Actual Start Date' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Modified Date' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Currency' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Duration Variance' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Task Index' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Project Type' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Project Manager' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Start Variance' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Actual Finish Date' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Finish Variance' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Start Date' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Project Category Name' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Deliverable List', Name of 'Deliverable List' was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Project Keywords' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Percent Work Completed' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Project Title' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Project Subject' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Resource Plan Type' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Task List', Name of 'Task List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Duration' attribute of the 'Task List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Project Company Name' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Issue List', Name of 'Issue List' was being processed. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Resource Who Created Issue', Name of 'Resource Who Created Issue' was being processed. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Issue Status', Name of 'Issue Status' was being processed. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Finish Date' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Start Date' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed. OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ; 08001. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Project List', Name of 'Project List' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Status Date' attribute of the 'Project List' dimension from the 'SP2013_Projects_DB_Cube' database was being processed.   . Standard Information: PSI Entry Point:  Project User: PROJECTSERVER\system Correlation Id: 4fbb5a60-e7de-e611-94c5-0050561007dc PWA Site URL: https://sp2013qa.com/PWA SA Name: Project_Service_application_2013 PSError: CBSOlapProcessingFailure (17004), LogLevelManager Warning-ulsID:0x3869637A has no entities explicitly specified.

     


    Subhash



    • Edited by Kris_sp2013 Saturday, January 21, 2017 2:57 AM
    Friday, January 20, 2017 8:32 AM

Answers

  • Finally I'm able to resolve the issue.

    3 months before We migrated SQL Instance from one domain to the other domain . Now when i try to build a cube it is giving me the error because the old instance is no where exists now.

    I did configured sql alias with sharepoint servers but not with sql servers.Hence i got above error. After configuring sql alias with SQL Server my error got resolved and able to build cube from  sharepoint.


    Subhash

    • Marked as answer by Kris_sp2013 Monday, February 6, 2017 8:13 AM
    Monday, February 6, 2017 8:13 AM

All replies

  • Hi Kris_sp2013,

    According to the error message, it seems like an ODBC Error, you cannot connect to the SQL server data source.

    To fix this issue, you may need to update the user name and password stored in window “Impersonation Information” of  data source 'Project Reporting data source'.
    In SQL Server Management Studio, connect to Analysis Services, explore to the data source “Project Reporting data source”, right click on it, select “Properties”.

    In “Data Source Properties” window, click on ellipsis button in “Impersonation Info”.

    In “Impersonation Information” window, please select “Use a specific windows user name and password ”  enter user name “domain\user” and password.

    You can update it in SSDT project also, double click on data source “Project Reporting data source”, select tab “Impersonation Information”.

    For more detail, please refer to Fixing Cube Processing ODBC Errors .


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, January 23, 2017 2:02 AM
    Moderator
  • Finally I'm able to resolve the issue.

    3 months before We migrated SQL Instance from one domain to the other domain . Now when i try to build a cube it is giving me the error because the old instance is no where exists now.

    I did configured sql alias with sharepoint servers but not with sql servers.Hence i got above error. After configuring sql alias with SQL Server my error got resolved and able to build cube from  sharepoint.


    Subhash

    • Marked as answer by Kris_sp2013 Monday, February 6, 2017 8:13 AM
    Monday, February 6, 2017 8:13 AM
  • Hi Kris_sp2013,

    Thanks for sharing your solution.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, February 6, 2017 8:17 AM
    Moderator