Forum Discussion

akatsman's avatar
akatsman
New Contributor III
3 years ago

Table view retrieve timing out in excel

Hello,

We are pulling in a table view into excel and it is bringing up a timeout error. The error says: Table View size exceeds the memory allocated. We are able to run this in OneStream through a dashboard and see that what we are testing with returns ~169k rows of data.

We believe it is due to a connection timeout between excel and OneStream. Has anyone found a solution for increasing the timeout connection or another way stop the timeout from happening? 

We already increased the time out directly in OneStream, but that did not resolve the issue within excel.

Thank you,

AJ

Excel Add In
  • Sue_T's avatar
    Sue_T
    New Contributor II
    3 years ago

    AJ,

    The error message you mentioned says it is a memory issue, not a timeout. Is it possible that the user's workstation (i.e. laptop) does not have enough memory for the operation? I have seen users have issues when they have been working for some time in Excel, and they need to reboot in order to free up memory.