That is a strange problem, did ant run-install report any errors?
Regards Scott On 7/09/2009, at 12:38 PM, Ruth Hoffman wrote:
Hi Scott:OK. I changed CommonTypeData.xml back and did an ant run-install and I get "Unable to login this application".Shouldn't ant run-install reset everything? Ruth Ruth Hoffman wrote:Hi Scott: I did an ant clean-all first. Then I did the ant run-install. To answer your question: I changed the theme in CommonTypeData.xmlNow that you've asked the question, you've got me thinking. I'm going to set it back to the original and see if things work.Ruth Scott Gray wrote:Hi RuthI 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
smime.p7s
Description: S/MIME cryptographic signature
