Makes sense. Shouldn't a fresh "ant run-install" with the download data
make this all well again? I guess I'm wondering how it should work. Are
you saying there is something missing in the download that should be
there and that what I'm experiencing is the result of a bad release?
Or, are you saying that I am not following the right procedure for
getting well. After all, all I'm trying to do is login to webtools and
create a new DataResource as the admin user.
TIA
Ruth
David E Jones wrote:
It's really simple. Either you have the login credentials and
necessary permissions configured in the database or you don't. If you
don't you can't login or access things that require permissions. If
you've emptied your database and there is an error loading data you
need... then the data you need isn't in there and that must be
resolved first.
-David
On Sep 6, 2009, at 4:06 PM, Ruth Hoffman wrote:
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
