Unable to import application with data on linux server

Confluence User - 11 Jul, 2023

Hii

We are using linux server (Cent OS) to host our joget application when we try to import any app from our existing windows hosted joget application with data it ran into error but when we import the application without data its being successfully imported . For your knowlege the file size of the application we are trying to import is around 7 mb and some greater than that 

Please note: When we migrate the same application across windows servers everything works fine all data is importe

Please find below  log Errors ..


  • ERROR   11 Jul 2023 14:18:19 org.joget.commons.spring.web.CustomDelegatingFilterProxy - Request processing failed; nested exception is org.springframework.transaction.UnexpectedRollbackException: JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is bitronix.tm.internal.BitronixRollbackException: transaction was marked as rollback only and has been rolled back
    org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.UnexpectedRollbackException: JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is bitronix.tm.internal.BitronixRollbackException: transaction was marked as rollback only and has been rolled back
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014) ~[spring-webmvc-5.3.27.jar:5.3.27]
  • 11 Jul 2023 14:18:19 org.hibernate.engine.jdbc.spi.SqlExceptionHelper - (conn=104) Incorrect string value: '\xD8\xB1\xD9\x82\xD9\x85...' for column 'c_TRADE_LICENCE_NO' at row 1
    ERROR   11 Jul 2023 14:18:19 org.joget.apps.util.AppLicenseUtil - javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement
    javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement 

lin


Any help will be appreciated

Thanks in advance


linux;centos;migrate;import;export;mysql

1


12 Jul, 2023
confluenceUser
confluenceUser

Hi, the key clue here is the error message "Incorrect string value: '\xD8\xB1\xD9\x82\xD9\x85...' for column". A quick web search returns https://stackoverflow.com/questions/10957238/incorrect-string-value-when-trying-to-insert-utf-8-into-mysql-via-jdbc which indicates it is a database character encoding issue. You will need to configure your database server to use correct matching encoding.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print