PortalData load errors on update
Locked
 
|
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 |
Re: PortalData load errors on update
|
|
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 |
|
|
In reply to this post by gcameo
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 <[hidden email]> wrote: From: David E Jones <[hidden email]> Subject: Re: PortalData load errors on update To: [hidden email] 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 |
Re: PortalData load errors on update
|
|
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 <[hidden email]> > wrote: > > From: David E Jones <[hidden email]> > Subject: Re: PortalData load errors on update > To: [hidden email] > 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 > |
|
|
In reply to this post by gcameo
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 <[hidden email]> wrote: From: David E Jones <[hidden email]> Subject: Re: PortalData load errors on update To: [hidden email] 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 <[hidden email]> wrote: > > From: David E Jones <[hidden email]> > Subject: Re: PortalData load errors on update > To: [hidden email] > 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 > |
Re: PortalData load errors on update
|
|
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 <[hidden email]> > wrote: > > From: David E Jones <[hidden email]> > Subject: Re: PortalData load errors on update > To: [hidden email] > 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 <[hidden email]> >> wrote: >> >> From: David E Jones <[hidden email]> >> Subject: Re: PortalData load errors on update >> To: [hidden email] >> 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 >> > |
|
|
In reply to this post by gcameo
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 <[hidden email]> wrote: From: David E Jones <[hidden email]> Subject: Re: PortalData load errors on update To: [hidden email] 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 <[hidden email]> wrote: > > From: David E Jones <[hidden email]> > Subject: Re: PortalData load errors on update > To: [hidden email] > 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 <[hidden email]> wrote: >> >> From: David E Jones <[hidden email]> >> Subject: Re: PortalData load errors on update >> To: [hidden email] >> 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 >> > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |