[Benny]

Thanks for the assistance.
I changed the datamigration properties to false, and set the dbCreate to create-drop, but I am still not able to get it running.

One error which I have seen multiple times when starting up opentele-server (the clinician server) is this:

Creating overview for patient with id: 12
Creating overview for patient with id: 13
2016-03-22 11:04:17,187 [localhost-startStop-1] ERROR spi.SqlExceptionHelper – Data truncation: Data too long for column ‘green_questionnaire_ids’ at row 1
2016-03-22 11:04:17,202 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener – Error initializing the application: Hibernate operation: could not execute statement; SQL [n/a]; Data truncation: Data too long for column ‘green_questionnaire_ids’ at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘green_questionnaire_ids’ at row 1
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not execute statement; SQL [n/a]; Data truncation: Data too long for column ‘green_questionnaire_ids’ at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘green_questionnaire_ids’ at row 1
at org.opentele.server.core.PatientOverviewMaintenanceService.createOverviewFor(PatientOverviewMaintenanceService.groovy:14)
at BootStrap$_createPatientOverviewDataForPatients_closure5.doCall(BootStrap.groovy:247)
at BootStrap.createPatientOverviewDataForPatients(BootStrap.groovy:245)
at BootStrap$_closure1_closure32_closure33.doCall(BootStrap.groovy:181)
at grails.util.Environment$EnvironmentBlockEvaluator.execute(Environment.java:340)
at grails.util.Environment.executeForEnvironment(Environment.java:321)
at grails.util.Environment.executeForCurrentEnvironment(Environment.java:296)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘green_questionnaire_ids’ at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3607)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330)
at io.jdev.miniprofiler.sql.log4jdbc.PreparedStatementSpy.executeUpdate(PreparedStatementSpy.java:1021)
… 11 more

It is as if the database schema is not according to domain classes or dummy data.

[Author]

Posts