Uploaded image for project: 'Spring Batch Admin'
  1. Spring Batch Admin
  2. BATCHADM-174

Can't view second page of job execution due to windowing paging query sql syntax error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.3.0
    • Fix Version/s: None
    • Component/s: Manager
    • Labels:
      None
    • Environment:
      DB2 LUW 9.7

      Description

      To reproduce:
      1. Create more than 20 job executions in the job repository.
      2. From spring batch admin web application, select Executions.
      3. Click Next page.
      An error screen will show up with exception.

      The root cause of this issue is in the spring batch, and is reported as BATCH-2087.
      Please refer to
      https://jira.springsource.org/browse/BATCH-2087

      for the reproduce procedure and root cause, and stack trace as well.

      As a workaround, we can avoid use table alias prefix for the sortKey in JdbcSearchableJobExecutionDao and JdbcSearchableStepExecutionDao.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              miles.huang Miles Huang
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: