| T O P I C R E V I E W |
| njojo |
Posted - 01/30/2007 : 06:42:59
Whenever I choose to create an OLAP report, Choose the server/database...then it takes a very long time to give me cube options. We have very large dimensions...is this related to the size? Does report portal have a threshold at which you begin to have problems?
I am also having the problem with filters. Sometimes the dimension used as a filter shows up as empty and other times I get this error:
Error occurred during attempt to iterate schema.
Can anyone shed some light on what is going on and how I can fix it?
Thanks,
njojo |
| 9 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 02/12/2007 : 03:39:31
You might be having a memory problem with XMLA and IIS.
Try modifying the datasources.xml file located here:
C:\Program Files\Microsoft XML For Analysis SDK\Config\datasources.xml
Please open it in Notepad.
You need to modify the connection sting inside DataSourceInfo XML tag.
<DataSourceInfo>Provider=MSOLAP.2;Data Source=local; Client Cache Size=150; Execution Location=3; Default Isolation Mode=1; Large Level Threshold=100;</DataSourceInfo>
Here are the connection properties you should try to change:
1) Client Cache Size=150; - try to make smaller
http://msdn2.microsoft.com/en-us/library/aa237360(SQL.80).aspx
2) Execution Location=3; 3 - Queries are executed on the server.
http://msdn2.microsoft.com/en-us/library/aa237489(SQL.80).aspx
3) Default Isolation Mode=1;
http://msdn2.microsoft.com/en-us/library/aa237474(SQL.80).aspx
4) Large Level Threshold=100; - try to make smaller
[url]http://msdn2.microsoft.com/en-us/library/aa237403(SQL.80).aspx[/url] |
| marco |
Posted - 01/30/2007 : 23:13:15
Analysis Services 2000 is that Standard or Enterprise Edition ?
If Standard only 2Gb RAM is supported and I have seen more GBs makes it slower but this is not always `the case !
Marco |
| njojo |
Posted - 01/30/2007 : 18:10:53
Analysis Services is on the web server (along with Report Portal). That is the server that has the 8 GB of ram.
Sql Server 2000 SP4, Standard Edition is on a different server.
The reports are not available for viewing outside of my company. |
| marco |
Posted - 01/30/2007 : 14:52:00
Hi,
8GB RAM is that for SQL Server or Analysis Services 2000 ?
I was expecting that the webserver and SQL Server were on 1 server and OLAP on the other ?
Do you use SQL Server 2000 sp3 or sp4 and use Enterprise Edition ?
Can I see somewhere on internet the reports ?
Regards, Marco |
| njojo |
Posted - 01/30/2007 : 13:09:57
Also, with ReportPortal 2.0, Build 34 what version of the .net framework should we be running?
|
| njojo |
Posted - 01/30/2007 : 12:21:57
We do plan to move to the latest version...but I need help now. Has anyone seen this error and can tell me what to do........
We just added ram to the web server, now has 8GB....AS2000 is running on the web server. SQL Server 2000 is on another machine.
Still getting: error occurred during attempt to iterate schema
Any help is greatly appreciated as we are to release this to a customer in 5 days.
|
| marco |
Posted - 01/30/2007 : 10:41:30
Maybe you can test with the latest build: ReportPortal 2.1 Build 135 it should be faster than 2.0.
MArco |
| njojo |
Posted - 01/30/2007 : 06:57:26
OLAP SSAS2000
Windows 2003
ReportPortal 2.0, Build 34
I have not tried it with Adventure Workds DW.
When I try to access the cubes (through olap creation) the service w3wp.exe hogs the memory on the machine. |
| marco |
Posted - 01/30/2007 : 06:47:34
Hi,
Which OLAP: SSAS2000 or SSAS2005 ?
If SSAS2005 SP1 or higher ?
Windows 2000 or 2003 Server ?
Which ReportPortal build ?
Do you have the same problems with Adventure Works DW ?
Regards, Marco |
Report Portal
