SQL Null Error

  • Hi


    I am getting the following error on a few images:


    20140221 10:20:33 ***Failed MYSQLExec : INSERT INTO DICOMImages (ImagePat, AccessTime, ObjectFile, DeviceName) VALUES ('0', 1392974432, '1.2.276.0.37.1.183.201007.5278763\\1.2.392.200036.9116.2.6.1.48.1214859555.1389310001.742175\\000001.dcm', 'MAG0')
    20140221 10:20:33 ***Error: Field 'SOPInstanc' doesn't have a default value
    20140221 10:20:33 ***Unable to DB.Add()
    20140221 10:20:33 ***SQL: INSERT INTO DICOMImages (ImagePat, AccessTime, ObjectFile, DeviceName) VALUES ('0', 1392974432, '1.2.276.0.37.1.183.201007.5278763\\1.2.392.200036.9116.2.6.1.48.1214859555.1389310001.742175\\000001.dcm', 'MAG0')
    20140221 10:20:33 ***Error: Field 'SOPInstanc' doesn't have a default value
    20140221 10:20:33 ***[Regen] D:\test\409225\1.2.276.0.37.1.183.201007.5278763\1.2.392.200036.9116.2.6.1.48.1214859555.1389310001.742175\000001.dcm -FAILED: Error SQL Add
    20140221 10:20:33 ***Failed MYSQLExec : INSERT INTO DICOMImages (ImagePat, AccessTime, ObjectFile, DeviceName) VALUES ('0', 1392974432, '1.2.276.0.37.1.183.201007.5278763\\1.2.392.200036.9116.2.6.1.48.1214859555.1389310001.742175\\000002.dcm', 'MAG0')
    20140221 10:20:33 ***Error: Field 'SOPInstanc' doesn't have a default value
    20140221 10:20:33 ***Unable to DB.Add()
    20140221 10:20:33 ***SQL: INSERT INTO DICOMImages (ImagePat, AccessTime, ObjectFile, DeviceName) VALUES ('0', 1392974432, '1.2.276.0.37.1.183.201007.5278763\\1.2.392.200036.9116.2.6.1.48.1214859555.1389310001.742175\\000002.dcm', 'MAG0')
    20140221 10:20:33 ***Error: Field 'SOPInstanc' doesn't have a default value
    20140221 10:20:33 ***[Regen] D:\test\409225\1.2.276.0.37.1.183.201007.5278763\1.2.392.200036.9116.2.6.1.48.1214859555.1389310001.742175\000002.dcm -FAILED: Error SQL Add


    That seems to be anew one I never encoutered.
    What does it mean? the rest of the images seem to be ok.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!