[OFBiz] Users - entity check on startup-Visit

[bjfree at free-man.net]

that may be a problem also, but this is about column names.
for instances, the DB has CLIENT_HOST_NAME
but it is trying to up date clientHostName(see below)
for the columns that do match, the data is put in the DB.
just all the other columns are blank.

so my question is why are these columns not changed/ADDED at start up.

-----Original Message-----
From: David E. Jones [mailto:jonesde at ofbiz.org]
Sent: Monday, May 02, 2005 1:02 PM
To: OFBiz Users / Usage Discussion
Subject: Re: [OFBiz] Users - entity check on startup-Visit


There is data missing. Can't update a row that isn't there. This is a  
common problem with the Visit table when you have sessions persisted  
by Tomcat and change your database between stopping and restarting.

If you want more details on this, search the mailing list archives as  
I have answered this in detail before.

-David


On May 1, 2005, at 7:28 PM, bjfree at free-man.net wrote:

> wasn't sure what to title this.
> here is the problem.
> on startup I get no warning or errors on the visit entity
> yet I get errors on inserting into the visit table.
> The noticeable difference is the columns names do not match what is  
> in the
> DB(previous version)
> So why was this not caught on start up?
>
> Failure in store operation for entity [Visit]:
> org.ofbiz.entity.GenericEntityException: Exception while updating the
> following entity:
> [GenericEntity:Visit][clientHostName,70.56.94.57(java.lang.String)] 
> [clientIp
> Address,70.56.94.57(java.lang.String)][clientUser,null()] 
> [createdStamp,2005-
> 05-01 18:27:51.737(java.sql.Timestamp)][createdTxStamp,2005-05-01
> 18:27:51.737(java.sql.Timestamp)][fromDate,2005-05-01
> 18:27:50.084(java.sql.Timestamp)][initialLocale,en_US 
> (java.lang.String)][ini
> tialReferrer,(java.lang.String)][initialRequest,https:// 
> 4dealersonly.busines
> sesnetwork.com:8443/control/main(java.lang.String)] 
> [initialUserAgent,Mozilla
> /5.0 (Windows; U; WinNT4.0; en-US; rv:1.7.5) Gecko/20041107
> Firefox/1.0(java.lang.String)][lastUpdatedStamp,2005-05-01
> 18:27:51.807(java.sql.Timestamp)][lastUpdatedTxStamp,2005-05-01
> 18:27:51.807(java.sql.Timestamp)][serverHostName,ns4 
> (java.lang.String)][serv
> erIpAddress,70.56.94.61(java.lang.String)] 
> [sessionId,A495D3C32BAC79621D26D1D
> 72357E645.jvm1(java.lang.String)][visitId,11617(java.lang.String)] 
> [visitorId
> ,10204(java.lang.String)][webappName,root(java.lang.String)] (Tried to
> update an entity that does not exist.). Rolling back transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Exception while updating the following entity:
> [GenericEntity:Visit][clientHostName,70.56.94.57(java.lang.String)] 
> [clientIp
> Address,70.56.94.57(java.lang.String)][clientUser,null()] 
> [createdStamp,2005-
> 05-01 18:27:51.737(java.sql.Timestamp)][createdTxStamp,2005-05-01
> 18:27:51.737(java.sql.Timestamp)][fromDate,2005-05-01
> 18:27:50.084(java.sql.Timestamp)][initialLocale,en_US 
> (java.lang.String)][ini
> tialReferrer,(java.lang.String)][initialRequest,https:// 
> 4dealersonly.busines
> sesnetwork.com:8443/control/main(java.lang.String)] 
> [initialUserAgent,Mozilla
> /5.0 (Windows; U; WinNT4.0; en-US; rv:1.7.5) Gecko/20041107
> Firefox/1.0(java.lang.String)][lastUpdatedStamp,2005-05-01
> 18:27:51.807(java.sql.Timestamp)][lastUpdatedTxStamp,2005-05-01
> 18:27:51.807(java.sql.Timestamp)][serverHostName,ns4 
> (java.lang.String)][serv
> erIpAddress,70.56.94.61(java.lang.String)] 
> [sessionId,A495D3C32BAC79621D26D1D
> 72357E645.jvm1(java.lang.String)][visitId,11617(java.lang.String)] 
> [visitorId
> ,10204(java.lang.String)][webappName,root(java.lang.String)] (Tried to
> update an entity that does not exist.)
>
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
Users at lists.ofbiz.org
http://lists.ofbiz.org/mailman/listinfo/users