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
