вторник, 18 июня 2013 г.

SAP BO 4 error with 1Mio rows (wis 30270)

In SAP BO 4.0 SP6

On refreshing WebI report which retrieves more than a million rows
throws the below error :-

An Internal error occured while calling 'getPages' API, Error
ERR_WIS_30270) WIS 30270.

Then:

The report cannot be generated.
Please contact your administrator:


==Resolution Summary==
SAP official answer:
"We have replicated this issue and this is raised as defect in the
product and raised as technical escalation.
We have received a positive update from the SAP PG team.

Firstly, we have received an adapt PR: ADAPT01695721, Milestone:
AURORA_4.0_Patch6.x candidates"


They offered workaround for WebI Rich Client and Server. Below
are the steps 

For server (windows only):
[HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI
4.0\default\WebIntelligence\Calculator]
Change "MaxThreads" to 1

For Richclient:
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI
4.0\default\WebIntelligence\Calculator]
Change "MaxThreads" to 1

I changed in Web Int Rich Client and it helped me.

But it was a problem to find this parameter in RHEL environment.
It is in
...SAP instal directorie/data/.bobj/registry/32/software/sap businessobjects/suite xi 4.0/default/webintelligence/calculator/.registry

But it didn't help.

wait FixPack:/

===Update:
Answer of SAP support:


"I have consulted this issue with our Webi team and found out that
the issue is still there for Linux environment even after making the
registry change and currently registry entry change only works for
windows System. "


"The current workaround available for Linux is to by applying filter
reduce the number of rows so that it can work correctly"


"Informed that as per the ADAPT01695593 this issue is fixed in Patch
3 i.e. 6.3 and SP07"


Also we can check matrix of new products:

In SAP note 1689146 - How to monitor release dates for upcoming service packs and fix packs?