Users - JOB _SANDBOX

[Andrew Dupa]

Hi,

 

I have two issues around JOB_SANDBOX.

 

 I currently have the problem of scheduled jobs failing and being rescheduled, the jobs in question are back order notifications. They keep failing and I would like to kill them permanently. Which brings me to my second problem 

 

The JOB_SANDBOX table has grown very large (25,000+ records) and thus I get memory problems on a 2 gig machine when trying to edit them thru the admin screen.

 

How do I purge old job records?

How do I identify those still scheduled to run but doomed to fail (i.e. thos that have failed 900 times) and how do I cancel them?

 

Does anyone have some SQL they run to clean these tables occasionally?

 

I'm running a 3.0 release build.

 

Thanks,

Andrew

 

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[David E. Jones]

You can manually cancel jobs in the WebTools webapp, and I think this  
functionality went back that far. You can also remove the records  
directly from the database.

The functionality for controlling jobs has improved a LOT in more  
recent code, so it is a bit of a pain with the older stuff (no  
failure re-run limit, etc).

-David


On Feb 1, 2006, at 3:54 PM, Andrew Dupa wrote:

> Hi,
>
> I have two issues around JOB_SANDBOX.
>
>  I currently have the problem of scheduled jobs failing and being  
> rescheduled, the jobs in question are back order notifications.  
> They keep failing and I would like to kill them permanently. Which  
> brings me to my second problem
>
> The JOB_SANDBOX table has grown very large (25,000+ records) and  
> thus I get memory problems on a 2 gig machine when trying to edit  
> them thru the admin screen.
>
> How do I purge old job records?
> How do I identify those still scheduled to run but doomed to fail  
> (i.e. thos that have failed 900 times) and how do I cancel them?
>
> Does anyone have some SQL they run to clean these tables occasionally?
>
> I'm running a 3.0 release build.
>
> Thanks,
> Andrew
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Andrew Dupa]

David,

 

Thanks for your response but the problem is the WebTools app doesn't work when you have 25,000+ records. Not even on a 2gig machine with all the memory dedicated to the Java app running ofbiz....!!!!

 

Hence my question in the first place.

 

I know I can remove records from the database....I was asking if anyone else run into this problem and could they please help me to understand the data model so I may intelligently delete from a live system. What issues are there? etc....please c'mon..

 

I'm trying very hard not to be rude and please take the following with a grain of salt as I'm very frustrated here. Honestly your response was pointless....I know you're one of the main contributors but if you have nothing to contribute to my questions please don't respond. I'm not a complete idiot. I was asking for help, not the obvious.

 

I understand that the Webtools area of the application may have improved in the latest version, I vcertainly hope it didn't get worse. Here's my growing concern from reading the list that maybe Ofbiz is lost in it's own never ending development cycle. What about real world scenarios and users who have current live systems. arrrgghh...

 

Come on please..

Andrew.

 

On 2/1/06, David E. Jones <[hidden email]> wrote:

You can manually cancel jobs in the WebTools webapp, and I think this
functionality went back that far. You can also remove the records
directly from the database.

The functionality for controlling jobs has improved a LOT in more
recent code, so it is a bit of a pain with the older stuff (no
failure re-run limit, etc).

-David


On Feb 1, 2006, at 3:54 PM, Andrew Dupa wrote:

> Hi,
>
> I have two issues around JOB_SANDBOX.
>
>  I currently have the problem of scheduled jobs failing and being
> rescheduled, the jobs in question are back order notifications.
> They keep failing and I would like to kill them permanently. Which
> brings me to my second problem
>
> The JOB_SANDBOX table has grown very large (25,000+ records) and
> thus I get memory problems on a 2 gig machine when trying to edit
> them thru the admin screen.
>
> How do I purge old job records?
> How do I identify those still scheduled to run but doomed to fail
> (i.e. thos that have failed 900 times) and how do I cancel them?
>
> Does anyone have some SQL they run to clean these tables occasionally?
>
> I'm running a 3.0 release build.
>
> Thanks,
> Andrew
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[BJ Freeman]

in webtools
Entity Reference & Editing Tools [Static Version]
if your saying you have 25K records in the sandbox, it does not should
like it is cleaning up.
you might check the clean up routine and modify it to clean the sandbox.


Andrew Dupa sent the following on 2/1/06 7:27 PM:

