Those look like two different things... but possibly related.
The first exception report you sent over was about a foreign key
violation that was part of importing the PartyDemoData.xml file. Based
on that it looks like there is some bad data in that file (ie someone
put some data in there in the wrong order).
After that you mentioned a login error, which could be caused by
missing data (ie data files that did not load successfully).
Which version/revision of OFBiz are you using?
-David
On Sep 6, 2009, at 3:44 PM, Ruth Hoffman wrote:
Just in case it wasn't clear, when going to login to webtools using
admin/ofbiz I got the following error message:
"The Following Errors Occurred: unable to login this application"
Any help would be greatly appreciated. This is getting frustrating
to say the least.
Ruth
Ruth Hoffman wrote:
Hello List:
What is going on? I couldn't login as admin/ofbiz so I clean data
and reinstall. Here's what I get on trunk version 809901, after ant
clean-all, ant run-install:
[java] 2009-09-06 17:29:57,994 (main) [ EntitySaxReader.java:
219:INFO ] Beginning import from URL: file:/Users/ruthhoffman/
809901-trunk-2009-09-01/applications/party/data/PartyDemoData.xml
[java] 2009-09-06 17:29:57,995 (main) [ EntitySaxReader.java:
257:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
[java] 2009-09-06 17:29:58,096 (main) [ DelegatorImpl.java:
503:ERROR]
[java] ---- exception report
----------------------------------------------------------
[java] Failure in create operation for entity [PartyRole]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:PartyRole][createdStamp,2009-09-06
17:29:58.091(java.sql.Timestamp)][createdTxStamp,2009-09-06
17:29:57.995(java.sql.Timestamp)][lastUpdatedStamp,2009-09-06
17:29:58.091(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-06
17:29:57.995(java.sql.Timestamp)][partyId,admin(java.lang.String)]
[roleTypeId,EMAIL_ADMIN(java.lang.String)] (SQL Exception while
executing the following:INSERT INTO OFBIZ.PARTY_ROLE (PARTY_ID,
ROLE_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (INSERT
on table 'PARTY_ROLE' caused a violation of foreign key constraint
'PARTY_RLE_ROLE' for key (EMAIL_ADMIN). The statement has been
rolled back.)). Rolling back transaction.
[java] Exception: org.ofbiz.entity.GenericEntityException
[java] Message: Error while inserting: [GenericEntity:PartyRole]
[createdStamp,2009-09-06 17:29:58.091(java.sql.Timestamp)]
[createdTxStamp,2009-09-06 17:29:57.995(java.sql.Timestamp)]
[lastUpdatedStamp,2009-09-06 17:29:58.091(java.sql.Timestamp)]
[lastUpdatedTxStamp,2009-09-06 17:29:57.995(java.sql.Timestamp)]
[partyId,admin(java.lang.String)]
[roleTypeId,EMAIL_ADMIN(java.lang.String)] (SQL Exception while
executing the following:INSERT INTO OFBIZ.PARTY_ROLE (PARTY_ID,
ROLE_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (INSERT
on table 'PARTY_ROLE' caused a violation of foreign key constraint
'PARTY_RLE_ROLE' for key (EMAIL_ADMIN). The statement has been
rolled back.))......
lots more errors....
Ruth
