12-16-2009 06:52 AM
Hi Everyone, We are running LMS 3.2 in a solaris environment. When attempting to create pollers in HUM we recieve an error message stating "Unable to update the database, Check the upm_process.log for more details. To try to correct the problem we reset the HUM database by executing the following "NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=upm dmprefix=UPM" Once resetting the DB we still experience the same error. We checked the upm_process.log file and found the following errors related to columns in the database that can not be null. We are unsure of the next steps to take to correct the problem. Has anyone ever experienced the errors below when trying to create HUM pollers ? Thanks for the help - John
[ Dec 16 08:24:40 EST 2009 ],ERROR,[Thread-245],com.cisco.nm.upm.pollermgmt.PollerMgmtServerUtil,addPoller,990,[Sybase][ODBC Driver][SQL Anywhere]Column 'Instance_Name' in table 'Poll_Units_Table' cannot be NULL Error code -195java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Column 'Instance_Name' in table 'Poll_Units_Table' cannot be NULL
[ Dec 16 08:24:40 EST 2009 ],ERROR,[Thread-245],com.cisco.nm.upm.pollermgmt.PollerMgmtServerUtil,addPoller,992,Rolling back the changes
[ Dec 16 08:25:49 EST 2009 ],ERROR,[TP-Processor16],com.cisco.nm.upm.pollermgmt.uii.helper.PollerMgmtUtil,addPoller,1312,Exception in adding poller:POLLERMGMT_ERR_DBUPDATEUnable to update the database. Check the upm_process.log for more details.
at com.cisco.nm.upm.pollermgmt.PollerMgmtServerUtil.addPoller(PollerMgmtServerUtil.java:997)
at com.cisco.nm.upm.pollermgmt.UPMPollerManagerSvc.addPoller(UPMPollerManagerSvc.java:113)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.cisco.nm.xms.ctm.common.CTMRequestProcessor.executeCall(CTMRequestProcessor.java:546)
at com.cisco.nm.xms.ctm.common.CTMRequestProcessor.handleRequest(CTMRequestProcessor.java:240)
at com.cisco.nm.xms.ctm.server.CTMServer.execute(CTMServer.java:401)
at com.cisco.nm.xms.ctm.server.TCPChannel.executeTask(TCPChannel.java:87)
at com.cisco.nm.xms.ctm.server.ThreadPool.run(ThreadPool.java:72)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Column 'Instance_Name' in table 'Poll_Units_Table' cannot be NULL
at ianywhere.ml.jdbcodbc.IIPreparedStatement.internalExecuteBatch(Native Method)
at ianywhere.ml.jdbcodbc.IPreparedStatement.executeBatch(IPreparedStatement.java:319)
at com.cisco.nm.upm.pollermgmt.PollerMgmtServerUtil.addPoller(PollerMgmtServerUtil.java:939)
... 11 more
12-16-2009 09:21 AM
It could be that you have a bad HUM installation. Exactly how are you creating these pollers? What templates are you using?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide