8 Replies Latest reply on May 23, 2016 3:17 AM by M Bagheryan M

    Web Reporter Migrate MySQL DB to MS SQL 2012 DB

    Rene Moj

      hi, we've migrated the internal mysql db to an external ms sql and since then web reporter is not able to connect to the new db..only the connection test is successful, but I get a lot of error messages in der error log:

       

       

      2014-06-27 18:31:27,433 ERROR [securecomputing.smartfilter.reportdbbuilder.ReportDbBuilder] Failed to create Session Factory, database unavailable.

      org.hibernate.HibernateException: Wrong column type: hour_of_day, expected: tinyint

      at org.hibernate.mapping.Table.validateColumns(Table.java:261)

      at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1083)

      at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:116)

      at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:317)

      at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)

      at securecomputing.smartfilter.reportdbbuilder.ReportDbBuilder.createSessionFactor y(ReportDbBuilder.java:1536)

      at securecomputing.smartfilter.reportdbbuilder.ReportDbBuilder.setReportingDatabas e(ReportDbBuilder.java:929)

      at securecomputing.smartfilter.reportdbbuilder.ReportDbBuilder.setReportingDatabas e(ReportDbBuilder.java:642)

      at securecomputing.smartfilter.server.project.services.reportDb.SetReportDatabaseT ask.runit(SetReportDatabaseTask.java:166)

      at securecomputing.smartfilter.server.project.ScheduledTask.run(ScheduledTask.java :67)

      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java: 886)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

      at java.lang.Thread.run(Thread.java:619)

       

      did something went wrong? Basically we've created a database and migrated the whole schema from the old mysql db to the new ms sql db...

       

       

      Thanks!

      Kind regards,

      Renata