Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-401

Deploying syncope.war with MSSQL server settings to Tomcat on Windows results in Error listenerStart

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 1.1.2
    • Fix Version/s: 1.1.3, 1.2.0-M1
    • Component/s: documentation
    • Labels:
      None
    • Environment:
      Microsoft Windows 2008 R2, Microsoft SQL Server 2008 and 2012

      Description

      Following the installation guide "Run Syncope in real environments" results in a generic error when deploying syncope.war to a Tomcat container (7.0.41) on Windows 2008 R2 + MS SQL Server 2008/2012.

      I tried a few times on different combinations of Windows and SQL Server (2008/2012), all resulted in the same error (non descriptive Error listenerStart). I then added a logging.properties to the deployed web archive. This gave me a terrible long exception. One of the nested exceptions (CannotReadScriptException) told me that the file [quartz\tables_sqlserver.sql] was not found. I noticed that the file was actually named tables_sqlServer.sql (with uppercase S).

      I renamed the file to tables_sqlserver.sql (all lowercase) and successfully deployed to all my installations afterwards.

        Attachments

          Activity

            People

            • Assignee:
              ilgrosso Francesco Chicchiriccò
              Reporter:
              ghar123 Mathias Holdt
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: