Ofbiz not working on Linux

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Ofbiz not working on Linux

Vishalkataria
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
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz not working on Linux

Ashish Vijaywargiya
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
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz not working on Linux

Ashish Vijaywargiya
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
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz not working on Linux

Vishalkataria
In reply to this post by Ashish Vijaywargiya
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 <vishal.kataria@hytechpro.com
> 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
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz not working on Linux

Ashish Vijaywargiya
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
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz not working on Linux

Vishalkataria
Hi Ashish

Thanks for you help

I am send you error log file as an attachment. 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
<vishal.kataria@hytechpro.com>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
> > <vishal.kataria@hytechpro.com
> >> 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
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz not working on Linux

Jacques Le Roux
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.
>
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz not working on Linux

Jacopo Cappellato-3
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