Error: Unable to start the Quartz scheduler

[pblanton]

I have a backup system for my SSC 16.11 server. It uses the a copy of the production SSC MSSQL database that is kept current via log shipping.

When I deploy the backup SSC Server, I get the following error...

2017-05-11 09:53:51,012   [ERROR] com.fortify.manager.service.scheduler.SchedulerService - Unable to start the Quartz scheduler

org.quartz.SchedulerConfigException: Failure occured during job recovery.

at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:692) ~[quartz-2.2.1.jar:?]

<snip>

Prod works fine.

So what is it about the quartz scheduler that is having a hard time on the backup system?

[andersonshatch]

It's difficult to say with just that, but I suspect the issue is that you're simply doing something SSC is not currently designed to do.

If the database is being kept up to date with the prod database in near real-time, there's essentially 2 running instances of SSC for the backup DB -- the production one, and the backup one -- running concurrently. It's very possible that they try to lock the same records at the same time or attempt to perform work that's already been/being done by the other instance.

I would stop the backup instance's app server and just keep the DB replication running. In the case that your primary goes down, you can spin up the backup app server.

Also, I assume you are taking regular backups of the DB as well as keeping a hot spare? If something fatal happens in one, it'll replicate quickly to the backup, so there's a real possibility you will want to restore from a previous snapshot.

-Josh

Fortify L3 Support Engineer

[pblanton]

Yeah. I thought of that too and so I simulated a failure, by shutting down the prod SSC Server and tried starting the backup system again, but he backup still fails with the quartz error.

[pblanton]

I suspected that maybe there was an issue with the index directory path maybe being slightly different, but after double-checking they are the same...

PROD Index Location - D:\apps\prd-ssc\SSCSearchIndex

BACK Index Location - D:\apps\prd-ssc\SSCSearchIndex

So it's not that.

[andersonshatch]

Hmm, ok... are you willing to share more of the log for examination?

I still wouldn't recommend having essentially 2 instances running against the DB at once.

-Josh

[andersonshatch]

Incidentally, 16.20 and above don't use quartz anymore, so solving for this version certainly doesn't guarantee future compatibility.

-Josh

[pblanton]

Well, they are two separate databases on two different database servers. They are just synchronized via Log Shipping. The backup instance never has any users hitting it but it runs all of the time.

Also, this particular instance of SSC isn't used for FPRs. There are no projects or users on it. It is only used to provide rule-packs and templates to scanners.

I have a ssc.log file with the full startup log in it. I'll post its contents in a separate reply.

[pblanton]

