Hi David:
From trunk version 809901 downloaded today/yesterday.
This all started when I did an ant clean-data because I was testing and
I wanted to start over with a clean database.
After I did that, I couldn't login to webtools. I got the "unable to
login application" error. So I tried to clean everything (ant
clean-all/ant run-install). I still couldn't login with admin/ofbiz. So
I did the ant load-admin-user-login -D... after which I was able to
login, but not create the DataResource.
TIA
Ruth
David E Jones wrote:
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