Adaptive processing server is going down frequently when i`m using OPEN DOCUMENT URL?

[Former Member]

Dear All,

The Adaptive Processing Server (APS) is shows that running and enabled but I`m facing an issues with Adaptive Processing Server (APS), frequently. We have a DASHBOARD which is linked to the WEBI Reports through OPEN DOCUMENT URL(S). Once we clicked the Open Document URL link it shows that " please wait while the document is being processed " for lone time, the WEBI report is not opening after 15 mins also. It`s working fine once we have restarted the APS, after sometime the issues is started again. The problem is occurred in daily and frequently. could you please suggest me to solve the issue?

Server : Windows server 2008 r2 enterprise

BO Version : Business Objects Edge 4.0 SP 05

Thanks,

Sella Perumal P,

SAP BO BI Consultant.

[Former Member]

Server Details are:

Microsoft Server 2008 r2

SAP Business Objects edge 4.0 sp 05

RAM ( 16 GB)

[Former Member]

Memory considerations to be taken 16GB is not good enough i believe for your system. Is this a cluster / distributed system you have?

As you mentioned that sizing has been done correctly, it would be best to provide the architecture along with the memory allocation for each servers. Please do mention at any point how many users might login.

Do specify whether issue is with specific document or else specific opendocument only.

How much free space does the installation directory of BO has?

[Former Member]

Hi Arvind,

Thanks for the reply.

The server is not clustered.

The sizing has been done based on the availability of RAM.( like DSL Connection - 4GB ; WebI - 4GB ; LCM - 1GB and Others - 2GB)

All the open document

33 GB free space is available in the server installed Drive.

[Former Member]

Check whether the issue is occurring in CMC as well.

If issue is only with open documents, try to open the opendocs in different viewer options in BILaunchPad for webi and see whether it works out.

Additionally, how much time does the report take to open in BI LaunchPad and on refreshing the same.

[Former Member]

Thanks for all the replies.I hope the issue is coming only in BI Launch Pad, I didn`t noticed in CMC. It takes approx. 1 min to refresh the report. I will check with the same in public folder, instead of open document, weather it is working or not?

I will clear the Apache Tomcat Cache and APS cache, installed folder directory and i will update you.

[Former Member]

In addition to all this check the status if the opendocument url is copied and executed directly from browser.

[Former Member]

Hi,

I had a also a similar problem with the APS , when i have interacted with my BASIS team, they had stabilized the server after interacting with SAP, due to unstability server will godown frequently, if possible raise a OSS message with SAP.

Regards,

G.SaiNath

[Former Member]

Hi Sainath,

Thanks for the reply. If any possibilities, explain me to fix this issue else I will raise the request to SAP Support to resolve this issue.

Regards,

Sella Perumal P,

SAP BO BI Consultant.

[Former Member]

Hi,

I would suggest to scale the APS by following the guide "Best Practices for SAPBO BI 4.0 Adaptive Processing Servers". The guide can be found in SCN on http://scn.sap.com/docs/DOC-31711

Thanks and Regards,

M.Sumesh

[Former Member]

Hi Sumesh,

Thanks for the reply. The issue is coming after sizing the APS as well. Some time the CPU utilized is 100%? what is reason behind that?. Could you suggest me to solve the issue?

Thanks,

Sella Perumal P,

SAP BO BI Consultant.

[Former Member]

Hi Perumal,

Have you noticed which services is consuming more CPU?

Is it Java.exe ? Is it particular to any DSL Services or anyother service?

[Former Member]

Hi Prasad,

Thanks for the reply. All the time Tomcat6.exe and Java.exe is taking more memory (RAM) and CPU.

[Former Member]

I would request yoi to follw the same flow by clearing the tomcat cache and Data folder in Business-objects.

[Former Member]

Thanks for the reply. Could you please tell me, how to clearing the tomcat cache?

[former_member136842]

Hi,

does this happen only with the one Dashboard an the linked WebI Doucments.

Try to run other Documents and check if you have the same System behaviour.

Regards

-Seb.

[Former Member]

• Delete the contents under the Local host folder in order to clear Tomcat Cache

In local host folder we can find number of files like  Admin ,analytic  balancer,Businssproces bi,,cmcAPP…………….)  You mean to say all this folder files has to be deleted…Please clarify on this(Driver:\Program Files (x86)\SAP BusinessObjects\Tomcat6\work\localhost)

• Rename contents under the work Folder in order to of APS.

In data folder (Driver:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\\java\pjs\container\work

STOP APS and reanme the respective APS work folder.