2017-05-12 08:48:47,979   [WARN] com.fortify.systemspec - ========================== Fortify Context Startup =============================
2017-05-12 08:48:48,135   [DEBUG] com.fortify.systemspec -
Version:16.10.0095
------------------------- Runtime Information -------------------------------
Fortify Runtime Properties
com.fortify.AuthenticationKey=${win32.LocalAppdata}/Fortify/config/tools
com.fortify.Core=D:\apps\prd-ssc\webapps\ssc\WEB-INF\Core
com.fortify.InstallationUserName=<SERVERNAME>$
com.fortify.SCAExecutablePath=
com.fortify.VS.DefaultFramework.10.0=DotNetFrameworkv40
com.fortify.VS.DefaultFramework.11.0=DotNetFrameworkv45
com.fortify.VS.DefaultFramework.12.0=DotNetFrameworkv451
com.fortify.VS.DefaultFramework.14.0=DotNetFrameworkv451
com.fortify.VS.Frameworks.DotNetFrameworkv11.SDKRegistry="SOFTWARE\Microsoft\.NETFramework","sdkInstallRootv1.1","\bin"
com.fortify.VS.Frameworks.DotNetFrameworkv11.VSProjectVersionCode=1;
com.fortify.VS.Frameworks.DotNetFrameworkv20.SDKRegistry="SOFTWARE\Microsoft\.NETFramework","sdkInstallRootv2.0","\bin"
com.fortify.VS.Frameworks.DotNetFrameworkv20.VSProjectVersionCode=131072
com.fortify.VS.Frameworks.DotNetFrameworkv30.SDKRegistry="SOFTWARE\Microsoft\Microsoft SDKs\Windows\v6.0A","InstallationFolder"
com.fortify.VS.Frameworks.DotNetFrameworkv30.VSProjectVersionCode=196608
com.fortify.VS.Frameworks.DotNetFrameworkv35.SDKRegistry="SOFTWARE\Microsoft\Microsoft SDKs\Windows\v6.0A","InstallationFolder"
com.fortify.VS.Frameworks.DotNetFrameworkv35.VSProjectVersionCode=196613
com.fortify.VS.Frameworks.DotNetFrameworkv40.DotNetFolder="v4.0.30319"
com.fortify.VS.Frameworks.DotNetFrameworkv40.SDKRegistry="SOFTWARE\Microsoft\Microsoft SDKs\Windows\v7.0A\WinSDK-NetFx40Tools-x86","InstallationFolder"
com.fortify.VS.Frameworks.DotNetFrameworkv40.VSProjectVersionCode=262144
com.fortify.VS.Frameworks.DotNetFrameworkv45.DotNetFolder="v4.0.30319"
com.fortify.VS.Frameworks.DotNetFrameworkv45.SDKPaths="Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools\";"Microsoft SDKs\Windows\v8.0A\bin\";"Microsoft SDKs\Windows\v8.0\bin\NETFX 4.0 Tools\";"Microsoft SDKs\Windows\v8.0\bin\"
com.fortify.VS.Frameworks.DotNetFrameworkv45.SDKRegistry="SOFTWARE\Microsoft\Microsoft SDKs\Windows\v8.0A\WinSDK-NetFx40Tools-x86","InstallationFolder"
com.fortify.VS.Frameworks.DotNetFrameworkv45.VSProjectVersionCode=262149
com.fortify.VS.Frameworks.DotNetFrameworkv451.DotNetFolder="v4.0.30319"
com.fortify.VS.Frameworks.DotNetFrameworkv451.SDKPaths="Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools\";"Microsoft SDKs\Windows\v8.1A\bin\";"Microsoft SDKs\Windows\v8.1\bin\NETFX 4.5.1 Tools\";"Microsoft SDKs\Windows\v8.1\bin\"
com.fortify.VS.Frameworks.DotNetFrameworkv451.SDKRegistry="SOFTWARE\Microsoft\Microsoft SDKs\Windows\v8.1A\WinSDK-NetFx40Tools-x86","InstallationFolder"
com.fortify.VS.Frameworks.DotNetFrameworkv451.VSProjectVersionCode=451
com.fortify.VS.Frameworks.default.SDKRegistry="SOFTWARE\Microsoft\Microsoft SDKs\Windows\v8.0A\WinSDK-NetFx35Tools-x86","InstallationFolder";"SOFTWARE\Microsoft\Microsoft SDKs\Windows\v7.0A\WinSDK-NetFx35Tools-x86","InstallationFolder";"SOFTWARE\Microsoft\Microsoft SDKs\Windows\v6.1","InstallationFolder","\bin"
com.fortify.VS.Frameworks.default.VSProjectVersionCode=-1
com.fortify.VS.RequireASPPrecompilation=true
com.fortify.WorkingDirectory=${win32.LocalAppdata}/Fortify
com.fortify.locale=en
com.fortify.search.defaultSyntaxVer=2
max.file.path.length=255

