Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-192

keikai can't evaluate EOMONTH after upgraded from ZSS

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Done
    • Affects Version/s: 5.0.0
    • Fix Version/s: 5.1.0
    • Component/s: None
    • Labels:
      None

      Description

      Steps to Reproduce

      1. run the war which is migrated from zss with repack.sh, replacing zss jar with keikai jar in keikai-zss-legacy-all-5.0.0.zip
      2. visit index.jsp

      A simple way to run a war

      1. download https://repo1.maven.org/maven2/com/github/jsimone/webapp-runner/8.5.47.2/webapp-runner-8.5.47.2.jar
      2. java -jar webapp-runner-8.5.47.2.jar usc_keikai.war
      visit http://localhost:8080/

      Current Result

      NFO: Error evaluating cell 'labor Effort'!AA10 when eval EOMONTH(G$10,0)
      java.text.ParseException: Unparseable date: "#NAME?"
      at java.text.DateFormat.parse(DateFormat.java:366)
      at edu.usc.isi.myportal.forecastmodule.laborplan.action.LaborPlanIntegrationController.populateDates(LaborPlanIntegrationController.java:1117)
      at edu.usc.isi.myportal.forecastmodule.laborplan.action.LaborPlanIntegrationController.populateData(LaborPlanIntegrationController.java:1070)
      at edu.usc.isi.myportal.forecastmodule.laborplan.action.LaborPlanIntegrationController.process(LaborPlanIntegrationController.java:164)
      at org.zkoss.zss.api.impl.ImporterImpl.imports(ImporterImpl.java:62)
      at org.zkoss.zss.api.impl.ImporterImpl.imports(ImporterImpl.java:90)
      at edu.usc.isi.myportal.forecastmodule.laborplan.action.LaborPlanIntegrationController.doAfterCompose(LaborPlanIntegrationController.java:183)
      at org.zkoss.zk.ui.impl.UiEngineImpl.doAfterCompose(UiEngineImpl.java:588)

      Expected Result

      no error

      Debug Information

      • this issue only happens when I replace jar with repack.sh. If I rewrite LaborPlanIntegrationController by replacing API. This error doesn't happen.
      • WEB-INF/classes contains source code

        Attachments

          Activity

            People

            Assignee:
            RaymondChao RaymondChao
            Reporter:
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: