I grabbed a compiled version of 9.04 and it is working fine so I will use that for now and will make noise if I find any errors. thanks for the help
Regards Farouk Alhassan --- On Sat, 4/18/09, David E Jones <[email protected]> wrote: From: David E Jones <[email protected]> Subject: Re: PortalData load errors on update To: [email protected] Date: Saturday, April 18, 2009, 2:46 PM The release09.04 branch is not even 2 days old yet, so it isn't necessarily more bug-free than the trunk (which is different from stable...), and unless a sub-community gathers around the release branch it will be stable but not bug-free. For more details please see the OFBiz Release Plan: http://docs.ofbiz.org/display/OFBADMIN/Release+Plan -David On Apr 18, 2009, at 3:39 PM, farouk alhassan wrote: > I am using revision 766301. I just saw the release of 9.04 branch on the > downloads page so i will go for that one. Hopefully, I will not have any > issues with that since it has been tested more than the main trunk. > > --- On Sat, 4/18/09, David E Jones <[email protected]> wrote: > > From: David E Jones <[email protected]> > Subject: Re: PortalData load errors on update > To: [email protected] > Date: Saturday, April 18, 2009, 2:32 PM > > > Which revision of OFBiz are you using? This must have already been fixed in > SVN... > > -David > > > On Apr 18, 2009, at 12:31 PM, farouk alhassan wrote: > >> Hi David, >> You were right. the following exception was thrown high up in the logs which >> i failed to catch. After that all portlet data stuff seem to fall over. Is >> it a column width issue or its a problem with the code doing the >> truncation? Looks like the description field is set to 20 chars. I am using >> MySQL and my revision is 766301 >> >> [java] ---- exception report >>---------------------------------------------------------- >> [java] Failure in create operation for entity [PortletCategory]: >>org.ofbiz.entity.GenericEntityException: Error while inserting: >>[GenericEntity:PortletCategory][createdStamp,2009-04-18 >>19:41:52.937(java.sql.Timestamp)][createdTxStamp,2009-04-18 >>19:41:52.921(java.sql.Timestamp)][description,Accounting related >>data(java.lang.String)][lastUpdatedStamp,2009-04-18 >>19:41:52.937(java.sql.Timestamp)][lastUpdatedTxStamp,2009-04-18 >>19:41:52.921(java.sql.Timestamp)][portletCategoryId,ACCOUNTING(java.lang.String)] >> (SQL Exception while executing the following:INSERT INTO >>OFBIZ.PORTLET_CATEGORY (PORTLET_CATEGORY_ID, DESCRIPTION, LAST_UPDATED_STAMP, >>LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, >>?, ?) (A truncation error was encountered trying to shrink VARCHAR >>'Accounting related data' to length 20.)). Rolling back transaction. >> [java] Exception: org.ofbiz.entity.GenericEntityException >> [java] Message: Error while inserting: >>[GenericEntity:PortletCategory][createdStamp,2009-04-18 >>19:41:52.937(java.sql.Timestamp)][createdTxStamp,2009-04-18 >>19:41:52.921(java.sql.Timestamp)][description,Accounting related >>data(java.lang.String)][lastUpdatedStamp,2009-04-18 >>19:41:52.937(java.sql.Timestamp)][lastUpdatedTxStamp,2009-04-18 >>19:41:52.921(java.sql.Timestamp)][portletCategoryId,ACCOUNTING(java.lang.String)] >> (SQL Exception while executing the following:INSERT INTO >>OFBIZ.PORTLET_CATEGORY (PORTLET_CATEGORY_ID, DESCRIPTION, LAST_UPDATED_STAMP, >>LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, >>?, ?) (A truncation error was encountered trying to shrink VARCHAR >>'Accounting related data' to length 20.)) >> [java] ---- cause >>--------------------------------------------------------------------- >> [java] Exception: org.ofbiz.entity.GenericDataSourceException >> [java] Message: SQL Exception while executing the following:INSERT INTO >>OFBIZ.PORTLET_CATEGORY (PORTLET_CATEGORY_ID, DESCRIPTION, LAST_UPDATED_STAMP, >>LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, >>?, ?) (A truncation error was encountered trying to shrink VARCHAR >>'Accounting related data' to length 20.) >> [java] ---- cause >>--------------------------------------------------------------------- >> [java] Exception: java.sql.SQLDataException >> [java] Message: A truncation error was encountered trying to shrink >>VARCHAR 'Accounting related data' to length 20. >> [java] ---- cause >>--------------------------------------------------------------------- >> [java] Exception: org.apache.derby.impl.jdbc.EmbedSQLException >> [java] Message: A truncation error was encountered trying to shrink >>VARCHAR 'Accounting related data' to length 20. >> [java] ---- cause >>--------------------------------------------------------------------- >> >> >> --- On Sat, 4/18/09, David E Jones <[email protected]> wrote: >> >> From: David E Jones <[email protected]> >> Subject: Re: PortalData load errors on update >> To: [email protected] >> Date: Saturday, April 18, 2009, 10:58 AM >> >> >> It looks like your data loading problem is further up than that. Keep in >> mind that if a file fails early on then other files that depend on it will >> fail too. >> >> I just tried this with the latest trunk with a clean database and the data >> files are loading fine. The best thing to do is look up a little ways >> further in the log and see which is the first file to fail and why, and then >> fix that, and then try again and repeat as necessary. >> >> -David >> >> >> On Apr 18, 2009, at 11:48 AM, farouk alhassan wrote: >> >>> hi, >>> I have just updated my copy of OFBiz from SVN and run >>> ant clean and ant run-install. >>> At the end of the installation I had the following messages on the console. >>> How do I resolve these as they seem to be database errors with regard to >>> the myportal application >>> >>> [EntityDataLoadContainer.java:280:INFO ] The following errors occured in >>> the data load: >>> 2009-04-18 19:42:39,984 (main) [EntityDataLoadContainer.java:282:INFO ] >>>[install.loadData]: Error loading XML Resource >>>"file:/C:/home/projects/antonov/hector/applications/accounting/data/AccountingPortletData.xml"; >>> Error was: A transaction error occurred reading data >>> 2009-04-18 19:42:39,984 (main) [EntityDataLoadContainer.java:282:INFO ] >>>[install.loadData]: Error loading XML Resource >>>"file:/C:/home/projects/antonov/hector/applications/order/data/OrderPortletData.xml"; >>> Error was: A transaction error occurred reading data >>> 2009-04-18 19:42:39,984 (main) [EntityDataLoadContainer.java:282:INFO ] >>>[install.loadData]: Error loading XML Resource >>>"file:/C:/home/projects/antonov/hector/specialpurpose/projectmgr/data/ProjectMgrPortletData.xml"; >>> Error was: A transaction error occurred reading data >>> 2009-04-18 19:42:39,984 (main) [EntityDataLoadContainer.java:282:INFO ] >>>[install.loadData]: Error loading XML Resource >>>"file:/C:/home/projects/antonov/hector/specialpurpose/myportal/data/MyPortalTypeData.xml"; >>> Error was: A transaction error occurred reading data >> >