System Runtime Properties
awt.toolkit=sun.awt.windows.WToolkit
catalina.base=D:\apps\prd-ssc
catalina.home=D:\apps\tomcat\current
catalina.useNaming=true
com.fortify.DisableDescriptionXMLEscaping=true
com.fortify.DisableJNI=true
com.fortify.InstallRoot=D:\apps\prd-ssc\webapps\ssc\WEB-INF
com.fortify.LicenseFile=D:\apps\prd-ssc\webapps\ssc\WEB-INF\classes\fortify.license
com.fortify.LoadFPropsFromCP=true
com.fortify.StoreOriginalDescriptions=true
com.fortify.model.DisableProgramInfo=true
com.fortify.model.DisableSnippets=true
com.springsource.tcserver.security.PropertyDecoder.passphrase=base64
common.loader="${catalina.base}/lib","${catalina.base}/lib/*.jar","${catalina.home}/lib","${catalina.base}/external/tcServer-decoder-primetaco-20141022.jar","${catalina.home}/lib/*.jar"
file.encoding=Cp1252
file.encoding.pkg=sun.io
file.separator=\
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=D:\apps\tomcat\current\bin\bootstrap.jar;D:\apps\prd-ssc\bin\tomcat-juli.jar;D:\apps\tomcat\current\bin\tomcat-juli.jar
java.class.version=51.0
java.endorsed.dirs=D:\apps\tomcat\current\endorsed
java.ext.dirs=D:\apps\java\current\lib\ext;C:\Windows\Sun\Java\lib\ext
java.home=D:\apps\java\current
java.io.tmpdir=D:\apps\prd-ssc\temp
java.library.path=D:\apps\tomcat\current\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\Tools;C:\Program Files\HP Openview\lib;C:\Program Files\HP Openview\bin;C:\Program Files\HP Openview\bin\win64;C:\Program Files\HP Openview\bin\win64\OpC;C:\Program Files\Venafi\Agent\Libs;D:\apps\java\current\bin;D:\apps\tomcat\current\bin;;.
java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory
java.naming.factory.url.pkgs=org.apache.naming
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.7.0_131-b12
java.specification.name=Java Platform API Specification
java.specification.vendor=Oracle Corporation
java.specification.version=1.7
java.util.logging.config.file=D:\apps\prd-ssc\conf\logging.properties
java.util.logging.manager=org.apache.juli.ClassLoaderLogManager
java.vendor=Oracle Corporation
java.vendor.url=http://java.oracle.com/
java.vendor.url.bug=http://bugreport.sun.com/bugreport/
java.version=1.7.0_131
java.vm.info=mixed mode
java.vm.name=Java HotSpot(TM) 64-Bit Server VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Oracle Corporation
java.vm.specification.version=1.7
java.vm.vendor=Oracle Corporation
java.vm.version=24.131-b12
line.separator=

org.apache.tomcat.util.digester.PROPERTY_SOURCE=com.springsource.tcserver.security.PropertyDecoder
os.arch=amd64
os.name=Windows Server 2012 R2
os.version=6.3
package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.jasper.,org.apache.tomcat.
package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.jasper.,org.apache.naming.,org.apache.tomcat.
path.separator=;
server.loader=
shared.loader=
sun.arch.data.model=64
sun.boot.class.path=D:\apps\java\current\lib\resources.jar;D:\apps\java\current\lib\rt.jar;D:\apps\java\current\lib\sunrsasign.jar;D:\apps\java\current\lib\jsse.jar;D:\apps\java\current\lib\jce.jar;D:\apps\java\current\lib\charsets.jar;D:\apps\java\current\lib\jfr.jar;D:\apps\java\current\classes
sun.boot.library.path=D:\apps\java\current\bin
sun.cpu.endian=little
sun.cpu.isalist=amd64
sun.desktop=windows
sun.io.unicode.encoding=UnicodeLittle
sun.jnu.encoding=Cp1252
sun.management.compiler=HotSpot 64-Bit Tiered Compilers
sun.os.patch.level=
tc.keyPass=s2enc://Q6YXtrX10DpcKfkCwko45Q==
tc.truststorePass=s2enc://Q6YXtrX10DpcKfkCwko45Q==
tomcat.util.buf.StringCache.byte.enabled=true
tomcat.util.scan.StandardJarScanFilter.jarsToScan=log4j-core*.jar,log4j-taglib*.jar
tomcat.util.scan.StandardJarScanFilter.jarsToSkip=bootstrap.jar,commons-daemon.jar,tomcat-juli.jar,annotations-api.jar,el-api.jar,jsp-api.jar,servlet-api.jar,websocket-api.jar,catalina.jar,catalina-ant.jar,catalina-ha.jar,catalina-storeconfig.jar,catalina-tribes.jar,jasper.jar,jasper-el.jar,ecj-*.jar,tomcat-api.jar,tomcat-util.jar,tomcat-util-scan.jar,tomcat-coyote.jar,tomcat-dbcp.jar,tomcat-jni.jar,tomcat-spdy.jar,tomcat-websocket.jar,tomcat-i18n-en.jar,tomcat-i18n-es.jar,tomcat-i18n-fr.jar,tomcat-i18n-ja.jar,tomcat-juli-adapters.jar,catalina-jmx-remote.jar,catalina-ws.jar,tomcat-jdbc.jar,tools.jar,commons-beanutils*.jar,commons-codec*.jar,commons-collections*.jar,commons-dbcp*.jar,commons-digester*.jar,commons-fileupload*.jar,commons-httpclient*.jar,commons-io*.jar,commons-lang*.jar,commons-logging*.jar,commons-math*.jar,commons-pool*.jar,jstl.jar,geronimo-spec-jaxrpc*.jar,wsdl4j*.jar,ant.jar,ant-junit*.jar,aspectj*.jar,jmx.jar,h2*.jar,hibernate*.jar,httpclient*.jar,jmx-tools.jar,jta*.jar,log4j*.jar,mail*.jar,slf4j*.jar,xercesImpl.jar,xmlParserAPIs.jar,xml-apis.jar,junit.jar,junit-*.jar,ant-launcher.jar,cobertura-*.jar,asm-*.jar,dom4j-*.jar,icu4j-*.jar,jaxen-*.jar,jdom-*.jar,jetty-*.jar,oro-*.jar,servlet-api-*.jar,tagsoup-*.jar,xmlParserAPIs-*.jar,xom-*.jar
user.country=US
user.dir=D:\apps\tomcat\current
user.home=C:\
user.language=en
user.name=<SERVERNAME>$
user.script=
user.timezone=America/Chicago
user.variant=

