UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21. Read more.
UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21.Read more.
This website uses cookies. By continuing to browse or login to this website, you consent to the use of cookies. Learn more.
OK
AshwiniNatikar
Ensign
Ensign
‎2020-10-21 13:56
1738 views

Fortify 19.1.0 ssc seeding error

Hi Team,

 

I am deploying fortify ssc 19.1.0 for the first time and facing error in database seeding step:

Database created is mysql, Attached screenshot of the error and Below exception is seen in the ssc.log file

Could you please help on the issue.

 

2020-10-20 13:57:39,201 [WARN] com.fortify.manager.service.scheduler.NullSchedulerServiceImpl - Null scheduler service instance, analysis trace refresh not scheduled

2020-10-20 13:57:41,351 [WARN] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1054, SQLState: 42S22

2020-10-20 13:57:41,351 [ERROR] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Unknown column 'scanlite0_.dataVersion' in 'field list'

2020-10-20 13:57:41,376 [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:111) ~[ssc-init-19.1.0.3009.jar:?]

at com.fortify.ssc.init.endpoints.AppInitDatabaseOperationsController.lambda$seed$2(AppInitDatabaseOperationsController.java:263) ~[ssc-init-19.1.0.3009.jar:?]

at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_265]

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_265]

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_265]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_265]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_265]

at java.lang.Thread.run(Thread.java:748) [?:1.8.0_265]
 
 
 

 

Preview file
157 KB
0 Likes
Reply
Report Inappropriate Content
10 Replies
Maulana_Irvans
Commander
Commander
‎2020-10-22 04:25

I often experience things like this, you can try another jdbc driver. For details, see the system requirements document.

Reply
Report Inappropriate Content
AshwiniNatikar
Ensign
Ensign
‎2020-10-22 09:28

Thank you Maulana_Irvans for the reply.

Today I tested with 

mysql-connector-java-8.0.19.jar,
mysql-connector-java-5.1.49-bin.jar,
mysql-connector-java-5.1.49.jar files by placing it in tomcat lib folder but still getting same exception during seeding.
 
As per the requirement document : 
mysql 5.7 (Community Edition) utf8_bin, latin1_general_cs
5.1.44 or later Driver class:
com.mysql.jdbc.driver jar file:
mysql‑connector‑java‑
<version>‑bin.jar
0 Likes
Reply
Report Inappropriate Content
MHuschenbett
Captain
Captain
‎2020-10-23 10:57

Hi,

Did you run the create-tables.sql-script against the database before seeding the database?

Best Regards,
Martin

Reply
Report Inappropriate Content
AshwiniNatikar
Ensign
Ensign
‎2020-10-26 10:19

Yes!!
0 Likes
Reply
Report Inappropriate Content
Maulana_Irvans
Commander
Commander
‎2020-10-26 07:06

Hi,

Please try this jdbc driver, hope it can help you.

and dont forget to run the create-tables.sql-script against the database before seeding the database.

 

 

 

jar_files.zip
Reply
Report Inappropriate Content
AshwiniNatikar
Ensign
Ensign
‎2020-10-26 10:45

Thanks Maulana_Irvans for the Reply,

I tried using the jar file shared and Created tables before seeding , I still see that Seeding is failing with same exception. Please find the attached screenshot.

Preview file
311 KB
0 Likes
Reply
Report Inappropriate Content
ebell
Micro Focus Expert
Micro Focus Expert
‎2020-10-26 14:47

I may have missed this, but what version of mySQL are you running?

If this is a new installation, why are you installing 19.1.0 when 20.1.0 has been released and 20.2.0 is right around the corner?

Have you tried with a new database? What collation did you use? Try the following to create the database:

CREATE DATABASE SSC DEFAULT CHARACTER SET latin1 COLLATE latin1_general_cs;

It would also be helpful to get a copy of the full SSC.log file; instead of screenshots. The latest screenshot provided some additional information the first/original did not.

