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
