Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

SIM does not send e-Mails, since problems with SQL database

SOLVED
Go to solution
blvidal
Occasional Visitor

SIM does not send e-Mails, since problems with SQL database

We have SIM 5.1 with SP1-Windows.
We had a problem with our SQL database, the log file was full. Our database was in suspect state. But we made free space, recovered the database and we could do a shrink.
But now, our SIM does not send e-mails with importat events althouth we have a task to do that.
But we do not know where we can find information about this problem, any log file?
any configuration file? any idea?

Thanks in advance.
6 REPLIES
Rob Buxton
Honored Contributor

Re: SIM does not send e-Mails, since problems with SQL database

I would try and create a new Event Handling task, say for all Major & Critical alerts to use e-mail and then use the HP Management Agents GUI to send traps.
You should see a generic Major Event - tests that the Event mechanism is working.
I'd recheck the SMTP settings, you can check if the hpsim server can reach the Exchange server by just using a cmd prompt and telnet using port 25. It should answer.
There are logs in the hpsim install directory.
blvidal
Occasional Visitor

Re: SIM does not send e-Mails, since problems with SQL database

We had done the test with a new task, it did not work.
We have other problems with the tasks, we can not delete them, when we try, a promt appears whith this message "unable to delete task".
When we try to see Task Results, we receive a "http Status 500" we have attached the error.
We have tested we can reach our mail server from the hpSIM server

In the logs directory, we have seen these errors :
",552 ERROR [BeanSerializer] Exception:
java.lang.IllegalArgumentException: The char '0x11' in 'æduà +öi¥å "à Z' is not a valid XML character."...
"818 ERROR [Engine] StandardWrapperValve[JBossAxisServlet]: Servlet.service() for servlet JBossAxisServlet threw exception"
"865 ERROR [CoyoteAdapter] ..."

But we have not any idea...

The log file is attached too.

Thanks in advance
Rob Buxton
Honored Contributor

Re: SIM does not send e-Mails, since problems with SQL database

I'm not an expert at that level of HPSIM, but at a guess there's a corruption in the database.
If you have any previous backups you might want to try restoring that and trying again.
David Claypool
Honored Contributor
Solution

Re: SIM does not send e-Mails, since problems with SQL database

On your HP SIM server, go to the %ProgramFiles%\HP\System~1\bin directory. Then run:

mxinitconfig -c

and HP SIM will do a check of the database. If it reports that there are errors in the database, go and stop the HP SIM service and run

mxinitconfig -f

...and then restart the service. Hopefully any errors in the database will be fixed and you'll be able to get going again.
Paz Pérez Coto
Occasional Visitor

Re: SIM does not send e-Mails, since problems with SQL database

The -c option is invalid for mxinitconfig command, instead of that we stop the HP SIM service and run mxinitconf -r to delete all the configuration and then mxinitconf -a to get a clean configuration. The command started the HP SIM service automatically and all the things began to go ok.
blvidal
Occasional Visitor

Re: SIM does not send e-Mails, since problems with SQL database

Thank you David.

As Paz answered, we have solved our problem.