Getting Exception when trying to upload a file with hyperlink data in Unix AIX |
S.P.L Srikanth |
2013-02-11 18:19:41 |
I was trying to upload an XLS file which has an email address. I was trying to upload the file in my local and everything works fine for me. When I deploy the application in QA(Unix AIX). I am getting the error which is shown below.
Error:
[2/11/13 10:42:21:743 EST] 7f17ba9c SystemOut U 2013-02-11 10:42:21,743 [Servlet.Engine.Transports:5] ERROR com.comerica.forms.types.FileUploadController - SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/11/13 10:42:21:743 EST] 7f17ba9c SystemOut U SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/11/13 10:42:21:743 EST] 7f17ba9c SystemOut U java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/11/13 10:42:21:743 EST] 7f17ba9c SystemOut U Error Code:393216
[2/11/13 10:42:21:743 EST] 7f17ba9c SystemOut U SQL State:60000
Uploaded File has test@email.com with hyper link in one of the cell. I will send the file in mail.
Please solve this ASAP.
|
Getting Exception when trying to upload a file with hyperlink data in Unix AIX |
S.P.L Srikanth |
2013-02-11 18:20:54 |
Data:
Test1
Test2
test@gmail.com(Hyperlink should be available).
|
Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX |
HXTT Support |
2013-02-11 18:59:09 |
|
Failed to recur your issue. Please send your sample file.
|
Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX |
S.P.L Srikanth |
2013-02-11 19:19:24 |
|
I have already sent the mail to webmaster@hxtt.net
|
Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX |
S.P.L Srikanth |
2013-02-11 19:23:28 |
|
Just now I have sent the mail to support@hxtt.com also. As I told, I cannot reproduce the issue in Windows but I can see issue when my app is deployed in UNIX AIX.
|
Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX |
HXTT Support |
2013-02-11 22:08:07 |
>java.lang.ArrayIndexOutOfBoundsException: 4090
Your sample is normal, but maybe your upload file contains invalid information. Please download the latest package, which will detect it.
|
Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX |
S.P.L Srikanth |
2013-02-12 14:46:36 |
I have downloaded Excel_Core_JDBC20.jar, HXTT_Common_JDBC20.jar and tried to reproduce the issue. I am getting the below error
Error:
[2/12/13 12:59:35:548 EST] 7f05e4d2 SystemOut U 2013-02-12 12:59:35,548 [Servlet.Engine.Transports:10] ERROR com.comerica.forms.types.FileUploadController - SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:154)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/12/13 12:59:35:549 EST] 7f05e4d2 SystemOut U SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:154)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/12/13 12:59:35:549 EST] 7f05e4d2 SystemOut U java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:154)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/12/13 12:59:35:549 EST] 7f05e4d2 SystemOut U Error Code:393216
[2/12/13 12:59:35:549 EST] 7f05e4d2 SystemOut U SQL State:60000
|
Re:Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX |
HXTT Support |
2013-02-12 17:04:30 |
>I have downloaded Excel_Core_JDBC20.jar, HXTT_Common_JDBC20.jar and tried to reproduce the issue. I am getting the below error
You should download Excel_JDBC20.jar or Excel_Embedded_JDBC20.jar, which is released on 2013-02-12. Older Excel_Core_JDBC20.jar and HXTT_Common_JDBC20.jar should be removed since it hasn't be refreshed this time.
|
Re:Re:Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix A |
S.P.L Srikanth |
2013-02-12 19:38:19 |
Hi have downloaded Excel_JDBC20.jar or Excel_Embedded_JDBC20.jar, removed the old Excel_Core_JDBC20.jar and HXTT_Common_JDBC20.jar and replaced with the downloaded jar files and tested. The belos is the error I got.
Error:
[2/12/13 22:32:54:132 EST] 74c8d0ae SystemOut U 2013-02-12 22:32:54,132 [Servlet.Engine.Transports:7] ERROR com.comerica.forms.types.FileUploadController - SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/12/13 22:32:54:133 EST] 74c8d0ae SystemOut U SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/12/13 22:32:54:133 EST] 74c8d0ae SystemOut U java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/12/13 22:32:54:133 EST] 74c8d0ae SystemOut U Error Code:393216
[2/12/13 22:32:54:133 EST] 74c8d0ae SystemOut U SQL State:60000
|
Re:Re:Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix A |
HXTT Support |
2013-02-12 20:40:08 |
1. How to know the detailed version information of HXTT Excel package?
1st way: "java com.hxtt.sql.excel.ExcelDriver" will print that information.
2nd way: check that MANIFEST.MF file in jar file.
It should be
Specification-Version: 4.1.108 on February 12, 2013
|
Re:Re:Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix A |
S.P.L Srikanth |
2013-02-14 21:30:57 |
When I cross checked
Excel_JDBC20.jar is updated on : 2013-02-10 11:08
Excel_Embedded_JDBC20.jar is updated on : 2013-02-11 09:35
Please check whether these are the updated ones and let me know which one I have to download and validate the issue
|
Re:Re:Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix A |
HXTT Support |
2013-02-14 23:41:34 |
|
The update date is 2013-02-12. Please login to download it.
|
Main
webmaster@hxtt.com