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
