Dear Experts
Recently, I have been getting this API error on few our reports and unable to track the root cause of this. I assume it is quite common error but couldn't find a correct resolution to this error for the last few days.
This error occurs on reports that contain multiple query tab/with object filters/long volume reports and especially on scheduling (since report run time last for few mins approx.20-45 mins depends on size).
During schedule failure, we also get different API errors upon excel/PDF format as listed below,
An internal error occured while calling 'getPages' API. (Error: ERR_WIS_30270)
An internal error occured while calling 'openDocument' API. (Error: ERR_WIS_30270)
1. Checked if there is any issue on objects used in query selection by removing one by one.
2. Already the query is modified to run better when compared to initial development stage.
3. Using dedicated server node for its report scheduling.
4. Tried different notes which already exists
Has anyone resolved this issue before or what are the suggestion to overcome this issue?
System:
* SAP Business Objects 4.0 SP6
* DB - Oracle 11
Regards
Kishore Balachandran
1 Answer
-
Former MemberPosted on Aug 13, 2016 at 08:10 PMHi Kishore,
How many reports do you have?
Are all based on single universe or multiple universes?
ProcessDPcommand error generally comes due to connectivity issues.
Do you get this error while refreshing the report or only while scheduling?
How many queries are there? Can your refresh them one by one and check which query is giving the error?
If affected reports are based on single universe, you might creating a new connection and check.
In case the reports are heavy and taking long time to run, you can set "Disconnect after each transaction" in connection properties.
Do you have both BO server and Oracle server on same machine? If yes, do you get this issue when you remotely log onto BO server and refresh the report?
Regards,
Yuvraj
Add a comment
Add a comment