Thanks. The logging was very helpful.
I turned on logging and this is the result of the query. As you can see, it
is using t0 as the table name before the field name. Where is this coming
from within the configuration. Instead of t0 it should be
Site_Daily_Sum.fieldname. Is there something I must do when I run the
modeler?
SELECT t0.INQ_CACHE_GEN_ELIG, t0.INQ_CACHE_GENERATED, t0.INQ_IDFY_BLANK,
t0.INQ_IDFY_NAMED, t0.INQ_IDFY_TOTAL, t0.INQ_INVALID, t0.INQ_TOTAL,
t0.INQ_VRFY_CACHE_RESP, t0.INQ_VRFY_TOTAL, t0.RESP_271_ELIG,
t0.RESP_271_NOTELIG, t0.RESP_271_TOTAL, t0.RESP_AAA_TIMEOUT,
t0.RESP_AAA_TOTAL, t0.RESP_ACTIVE, t0.RESP_BADRESP, t0.RESP_CACHE,
t0.RESP_INACTIVE, t0.RESP_INQ_MGR, t0.RESP_INVALID270, t0.RESP_NULL,
t0.RESP_UNDETERMINED, t0.SITE_NUMBER, t0.SUMMARY_DATE, t0.VISN_NUMBER FROM
SITE_DAILY_SUM t0
Thanks,
Roy
-----Original Message-----
From: Andrus Adamchik [mailto:andru..bjectstyle.org]
Sent: Wednesday, July 14, 2004 9:25 PM
To: cayenne-use..bjectstyle.org
Subject: Re: Newbie question on Cayenne error at runtime
On Jul 14, 2004, at 6:05 PM, McBrayer, Roy wrote:
> iiv_test.CreateReport.main(CreateReport.java:20) Caused by:
> java.sql.SQLException: ORA-00600: internal error code, arguments:
> [ttcgcshnd-1], [0], [], [], [], [], [], []
This is an Oracle error and does not seem to be related to Cayenne.
From http://www.orafaq.com/error/ora-00600.htm :
"Possible causes include
* time-outs,
* file corruption,
* failed data checks in memory, hardware, memory, or I/O messages,
* incorrectly restored files"
Sounds scary, and not related to the client-sent SQL... One more thing
to check before calling your DBA. Turn on SQL logging per
http://objectstyle.org/cayenne/userguide/deploy/logging.html and see
what SQL is generated by Cayenne. Try running the same query from
SQLPlus and see if it produces a similar crash.
Andrus
This archive was generated by hypermail 2.0.0 : Thu Jul 15 2004 - 09:56:06 EDT