> David,
>
> Thanks for your response but the problem is the WebTools app doesn't work
> when you have 25,000+ records. Not even on a 2gig machine with all the
> memory dedicated to the Java app running ofbiz....!!!!
>
> Hence my question in the first place.
>
> I know I can remove records from the database....I was asking if anyone else
> run into this problem and could they please help me to understand the data
> model so I may intelligently delete from a live system. What issues are
> there? etc....please c'mon..
>
> I'm trying very hard not to be rude and please take the following with a
> grain of salt as I'm very frustrated here. Honestly your response was
> pointless....I know you're one of the main contributors but if you have
> nothing to contribute to my questions please don't respond. I'm not a
> complete idiot. I was asking for help, not the obvious.
>
> I understand that the Webtools area of the application may have improved in
> the latest version, I vcertainly hope it didn't get worse. Here's my growing
> concern from reading the list that maybe Ofbiz is lost in it's own never
> ending development cycle. What about real world scenarios and users who have
> current live systems. arrrgghh...
>
> Come on please..
> Andrew.
>
>
> On 2/1/06, David E. Jones <[hidden email]> wrote:
>
>>
>>You can manually cancel jobs in the WebTools webapp, and I think this
>>functionality went back that far. You can also remove the records
>>directly from the database.
>>
>>The functionality for controlling jobs has improved a LOT in more
>>recent code, so it is a bit of a pain with the older stuff (no
>>failure re-run limit, etc).
>>
>>-David
>>
>>
>>On Feb 1, 2006, at 3:54 PM, Andrew Dupa wrote:
>>
>>
>>>Hi,
>>>
>>>I have two issues around JOB_SANDBOX.
>>>
>>> I currently have the problem of scheduled jobs failing and being
>>>rescheduled, the jobs in question are back order notifications.
>>>They keep failing and I would like to kill them permanently. Which
>>>brings me to my second problem
>>>
>>>The JOB_SANDBOX table has grown very large (25,000+ records) and
>>>thus I get memory problems on a 2 gig machine when trying to edit
>>>them thru the admin screen.
>>>
>>>How do I purge old job records?
>>>How do I identify those still scheduled to run but doomed to fail
>>>(i.e. thos that have failed 900 times) and how do I cancel them?
>>>
>>>Does anyone have some SQL they run to clean these tables occasionally?
>>>
>>>I'm running a 3.0 release build.
>>>
>>>Thanks,
>>>Andrew
>>>
>>>
>>>_______________________________________________
>>>Users mailing list
>>>[hidden email]
>>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>>
>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>>
>
>
>
> ------------------------------------------------------------------------
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Andrew Dupa]

OK - so what clean up routine is that?

On 2/1/06, bjfree <[hidden email]> wrote:

in webtools
Entity Reference & Editing Tools [Static Version]
if your saying you have 25K records in the sandbox, it does not should
like it is cleaning up.
you might check the clean up routine and modify it to clean the sandbox.


Andrew Dupa sent the following on 2/1/06 7:27 PM:

