Hi Mridul,Thanks for the info, I'm aware that the admin user login needs to be created separately but the problem is that ant run-install is no longer successful without the special purpose apps.
I had a quick look into it and the first problem I saw was that myportal defines a RoleType record which is referred to in the party app data. It could be that one is the only problem but I didn't have time to look any further.
Regards Scott On 7/09/2009, at 10:28 PM, Mridul Pathak wrote:
Ruth, Scott The admin user login now lies in ecommerce component as demo data. After the introduction of ant target "create-admin-user-login" what Iremember is that seed data for admin user login was removed and for any ant target (that installs data) other than run-install, you need to create admin user login using the ant target introduced. On the other hand in case of run-install demo data for admin is present in ecommerce component, so youneed not to run the other ant target. But in Ruth's case, since hecommented out special purpose applications, this demo data wasn't loaded andhe had to create admin user login using the ant target.The other thing is that, when you create admin user login using the ant target Party record for admin is not created, that is when you see problemssuch as one specified by Ruth about creating DataResource. When aDataResource is created the logged in party is associated to data resourceas its owner, but since admin user doesn't have any party the business process fails. -- Thanks & Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [email protected]On Mon, Sep 7, 2009 at 7:23 AM, Scott Gray <[email protected]>wrote:Hi RuthFor future reference it is much easier to help you diagnose a problem ifyou fully describe what changes you've made to the system.It sounds like there are dependencies on the special purpose applications in the base applications for the seed or demo data (hopefully only there)which is definitely a bug. Could you create a jira issue for this? Thanks Scott On 7/09/2009, at 1:17 PM, Ruth Hoffman wrote:Ok, I just verified that adding back specialpurpose & hot-deplay fixed allmy 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 DataResource. No errors. So, Scott and David (if you are listening), is this a problem of mycreation - 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 tologin 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-install5) ./startofbiz.sh and try to login to webtools <-- get the "unable tologin application" error Did I do something wrong? Isn't one suppose to be able to decouplespecialpurpose & hot-deploy from the framework and still be able to usewebtools? TIA Ruth Scott Gray wrote:Hi RuthI just downloaded r809901, did an ant run-install without errors and wasable 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 datamake 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 andthat 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 andcreate a new DataResource as the admin user. TIA Ruth David E Jones wrote:It's really simple. Either you have the login credentials andnecessary 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 datayou 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 testingand 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 createthe 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 somedata in there in the wrong order).After that you mentioned a login error, which could be caused bymissing 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 usingadmin/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 frustratingto 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 antclean-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 (7200seconds) [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-0617: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 backtransaction. [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-0617: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
