SLP Import OLE records

本文由 Su.Chow 在 2011-07-12 發表於 "WebSAMS 討論區" 討論區

  1. 55057471

    Su.Chow
    Expand Collapse

    文章:
    44
    讚:
    0
    My school faces this problem while uploading OLE records. Please help!

    When uploading a file of OLE records with multiple students, the screen flashes once and there is no successful or error message on top. Upon refreshing the screen, the following appears:

    WebSAMS > Page Error
    The action has been aborted. The page is not currently available.
    Please contact technical support
    Thanks for your understanding.
    Technical Details
    Referer = http://xxxxxx.edu.hk/jsp/index.jsp
    javax.servlet.ServletException at websams.web.asr.TermAssessAction.perform(TermAssessAction.java:147) at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787) at websams.web.WSActionServlet.processActionPerform(WSActionServlet.java:414) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586) at websams.web.WSActionServlet.process(WSActionServlet.java:322) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at websams.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:245) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458) at org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551) at java.lang.Thread.run(Thread.java:484)
     
    #1 Su.Chow, 2011-07-12
  2. 56953375

    edb-石頭
    Expand Collapse

    文章:
    1,160
    讚:
    0
    Does the same error happen even after server rebooted? if so, pls contact school tech support ro call 31258510 NCS Helpdesk for assistance.
     
    #2 edb-石頭, 2011-07-12
  3. 55057471

    Su.Chow
    Expand Collapse

    文章:
    44
    讚:
    0
    Yes, the problem still exists after rebooting.
     
    #3 Su.Chow, 2011-07-12
  4. 55036102

    Tim
    Expand Collapse

    文章:
    33
    讚:
    0
    My school had the similar problem too. As I did not refresh the page, I could not see the error page. After investigation, I found that many of my students did not fill in the excel template correctly. That is, they could not pass the validation. The system showed no response when large amount of problematic records were being uploaded, generating very slowly the error report, I guessed.
     
  5. 55057471

    Su.Chow
    Expand Collapse

    文章:
    44
    讚:
    0
    My school's case is little different from Tim's.
    I was testing the uploading process by using one student's OLE records. The validation passed and I tried to upload using both methods (one file with multiple students and one file per student; of course two different excel files were used and both passed the validation process). But the situations were similar: the screen flashed and didn't return any message of whether the upload is successful or not. Then, when clicking onto other function in any module in WebSAMSm the looooooooong error page was seen.
     
    #5 Su.Chow, 2011-07-12
  6. 55057471

    Su.Chow
    Expand Collapse

    文章:
    44
    讚:
    0
    After trial and error, the major problem is the punctuation mark apostrophe '. If the English content of the file contains this punctuation, the screen flashes and doesn't return any message of whether the upload is successful or not. If all the spostrophes are replaced by ’ (i.e. 全形), the file can then be uploaded as usual.
    For those who are going to do the uploading of OLE, please pay attention to this!
     
    #6 Su.Chow, 2011-07-13
  7. 56955171

    Hello Wind
    Expand Collapse

    文章:
    173
    讚:
    0
    #7 Hello Wind, 2011-07-19
  8. 56424333

    edb-stsim2
    Expand Collapse

    文章:
    258
    讚:
    0
    八月份私「版本升級」將會處理這個問題,敬請老師留意 CDR
     
    #8 edb-stsim2, 2011-07-21