web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Error While Processing Cube from Analysis services

(0) ShareShare
ReportReport
Posted on by 155

Hi , Im getting below error while processing the cube

<Batch xmlns="schemas.microsoft.com/.../engine">
  <Process xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:ddl2="schemas.microsoft.com/.../2" xmlns:ddl2_2="schemas.microsoft.com/.../2" xmlns:ddl100_100="schemas.microsoft.com/.../100" xmlns:ddl200="schemas.microsoft.com/.../200" xmlns:ddl200_200="schemas.microsoft.com/.../200" xmlns:ddl300="schemas.microsoft.com/.../300" xmlns:ddl300_300="schemas.microsoft.com/.../300" xmlns:ddl400="schemas.microsoft.com/.../400" xmlns:ddl400_400="schemas.microsoft.com/.../400">
    <Object>
      <DatabaseID>Dynamics AX</DatabaseID>
      <CubeID>ProjCube</CubeID>
    </Object>
    <Type>ProcessFull</Type>
    <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
  </Process>
</Batch>
	Processing Dimension 'Aging period' completed.
		Start time: 12/17/2015 10:51:32 AM; End time: 12/17/2015 10:52:35 AM; Duration: 0:01:03
		Processing Dimension Attribute '(All)' completed.
			Start time: 12/17/2015 10:51:32 AM; End time: 12/17/2015 10:51:32 AM; Duration: 0:00:00
		Processing Dimension Attribute 'DATAAREAID' completed.
			Start time: 12/17/2015 10:51:32 AM; End time: 12/17/2015 10:52:35 AM; Duration: 0:01:03
		Processing Dimension Attribute 'Outstanding age range  major' completed.
			Start time: 12/17/2015 10:51:32 AM; End time: 12/17/2015 10:52:35 AM; Duration: 0:01:03
		Processing Dimension Attribute 'Outstanding age range  minor' completed.
			Start time: 12/17/2015 10:51:32 AM; End time: 12/17/2015 10:52:35 AM; Duration: 0:01:03
		Processing Dimension Attribute 'WIP age range  major' completed.
			Start time: 12/17/2015 10:51:32 AM; End time: 12/17/2015 10:52:35 AM; Duration: 0:01:03
		Processing Dimension Attribute 'WIP age range  minor' completed.
			Start time: 12/17/2015 10:51:32 AM; End time: 12/17/2015 10:52:35 AM; Duration: 0:01:03
Errors and Warnings from Response
	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; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
	Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
	Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'PROJTRANSPOSTINGDIMENSION', Name of 'Aging period' was being processed.
	Errors in the OLAP storage engine: An error occurred while the 'Outstanding age range  minor' attribute of the 'Aging period' dimension from the 'Dynamics AX' 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; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
	Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
	Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'PROJTRANSPOSTINGDIMENSION', Name of 'Aging period' was being processed.
	Errors in the OLAP storage engine: An error occurred while the 'DATAAREAID' attribute of the 'Aging period' dimension from the 'Dynamics AX' 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; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
	Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
	Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'PROJTRANSPOSTINGDIMENSION', Name of 'Aging period' was being processed.
	Errors in the OLAP storage engine: An error occurred while the 'WIP age range  major' attribute of the 'Aging period' dimension from the 'Dynamics AX' 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; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
	Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
	Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'PROJTRANSPOSTINGDIMENSION', Name of 'Aging period' was being processed.
	Errors in the OLAP storage engine: An error occurred while the 'Outstanding age range  major' attribute of the 'Aging period' dimension from the 'Dynamics AX' 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; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
	Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
	Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'PROJTRANSPOSTINGDIMENSION', Name of 'Aging period' was being processed.
	Errors in the OLAP storage engine: An error occurred while the 'WIP age range  minor' attribute of the 'Aging period' dimension from the 'Dynamics AX' database was being processed.
	Server: The current operation was cancelled because another operation in the transaction failed.


*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Brandon Wiese Profile Picture
    17,788 on at
    RE: Error While Processing Cube from Analysis services

    The error message is clear.

    "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; Named Pipes Provider: Could not open a connection to SQL Server [53]."

    The SSAS service is trying to connect to your SQL Server using the named pipes provider.  This provider is not typically enabled by default.  Either enable the Named Pipes provider on your SQL Server, or configure the Connection string in your SSAS project to use TCP/IP instead.  Alternately you can probably use the SQL Server client configuration on your SSAS server to disable the Named Pipes option on the client configuration.

  • Suggested answer
    Rudi Hansen Profile Picture
    4,055 on at
    RE: Error While Processing Cube from Analysis services

    Well then you need to look for the table 'PROJTRANSPOSTINGDIMENSION' and select 'Edit Named Query'

    Then in that tool that comes up you need to make sure that the Query can run.

    If it can't then you have to fix the query so it runs.

  • smshyd Profile Picture
    155 on at
    RE: Error While Processing Cube from Analysis services

    it didn't work, any suggestions

  • Suggested answer
    Rudi Hansen Profile Picture
    4,055 on at
    RE: Error While Processing Cube from Analysis services

    Can you try one thing, before you process the Cube, go to Change Settings/Processing Order/Processing Order set it to Sequential and Separate Transactions.

    I have sometimes seen that solve problems with processing a cube

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
howalker Profile Picture

howalker 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans