Re: Error with Cross-Model/Database Relationship
Re: Error with Cross-Model/Database Relationship
- Subject: Re: Error with Cross-Model/Database Relationship
- From: David Avendasora <email@hidden>
- Date: Thu, 4 Dec 2008 06:17:04 -0500
On Dec 3, 2008, at 5:28 PM, Chuck Hill wrote:
I think I will guess that this is a bug. What does the fetch spec
and qualifier look like again?
Ahg. You would ask that.
Well, see, this here is a Direct To Java Client app, so it is making
the fetch automatically, on it's own, based on the fields I fill out
in the auto-generated UI.
Any suggestions on how to get the app to spit the fetch spec that it
is creating out to the console? You can see by the SQL log that it
doesn't appear to even be getting to the point of looking the info up
in the DB, it is just stating that it couldn't be found immediately
after finding the 45 objects that eventually point to this item. (see
below)
Because I'm on a tight deadline I've now moved the table (over a
million records) into the same DB as the rest of the app and all is
working correctly. I don't want the table in there long term because
this table would be different depending upon what external Inventory
Management system it is integrating with.
I have a feeling that it is a bug in handling cross-database
relationships where the destination object is part of an inheritance
structure. I see that ERXEntityDependencyOrderingDelegate is what is
throwing the error... maybe the bug is in there?
Dave
Dec 02 08:24:34 BakeryManagementJavaClient[60404]
(ERXNSLogLog4jBridge.java:46) DEBUG NSLog - === Begin Internal
Transaction
Dec 02 08:24:34 BakeryManagementJavaClient[60404]
(ERXNSLogLog4jBridge.java:46) DEBUG NSLog - evaluateExpression:
<com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression:
"SELECT t0.External_Lot_Code_ID, t0.External_Lot_Code_Value,
t0.External_Part_Number, t0.Lot_Code_ID FROM dbo.MSDynamics_Lot_Code
t0 WHERE UPPER(t0.External_Lot_Code_Value) LIKE UPPER(?) ESCAPE '\'"
withBindings: 1:"8P31808269%"(externalLotCodeValue)>
Dec 02 08:24:37 BakeryManagementJavaClient[60404]
(ERXNSLogLog4jBridge.java:46) DEBUG NSLog - 45 row(s) processed
Dec 02 08:24:37 BakeryManagementJavaClient[60404]
(ERXNSLogLog4jBridge.java:46) DEBUG NSLog - === Commit Internal
Transaction
Dec 02 08:24:37 BakeryManagementJavaClient[60404]
(ERXDatabaseContextDelegate.java:153) INFO
er.transaction.adaptor.Exceptions - Database Exception occured:
java.lang.IllegalStateException: The object with globalID
_EOIntegralKeyGlobalID[LotCode (java.lang.Long)143937] could not be
found in the database. This could be result of a referential
integrity problem with the database. An empty fault could not be
created because the object's class could not be determined (e.g. the
GID is temporary or it is for an abstract entity).
Dec 02 08:24:37 BakeryManagementJavaClient[60404]
(ERXEntityDependencyOrderingDelegate.java:69) ERROR
com.webobjects.eoaccess.ERXEntityDependencyOrderingDelegate -
Unexpected non-EOGeneralAdaptorException exception
java.lang.IllegalStateException: The object with globalID
_EOIntegralKeyGlobalID[LotCode (java.lang.Long)143937] could not be
found in the database. This could be result of a referential
integrity problem with the database. An empty fault could not be
created because the object's class could not be determined (e.g. the
GID is temporary or it is for an abstract entity).
at
com
.webobjects
.eoaccess
.EODatabaseContext._fetchSingleObject(EODatabaseContext.java:3583)
at
com
.webobjects
.eoaccess
.EODatabaseContext
._objectFaultWithSnapshotRelationshipEditingContext
(EODatabaseContext.java:2532)
at
com
.webobjects
.eoaccess
.EODatabaseContext
.initializeObjectRowEntityEditingContext(EODatabaseContext.java:2433)
at
com
.webobjects
.eoaccess.EODatabaseContext.initializeObject(EODatabaseContext.java:
3734)
at
com
.webobjects
.eocontrol
.EOObjectStoreCoordinator
.initializeObject(EOObjectStoreCoordinator.java:646)
at
com
.webobjects
.eocontrol.EOEditingContext.initializeObject(EOEditingContext.java:
3805)
at er.extensions.eof.ERXEC.initializeObject(ERXEC.java:1047)
at com.webobjects.eoaccess.EODatabaseChannel
$
_EODatabaseChannelFetchResult
.initializeObjects(EODatabaseChannel.java:478)
at
com
.webobjects
.eoaccess
.EODatabaseContext
._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:
3240)
at
com
.webobjects
.eoaccess
.EODatabaseContext
.objectsWithFetchSpecification(EODatabaseContext.java:3346)
at
com
.webobjects
.eocontrol
.EOObjectStoreCoordinator
.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:539)
at
com
.webobjects
.eocontrol
.EOEditingContext
.objectsWithFetchSpecification(EOEditingContext.java:4114)
at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:
1109)
at
com
.webobjects
.eocontrol
.EOEditingContext
.objectsWithFetchSpecification(EOEditingContext.java:4500)
_______________________________________________
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