Re: Many records in table "Schedule" with message "message processor record" and (457 Views)
Reply
Occasional Advisor
AlexeyL
Posts: 13
Registered: ‎03-12-2013
Message 1 of 9 (490 Views)

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

HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 2 of 9 (481 Views)

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."
HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 3 of 9 (480 Views)

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
Jacob Heubner
Posts: 4,177
Registered: ‎07-21-2008
Message 4 of 9 (478 Views)

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.

Honored Contributor
John Stagaman
Posts: 3,604
Registered: ‎07-13-2007
Message 5 of 9 (457 Views)

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
AlexeyL
Posts: 13
Registered: ‎03-12-2013
Message 6 of 9 (440 Views)

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

Hi!

 

sm.log in Attachment

Occasional Advisor
AlexeyL
Posts: 13
Registered: ‎03-12-2013
Message 7 of 9 (438 Views)

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
Piku
Posts: 4,203
Registered: ‎06-17-2010
Message 8 of 9 (434 Views)

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/603...


hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Occasional Advisor
AlexeyL
Posts: 13
Registered: ‎03-12-2013
Message 9 of 9 (434 Views)

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

Version 9.20.021

 

And attachment.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.