Topic
  • 2 replies
  • Latest Post - ‏2013-11-12T20:45:33Z by brunoro
brunoro
brunoro
29 Posts

Pinned topic Erro while building an Cube

‏2013-11-12T16:48:35Z |

Hello,

 

Can someone help me on this error message attached?

I am buildind an cube and when is close to finish get this error...I dont know what means..maybe is time out from database connection...

 

Attachments

  • OpherB
    OpherB
    664 Posts

    Re: Erro while building an Cube

    ‏2013-11-12T20:32:59Z  

    It's hard to tell just where the problem is from this error. Here are the possibilities I see:

    • Timeout of data source
    • Out of Temp Space on database server
    • Out of Temp Space on Transformer server/PC
    • Too many categories in Model
    • Divide by zero error or similar data quality issue

    I suggest you filter down the data source to take records after the 155 million that were processed. See if the cube can build. Monitor disk space on all affected systems. View the Dimension Map with category count turned on - is it ugly?

    Hopefully, one or more of these will point to the problem.

    Good luck,
    Opher

     

     

  • brunoro
    brunoro
    29 Posts

    Re: Erro while building an Cube

    ‏2013-11-12T20:45:33Z  
    • OpherB
    • ‏2013-11-12T20:32:59Z

    It's hard to tell just where the problem is from this error. Here are the possibilities I see:

    • Timeout of data source
    • Out of Temp Space on database server
    • Out of Temp Space on Transformer server/PC
    • Too many categories in Model
    • Divide by zero error or similar data quality issue

    I suggest you filter down the data source to take records after the 155 million that were processed. See if the cube can build. Monitor disk space on all affected systems. View the Dimension Map with category count turned on - is it ugly?

    Hopefully, one or more of these will point to the problem.

    Good luck,
    Opher

     

     

    Thaks so much Opher B.

    I'll follow your tips!

    Brunoro