VM Info
OperatingSystemMXBean: Windows Server 2012 R2
  Arch: amd64
  AvailableProcessors: 4
  CommittedVirtualMemorySize: 2821652480
  FreePhysicalMemorySize: 30142357504
  FreeSwapSpaceSize: 33301987328
  ProcessCpuLoad: -1.0
  ProcessCpuTime: 53156250000
  SystemCpuLoad: 0.2504253604370019
  SystemLoadAverage: -1.0
  TotalPhysicalMemorySize: 34359267328
  TotalSwapSpaceSize: 38653186048
  Version: 6.3
RuntimeMXBean: 9376@<SERVERNAME>
  BootClassPath: D:\apps\java\current\lib\resources.jar;D:\apps\java\current\lib\rt.jar;D:\apps\java\current\lib\sunrsasign.jar;D:\apps\java\current\lib\jsse.jar;D:\apps\java\current\lib\jce.jar;D:\apps\java\current\lib\charsets.jar;D:\apps\java\current\lib\jfr.jar;D:\apps\java\current\classes
  BootClassPathSupported: true
  ClassPath: D:\apps\tomcat\current\bin\bootstrap.jar;D:\apps\prd-ssc\bin\tomcat-juli.jar;D:\apps\tomcat\current\bin\tomcat-juli.jar
  LibraryPath: D:\apps\tomcat\current\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\Tools;C:\Program Files\HP Openview\lib;C:\Program Files\HP Openview\bin;C:\Program Files\HP Openview\bin\win64;C:\Program Files\HP Openview\bin\win64\OpC;C:\Program Files\Venafi\Agent\Libs;D:\apps\java\current\bin;D:\apps\tomcat\current\bin;;.
  ManagementSpecVersion: 1.2
  SpecName: Java Virtual Machine Specification
  SpecVendor: Oracle Corporation
  SpecVersion: 1.7
  StartTime: 1494596896197
  Uptime: 31938
  VmName: Java HotSpot(TM) 64-Bit Server VM
  VmVendor: Oracle Corporation
  VmVersion: 24.131-b12
