Re: Bizarre Insert into DB error
Re: Bizarre Insert into DB error
- Subject: Re: Bizarre Insert into DB error
- From: Chuck Hill <email@hidden>
- Date: Tue, 6 Sep 2005 15:08:06 -0700
Two possibilities come to mind:
1. The app is running out of memory, all bets are off if that
happens. Check the log for OutOfMemory
2. You are violating one or more of the EOF commandments: http://
www.wodev.com/cgi-bin/WebObjects/WODev.woa/wa/Main?
wikiPage=EOFCommandments
Chuck
On Sep 6, 2005, at 1:54 PM, Calven Eggert wrote:
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:
40global-village.net
This email sent to email@hidden
--
Practical WebObjects - a book for intermediate WebObjects developers
who want to increase their overall knowledge of WebObjects, or those
who are trying to solve specific application development problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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