Thanks for your reply Robinshen, after suggested by you I have tried to restore the data from the backup created by the QB4 migration script and now I am getting the below error. Except User table I have cleared all other table data and we are using JDK1.8.
Please help us to restore to QB 2
2019-01-10 11:35:38,347 WARN - SQL Error: 206, SQLState: 22005
2019-01-10 11:35:38,357 ERROR - Operand type clash: nvarchar is incompatible wi
h image
2019-01-10 11:35:38,381 ERROR - Could not synchronize database state with sessi
n
org.hibernate.exception.DataException: could not insert: [com.pmease.quickbuild
model.Configuration]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.
ava:77)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHel
er.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstra
tEntityPersister.java:2267)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstra
tEntityPersister.java:2660)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.j
va:56)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141
at org.hibernate.event.def.AbstractFlushingEventListener.performExecuti
ns(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlu
hEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.importDa
a(DefaultDataManager.java:604)
at com.pmease.quickbuild.Quickbuild.importData(Quickbuild.java:616)
at com.pmease.quickbuild.bootstrap.Restore$1.execute(Restore.java:67)
at com.pmease.quickbuild.Quickbuild.startServer(Quickbuild.java:255)
at com.pmease.quickbuild.Quickbuild.access$3(Quickbuild.java:237)
at com.pmease.quickbuild.Quickbuild$2.run(Quickbuild.java:159)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Operand type clash: nvarchar is incompatible
ith image
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.
ava:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement
java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.jav
:546)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPr
paredStatement.java:505)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.
ava:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstra
tEntityPersister.java:2247)
... 15 more
2019-01-10 11:35:38,680 INFO - Stopping QuickBuild server...
2019-01-10 11:35:38,688 INFO - Stopping task scheduler...
2019-01-10 11:35:38,697 INFO - Closing session factory...
2019-01-10 11:35:38,709 INFO - Cleaning up temp files...
2019-01-10 11:35:38,731 INFO - QuickBuild server stopped.
Exception in thread "main" org.hibernate.exception.DataException: could not ins
rt: [com.pmease.quickbuild.model.Configuration]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.
ava:77)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHel
er.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstra
tEntityPersister.java:2267)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstra
tEntityPersister.java:2660)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.j
va:56)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141
at org.hibernate.event.def.AbstractFlushingEventListener.performExecuti
ns(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlu
hEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.importDa
a(DefaultDataManager.java:604)
at com.pmease.quickbuild.Quickbuild.importData(Quickbuild.java:616)
at com.pmease.quickbuild.bootstrap.Restore$1.execute(Restore.java:67)
at com.pmease.quickbuild.Quickbuild.startServer(Quickbuild.java:255)
at com.pmease.quickbuild.Quickbuild.access$3(Quickbuild.java:237)
at com.pmease.quickbuild.Quickbuild$2.run(Quickbuild.java:159)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Operand type clash: nvarchar is incompatible
ith image
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.
ava:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement
java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.jav
:546)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPr
paredStatement.java:505)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.
ava:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstra
tEntityPersister.java:2247)
... 15 more
Press any key to continue . . .