ManifoldCF
  1. ManifoldCF
  2. CONNECTORS-797

Database Exception on Status and Job Management screen

    Details

      Description

      Receive the following message on the ' Status and Job Management' screen:

      Error: Database exception: SQLException doing query (42601): ERROR: syntax error at or near "status" Position: 60

      Digging through the debug logs found:
      DEBUG 2013-10-31 12:29:11,911 (http-apr-8081-exec-5) - Requested query: [SELECT COUNT(dochash) AS doccount FROM jobqueue WHERE id=?status IN (?,?,?,?,?,?) LIMIT 500001]
      DEBUG 2013-10-31 12:29:11,911 (Thread-16) - Actual query: [SELECT COUNT(dochash) AS doccount FROM jobqueue WHERE id=?status IN (?,?,?,?,?,?) LIMIT 500001]
      DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 0: '1380815567276'
      DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 1: 'A'
      DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 2: 'a'
      DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 3: 'P'
      DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 4: 'F'
      DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 5: 'f'
      DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 6: 'G'
      DEBUG 2013-10-31 12:29:11,918 (http-apr-8081-exec-5) - Reinterpreting exception 'Database exception: SQLException doing query (42601): ERROR: syntax error at or near "status"
      Position: 60'. The exception type is 4
      DEBUG 2013-10-31 12:29:11,918 (http-apr-8081-exec-5) - Exception Database exception: SQLException doing query (42601): ERROR: syntax error at or near "status"
      Position: 60 is possibly a transaction abort signal
      DEBUG 2013-10-31 12:29:11,918 (http-apr-8081-exec-5) - Exception Database exception: SQLException doing query (42601): ERROR: syntax error at or near "status"
      Position: 60 is NOT a transaction abort signal

      Appears that the SQL request is missing a space at 'WHERE id=?status IN (....'

      1. CONNECTORS-797.patch
        1 kB
        Karl Wright
      2. CONNECTORS-797.patch.2
        2 kB
        Karl Wright

        Activity

          People

          • Assignee:
            Karl Wright
            Reporter:
            Graeme Seaton
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development