some studies get rejected with NullPointerException

[Markus Holzer]

hi,

dcm4che-sql-17.1 was running fine for some years now, but it seems like some of the studies get rejected and i cannot find out why.

i queried the mysql server table "study" for the study_iuid and found out that the patient_fk=NULL. i dont understand why it is failing to insert the new records and why there is such an entry in the db.

anyone stumbled upon the same problem or can help me with it?

thanks!

cheers Markus

[fleetwoodfc]

I have seen the same issue and assume it is caused by a 'create new  study' db transaction failing to complete and not rolling back correctly - have been unable to pin down the cause.

You should also find db records at the file, instance and series levels with NULL fk fields e.g. series will have a NULL study_fk. The 'file' record should have the location of the effected DICOM file which will contain the patient info etc. If this is the case then you can recover by noting the effected files (db query files where instance_fk is NULL) then delete all the effected DB records and then import the files again.

[Markus Holzer]

thanks! that actually did the trick, the former rejected file was now accepted by the server!

does this also occur with the newer versions or is this a bug of the version i am using?

cheers Markus