If this does not resolve your issue, then it may be best to create a ticket with support for a faster resolution to this issue.

Reply
Report Inappropriate Content
AshwiniNatikar
Ensign
Ensign
‎2020-10-29 07:49

Thanks ebell for the reply, Please find the complete log

2020-10-29 07:33:42,481 [WARN] com.fortify.ssc.config.AppConfProvider - Version file not found in application configuration location: &#x2F;root&#x2F;.fortify&#x2F;ssc&#x2F;conf&#x2F;version.properties
2020-10-29 07:33:43,125 [INFO] com.fortify.systemspec - ---------------------------------------------------------------------------------------------------
2020-10-29 07:33:43,125 [INFO] com.fortify.systemspec - Application has booted to initialization mode.
2020-10-29 07:33:43,125 [INFO] com.fortify.systemspec - Please navigate to http(s)://<host>:<port>/ssc/init.jsp in your browser to start application configuration
2020-10-29 07:33:43,125 [INFO] com.fortify.systemspec - To access the configuration page please use token stored at /root/.fortify/ssc/init.token
2020-10-29 07:33:43,125 [INFO] com.fortify.systemspec - ---------------------------------------------------------------------------------------------------
2020-10-29 07:37:16,445 [WARN] com.fortify.manager.service.scheduler.NullSchedulerServiceImpl - Null scheduler service instance, analysis trace refresh not scheduled
2020-10-29 07:37:17,939 [WARN] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1054, SQLState: 42S22
2020-10-29 07:37:17,939 [ERROR] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Unknown column &apos;scanlite0_.dataVersion&apos; in &apos;field list&apos;
2020-10-29 07:37:17,965 [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:111) ~[ssc-init-19.1.0.3009.jar:?]
at com.fortify.ssc.init.endpoints.AppInitDatabaseOperationsController.lambda$seed$2(AppInitDatabaseOperationsController.java:263) ~[ssc-init-19.1.0.3009.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_265]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_265]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_265]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_265]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_265]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_265]
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:838) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:817) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.HibernateDatabaseInterface.executeBoundedListQuery(HibernateDatabaseInterface.java:322) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.HibernateDatabaseInterface.executeListQuery(HibernateDatabaseInterface.java:312) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.migration.impl.AbstractMigrationManager.getUnmigratedScans(AbstractMigrationManager.java:54) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.migration.impl.AbstractMigrationManager.migrateScans(AbstractMigrationManager.java:77) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.migration.impl.MigrationManager36Impl.preSeedingMigration(MigrationManager36Impl.java:48) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.impl.SeedManagerImpl.batchSeed(SeedManagerImpl.java:266) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.impl.SeedManagerImpl$$FastClassBySpringCGLIB$$7c11a665.invoke(<generated>) ~[ssc-core-19.1.0.3009.jar:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294) ~[spring-tx-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at com.fortify.manager.BLL.impl.SeedManagerImpl$$EnhancerBySpringCGLIB$$72dfd5e5.batchSeed(<generated>) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.ssc.init.SeedContextProvider.seedInitBundles(SeedContextProvider.java:109) ~[ssc-init-19.1.0.3009.jar:?]
... 7 more
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.getResultSet(Loader.java:2168) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:938) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2692) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2675) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.list(Loader.java:2502) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1489) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:838) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:817) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.HibernateDatabaseInterface.executeBoundedListQuery(HibernateDatabaseInterface.java:322) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.HibernateDatabaseInterface.executeListQuery(HibernateDatabaseInterface.java:312) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.migration.impl.AbstractMigrationManager.getUnmigratedScans(AbstractMigrationManager.java:54) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.migration.impl.AbstractMigrationManager.migrateScans(AbstractMigrationManager.java:77) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.migration.impl.MigrationManager36Impl.preSeedingMigration(MigrationManager36Impl.java:48) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.impl.SeedManagerImpl.batchSeed(SeedManagerImpl.java:266) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.impl.SeedManagerImpl$$FastClassBySpringCGLIB$$7c11a665.invoke(<generated>) ~[ssc-core-19.1.0.3009.jar:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294) ~[spring-tx-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at com.fortify.manager.BLL.impl.SeedManagerImpl$$EnhancerBySpringCGLIB$$72dfd5e5.batchSeed(<generated>) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.ssc.init.SeedContextProvider.seedInitBundles(SeedContextProvider.java:109) ~[ssc-init-19.1.0.3009.jar:?]
... 7 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'scanlite0_.dataVersion' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_265]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_265]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_265]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_265]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.44.jar:5.1.44]
at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.44.jar:5.1.44]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) ~[mysql-connector-java-5.1.44.jar:5.1.44]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) ~[mysql-connector-java-5.1.44.jar:5.1.44]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) ~[mysql-connector-java-5.1.44.jar:5.1.44]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) ~[mysql-connector-java-5.1.44.jar:5.1.44]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) ~[mysql-connector-java-5.1.44.jar:5.1.44]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2487) ~[mysql-connector-java-5.1.44.jar:5.1.44]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) ~[mysql-connector-java-5.1.44.jar:5.1.44]
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966) ~[mysql-connector-java-5.1.44.jar:5.1.44]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.getResultSet(Loader.java:2168) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:938) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2692) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2675) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.Loader.list(Loader.java:2502) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1489) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414) ~[hibernate-core-5.2.16.Final.jar:5.2.16.Final]
at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:838) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.HibernateDatabaseInterface$1.doInHibernate(HibernateDatabaseInterface.java:817) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.HibernateDatabaseInterface.executeBoundedListQuery(HibernateDatabaseInterface.java:322) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.HibernateDatabaseInterface.executeListQuery(HibernateDatabaseInterface.java:312) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.migration.impl.AbstractMigrationManager.getUnmigratedScans(AbstractMigrationManager.java:54) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.migration.impl.AbstractMigrationManager.migrateScans(AbstractMigrationManager.java:77) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.DAL.migration.impl.MigrationManager36Impl.preSeedingMigration(MigrationManager36Impl.java:48) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.impl.SeedManagerImpl.batchSeed(SeedManagerImpl.java:266) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.manager.BLL.impl.SeedManagerImpl$$FastClassBySpringCGLIB$$7c11a665.invoke(<generated>) ~[ssc-core-19.1.0.3009.jar:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294) ~[spring-tx-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) ~[spring-aop-5.1.1.RELEASE.jar:5.1.1.RELEASE]
at com.fortify.manager.BLL.impl.SeedManagerImpl$$EnhancerBySpringCGLIB$$72dfd5e5.batchSeed(<generated>) ~[ssc-core-19.1.0.3009.jar:?]
at com.fortify.ssc.init.SeedContextProvider.seedInitBundles(SeedContextProvider.java:109) ~[ssc-init-19.1.0.3009.jar:?]
... 7 more
0 Likes
Reply
Report Inappropriate Content
ebell
Micro Focus Expert
Micro Focus Expert
‎2020-10-29 14:10

As mentioned previously, your quickest course of resolution will probably be opening a ticket with support.

In the SSC.log, we see the following:

2020-10-29 07:37:17,939 [WARN] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1054, SQLState: 42S22
2020-10-29 07:37:17,939 [ERROR] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Unknown column &apos;scanlite0_.dataVersion&apos; in &apos;field list&apos;

In the ssc/logs directory there is an ssc_seeding.log. When opening the ticket please provide a copy of both the ssc.log and ssc_seeding.log.

Reply
Report Inappropriate Content
shashidhar
Cadet 3rd Class
Cadet 3rd Class
‎2021-04-05 05:31

Hi All

I am getting Same problem when i am installing SSC 19.1 on java 1.8 .If there is any solution Please post hear

0 Likes
Reply
Report Inappropriate Content
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.