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 >
