Fortify SSC - error when seeding init bundle when updating

Question

Hello everyone,

We are currently in the process of upgrading to Fortify SSC 22.2 (from 21.2) on a Windows Server 2019 VM on a production environment and we are facing some errors when trying to seed the database.

The migration process goes without issues but when we try the next step of seeding the database we are faced the the following error: Unable to process the Fortify_Process_Seed_Bundle-2022_Q3_0002.zip. Seeding failed: Unable to seed all init seed bundles.

the ssc.log shows the following:

2024-11-07 14:23:26,059   [INFO] com.fortify.manager.DAL.HibernateDatabaseInterface - Using JDBC driver Microsoft JDBC Driver 11.2 for SQL Server [11.2.1.0], connecting to Microsoft SQL Server [15.00.2104]
2024-11-07 14:23:28,838   [WARN] com.fortify.manager.service.scheduler.NullSchedulerServiceImpl - Null scheduler service instance, analysis trace refresh not scheduled
2024-11-07 14:24:05,733   [WARN] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 207, SQLState: S0001
2024-11-07 14:24:05,733   [ERROR] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Invalid column name 'requiresComment'.
2024-11-07 14:24:09,907   [ERROR] com.fortify.ssc.init.endpoints.AppInitDatabaseOperationsController - Unable to seed all init seed bundles.
com.fortify.ssc.init.SeedingException: Unable to seed all init seed bundles.
	at com.fortify.ssc.init.SeedContextProvider.seedInitBundles(SeedContextProvider.java:110) ~[ssc-init-23.1.0.0148.jar:?]
	at com.fortify.ssc.init.endpoints.AppInitDatabaseOperationsController.lambda$seed$2(AppInitDatabaseOperationsController.java:268) ~[ssc-init-23.1.0.0148.jar:?]
	at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: com.fortify.manager.exception.FMDALGeneralException: An unexpected error occurred.
	at com.fortify.manager.DAL.support.FMDALExceptionTranslationInterceptor.translateException(FMDALExceptionTranslationInterceptor.java:75) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.support.FMDALExceptionTranslationInterceptor.aroundRepositoryMethod(FMDALExceptionTranslationInterceptor.java:42) ~[ssc-core-23.1.0.0148.jar:?]
	at jdk.internal.reflect.GeneratedMethodAccessor310.invoke(Unknown Source) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.DAL.impl.AttrManagerImpl$$EnhancerBySpringCGLIB$$6e1b159b.getByGuid(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl.importTagFromProviders(ProjectTemplateBLLImpl.java:1279) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl.importSystemTags(ProjectTemplateBLLImpl.java:1260) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl$$FastClassBySpringCGLIB$$e09d5e26.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl$$EnhancerBySpringCGLIB$$3dd33fa6.importSystemTags(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.seedSystemTags(SeedManagerImpl.java:959) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.loadSeedRoot(SeedManagerImpl.java:443) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.loadSeedRoot(SeedManagerImpl.java:432) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.batchSeed(SeedManagerImpl.java:254) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl$$FastClassBySpringCGLIB$$7c11a665.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.BLL.impl.SeedManagerImpl$$EnhancerBySpringCGLIB$$6a63b7c3.batchSeed(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.ssc.init.SeedContextProvider.seedInitBundles(SeedContextProvider.java:108) ~[ssc-init-23.1.0.0148.jar:?]
	... 6 more
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:919) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:904) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.HibernateDatabaseInterface.executeBoundedListQuery(HibernateDatabaseInterface.java:331) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.HibernateDatabaseInterface.executeListQuery(HibernateDatabaseInterface.java:321) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.impl.AttrManagerImpl.getByGuid(AttrManagerImpl.java:523) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.impl.AttrManagerImpl$$FastClassBySpringCGLIB$$93e8f2d8.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.DAL.support.FMDALExceptionTranslationInterceptor.aroundRepositoryMethod(FMDALExceptionTranslationInterceptor.java:40) ~[ssc-core-23.1.0.0148.jar:?]
	at jdk.internal.reflect.GeneratedMethodAccessor310.invoke(Unknown Source) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.DAL.impl.AttrManagerImpl$$EnhancerBySpringCGLIB$$6e1b159b.getByGuid(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl.importTagFromProviders(ProjectTemplateBLLImpl.java:1279) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl.importSystemTags(ProjectTemplateBLLImpl.java:1260) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl$$FastClassBySpringCGLIB$$e09d5e26.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl$$EnhancerBySpringCGLIB$$3dd33fa6.importSystemTags(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.seedSystemTags(SeedManagerImpl.java:959) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.loadSeedRoot(SeedManagerImpl.java:443) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.loadSeedRoot(SeedManagerImpl.java:432) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.batchSeed(SeedManagerImpl.java:254) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl$$FastClassBySpringCGLIB$$7c11a665.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.BLL.impl.SeedManagerImpl$$EnhancerBySpringCGLIB$$6a63b7c3.batchSeed(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.ssc.init.SeedContextProvider.seedInitBundles(SeedContextProvider.java:108) ~[ssc-init-23.1.0.0148.jar:?]
	... 6 more
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.getResultSet(Loader.java:2322) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2075) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2037) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.doQuery(Loader.java:956) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:357) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.doList(Loader.java:2868) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.doList(Loader.java:2850) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2682) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.list(Loader.java:2677) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:540) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1459) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:919) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:904) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.HibernateDatabaseInterface.executeBoundedListQuery(HibernateDatabaseInterface.java:331) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.HibernateDatabaseInterface.executeListQuery(HibernateDatabaseInterface.java:321) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.impl.AttrManagerImpl.getByGuid(AttrManagerImpl.java:523) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.impl.AttrManagerImpl$$FastClassBySpringCGLIB$$93e8f2d8.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.DAL.support.FMDALExceptionTranslationInterceptor.aroundRepositoryMethod(FMDALExceptionTranslationInterceptor.java:40) ~[ssc-core-23.1.0.0148.jar:?]
	at jdk.internal.reflect.GeneratedMethodAccessor310.invoke(Unknown Source) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.DAL.impl.AttrManagerImpl$$EnhancerBySpringCGLIB$$6e1b159b.getByGuid(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl.importTagFromProviders(ProjectTemplateBLLImpl.java:1279) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl.importSystemTags(ProjectTemplateBLLImpl.java:1260) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl$$FastClassBySpringCGLIB$$e09d5e26.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl$$EnhancerBySpringCGLIB$$3dd33fa6.importSystemTags(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.seedSystemTags(SeedManagerImpl.java:959) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.loadSeedRoot(SeedManagerImpl.java:443) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.loadSeedRoot(SeedManagerImpl.java:432) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.batchSeed(SeedManagerImpl.java:254) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl$$FastClassBySpringCGLIB$$7c11a665.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.BLL.impl.SeedManagerImpl$$EnhancerBySpringCGLIB$$6a63b7c3.batchSeed(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.ssc.init.SeedContextProvider.seedInitBundles(SeedContextProvider.java:108) ~[ssc-init-23.1.0.0148.jar:?]
	... 6 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'requiresComment'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) ~[mssql-jdbc-11.2.1.jre11.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1673) ~[mssql-jdbc-11.2.1.jre11.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:620) ~[mssql-jdbc-11.2.1.jre11.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:540) ~[mssql-jdbc-11.2.1.jre11.jar:?]
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7627) ~[mssql-jdbc-11.2.1.jre11.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3912) ~[mssql-jdbc-11.2.1.jre11.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268) ~[mssql-jdbc-11.2.1.jre11.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242) ~[mssql-jdbc-11.2.1.jre11.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:459) ~[mssql-jdbc-11.2.1.jre11.jar:?]
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.9.0.jar:2.9.0]
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.9.0.jar:2.9.0]
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.getResultSet(Loader.java:2322) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2075) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2037) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.doQuery(Loader.java:956) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:357) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.doList(Loader.java:2868) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.doList(Loader.java:2850) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2682) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.Loader.list(Loader.java:2677) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:540) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1459) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617) ~[hibernate-core-5.6.12.Final.jar:5.6.12.Final]
	at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:919) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:904) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.HibernateDatabaseInterface.executeBoundedListQuery(HibernateDatabaseInterface.java:331) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.HibernateDatabaseInterface.executeListQuery(HibernateDatabaseInterface.java:321) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.impl.AttrManagerImpl.getByGuid(AttrManagerImpl.java:523) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.DAL.impl.AttrManagerImpl$$FastClassBySpringCGLIB$$93e8f2d8.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.DAL.support.FMDALExceptionTranslationInterceptor.aroundRepositoryMethod(FMDALExceptionTranslationInterceptor.java:40) ~[ssc-core-23.1.0.0148.jar:?]
	at jdk.internal.reflect.GeneratedMethodAccessor310.invoke(Unknown Source) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.DAL.impl.AttrManagerImpl$$EnhancerBySpringCGLIB$$6e1b159b.getByGuid(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl.importTagFromProviders(ProjectTemplateBLLImpl.java:1279) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl.importSystemTags(ProjectTemplateBLLImpl.java:1260) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl$$FastClassBySpringCGLIB$$e09d5e26.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.BLL.impl.ProjectTemplateBLLImpl$$EnhancerBySpringCGLIB$$3dd33fa6.importSystemTags(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.seedSystemTags(SeedManagerImpl.java:959) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.loadSeedRoot(SeedManagerImpl.java:443) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.loadSeedRoot(SeedManagerImpl.java:432) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl.batchSeed(SeedManagerImpl.java:254) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.manager.BLL.impl.SeedManagerImpl$$FastClassBySpringCGLIB$$7c11a665.invoke(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.25.jar:5.3.25]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.25.jar:5.3.25]
	at com.fortify.manager.BLL.impl.SeedManagerImpl$$EnhancerBySpringCGLIB$$6a63b7c3.batchSeed(<generated>) ~[ssc-core-23.1.0.0148.jar:?]
	at com.fortify.ssc.init.SeedContextProvider.seedInitBundles(SeedContextProvider.java:108) ~[ssc-init-23.1.0.0148.jar:?]
	... 6 more

and the ssc_seeding log:

2024-11-07 14:23:32,659 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Opening seed bundle: ConfPropertiesSeedBundle.zip
2024-11-07 14:23:32,675 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Loading entry: SeedBootstrap.xml
2024-11-07 14:23:32,699 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Seeding bundle ConfigProperties version 23.1.0
2024-11-07 14:23:32,700 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Loading entry: ConfProperties.xml
2024-11-07 14:23:32,915 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Opening seed bundle: ExternalMetadataSeedBundle.zip
2024-11-07 14:23:32,932 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Loading entry: SeedBootstrap.xml
2024-11-07 14:23:32,938 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Seeding bundle Metadata version 23.1.0
2024-11-07 14:23:32,939 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Loading entry: Metadata.xml
2024-11-07 14:24:05,422 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Opening seed bundle: UserSeedBundle.zip
2024-11-07 14:24:05,442 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Loading entry: SeedBootstrap.xml
2024-11-07 14:24:05,602 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Seeding bundle Master version 8.20
2024-11-07 14:24:05,602 [pool-3-thread-1] INFO  com.fortify.manager.BLL.impl.SeedManagerImpl - Loading entry: PermissionUsers.xml

Some other information:

- Both machines (SSC and Database) are using Windows Server 2019

- We are using SQL Server 2019

- SSC currently installed on Tomcat 9.0.82

- We are using Zulu 11.0.23+9 JDK

- Collation of the DB is: SQL_Latin1_General_CP1_CS_AS

What we've tried so far:

- Installing different versions of SSC, first we tried 23.1

- Doing a fresh tomcat install on a newer version (9.0.96)

- Using different DB users in the set up process.

- Deleting the ssc folder and trying to re-deploy. (also deleting the .fortify folder)

Have you ever encountered this error? Any ideas? Feel free to ask for any other information about the systems.

find-fix-fortify · Accepted Answer

From the log snippet, it looks like you're using the ssc.war file for 23.1.0. The root error is: 
 Invalid column name 'requiresComment'. 
 This column was added to the attr table in 22.1 (check the create-tables.sql script if you wish). This tells me you did not generate the migration sql script in 23.1.0 and run it on your SSC database.

Menu

Fortify Discussions

Fortify SSC - error when seeding init bundle when updating

Tags:

Top Replies

Verified Answer

Resources