[SYNCOPE-401] Deploying syncope.war with MSSQL server settings to Tomcat on Windows results in Error listenerStart

• 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
• Environment: Microsoft Windows 2008 R2, Microsoft SQL Server 2008 and 2012
• Assignee: Francesco Chicchiriccò
• Reporter: Mathias Holdt
• Created: 11/Jul/13 14:55
• Updated: 12/Jul/13 07:02
• Resolved: 11/Jul/13 15:01

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.