Ok, I just verified that adding back specialpurpose & hot-deplay fixed all my problems. After adding them back to my original working set and then running an ant clean-data, ant run-install I was able to login to webtools (http://localhost:8080/webtools) and go to the Content tab and add Data Resource. No errors.

So, Scott and David (if you are listening), is this a problem of my creation - that is taking out those two component directories is a "no no" - or is this a problem with the demo/seed data that comes with the distribution?

TIA
Ruth


Ruth Hoffman wrote:
Hi Scott:
Here is one way things break:
1) From a fresh download start up ofbiz (./startofbiz.sh) and try to login to webtools using admin/ofbiz <-- this works! 2) Comment out specialpurpose & hot-deploy in ~framework/base/config/component-load.xml
3) Run ant clean-data
4) Run ant run-install
5) ./startofbiz.sh and try to login to webtools <-- get the "unable to login application" error

Did I do something wrong? Isn't one suppose to be able to decouple specialpurpose & hot-deploy from the framework and still be able to use webtools?

TIA
Ruth
Scott Gray wrote:
Hi Ruth

I just downloaded r809901, did an ant run-install without errors and was able to login successfully. Did you modify any of the files after downloading?

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 7/09/2009, at 10:32 AM, Ruth Hoffman wrote:

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








Reply via email to