on 01-06-2016 8:21 AM
Hi,
I tried to get the content of webi reports using REST calls.
I am interested in querying the dataprovider properties (viz source, source type) and dataprovider details (objects in the data provider, links if any).
When I try to execute them in batch mode through java application, after fetching few reports details my requests are getting time out. I have the connection time out as 10 minutes. When I retry the same report, I am getting the required data.
I am on BI 4.0 SP9.
Any specific settings needs to be made on WACS or any other services to avoid this issue.
Regards,
Subramanian S.
Hi Subramanian,
I can't think of any specific setting on the WACS that would cause this.
Since you are batch processing, you may be running into the "Maxmimum Documents per User" setting which is 5 by default on the webi processing server.
To avoid this, ensure that you are closing each document once you have finished gathering the details you need for each document.
To close a document, use the following
PUT /biprws/raylight/v1/documents/<docID>
body:
<document>
<state>Unused</state>
</document>
for more info, look for "updating the state of a document" in the documentation.
Dan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You don't have to close the document after every GET, but as a best practice you should close the document when you are finished with it to free up resources.
As per the documentation you don't need to modify a report in order for it to be opened. If you query for specific internal information about the report, the document will be opened an put into a state of "Original" if no changes have been applied, so this will count against the user's open document limit. Once closed (put into a state of "Unused"), the use count for the user is decremented.
Dan
Hi Subramanian
Possibly a session management problem where you accidentally opened too many sessions and the system gets confused, or maybe a memory issue with your program.
I had a similar requirement and used the examples here. I initially had problems similar to the ones you were talking about but once I cleared up session problems (both for reading from RESTful and writing to Oracle), the problem disappeared.
Regards
Richard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.