> David,
>
> Thanks for your response but the problem is the WebTools app doesn't work
> when you have 25,000+ records. Not even on a 2gig machine with all the
> memory dedicated to the Java app running ofbiz....!!!!
>
> Hence my question in the first place.
>
> I know I can remove records from the database....I was asking if anyone else
> run into this problem and could they please help me to understand the data
> model so I may intelligently delete from a live system. What issues are
> there? etc....please c'mon..
>
> I'm trying very hard not to be rude and please take the following with a
> grain of salt as I'm very frustrated here. Honestly your response was
> pointless....I know you're one of the main contributors but if you have
> nothing to contribute to my questions please don't respond. I'm not a
> complete idiot. I was asking for help, not the obvious.
>
> I understand that the Webtools area of the application may have improved in
> the latest version, I vcertainly hope it didn't get worse. Here's my growing
> concern from reading the list that maybe Ofbiz is lost in it's own never
> ending development cycle. What about real world scenarios and users who have
> current live systems. arrrgghh...
>
> Come on please..
> Andrew.
>
>
> On 2/1/06, David E. Jones <[hidden email]> wrote:
>
>>
>>You can manually cancel jobs in the WebTools webapp, and I think this
>>functionality went back that far. You can also remove the records
>>directly from the database.
>>
>>The functionality for controlling jobs has improved a LOT in more
>>recent code, so it is a bit of a pain with the older stuff (no
>>failure re-run limit, etc).
>>
>>-David
>>
>>
>>On Feb 1, 2006, at 3:54 PM, Andrew Dupa wrote:
>>
>>
>>>Hi,
>>>
>>>I have two issues around JOB_SANDBOX.
>>>
>>> I currently have the problem of scheduled jobs failing and being
>>>rescheduled, the jobs in question are back order notifications.
>>>They keep failing and I would like to kill them permanently. Which
>>>brings me to my second problem
>>>
>>>The JOB_SANDBOX table has grown very large (25,000+ records) and
>>>thus I get memory problems on a 2 gig machine when trying to edit
>>>them thru the admin screen.
>>>
>>>How do I purge old job records?
>>>How do I identify those still scheduled to run but doomed to fail
>>>(i.e. thos that have failed 900 times) and how do I cancel them?
>>>
>>>Does anyone have some SQL they run to clean these tables occasionally?
>>>
>>>I'm running a 3.0 release build.
>>>
>>>Thanks,
>>>Andrew
>>>
>>>
>>>_______________________________________________
>>>Users mailing list
>>>[hidden email]
>>> http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>>
>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>

>>

>
>
>
> ------------------------------------------------------------------------
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[David E. Jones]

I certainly wouldn't want to insult your intelligence. It sounds like  
you're handling it just fine, so I'll not ask for more details and  
just take your advice and not respond.

You are totally correct, BTW, about the never ending development  
cycle going on with OFBiz and that no single user has opened up and  
gone through a full testing cycle (though the Sequoia community is  
certainly giving it a shot), so we don't really have a perfect  
version anywhere. It's really frustrating as hell.

-David


On Feb 1, 2006, at 8:27 PM, Andrew Dupa wrote:

> David,
>
> Thanks for your response but the problem is the WebTools app  
> doesn't work when you have 25,000+ records. Not even on a 2gig  
> machine with all the memory dedicated to the Java app running  
> ofbiz....!!!!
>
> Hence my question in the first place.
>
> I know I can remove records from the database....I was asking if  
> anyone else run into this problem and could they please help me to  
> understand the data model so I may intelligently delete from a live  
> system. What issues are there? etc....please c'mon..
>
> I'm trying very hard not to be rude and please take the following  
> with a grain of salt as I'm very frustrated here. Honestly your  
> response was pointless....I know you're one of the main  
> contributors but if you have nothing to contribute to my questions  
> please don't respond. I'm not a complete idiot. I was asking for  
> help, not the obvious.
>
> I understand that the Webtools area of the application may have  
> improved in the latest version, I vcertainly hope it didn't get  
> worse. Here's my growing concern from reading the list that maybe  
> Ofbiz is lost in it's own never ending development cycle. What  
> about real world scenarios and users who have current live systems.  
> arrrgghh...
>
> Come on please..
> Andrew.
>
>
> On 2/1/06, David E. Jones <[hidden email]> wrote:
> You can manually cancel jobs in the WebTools webapp, and I think this
> functionality went back that far. You can also remove the records
> directly from the database.
>
> The functionality for controlling jobs has improved a LOT in more
> recent code, so it is a bit of a pain with the older stuff (no
> failure re-run limit, etc).
>
> -David
>
>
> On Feb 1, 2006, at 3:54 PM, Andrew Dupa wrote:
>
> > Hi,
> >
> > I have two issues around JOB_SANDBOX.
> >
> >  I currently have the problem of scheduled jobs failing and being
> > rescheduled, the jobs in question are back order notifications.
> > They keep failing and I would like to kill them permanently. Which
> > brings me to my second problem
> >
> > The JOB_SANDBOX table has grown very large (25,000+ records) and
> > thus I get memory problems on a 2 gig machine when trying to edit
> > them thru the admin screen.
> >
> > How do I purge old job records?
> > How do I identify those still scheduled to run but doomed to fail
> > (i.e. thos that have failed 900 times) and how do I cancel them?
> >
> > Does anyone have some SQL they run to clean these tables  
> occasionally?
> >
> > I'm running a 3.0 release build.
> >
> > Thanks,
> > Andrew
> >
> >
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
>
>
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
>
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users