I'm using SAP Olap Connector 5.6 to access an Infocube. The infocube is big and I get this error:
> 2011-12-07 09:38:16 Error ErrorKey: TSV_TNEW_PAGE_ALLOC_FAILED, ErrorMessage: No more storage space available for extending an internal table.
> 2011-12-07 09:38:16 Trace Cube not sliced. Retreival failed.
> 2011-12-07 09:39:24 Progress Disconnected
I tried to slice the cube and it works but the SAP Administrator told me that the cause of the problem is that the SAP Connector opens a Dialog job, not a Batch job. The administrator told me that the dialog jobs are limited to avoid that an online user collapse the system. He suggested to use a Batch job to avoid the need of slice the cube.
You can schedule the QV as a Batch Job process. But from SAP's point of view, "batch job" means a little bit different.
I just read something about this issue from SAP's web site. May be it makes sense to you.
By the way, I had faced exactly same error message when I was a Business Objects consultant. Again, the InfoCube is very big and we can not run reports due to the limitations. We were natively using the connector that was provided by SAP Business Objects..
What I can suggest you, try to connect DSO or R/3 instead of Infocube. By doing this, you can develop your own schema at QV. This will give you the flexiability of QlikView also.
If you develop your QV document over Infocube, you all depend on the hierarchies that are develop at the cube. If the business user wants to add a new level in their hierarchies, you need to restructure your Infocube. So, this will increase the development time etc..
Hope that information are useful for you..