Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] "Report_xjlarwer[1] is not a valid Web Archive" error in Excel

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] "Report_xjlarwer[1] is not a valid Web Archive" error in Excel
 Login/Join
 
<Navin>
posted
Hi,

We are trying to split the data content into mutiple excel sheets if the rumber of rows crosses 65K.
Below is the code used.

SQL SQLORA
select * from CSAT_CRNT_STAT_ACTY;

TABLE FILE SQLOUT
PRINT
*
COMPUTE COUNTER/I7=COUNTER + 1; NOPRINT
COMPUTE WORKSHEET/I3=COUNTER/65000; NOPRINT
BY TOTAL WORKSHEET NOPRINT
ON TABLE PCHOLD FORMAT EXL2K BYTOC
END

While trying to open excel the following error message is received
"Report_xjlarwer[1] is not a valid Web Archive"

We also tried to test the code with less number of records say 8000 rows and for every 1000 records a new excel sheet would be created
and it was working fine.
Code :

SQL SQLORA
select * from CSAT_CRNT_STAT_ACTY where rownum <=8000;

TABLE FILE SQLOUT
PRINT
*
COMPUTE COUNTER/I7=COUNTER + 1; NOPRINT
COMPUTE WORKSHEET/I3=COUNTER/1000; NOPRINT
BY TOTAL WORKSHEET NOPRINT
ON TABLE PCHOLD FORMAT EXL2K BYTOC
END


Kindly let me know what could be the issue as the code is not working only for large number of output.

This message has been edited. Last edited by: Kerry,
 
Report This Post
GamP
Virtuoso
posted Hide Post
Naveen,

Have tried your exact code, but with another table of course and against a db2 database, but did not get your error message. I just recieved a complete and correct excel document with a number of sheets.
My total report size was 170.000 records. If yours is larger, then maybe there is some extra limit imposed by excel that you violate?


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
<Navin>
posted
Hi,

I am trying to download only 90k rows into excel.
This code also works fine in the Windows environment. It is causing issue only in the Unix environment.

Is it that the xl loading starts after the .xht file is completely loaded. If yes then will this issue occur if there is time-out when the .xht file is getting populated ?
 
Report This Post
GamP
Virtuoso
posted Hide Post
Navin,

Please update your profile, so that it shows what platform you're running on - that saves time and topic entries.

I've been doing the excel run also on unix today - the USS flavor on mainframe. As I stated, no problems. But, one big difference is that my server release is 764, where yours in 716. That may be why mine is running fine, although I'm not sure of that.
Starting excel and populating the sheet is always only started after the result file is completed by the server. It will never happen that excel is started while the file that it is going to read is not fully ready yet.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] "Report_xjlarwer[1] is not a valid Web Archive" error in Excel

Copyright © 1996-2020 Information Builders