[SOLVED] Excel 2007 Output giving Internal Server Error ( webserver) sometimes
HI, I am using webfocus 773 and use the below report.
i am getting the Internal Server Error if I use the below code. SQL ORA SELECT POL_NO, POL_EFF_DATE, ANN_STMT_CO_CODE, DUNS_NO, INSURED_NAME, SOURCE_SYSTEM_ID, PRODUCER_NO, POL_EXP_DATE, PREMIUM_MARKET_SEGMENT_CODE, BRANCH_CODE, DSP_DIV_NO, DSP_SEC_CODE, DSP_PUC, PRIOR_POL_NO, POL_TERM, POL_NO_PREFIX, AIGRM_CONTRACT_NO, ORIG_DSP_DIV_NO, ORIG_DSP_SEC_CODE, ORIG_DSP_PUC, LOAD_DATE, WORKING_BRANCH_CD FROM TABLE A WHERE ROWNUM<70000; TABLE ON TABLE HOLD AS ONE END
TABLE FILE ONE PRINT * WHERE RECORDLIMIT EQ 70000; ON TABLE PCHOLD FORMAT EXL07 END
But If i use the below query,i am getting the o/p in excel. SQL ORA SELECT POL_NO, POL_EFF_DATE, ANN_STMT_CO_CODE FROM EDW.POLICY WHERE ROWNUM<64000; TABLE ON TABLE HOLD AS ONE END
TABLE FILE ONE PRINT * WHERE RECORDLIMIT EQ 63999; ON TABLE PCHOLD FORMAT EXL2K END
Please help me to fix this issue.
Error:
"Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, you@your.address and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log."This message has been edited. Last edited by: <Kathryn Henning>,
Webfocus 7.1.6, Webfocus 7.7, Webfocus 8
June 13, 2013, 06:11 AM
santu
Hi Rakesh,
For Excel Worksheet size 65,536 rows by 256 columns.
Its better to check the number of lines while printing in the sheet. If the number of rows are more than 65,536 then change the sheet but i dont know exactly how to change the sheet....
Web FOCUS 7.7.03 PDF
June 13, 2013, 08:47 AM
jgelona
Create a new sheet like this:
DEFINE FILE XXXX
ROWNUM/I8=LAST ROWNUM+1;
SHEETNUM/I4=ROWNUM/65537;
END
TABLE FILE XXX
PRINT *
BY SHEETNUM NOPRINT
ON TABLE PCHOLD FORMAT EXL?? BYTOC
END
The BYTOC creates a new sheet when the Primary Sort Field Changes
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
June 13, 2013, 09:24 AM
Rakesh P
Thanks for your replay. Webfocus 77 support Excel 2007 and I think it can hold more than 65,536 rows.
ON TABLE PCHOLD FORMAT EXL07
My concern is that if I am running report with huge data, I am getting the error.
Webfocus 7.1.6, Webfocus 7.7, Webfocus 8
June 13, 2013, 10:21 AM
George Patton
EXL07 output is only fully supported with WF server version 7704 and higher ... There was some talk of making a hotfix back to 7703 but I don't know if that happened.