 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Excel gone after a while?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Excel gone after a while? Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Excel gone after a while? | Login/Join |
| Master |
Hi all, I have a question. I tried to search it in the forum but couldn't find anything. I have a .fex with output format EXL2K. When done the browser show a message what to do with it: Open, Save or Cancel But I'm not always behind my computer when this happens. And when I come back I choose 'open'... ...and then nothing happens. I seems that the excel is removed from the server? Does it clean-up after a time-out? Setting the windows xls-setting to open automatically is not what I want. I need it to ask me what to do with it. Does anyone ever noticed this? Is it a time-out setting? It does seems to happen only with bigger files.. ( 40000+ rows ) any clues? Greets,DaveThis message has been edited. Last edited by: Kerry, _____________________ WF: 8.0.0.9 > going 8.2.0.5 | ||
|
| Gold member |
Hi, I've often had this problem. No idea why it happen though and never thought to ask! Interested to see if anyone does know why it happens. Jinx. 7.6.11 Windows HTML, PDF, Excel etc DevStudio/Webfocus/Focus IBM SQL Server 2000 / 2008 DB2 | |||
|
| Virtuoso |
Someone explained it to me once...Because when the report is run...depending on your Release of WebFocus..the report is actually going to a .MHT format and not native Excel. I'm sure there is a better explanation. It is quite annoying. | |||
|
| Virtuoso |
May also have something to do with redirection. With redirection enabled for a file type, the file is actually saved to a temp location on the webserver ( as opposed to being sent directly to the browser) and then the user receives a redirection to that location. As it is temporary, it IS cleaned up after a while. There is a setting that determines how long those are held, but I can't remeber off the top of my head what it is. You might also turning off redirection for xls/mht file types in the W Client console and see if that makes any difference. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Expert |
We have this problem too, but only since we changed the environment from two-tier to three-tier. I've never had the problem with the web server and WebFOCUS servers on the same machine. We now have the web server on a windows machine and the WebFOCUS server on a AIX machine and we very often have the problem. We use IBM WebSphere and IBM HTTP Server, I dug around the IBM support site and may have found a hot fix to correct the problem, but it has not been applied yet. Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Virtuoso |
we also have this, and running on the same machine what i do is running it deferred. might be a solution for you too
| |||||||
|
| Expert |
I would suggest that you don't rely on the report still being there, instead, save it somewhere, and return a link to it or email it. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
Thanks so far, I trying to find a solid solution. "Run deferred" is indeed good way to prevent your reports from dissapearing. But for the end-user this somtimes seems unneccesary elaborate. I'm interested in Francis' remark about the possible time-out. Waz: I that case I must create an unique filename I guess? And a e-mail containing a link. Can this be done in a self-service report on a dashboard? ( could you give me some pointers where I might find a sample of that? ) ( and I have to check with IT how and where to save... ) Thanks all, Dave _____________________ WF: 8.0.0.9 > going 8.2.0.5 | |||
|
| Expert |
I've worked with WebFOCUS for over 10 years, why is this problem rearing its ugly head now? Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Excel gone after a while?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Excel gone after a while?Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |