Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Many records in table "Schedule" with message "message processor record" and no e-mails

Occasional Advisor

Many records in table "Schedule" with message "message processor record" and no e-mails

Hi, Experts!

I need help!!!

In my table Schedule i have more than 100.000 recods with message "message processor record" and SM not send e-mails.

 

In last time no changed in system, but today have this problem. What kind "message processor record" and what problem? Big problem with e-mails.

 

Please, he

9 REPLIES
HPE Expert

Re: Many records in table "Schedule" with message "message processor record" and

Hi Alex

 

Do you have any errors in the sm logs or can you attach the sm .log?

 

Thank you

 

LIsa

"HP Support
If you find that this post or any post resolves your issue, please make sure to mark it as an accepted solution."
HPE Expert

Re: Many records in table "Schedule" with message "message processor record" and

Hi Alex

 

Also do you see anything in your event out

"HP Support
If you find that this post or any post resolves your issue, please make sure to mark it as an accepted solution."
Honored Contributor [Founder]

Re: Many records in table "Schedule" with message "message processor record" and

the 'message processor record' is the name given to the background schedulers that process messages and notifications.

 

Check the Strings tab and the Booleans/Times tab, and there should be details as to what the notification is for.  If there is something on the Boolean/Times tab, there should be a record in the 'mail' table with the same date/timestamp.  In that case, that's the content of the notification being sent.

Highlighted
Honored Contributor [Founder]

Re: Many records in table "Schedule" with message "message processor record" and

Have the message processor schedule records errored out?

What is your current release?

 

If the messages are related to alerts, in some releases there was a problem with SLA and alert related notifications which caused the message creation to abend and leave orphaned message processor records. 

----------------------------------------------------
Kudos - what, where, how, and why
Want Good Answers? Ask Good Questions...
Occasional Advisor

Re: Many records in table "Schedule" with message "message processor record" and

Hi!

 

sm.log in Attachment

Occasional Advisor

Re: Many records in table "Schedule" with message "message processor record" and

Hi, Jacob!

In tab Strings:
3
event management errors
record "scautotest" after set was deleted another user ....
axces
SYSTEM
Honored Contributor [Founder]

Re: Many records in table "Schedule" with message "message processor record" and

Hi ,

As John stated these are mostly due to error generated in processing of some scheduler record and to make it retry sm adds new record.
SM used to delete such type of recrods automatically, if these are still piling up then either deletion is not working or records are adding at faster rate then deletion.
You should check the scheduler records having status 'application running' and delete it if some junk type is there.

Same issue will lead to delay in process of scheduler due to large records in scheduler file and ultimately mails will not be processed and delivered.

http://h30499.www3.hp.com/t5/HP-Service-Manager-Service/40-million-records-in-schedule-table/m-p/6037279#M99399


hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Occasional Advisor

Re: Many records in table "Schedule" with message "message processor record" and

Version 9.20.021

 

And attachment.

Advisor

Re: Many records in table "Schedule" with message "message processor record" and

Dear Sir,

 

Same issue i am also facing in my environment. Is your issue resolved ? If yes then can you please share the solution which you have applied at your end?

 

Regards,

Rajiv