topic SIM does not send e-Mails, since problems with SQL database in Server Management - Systems Insight Manager

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

blvidal — Thu, 18 Oct 2007 11:28:50 GMT

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.

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

Rob Buxton — Thu, 18 Oct 2007 14:11:03 GMT

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.

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

blvidal — Fri, 19 Oct 2007 03:27:55 GMT

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

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

Rob Buxton — Fri, 19 Oct 2007 19:20:15 GMT

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.

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

David Claypool — Fri, 19 Oct 2007 19:45:29 GMT

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.

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

Paz Pérez Coto — Mon, 22 Oct 2007 04:28:36 GMT

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.

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

blvidal — Tue, 23 Oct 2007 09:31:14 GMT

Thank you David.

As Paz answered, we have solved our problem.