Environment:
SAP BusinessObjects BI Platform 4.3 Support Pack 2 Patch 6
Version : 14.3.2.4343.6
Question:
What can be done to trace/recreate the below error consistently so we can track down and address root cause? Or if you know what is causing this what should we be looking at?
Exact Error: (Occurs after 60 minutes for same user on same report and other users on their reports)
You do not have access to one or more data providers. Only the data providers to which you have access will be refreshed
Steps user took to encounter error:
- User had been working in Fiori Webi Interface for 60 minutes +
- User Opens existing report in personal folder
- User refreshes data
- User enters query filter prompted values.
- user selects run
- User encounters error
Work around:
- User logs out of WebI
- User logs back into WebI
- User accesses EXACT same report for which error was encountered and follows exact same steps in steps user took to encounter error
- Report refreshes fine without error.
- 60 minutes later, errors return.
- Developer tools show a BOETimeoutPing occurring roughly at the same time and a KeepBOESessionAlive.jsp?random=XXXXXXXX about every 3 minutes.
Considerations:
- All servers are in a valid and healthy state.
- The issue appears to have started following update to 4.3 SP2 P600 from 4.3 SP2 P300
- We've found issue always occurs after1 hour following login. Each time for all users. 1 hour regardless of activity After the 1 hour; the user MUST log out and back in for WebI to function as user needs. Symptoms: various errors will be thrown depending on user interaction. If user attempts to export data; the saved data will be exported; not the "REFRESHED" displayed data.
- SIA is restarted nightly
- This happens to many users, for ANY report we've tested.
To further isolate the issue:
- The issue is not just the error: but data is being exchanged without error or user knowledge
- I created a report based on an uploaded excel document.
- The original Excel version had a value of "Saved data" I generated the report using ONLY this Excel document and saved the report. I then replaced the Excel document with a version having a value of "Refreshed Data"
- I then logged out and back in, refreshed the report. Confirmed the refreshed report showed "Refreshed Data" and not the original "Saved Data"
- I then exported the report and saw the "Refreshed Data" value on the PDF/Excel exports.
- I then waited for 1 hour. At the end of the hour I exported the data again.
- The data now had the "Saved Data" entry. The "Refreshed Data" no longer was exported even though it was displayed on the WebI Document that way. So no error; and now OLD Data...
- I did this having logged into the IP address of the CMS server directly to bypass any Load balancer, Dual node, or routing issues. I used excel to eliminate any RDBMS data source and it's settings as bein at issue.
- What is causing the "Refreshed" value to be Replaced with the "saved" version of the report? I know Fiori uses RESTful to interact; is Fiori somehow timing out at 1 hour and where is this setting!?!?
Thoughts:
- Could this be a caching issue of some sort?
- Why does logging out fix the symptom?
- Could it be somehow the session is corrupted by other reports and logging out clears out session?
- What steps can we take to further trace the error and isolate root cause?
Limitations
- I've access to the CMC/WebI Query builder
- No access to Operating System, install file, logs, webserver, database
- I can work with people to get information but it takes time.
Amendments:
- We can now create this on demand. It requires us to have authenticated to the system and be logged in for 60 minutes. Before 60 minutes the reports work fine, after 60 minutes all reports cease to function as desired and instead operate as if they were not refreshed (operate using saved data from original file load) Interaction with the report by filtering, navigating tabs, saving all result in one of various errors to be thrown.
- I can create this using just an Excel document and a report based on the excel upload. So, it's not firewall, Proxy, or Database limits. It's likely something with WebI/Fiori/RESTful...
Current Actions:
- 1/6/2022
- EUREKA!!!! the issue was with the biprws.properties file. Evidently the RESTful services fiori used were running via Tomcat and not the WACS RESTful server as we thought. In that poperties file there's an Enterprise Session Timeout Setting which was at 60 minutes. We adjusted to 1440 and no longer hhave the issue. I no longer feel like Charlie Brown having the ball pulled from him by Lucy.
- 12/29/2022
- We've been at this for over a month now. We've tried using developer tools to trace the issue, several other KB articles, provided numerous Log files, steps to reproduce, evaluations of Firewall, Proxy, Ports, Load Balancer. Provided BI support tool landscape details. So far; it's not been a quick answer.
- We're about to adjust remove command line parameters on the servers of -requesttimeout 3600000 (on many servers) and -cdzReqTimeoutMS 3600000 (on job servers) to eliminate these values which have been retained since 4.1. I don't expect it to work (It didn't)
- We will then try KB ##1608960 - Deploy BI4.x war files using the wdeploy command [How-To] [video] as recommended by SAP (We didnt do this either we found the BIPRWS.properties file setting!)
- Then we may try updating to 4.3SP3P0000 as in it RESTful has had an overhaul combining biprws.war files into BOE.war files for tighter integration. Since I think this is where the problem exists; It seems to be something worth to try. In the relase notes session issues were indicated as a problem. What I don't like about this approach is we may never know what the problem was. (this is still on the radar. but likely will wait to P100)