-----------------------------------------------------------------------------
2017-05-12 08:49:19,214   [WARN] com.fortify.manager.service.ldap.impl.LdapConfigRestorerImpl - Not loading ldap properties into DB because enabled flag is false.
2017-05-12 08:49:26,261   [INFO] com.fortify.manager.service.runtime.RuntimeControllerConnectionConfiguration - Initializing runtime event handlers: [10234]
2017-05-12 08:49:26,261   [WARN] com.fortify.manager.service.runtime.RuntimeControllerConnectionConfiguration - Runtime integration disabled
2017-05-12 08:49:26,418   [ERROR] com.fortify.manager.service.scheduler.SchedulerService - Unable to start the Quartz scheduler
org.quartz.SchedulerConfigException: Failure occured during job recovery.
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:692) ~[quartz-2.2.1.jar:?]
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:?]
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:131) [ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) [ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) [ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) [spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:51) [spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:346) [spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:149) [spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:112) [spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:847) [spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:540) [spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:446) [spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:328) [spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) [spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4728) [catalina.jar:8.0.20]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5162) [catalina.jar:8.0.20]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:8.0.20]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725) [catalina.jar:8.0.20]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701) [catalina.jar:8.0.20]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) [catalina.jar:8.0.20]
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:917) [catalina.jar:8.0.41]
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1701) [catalina.jar:8.0.41]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.7.0_131]
at java.lang.Thread.run(Unknown Source) [?:1.7.0_131]
Caused by: org.quartz.JobPersistenceException: Couldn't store trigger 'RECURRING_LDAP_CACHE_REFRESH.RECURRING_LDAP_CACHE_REFRESH' for 'RECURRING_LDAP_CACHE_REFRESH.RECURRING_LDAP_CACHE_REFRESH' job:Failed to update database "SSC" because the database is read-only.
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1223) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1037) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:986) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:866) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.executeVoid(JobStoreSupport.java:838) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3703) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3701) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:834) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:690) ~[quartz-2.2.1.jar:?]
... 28 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to update database "SSC" because the database is read-only.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314) ~[sqljdbc4.jar:?]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTrigger(StdJDBCDelegate.java:1222) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1218) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1037) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:986) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:866) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.executeVoid(JobStoreSupport.java:838) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3703) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3701) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:834) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:690) ~[quartz-2.2.1.jar:?]
... 28 more
2017-05-12 08:49:26,418   [WARN] org.springframework.web.context.support.XmlWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt
org.springframework.context.ApplicationContextException: Failed to start bean 'appInitializer'; nested exception is com.fortify.manager.service.scheduler.FmSchedulerException: Unable to start job scheduler
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:176) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:51) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:346) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:149) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:112) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:847) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:540) [spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:446) [spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:328) [spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) [spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4728) [catalina.jar:8.0.20]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5162) [catalina.jar:8.0.20]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:8.0.20]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725) [catalina.jar:8.0.20]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701) [catalina.jar:8.0.20]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) [catalina.jar:8.0.20]
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:917) [catalina.jar:8.0.41]
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1701) [catalina.jar:8.0.41]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.7.0_131]
at java.lang.Thread.run(Unknown Source) [?:1.7.0_131]
Caused by: com.fortify.manager.service.scheduler.FmSchedulerException: Unable to start job scheduler
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:135) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery.
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:692) ~[quartz-2.2.1.jar:?]
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:?]
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:131) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
Caused by: org.quartz.JobPersistenceException: Couldn't store trigger 'RECURRING_LDAP_CACHE_REFRESH.RECURRING_LDAP_CACHE_REFRESH' for 'RECURRING_LDAP_CACHE_REFRESH.RECURRING_LDAP_CACHE_REFRESH' job:Failed to update database "SSC" because the database is read-only.
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1223) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1037) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:986) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:866) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.executeVoid(JobStoreSupport.java:838) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3703) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3701) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:834) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:690) ~[quartz-2.2.1.jar:?]
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:?]
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:131) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to update database "SSC" because the database is read-only.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314) ~[sqljdbc4.jar:?]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTrigger(StdJDBCDelegate.java:1222) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1218) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1037) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:986) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:866) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.executeVoid(JobStoreSupport.java:838) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3703) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3701) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:834) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:690) ~[quartz-2.2.1.jar:?]
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:?]
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:131) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
2017-05-12 08:49:27,496   [ERROR] org.springframework.web.context.ContextLoader - Context initialization failed
org.springframework.context.ApplicationContextException: Failed to start bean 'appInitializer'; nested exception is com.fortify.manager.service.scheduler.FmSchedulerException: Unable to start job scheduler
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:176) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:51) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:346) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:149) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:112) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:847) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:540) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:446) ~[spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:328) [spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) [spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4728) [catalina.jar:8.0.20]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5162) [catalina.jar:8.0.20]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:8.0.20]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725) [catalina.jar:8.0.20]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701) [catalina.jar:8.0.20]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) [catalina.jar:8.0.20]
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:917) [catalina.jar:8.0.41]
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1701) [catalina.jar:8.0.41]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.7.0_131]
at java.lang.Thread.run(Unknown Source) [?:1.7.0_131]
Caused by: com.fortify.manager.service.scheduler.FmSchedulerException: Unable to start job scheduler
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:135) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery.
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:692) ~[quartz-2.2.1.jar:?]
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:?]
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:131) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
Caused by: org.quartz.JobPersistenceException: Couldn't store trigger 'RECURRING_LDAP_CACHE_REFRESH.RECURRING_LDAP_CACHE_REFRESH' for 'RECURRING_LDAP_CACHE_REFRESH.RECURRING_LDAP_CACHE_REFRESH' job:Failed to update database "SSC" because the database is read-only.
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1223) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1037) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:986) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:866) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.executeVoid(JobStoreSupport.java:838) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3703) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3701) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:834) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:690) ~[quartz-2.2.1.jar:?]
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:?]
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:131) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to update database "SSC" because the database is read-only.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314) ~[sqljdbc4.jar:?]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTrigger(StdJDBCDelegate.java:1222) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1218) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1037) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:986) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:866) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.executeVoid(JobStoreSupport.java:838) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3703) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3701) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:834) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:690) ~[quartz-2.2.1.jar:?]
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:?]
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:131) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
2017-05-12 08:49:27,496   [ERROR] org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/ssc] - Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.context.ApplicationContextException: Failed to start bean 'appInitializer'; nested exception is com.fortify.manager.service.scheduler.FmSchedulerException: Unable to start job scheduler
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:176) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:51) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:346) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:149) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:112) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:847) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:540) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:446) ~[spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:328) ~[spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) ~[spring-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4728) [catalina.jar:8.0.20]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5162) [catalina.jar:8.0.20]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:8.0.20]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725) [catalina.jar:8.0.20]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701) [catalina.jar:8.0.20]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) [catalina.jar:8.0.20]
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:917) [catalina.jar:8.0.41]
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1701) [catalina.jar:8.0.41]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.7.0_131]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.7.0_131]
at java.lang.Thread.run(Unknown Source) [?:1.7.0_131]
Caused by: com.fortify.manager.service.scheduler.FmSchedulerException: Unable to start job scheduler
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:135) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery.
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:692) ~[quartz-2.2.1.jar:?]
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:?]
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:131) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
Caused by: org.quartz.JobPersistenceException: Couldn't store trigger 'RECURRING_LDAP_CACHE_REFRESH.RECURRING_LDAP_CACHE_REFRESH' for 'RECURRING_LDAP_CACHE_REFRESH.RECURRING_LDAP_CACHE_REFRESH' job:Failed to update database "SSC" because the database is read-only.
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1223) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1037) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:986) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:866) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.executeVoid(JobStoreSupport.java:838) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3703) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3701) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:834) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:690) ~[quartz-2.2.1.jar:?]
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:?]
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:131) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to update database "SSC" because the database is read-only.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc4.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314) ~[sqljdbc4.jar:?]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTrigger(StdJDBCDelegate.java:1222) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1218) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1037) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:986) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:866) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.executeVoid(JobStoreSupport.java:838) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3703) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3701) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:834) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:690) ~[quartz-2.2.1.jar:?]
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:?]
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:?]
at com.fortify.manager.service.scheduler.SchedulerServiceImpl.startScheduler(SchedulerServiceImpl.java:131) ~[ssc-core.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.startScheduler(AppInitializer.java:114) ~[ssc-web.jar:?]
at com.fortify.manager.web.listeners.AppInitializer.start(AppInitializer.java:53) ~[ssc-web.jar:?]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173) ~[spring-context-4.2.1.RELEASE.jar:4.2.1.RELEASE]
... 22 more

[andersonshatch]

Database is read-only?

Caused by: org.quartz.JobPersistenceException: Couldn't store trigger 'RECURRING_LDAP_CACHE_REFRESH.RECURRING_LDAP_CACHE_REFRESH' for 'RECURRING_LDAP_CACHE_REFRESH.RECURRING_LDAP_CACHE_REFRESH' job:Failed to update database "SSC" because the database is read-only.