Hi All
I Am facing this error when i am running ofbiz on Linux system. Please help me to resolve this issue. When i am trying to run ./startofbiz.sh, it showing given below error: --------------------------------------****************---------------------------------------- 2008-08-08 12:41:46,015 (org.ofbiz.service.job.JobPoller@ba5c7a) [ JobManager.java:178:ERROR] ---- exception report ---------------------------------------------------------- Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 12:41:36.394' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (Base table or view not found message from server: "Table 'testdata.JOB_SANDBOX' doesn't exist"))]. Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 12:41:36.394' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (Base table or view not found message from server: "Table 'testdata.JOB_SANDBOX' doesn't exist")) ------------------------------------------****************------------------------------------ Thanks in advance Regards Vishal Kataia |
Which OFBiz version ?
Which Linux Flavour ? What is the JDK version ? Do you know how to read "sh" files ? Please let us know this details as soon as you get a chance. On Fri, Aug 8, 2008 at 12:50 PM, Vishalkataria <[hidden email] > wrote: > > Hi All > > I Am facing this error when i am running ofbiz on Linux system. Please help > me to resolve this issue. > When i am trying to run ./startofbiz.sh, it showing given below error: > > > --------------------------------------****************---------------------------------------- > > 2008-08-08 12:41:46,015 (org.ofbiz.service.job.JobPoller@ba5c7a) [ > JobManager.java:178:ERROR] > ---- exception report > ---------------------------------------------------------- > Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: > Generic Entity Exception occured in updateByCondition (SQL Exception while > executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, > STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 12:41:36.394' AND > START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID > IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (Base table or view not > found message from server: "Table 'testdata.JOB_SANDBOX' doesn't exist"))]. > Rolling back transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: Generic Entity Exception occured in updateByCondition (SQL > Exception while executing the following:UPDATE JOB_SANDBOX SET > RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 > 12:41:36.394' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND > RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) > (Base > table or view not found message from server: "Table 'testdata.JOB_SANDBOX' > doesn't exist")) > > > ------------------------------------------****************------------------------------------ > > Thanks in advance > > Regards > Vishal Kataia > -- > View this message in context: > http://www.nabble.com/Ofbiz-not-working-on-Linux-tp18886923p18886923.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > > -- Ashish Vijaywargiya Indore (M.P), India http://en.wikipedia.org/wiki/Indore |
I am using Linux CentOS 5.2 Stable release.
I am using JDK1.5. I am using OFBiz trunk rev no. 683536. It's working fine for me without any problem. OFBiz is also working fine on some other system I have that has Ubuntu 8.0. On Fri, Aug 8, 2008 at 12:59 PM, Ashish Vijaywargiya < [hidden email]> wrote: > Which OFBiz version ? > Which Linux Flavour ? > What is the JDK version ? > Do you know how to read "sh" files ? > > Please let us know this details as soon as you get a chance. > > > > On Fri, Aug 8, 2008 at 12:50 PM, Vishalkataria < > [hidden email]> wrote: > >> >> Hi All >> >> I Am facing this error when i am running ofbiz on Linux system. Please >> help >> me to resolve this issue. >> When i am trying to run ./startofbiz.sh, it showing given below error: >> >> >> --------------------------------------****************---------------------------------------- >> >> 2008-08-08 12:41:46,015 (org.ofbiz.service.job.JobPoller@ba5c7a) [ >> JobManager.java:178:ERROR] >> ---- exception report >> ---------------------------------------------------------- >> Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: >> Generic Entity Exception occured in updateByCondition (SQL Exception while >> executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >> STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 12:41:36.394' AND >> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND >> RUN_BY_INSTANCE_ID >> IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (Base table or view >> not >> found message from server: "Table 'testdata.JOB_SANDBOX' doesn't >> exist"))]. >> Rolling back transaction. >> Exception: org.ofbiz.entity.GenericDataSourceException >> Message: Generic Entity Exception occured in updateByCondition (SQL >> Exception while executing the following:UPDATE JOB_SANDBOX SET >> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 >> 12:41:36.394' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND >> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) >> (Base >> table or view not found message from server: "Table 'testdata.JOB_SANDBOX' >> doesn't exist")) >> >> >> ------------------------------------------****************------------------------------------ >> >> Thanks in advance >> >> Regards >> Vishal Kataia >> -- >> View this message in context: >> http://www.nabble.com/Ofbiz-not-working-on-Linux-tp18886923p18886923.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> >> > > > -- > Ashish Vijaywargiya > Indore (M.P), India > http://en.wikipedia.org/wiki/Indore > > -- Ashish Vijaywargiya Indore (M.P), India http://en.wikipedia.org/wiki/Indore |
In reply to this post by Ashish Vijaywargiya
Hi Ashish
ofbiz 4.0 fedora 7 jdk 1.5.0_12 Regards Vishal Kataria
|
Thanks Vishal.
I didn't try OFBiz 4.0 since long. So please wait somebody using OFBiz 4.0 will get back to you. One more thing :- Can you please send the detailed log message ? It looks like that some schedule service is not working properly and throwing JobSandBox kind of error. Did you do some custom modification in your instance ? Please read following line from log message (Specially look at the testdata.JOB_SANDBOX) :- STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 12:41:36.394' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (Base table or view not found message from server: "Table 'testdata.JOB_SANDBOX' doesn't exist"))]. Rolling back transaction. On Fri, Aug 8, 2008 at 1:03 PM, Vishalkataria <[hidden email]>wrote: > > Hi Ashish > > ofbiz 4.0 > fedora 7 > jdk 1.5.0_12 > > Regards > Vishal Kataria > > > Ashish Vijaywargiya-4 wrote: > > > > Which OFBiz version ? > > Which Linux Flavour ? > > What is the JDK version ? > > Do you know how to read "sh" files ? > > > > Please let us know this details as soon as you get a chance. > > > > > > On Fri, Aug 8, 2008 at 12:50 PM, Vishalkataria > > <[hidden email] > >> wrote: > > > >> > >> Hi All > >> > >> I Am facing this error when i am running ofbiz on Linux system. Please > >> help > >> me to resolve this issue. > >> When i am trying to run ./startofbiz.sh, it showing given below error: > >> > >> > >> > --------------------------------------****************---------------------------------------- > >> > >> 2008-08-08 12:41:46,015 (org.ofbiz.service.job.JobPoller@ba5c7a) [ > >> JobManager.java:178:ERROR] > >> ---- exception report > >> ---------------------------------------------------------- > >> Error in polling JobSandbox: > >> [org.ofbiz.entity.GenericDataSourceException: > >> Generic Entity Exception occured in updateByCondition (SQL Exception > >> while > >> executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, > >> STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 12:41:36.394' AND > >> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND > >> RUN_BY_INSTANCE_ID > >> IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (Base table or view > >> not > >> found message from server: "Table 'testdata.JOB_SANDBOX' doesn't > >> exist"))]. > >> Rolling back transaction. > >> Exception: org.ofbiz.entity.GenericDataSourceException > >> Message: Generic Entity Exception occured in updateByCondition (SQL > >> Exception while executing the following:UPDATE JOB_SANDBOX SET > >> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 > >> 12:41:36.394' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL > >> AND > >> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) > >> (Base > >> table or view not found message from server: "Table > >> 'testdata.JOB_SANDBOX' > >> doesn't exist")) > >> > >> > >> > ------------------------------------------****************------------------------------------ > >> > >> Thanks in advance > >> > >> Regards > >> Vishal Kataia > >> -- > >> View this message in context: > >> > http://www.nabble.com/Ofbiz-not-working-on-Linux-tp18886923p18886923.html > >> Sent from the OFBiz - User mailing list archive at Nabble.com. > >> > >> > > > > > > -- > > Ashish Vijaywargiya > > Indore (M.P), India > > http://en.wikipedia.org/wiki/Indore > > > > > > -- > View this message in context: > http://www.nabble.com/Ofbiz-not-working-on-Linux-tp18886923p18887082.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > > -- Ashish Vijaywargiya Indore (M.P), India http://en.wikipedia.org/wiki/Indore |
Hi Ashish
Thanks for you help I am send you error log file as an attachment. error.log
|
Administrator
|
In reply to this post by Vishalkataria
Just checked, release 4.0 r683895 works well for me on Ubuntu 8.4 using Sun jdk 1.6.0_03
You can check it yourself from the alternate demo server on OFBiz main page http://ofbiz.apache.org/ Jacques From: "Vishalkataria" <[hidden email]> > > Hi Ashish > > ofbiz 4.0 > fedora 7 > jdk 1.5.0_12 > > Regards > Vishal Kataria > > > Ashish Vijaywargiya-4 wrote: >> >> Which OFBiz version ? >> Which Linux Flavour ? >> What is the JDK version ? >> Do you know how to read "sh" files ? >> >> Please let us know this details as soon as you get a chance. >> >> >> On Fri, Aug 8, 2008 at 12:50 PM, Vishalkataria >> <[hidden email] >>> wrote: >> >>> >>> Hi All >>> >>> I Am facing this error when i am running ofbiz on Linux system. Please >>> help >>> me to resolve this issue. >>> When i am trying to run ./startofbiz.sh, it showing given below error: >>> >>> >>> --------------------------------------****************---------------------------------------- >>> >>> 2008-08-08 12:41:46,015 (org.ofbiz.service.job.JobPoller@ba5c7a) [ >>> JobManager.java:178:ERROR] >>> ---- exception report >>> ---------------------------------------------------------- >>> Error in polling JobSandbox: >>> [org.ofbiz.entity.GenericDataSourceException: >>> Generic Entity Exception occured in updateByCondition (SQL Exception >>> while >>> executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >>> STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 12:41:36.394' AND >>> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND >>> RUN_BY_INSTANCE_ID >>> IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (Base table or view >>> not >>> found message from server: "Table 'testdata.JOB_SANDBOX' doesn't >>> exist"))]. >>> Rolling back transaction. >>> Exception: org.ofbiz.entity.GenericDataSourceException >>> Message: Generic Entity Exception occured in updateByCondition (SQL >>> Exception while executing the following:UPDATE JOB_SANDBOX SET >>> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 >>> 12:41:36.394' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL >>> AND >>> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) >>> (Base >>> table or view not found message from server: "Table >>> 'testdata.JOB_SANDBOX' >>> doesn't exist")) >>> >>> >>> ------------------------------------------****************------------------------------------ >>> >>> Thanks in advance >>> >>> Regards >>> Vishal Kataia >>> -- >>> View this message in context: >>> http://www.nabble.com/Ofbiz-not-working-on-Linux-tp18886923p18886923.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >>> >> >> >> -- >> Ashish Vijaywargiya >> Indore (M.P), India >> http://en.wikipedia.org/wiki/Indore >> >> > > -- > View this message in context: http://www.nabble.com/Ofbiz-not-working-on-Linux-tp18886923p18887082.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
In reply to this post by Vishalkataria
please, double check the way you have configured your db. Is it
working if you just use the default Derby db? I guess so. Jacopo On Aug 8, 2008, at 9:48 AM, Vishalkataria wrote: > > Hi Ashish > > Thanks for you help > > I am send you error log file as an attachment. > http://www.nabble.com/file/p18887293/error.log error.log > > > > Ashish Vijaywargiya-4 wrote: >> >> Thanks Vishal. >> I didn't try OFBiz 4.0 since long. >> >> So please wait somebody using OFBiz 4.0 will get back to you. >> One more thing :- >> Can you please send the detailed log message ? >> It looks like that some schedule service is not working properly and >> throwing JobSandBox kind of error. >> >> Did you do some custom modification in your instance ? >> Please read following line from log message (Specially look at the >> testdata.JOB_SANDBOX) :- >> >> STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 12:41:36.394' AND >> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND >> RUN_BY_INSTANCE_ID >> IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (Base table or >> view >> not >> found message from server: "Table 'testdata.JOB_SANDBOX' doesn't >> exist"))]. >> Rolling back transaction. >> >> >> >> On Fri, Aug 8, 2008 at 1:03 PM, Vishalkataria >> <[hidden email]>wrote: >> >>> >>> Hi Ashish >>> >>> ofbiz 4.0 >>> fedora 7 >>> jdk 1.5.0_12 >>> >>> Regards >>> Vishal Kataria >>> >>> >>> Ashish Vijaywargiya-4 wrote: >>>> >>>> Which OFBiz version ? >>>> Which Linux Flavour ? >>>> What is the JDK version ? >>>> Do you know how to read "sh" files ? >>>> >>>> Please let us know this details as soon as you get a chance. >>>> >>>> >>>> On Fri, Aug 8, 2008 at 12:50 PM, Vishalkataria >>>> <[hidden email] >>>>> wrote: >>>> >>>>> >>>>> Hi All >>>>> >>>>> I Am facing this error when i am running ofbiz on Linux system. >>>>> Please >>>>> help >>>>> me to resolve this issue. >>>>> When i am trying to run ./startofbiz.sh, it showing given below >>>>> error: >>>>> >>>>> >>>>> >>> -------------------------------------- >>> ****************---------------------------------------- >>>>> >>>>> 2008-08-08 12:41:46,015 (org.ofbiz.service.job.JobPoller@ba5c7a) [ >>>>> JobManager.java:178:ERROR] >>>>> ---- exception report >>>>> ---------------------------------------------------------- >>>>> Error in polling JobSandbox: >>>>> [org.ofbiz.entity.GenericDataSourceException: >>>>> Generic Entity Exception occured in updateByCondition (SQL >>>>> Exception >>>>> while >>>>> executing the following:UPDATE JOB_SANDBOX SET >>>>> RUN_BY_INSTANCE_ID = ?, >>>>> STATUS_ID = ? WHERE ((RUN_TIME <= '2008-08-08 12:41:36.394' AND >>>>> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND >>>>> RUN_BY_INSTANCE_ID >>>>> IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (Base table or >>> view >>>>> not >>>>> found message from server: "Table 'testdata.JOB_SANDBOX' doesn't >>>>> exist"))]. >>>>> Rolling back transaction. >>>>> Exception: org.ofbiz.entity.GenericDataSourceException >>>>> Message: Generic Entity Exception occured in updateByCondition >>>>> (SQL >>>>> Exception while executing the following:UPDATE JOB_SANDBOX SET >>>>> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= >>>>> '2008-08-08 >>>>> 12:41:36.394' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME >>>>> IS NULL >>>>> AND >>>>> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = >>>>> 'pool')) >>>>> (Base >>>>> table or view not found message from server: "Table >>>>> 'testdata.JOB_SANDBOX' >>>>> doesn't exist")) >>>>> >>>>> >>>>> >>> ------------------------------------------ >>> ****************------------------------------------ >>>>> >>>>> Thanks in advance >>>>> >>>>> Regards >>>>> Vishal Kataia >>>>> -- >>>>> View this message in context: >>>>> >>> http://www.nabble.com/Ofbiz-not-working-on-Linux-tp18886923p18886923.html >>>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>>>> >>>>> >>>> >>>> >>>> -- >>>> Ashish Vijaywargiya >>>> Indore (M.P), India >>>> http://en.wikipedia.org/wiki/Indore >>>> >>>> >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Ofbiz-not-working-on-Linux-tp18886923p18887082.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >>> >> >> >> -- >> Ashish Vijaywargiya >> Indore (M.P), India >> http://en.wikipedia.org/wiki/Indore >> >> > > -- > View this message in context: http://www.nabble.com/Ofbiz-not-working-on-Linux-tp18886923p18887293.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > smime.p7s (3K) Download Attachment |
Free forum by Nabble | Edit this page |