java.sql.SQLSyntaxErrorException: Unknown column 'Birthdate' in 'field list'

[Marco Cruz]

Hi,

we are using dcm4chee 5.29.1 and when receiving a study from we get the message:

2024-06-26 11:56:08,096 DEBUG [org.hibernate.SQL] (EE-ManagedExecutorService-default-Thread-5) insert into patient (dicomattrs_fk, created_time, failed_verifications, merge_fk, num_studies, pat_birthdate, pat_custom1, pat_custom2, pat_custom3, patient_id_fk, pat_name_fk, pat_sex, $
2024-06-26 11:56:08,098 DEBUG [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EE-ManagedExecutorService-default-Thread-5) could not execute statement [n/a]: java.sql.SQLSyntaxErrorException: Unknown column 'Birthdate' in 'field list'
        at com....@8.0.29//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
        at com....@8.0.29//com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
        at com....@8.0.29//com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
        at com....@8.0.29//com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061)
        at com....@8.0.29//com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009)
        at com....@8.0.29//com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320)
        at com....@8.0.29//com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994)
        at org.jboss.ironjac...@1.5.3.Final//org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)
        at org.hi...@5.3.24.Final//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
        at org.hi...@5.3.24.Final//org.hibernate.dialect.identity.GetGeneratedKeysDelegate.executeAndExtract(GetGeneratedKeysDelegate.java:57)
        at org.hi...@5.3.24.Final//org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:42)
        at org.hi...@5.3.24.Final//org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3091)
        at org.hi...@5.3.24.Final//org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3684)
        at org.hi...@5.3.24.Final//org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
        at org.hi...@5.3.24.Final//org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:645)
        at org.hi...@5.3.24.Final//org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:282)
        at org.hi...@5.3.24.Final//org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:263)
        at org.hi...@5.3.24.Final//org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:317)
        at org.hi...@5.3.24.Final//org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:332)
        at org.hi...@5.3.24.Final//org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:289)
        at org.hi...@5.3.24.Final//org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:196)
        at org.hi...@5.3.24.Final//org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:127)
        at org.hi...@5.3.24.Final//org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:192)
        at org.hi...@5.3.24.Final//org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:135)
        at org.hi...@5.3.24.Final//org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:62)
        at org.hi...@5.3.24.Final//org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:804)
        at org.hi...@5.3.24.Final//org.hibernate.internal.SessionImpl.persist(SessionImpl.java:789)
        at org.jbos...@26.1.1.Final//org.jboss.as.jpa.container.AbstractEntityManager.persist(AbstractEntityManager.java:583)
        at deployment.dcm4chee-arc-ear-5.29.1-mysql.ear.dcm4chee-arc-patient-5.29.1.jar//org.dcm4chee.arc.patient.impl.PatientServiceEJB.createPatient(PatientServiceEJB.java:131)
        at deployment.dcm4chee-arc-ear-5.29.1-mysql.ear.dcm4chee-arc-patient-5.29.1.jar//org.dcm4chee.arc.patient.impl.PatientServiceEJB.createPatient(PatientServiceEJB.java:121)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at org.jbo...@26.1.1.Final//org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
        at org.jboss....@1.7.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
        at org.jboss....@1.7.0.Final//org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509)

I have checked that the birthdate of the study is yyymmdd

Can someone advise us?

Thanks

[Marco Cruz]

It is solved.

regards,