Bizarre Insert into DB error
Bizarre Insert into DB error
- Subject: Bizarre Insert into DB error
- From: Calven Eggert <email@hidden>
- Date: Tue, 06 Sep 2005 16:54:35 -0400
Title: Bizarre Insert into DB error
Hi All,
I get the following message when I attempt to insert a record into a db:
EvaluateExpression failed: <com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "INSERT INTO CRR_PATIENT_TRIALS(PATIENT_ID, STATUS, ENROLLED_DATE, OBJECT_ID, CONSENT_DATE, REGISTRATION, LONG_TERM_ARCHIVE, ENROLLEDBY_ID, CREATION_DATE, STATUS_CHANGE_DATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, NULL)" withBindings: 1:1093(patientId), 2:1(status), 3:2005-08-17 00:00:00(enrolledDate), 4:1051(objectId), 5:2005-08-17 00:00:00(consentDate), 6:"CAMP-106"(registration), 7:"Y"(longtermarchive), 8:2065(enrolledBy), 9:2005-09-01 12:39:49(creationDate)>:
Next exception:SQL State:23000 -- error code: 1400 -- msg: ORA-01400: cannot insert NULL into ("CRE_MASTER"."CRR_PATIENT_TRIALS"."ACCRUEDBY_ID")
The odd thing is that the Accruedby_id column is not in the insert statement. Here is the other odd thing...this error msg only happens once a month or so, and therefore it must be working the rest of the time, which is daily.
Why would this happen? Any ideas?
Calven
This e-mail may contain confidential and/or privileged information for the sole use of the intended recipient. Any review or distribution by anyone other than the person for whom it was originally intended is strictly prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Opinions, conclusions or other information contained in this e-mail may not be that of the organization.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden