Virtualiser plante à 80896 ko

[jadey]

Hello les gens,
J'utilise un

Code :

JRSwapFileVirtualizer

pour palier au problème de saturation mémoire lors de la génération de rapport volumineux.
Quant celui ci est utilisé la taille du fichier swap ne cesse d'augmenter jusqu'à atteindre 80896 ko je me retrouve avec la pile d'exception suivante:

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
[04/04/11 15:10:09:765 GMT] 1676250a JRAbstractLRU E net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer  Error devirtualizing object
[04/04/11 15:10:09:780 GMT] 1676250a JRAbstractLRU E net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer  TRAS0014I: L'exception suivante a été consignée : java.io.IOException: Seek failed
	at java.io.RandomAccessFile.seek(Native Method)
	at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:190)
	at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:174)
	at net.sf.jasperreports.engine.fill.JRSwapFileVirtualizer.pageIn(JRSwapFileVirtualizer.java:106)
	at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.requestData(JRAbstractLRUVirtualizer.java(Compiled Code))
	at net.sf.jasperreports.engine.base.JRVirtualPrintPage.getElements(JRVirtualPrintPage.java(Compiled Code))
	at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:479)
	at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:419)
	at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:182)
	at com.maroclear.facturation.common.util.XcelHelper.getBytes(XcelHelper.java:72)
	at com.maroclear.facturation.action.business.OnDemandProdReportAction.generateReport(OnDemandProdReportAction.java:256)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
	at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
	at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
	at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
	at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
	at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
	at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
	at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:61)
	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
	at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
	at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
	at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
	at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
	at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
	at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
	at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
	at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
.
                                 java.io.IOException: Seek failed
	at java.io.RandomAccessFile.seek(Native Method)
	at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:190)
	at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:174)
	at net.sf.jasperreports.engine.fill.JRSwapFileVirtualizer.pageIn(JRSwapFileVirtualizer.java:106)
	at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.requestData(JRAbstractLRUVirtualizer.java(Compiled Code))
	at net.sf.jasperreports.engine.base.JRVirtualPrintPage.getElements(JRVirtualPrintPage.java(Compiled Code))
	at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:479)
	at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:419)
	at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:182)
	at com.maroclear.facturation.common.util.XcelHelper.getBytes(XcelHelper.java:72)
	at com.maroclear.facturation.action.business.OnDemandProdReportAction.generateReport(OnDemandProdReportAction.java:256)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
	at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
	at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
	at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
	at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
	at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
	at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
	at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:61)
	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
	at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
	at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
	at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
	at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
	at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
	at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
	at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
	at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
 
[04/04/11 15:10:09:796 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources    Resource org/apache/struts/action/ActionResources_fr_FR.properties Not Found.
[04/04/11 15:10:09:796 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources    Resource org/apache/struts/action/ActionResources_fr.properties Not Found.
[04/04/11 15:10:09:858 GMT] 1676250a RequestProces W org.apache.struts.action.RequestProcessor  Unhandled Exception thrown: class net.sf.jasperreports.engine.JRRuntimeException
[04/04/11 15:10:09:858 GMT] 1676250a WebGroup      E SRVE0026E: [Erreur de servlet]-[java.io.IOException: Seek failed]: net.sf.jasperreports.engine.JRRuntimeException: java.io.IOException: Seek failed
	at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.requestData(JRAbstractLRUVirtualizer.java(Compiled Code))
	at net.sf.jasperreports.engine.base.JRVirtualPrintPage.getElements(JRVirtualPrintPage.java(Compiled Code))
	at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:479)
	at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:419)
	at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:182)
	at com.maroclear.facturation.common.util.XcelHelper.getBytes(XcelHelper.java:72)
	at com.maroclear.facturation.action.business.OnDemandProdReportAction.generateReport(OnDemandProdReportAction.java:256)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
	at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
	at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
	at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
	at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
	at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
	at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
	at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:61)
	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
	at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
	at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
	at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
	at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
	at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
	at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
	at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
	at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
Caused by: java.io.IOException: Seek failed
	at java.io.RandomAccessFile.seek(Native Method)
	at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:190)
	at net.sf.jasperreports.engine.util.JRSwapFile.read(JRSwapFile.java:174)
	at net.sf.jasperreports.engine.fill.JRSwapFileVirtualizer.pageIn(JRSwapFileVirtualizer.java:106)
	... 39 more
 
[04/04/11 15:10:09:905 GMT] 1676250a WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: /jsp/nonAuthUser/penalitesLayout.jsp: init
[04/04/11 15:10:10:046 GMT] 1676250a WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: /jsp/nonAuthUser/header.jsp: init
[04/04/11 15:10:10:077 GMT] 1676250a WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: /jsp/nonAuthUser/quitPopup.jsp: init
[04/04/11 15:10:10:187 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources    Resource com/maroclear/facturation/ressources/ApplicationRessources_fr.properties Not Found.
[04/04/11 15:10:10:218 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources    Resource com/maroclear/common/struts/resources/labelScreen_fr.properties Not Found.
[04/04/11 15:10:10:280 GMT] 1676250a WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: /jsp/nonAuthUser/httpServerError.jsp: init
[04/04/11 15:10:10:483 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources    Resource com/maroclear/common/struts/resources/erreurs_fr.properties Not Found.
[04/04/11 15:10:10:483 GMT] 1676250a PropertyMessa W org.apache.struts.util.PropertyMessageResources    Resource com/maroclear/common/struts/resources/commonMessages_fr.properties Not Found.
[04/04/11 15:10:10:546 GMT] 1676250a WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: /jsp/nonAuthUser/footer.jsp: init
[04/04/11 15:10:17:015 GMT]  73ae508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: /index.jsp: init
[04/04/11 15:10:17:218 GMT]  73ae508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: /jsp/user/sayHello.jsp: init
[04/04/11 15:10:17:452 GMT]  73ae508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: /jsp/DAF/extractionEtatRecap.jsp: init
[04/04/11 15:10:55:265 GMT] 38cce508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: InvokerServlet: destroy
[04/04/11 15:10:55:265 GMT] 38cce508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: SimpleFileServlet: destroy
[04/04/11 15:10:55:265 GMT] 38cce508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: JSP 1.2 Processor:  destroy
[04/04/11 15:10:55:937 GMT] 38cce508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: JSP 1.2 Processor: init
[04/04/11 15:10:56:296 GMT] 38cce508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: FormLoginServlet: init
[04/04/11 15:10:56:312 GMT] 38cce508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: FormLogoutServlet: init
[04/04/11 15:10:56:312 GMT] 38cce508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: SimpleFileServlet: init
[04/04/11 15:10:56:312 GMT] 38cce508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: InvokerServlet: init
[04/04/11 15:10:56:327 GMT] 38cce508 WebGroup      I SRVE0180I: [FacturationWeb] [/FacturationWeb] [Servlet.LOG]: action: init
[04/04/11 15:10:56:608 GMT] 38cce508 ActionServlet I org.apache.struts.action.ActionServlet  Loading chain catalog from wsjar:file:/D:/work in progress/appli/all sources/PROD/JAVA/facturation/FacturationWeb/WebContent/WEB-INF/lib/struts-core-1.3.10.jar!/org/apache/struts/chain/chain-config.xml
[04/04/11 15:10:57:577 GMT] 38cce508 TilesPlugin   I org.apache.struts.tiles.TilesPlugin  Tiles definition factory loaded for module ''.

Quelqu'un peut il m'aider ?
Merci pour toutes vos contributions.

[jadey]

Alors en fait premièrement, pourquoi est ce que ça plante toujours à 80896 ko ? La réponse est toute bête: parceque

Code :

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, params, resultSetDataSource);

a fini son execution et

Code :

JRSwapFileVirtualizer

a bien fait son boulot et qu'un fichier de 80896 ko a été necessaire pour contenir les données de la requête executée.
La suite c'est l'export vers le format excel, et c'est la ou ça plante. J'ai l'impression que le fichier est tellement grand qu'il ne peut être lu et que ça plante au niveau de java.io.RandomAccessFile.seek(Long)
À l'aide

[Ecosmose]

Remarque toute bête qui ne répondra pas forcément à ta question ...

Penche toi peut être sur la limitation des 65535 lignes sous Excel... (en faisant un copier coller par exemple ou en ayant le nombre de ligne de ton rapport...)