Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

Creating HUM Pollers failing

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

1 REPLY
Cisco Employee

Re: Creating HUM Pollers failing

It could be that you have a bad HUM installation.  Exactly how are you creating these pollers?  What templates are you using?

221
Views
0
Helpful
1
Replies
CreatePlease to create content