Re: exception report
Hi Mridul: Thanks for this information. A general question: in order to get this changed, do I need to create a Jira issue? Regards, Ruth 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.
Re: exception report
ialpurpose & 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
Re: exception report
t 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
Re: exception report
t;>>>> 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 >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>> >>>>>>>> >>>>>> >>>>>> >>>> >>> >
Re: exception report
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 ---
Re: exception report
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.St
Re: exception report
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 1
Re: exception report
Also, what application are you trying to log in to? I'll try it for that app as well just to make sure it isn't a problem specific to a certain app. Regards Scott On 7/09/2009, at 12:59 PM, Scott Gray wrote: 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.xml Now 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 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
Re: exception report
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.xml Now 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 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.GenericEntityExcepti
Re: exception report
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.xml Now 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 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.sq
Re: exception report
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.xml Now 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 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)] (S
Re: exception report
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' caus
Re: exception report
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
Re: exception report
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
Re: exception report
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
Re: exception report
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
Re: exception report
More info on this... When I do the ant load-admin-user-login -DuserLoginId=admin I am now able to login to webtools, but I can't use the Content Manager to add a DataResource. I get the following error in the log files: Log.java:111:INFO ] [CommonPermissionServices.xml#genericBasePermissionCheck] Checking for primary permission CONTENTMGR_CREATE 2009-09-06 17:49:49,959 (http-0.0.0.0-8443-1) [ Log.java:111:INFO ] [DataResourcePermissionServices.xml#genericDataResourcePermission] Admin permission found: CONTENTMGR_CREATE 2009-09-06 17:49:49,960 (http-0.0.0.0-8443-1) [ Log.java:111:INFO ] [DataResourcePermissionServices.xml#genericDataResourcePermission] Permission service [CREATE / ] completed; returning hasPermission = true 2009-09-06 17:49:49,960 (http-0.0.0.0-8443-1) [ ServiceDispatcher.java:585:INFO ] Sync service [content/genericDataResourcePermission] finished in [90] milliseconds 2009-09-06 17:49:50,074 (http-0.0.0.0-8443-1) [ServiceEcaCondition.java:155:WARN ] From Field (partyId) is not found in context for createDataResource, defaulting to null. 2009-09-06 17:49:50,075 (http-0.0.0.0-8443-1) [ ServiceEcaRule.java:134:INFO ] For Service ECA [createDataResource] on [commit] got false for condition: [partyId][is-not-empty][true][String] 2009-09-06 17:49:50,075 (http-0.0.0.0-8443-1) [ServiceEcaCondition.java:155:WARN ] From Field (partyId) is not found in context for createDataResource, defaulting to null. 2009-09-06 17:49:50,076 (http-0.0.0.0-8443-1) [ ServiceEcaRule.java:134:INFO ] For Service ECA [createDataResource] on [commit] got false for condition: [partyId][is-not-empty][true][String] 2009-09-06 17:49:50,076 (http-0.0.0.0-8443-1) [ServiceEcaCondition.java:155:WARN ] From Field (partyId) is not found in context for createDataResource, defaulting to null. 2009-09-06 17:49:50,076 (http-0.0.0.0-8443-1) [ServiceEcaCondition.java:155:WARN ] From Field (roleTypeId) is not found in context for createDataResource, defaulting to null. 2009-09-06 17:49:50,077 (http-0.0.0.0-8443-1) [ ServiceEcaSetField.java:66 :INFO ] Expanded String: 2009-09-06 17:49:50,077 (http-0.0.0.0-8443-1) [ ServiceEcaRule.java:151:INFO ] Running Service ECA Service: createDataResourceRole, triggered by rule on Service: createDataResource 2009-09-06 17:49:50,080 (http-0.0.0.0-8443-1) [ Log.java:111:INFO ] [CommonPermissionServices.xml#genericBasePermissionCheck] Checking for primary permission CONTENTMGR_UPDATE 2009-09-06 17:49:50,085 (http-0.0.0.0-8443-1) [ Log.java:111:INFO ] [DataResourcePermissionServices.xml#genericDataResourcePermission] Admin permission found: CONTENTMGR_UPDATE 2009-09-06 17:49:50,085 (http-0.0.0.0-8443-1) [ Log.java:111:INFO ] [DataResourcePermissionServices.xml#genericDataResourcePermission] Permission service [UPDATE / ] completed; returning hasPermission = true 2009-09-06 17:49:50,086 (http-0.0.0.0-8443-1) [ ServiceEcaRule.java:151:INFO ] Running Service ECA Service: ensurePartyRole, triggered by rule on Service: createDataResourceRole 2009-09-06 17:49:50,132 (http-0.0.0.0-8443-1) [ DelegatorImpl.java:1436:ERROR] exception report -- Failure in findOne operation for entity [PartyRole]: org.ofbiz.entity.GenericModelException: [GenericDelegator.findOne] Passed primary key is not a valid primary key: [GenericEntity:PartyRole][roleTypeId,OWNER(java.lang.String)]. Rolling back transaction. Exception: org.ofbiz.entity.GenericModelException Message: [GenericDelegator.findOne] Passed primary key is not a valid primary key: [GenericEntity:PartyRole][roleTypeId,OWNER(java.lang.String)] stack trace --- org.ofbiz.entity.GenericModelException: [GenericDelegator.findOne] Passed primary key is not a valid primary key: [GenericEntity:PartyRole][roleTypeId,OWNER(java.lang.String)] TIA for any help. Ruth 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]
Re: exception report
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
exception report
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
