Hi All,
Currently we are upgrading our hybris from 6.1 to hybris2105.As part of this we are migrating from Oracle to MSSQL server DB.We have completed the 2105 upgrade in Onprem test server with Oracle DB.
And we have completed hybris setup in Cloud DEV environment and DB data migration is also completed from Oracle to MSSQL server.
Now We pointed our hybris to MSSQL server and trying to perform system update but we are facing some datatype issues.Below is the stacktrace:
Caused by: org.springframework.dao.DataIntegrityViolationException: query; SQL []; Error converting data type nvarchar to numeric.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type nvarchar to numeric.
[java] at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:251) ~[spring-jdbc-5.3.18.jar:5.3.18]
[java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.18.jar:5.3.18]
[java] at de.hybris.platform.jdbcwrapper.DataSourceImpl.translateToDataAccessException(DataSourceImpl.java:1055) ~[coreserver.jar:?]
[java] at de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityState.createEntity(GenericBMPBean.java:1872) ~[coreserver.jar:?]
[java] at de.hybris.platform.persistence.GenericBMPBean.ejbCreate(GenericBMPBean.java:394) ~[coreserver.ja
Below are the steps followed for DB migration:
1.Setup hybris in Cloud DEV environment with custom code
2.Point hybris to MSSQL server and perform initialization to create structure(tables) of DB before data migration.
3.Once the tables are created ,Data migration has been completed with SSMA tool.
4.After data migration,I tried to perform System update and facing many datatype issues so,update is failing with issues.
I thought of trying to retrive the update SQL queries to check which query is actually causing the issue but I am not able to open HAC/Backoffice.Attaching Log file.logs.txt
I am not able to proceed furthur to fix these datatype issues.
Can someone please provide any ideas/any way to fix these kind of DB issues?