send dicom file to dcm4chee 5.10.5(CStoreSCP) Error

kong ye

unread,

Nov 2, 2017, 5:43:05 AM11/2/17

to dcm4che

sending dicom file, throw an error in org.dcm4chee.arc.store.impl.StoreServiceEJB.findSeries(..)

findSeries method

private Series findSeries(String studyInstanceUID, String seriesInstanceUID) {

//Series.FIND_BY_SERIES_IUID_EAGER

/*String query="select se from Series se " +

"join fetch se.study st " +

"join fetch st.patient p " +

"left join fetch p.patientName " +

"left join fetch st.referringPhysicianName " +

"left join fetch se.performingPhysicianName " +

"join fetch se.attributesBlob " +

"join fetch st.attributesBlob " +

"join fetch p.attributesBlob " +

"where st.studyInstanceUID = ?1 " +

"and se.seriesInstanceUID = ?2";*/

try {

return em.createNamedQuery(Series.FIND_BY_SERIES_IUID_EAGER, Series.class)

.setParameter(1, studyInstanceUID)

.setParameter(2, seriesInstanceUID)

.getSingleResult();

} catch (NoResultException e) {

return null;

}

exception:

Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)

at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)

at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)

at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:449)

at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:202)

at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:137)

at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:102)

at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:186)

at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4126)

at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:503)

at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:468)

at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'issuerenti1_.localNamespaceEntityID' in 'field list'

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)

at com.mysql.jdbc.Util.getInstance(Util.java:383)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)

at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)

... 65 common frames omitted

what should i do

gunterze

unread,

Nov 3, 2017, 4:57:58 AM11/3/17

to dcm4che

I could nor reproduce the problem with dcm4chee-arc-5.10.6-mysql. The SQL statement which corresponds to the mentioned JPQL statement is performed successfully:

2017-11-03 09:42:57,977 DEBUG [org.hibernate.SQL] (EE-ManagedExecutorService-default-Thread-5) select series0_.pk as pk1_18_0_, study1_.pk as pk1_24_1_, patient2_.pk as pk1_13_2_, personname3_.pk as pk1_15_3_, attributes8_.pk as pk1_2_4_, personname4_.pk as pk1_15_5_, attributes7_.pk as pk1_2_6_, personname5_.pk as pk1_15_7_, attributes6_.pk as pk1_2_8_, series0_.dicomattrs_fk as dicomat30_18_0_, series0_.body_part as body_par2_18_0_, series0_.completeness as complete3_18_0_, series0_.created_time as created_4_18_0_, series0_.expiration_date as expirati5_18_0_, series0_.ext_retrieve_aet as ext_retr6_18_0_, series0_.failed_retrieves as failed_r7_18_0_, series0_.inst_purge_state as inst_pur8_18_0_, series0_.inst_purge_time as inst_pur9_18_0_, series0_.inst_code_fk as inst_co31_18_0_, series0_.institution as institu10_18_0_, series0_.department as departm11_18_0_, series0_.laterality as lateral12_18_0_, series0_.metadata_fk as metadat32_18_0_, series0_.metadata_update_time as metadat13_18_0_, series0_.modality as modalit14_18_0_, series0_.pps_cuid as pps_cui15_18_0_, series0_.pps_iuid as pps_iui16_18_0_, series0_.pps_start_date as pps_sta17_18_0_, series0_.pps_start_time as pps_sta18_18_0_, series0_.perf_phys_name_fk as perf_ph33_18_0_, series0_.rejection_state as rejecti19_18_0_, series0_.series_custom1 as series_20_18_0_, series0_.series_custom2 as series_21_18_0_, series0_.series_custom3 as series_22_18_0_, series0_.series_desc as series_23_18_0_, series0_.series_iuid as series_24_18_0_, series0_.series_no as series_25_18_0_, series0_.src_aet as src_aet26_18_0_, series0_.station_name as station27_18_0_, series0_.study_fk as study_f34_18_0_, series0_.updated_time as updated28_18_0_, series0_.version as version29_18_0_, study1_.access_control_id as access_c2_24_1_, study1_.access_time as access_t3_24_1_, study1_.accession_no as accessio4_24_1_, study1_.dicomattrs_fk as dicomat23_24_1_, study1_.completeness as complete5_24_1_, study1_.created_time as created_6_24_1_, study1_.expiration_date as expirati7_24_1_, study1_.ext_retrieve_aet as ext_retr8_24_1_, study1_.failed_retrieves as failed_r9_24_1_, study1_.accno_issuer_fk as accno_i24_24_1_, study1_.modified_time as modifie10_24_1_, study1_.patient_fk as patient25_24_1_, study1_.ref_phys_name_fk as ref_phy26_24_1_, study1_.rejection_state as rejecti11_24_1_, study1_.storage_ids as storage12_24_1_, study1_.study_custom1 as study_c13_24_1_, study1_.study_custom2 as study_c14_24_1_, study1_.study_custom3 as study_c15_24_1_, study1_.study_date as study_d16_24_1_, study1_.study_desc as study_d17_24_1_, study1_.study_id as study_i18_24_1_, study1_.study_iuid as study_i19_24_1_, study1_.study_time as study_t20_24_1_, study1_.updated_time as updated21_24_1_, study1_.version as version22_24_1_, patient2_.dicomattrs_fk as dicomat11_13_2_, patient2_.created_time as created_2_13_2_, patient2_.merge_fk as merge_f12_13_2_, patient2_.num_studies as num_stud3_13_2_, patient2_.pat_birthdate as pat_birt4_13_2_, patient2_.pat_custom1 as pat_cust5_13_2_, patient2_.pat_custom2 as pat_cust6_13_2_, patient2_.pat_custom3 as pat_cust7_13_2_, patient2_.patient_id_fk as patient13_13_2_, patient2_.pat_name_fk as pat_nam14_13_2_, patient2_.pat_sex as pat_sex8_13_2_, patient2_.resp_person_fk as resp_pe15_13_2_, patient2_.updated_time as updated_9_13_2_, patient2_.version as version10_13_2_, personname3_.family_name as family_n2_15_3_, personname3_.given_name as given_na3_15_3_, personname3_.i_family_name as i_family4_15_3_, personname3_.i_given_name as i_given_5_15_3_, personname3_.i_middle_name as i_middle6_15_3_, personname3_.i_name_prefix as i_name_p7_15_3_, personname3_.i_name_suffix as i_name_s8_15_3_, personname3_.middle_name as middle_n9_15_3_, personname3_.name_prefix as name_pr10_15_3_, personname3_.name_suffix as name_su11_15_3_, personname3_.p_family_name as p_famil12_15_3_, personname3_.p_given_name as p_given13_15_3_, personname3_.p_middle_name as p_middl14_15_3_, personname3_.p_name_prefix as p_name_15_15_3_, personname3_.p_name_suffix as p_name_16_15_3_, attributes8_.attrs as attrs2_2_4_, personname4_.family_name as family_n2_15_5_, personname4_.given_name as given_na3_15_5_, personname4_.i_family_name as i_family4_15_5_, personname4_.i_given_name as i_given_5_15_5_, personname4_.i_middle_name as i_middle6_15_5_, personname4_.i_name_prefix as i_name_p7_15_5_, personname4_.i_name_suffix as i_name_s8_15_5_, personname4_.middle_name as middle_n9_15_5_, personname4_.name_prefix as name_pr10_15_5_, personname4_.name_suffix as name_su11_15_5_, personname4_.p_family_name as p_famil12_15_5_, personname4_.p_given_name as p_given13_15_5_, personname4_.p_middle_name as p_middl14_15_5_, personname4_.p_name_prefix as p_name_15_15_5_, personname4_.p_name_suffix as p_name_16_15_5_, attributes7_.attrs as attrs2_2_6_, personname5_.family_name as family_n2_15_7_, personname5_.given_name as given_na3_15_7_, personname5_.i_family_name as i_family4_15_7_, personname5_.i_given_name as i_given_5_15_7_, personname5_.i_middle_name as i_middle6_15_7_, personname5_.i_name_prefix as i_name_p7_15_7_, personname5_.i_name_suffix as i_name_s8_15_7_, personname5_.middle_name as middle_n9_15_7_, personname5_.name_prefix as name_pr10_15_7_, personname5_.name_suffix as name_su11_15_7_, personname5_.p_family_name as p_famil12_15_7_, personname5_.p_given_name as p_given13_15_7_, personname5_.p_middle_name as p_middl14_15_7_, personname5_.p_name_prefix as p_name_15_15_7_, personname5_.p_name_suffix as p_name_16_15_7_, attributes6_.attrs as attrs2_2_8_ from series series0_ inner join study study1_ on series0_.study_fk=study1_.pk inner join patient patient2_ on study1_.patient_fk=patient2_.pk left outer join person_name personname3_ on patient2_.pat_name_fk=personname3_.pk inner join dicomattrs attributes8_ on patient2_.dicomattrs_fk=attributes8_.pk left outer join person_name personname4_ on study1_.ref_phys_name_fk=personname4_.pk inner join dicomattrs attributes7_ on study1_.dicomattrs_fk=attributes7_.pk left outer join person_name personname5_ on series0_.perf_phys_name_fk=personname5_.pk inner join dicomattrs attributes6_ on series0_.dicomattrs_fk=attributes6_.pk where study1_.study_iuid=? and series0_.series_iuid=?

kong ye

unread,

Nov 3, 2017, 5:16:16 AM11/3/17

to dcm4che

i didnt load the orm-identify.xml before,just change the IssueEntity. now i change back. its ok now.

and i continue to got a error in next.

Caused by: java.lang.IllegalStateException: There are delayed insert actions before operation as cascade level 0.

at org.hibernate.internal.SessionImpl.checkNoUnresolvedActionsBeforeOperation(SessionImpl.java:652)

at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:809)

at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:784)

at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:789)

at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1181)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:344)

at com.sun.proxy.$Proxy101.persist(Unknown Source)

at org.dcm4chee.arc.store.impl.StoreServiceEJB.createInstance(StoreServiceEJB.java:1133)

at org.dcm4chee.arc.store.impl.StoreServiceEJB.createInstance(StoreServiceEJB.java:603)

at org.dcm4chee.arc.store.impl.StoreServiceEJB.updateDB(StoreServiceEJB.java:228)

at org.dcm4chee.arc.store.impl.StoreServiceEJB$$FastClassBySpringCGLIB$$8f329c9c.invoke(<generated>)