May be we can move admin demo data from ecommerce component to a new CommonDemoData.xml file in framework/common component, only if it sounds reasonable.Also, what about creating a Party record for admin as part of create-admin-user-login ant target, or may be at the time of password reset? So that we don't come across issues like creating records associated to Party for a non-existing Party, normally it happens on triggers and not directly?
-- Thanks & Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Mon, Sep 7, 2009 at 4:22 PM, Scott Gray <scott.g...@hotwaxmedia.com>wrote: > 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 I >> remember 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 you >> need not to run the other ant target. But in Ruth's case, since he >> commented out special purpose applications, this demo data wasn't loaded >> and >> he 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 >> problems >> such as one specified by Ruth about creating DataResource. When a >> DataResource is created the logged in party is associated to data resource >> as 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 >> mridul.pat...@hotwaxmedia.com >> >> On Mon, Sep 7, 2009 at 7:23 AM, Scott Gray <scott.g...@hotwaxmedia.com >> >wrote: >> >> Hi Ruth >>> >>> For future reference it is much easier to help you diagnose a problem if >>> you 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 >>> 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 >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>> >>>>>>>> >>>>>> >>>>>