Delete of Instance Fails

The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog


Home	No Ads ever, except search!

Thursday, April 25, 2024

Recent Posts

Delete of Instance Fails

4/4/2008 10:50:48 AM

Trying to delete a SQL Instance from polyserve, 3.6 fails with an internal error.

Detail description is:

java.lang.IllegalArgumentException: No value found for sqldataroot
at com.polyserve.mssql.common.domain.SpackDAO.getParamaterValue(SpackDAO.java:142)
at com.polyserve.mssql.common.tasks.TaskFactory.removeService(TaskFactory.java:483)
at com.polyserve.mssql.common.gui.SpackServicePM.doDelete(SpackServicePM.java:320)
at com.polyserve.mssql.common.gui.SpackServiceEditor.showDeleteProgress(SpackServiceEditor.java:98)
at com.polyserve.gui.controller.MonitorController$DeleteMonitorAction.actionPerformed(MonitorController.java:110)
at com.polyserve.mssql.common.gui.SpackServiceController$DeleteAction.actionPerformed(SpackServiceController.java:139)
at com.polyserve.gui.controller.AbstractController$ProxyVisualAction.actionPerformed(AbstractController.java:198)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1216)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1257)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

Solution provided by technincal support below (it worked)...

No value found for sqldataroot (3.4 upgrade to 3.6)

This error indicates that monitor_agent is still using 3.4 parameters, and therefore needs to be updated using one or both of these methods:

Update the probe parameter by right-clicking on the instance, selecting properties, modify the probe timeout by 1 and hit OK.

Kill monitor_agent by opening task manager, selecting the processes tab, find monitor_agent.exe and kill the process. It will automatically restart.

--------------------------------------------------------------------------

From: Mokhtari, Mostafa [mailto:Mostafa.Mokhtari@hp.com]
Sent: Friday, April 04, 2008 11:29 AM
To: Horkay, Robert
Subject: RE: #3601519915

You would want to do this on any instance that's having the problem. If changing the instance properties doesn't update the monitor and you decide to kill monitor agent, then killing monitor agent would only need to be performed once per node.

Regards,

Mostafa Mokhtari

HEWLETT-PACKARD COMPANY

High Availability Team

(719) 592-6700 ext. 65209

Monday-Friday 8-4pm PST

From: Horkay, Robert [mailto:RHorkay@....com]
Sent: Friday, April 04, 2008 9:19 AM
To: Horkay, Robert; Mokhtari, Mostafa
Subject: RE: #3601519915

Ok,

That worked !

Do we need to do this for every instance ? or would it happen automatically as a box was restarted (as that would cause the monitor_agent to restart)....as we have yet to reboot every box after the 3.6 upgrade...

bob

From: Horkay, Robert
Sent: Friday, April 04, 2008 11:13 AM
To: 'Mokhtari, Mostafa'
Subject: RE: #3601519915

Yes that is correct.

I will try that.

On a side note, no where in the documentaiton on 3.4 to 3.6 upgrade did it mention doing this...?

let me see if it works...

bob

From: Mokhtari, Mostafa [mailto:Mostafa.Mokhtari@hp.com]
Sent: Friday, April 04, 2008 11:11 AM
To: Horkay, Robert
Subject: RE: #3601519915

Was this an upgrade from 3.4? If so,

No value found for sqldataroot (3.4 upgrade to 3.6)

This error indicates that monitor_agent is still using 3.4 parameters, and therefore needs to be updated using one or both of these methods:

Update the probe parameter by right-clicking on the instance, selecting properties, modify the probe timeout by 1 and hit OK.
Kill monitor_agent by opening task manager, selecting the processes tab, find monitor_agent.exe and kill the process. It will automatically restart.

Regards,

Mostafa Mokhtari

HEWLETT-PACKARD COMPANY

High Availability Team

(719) 592-6700 ext. 65209

Monday-Friday 8-4pm PST

_____________________________________________
From: Mokhtari, Mostafa
Sent: Friday, April 04, 2008 8:57 AM
To: 'Horkay, Robert'
Subject: #3601519915

Hi Robert,

I just picked up your case. Is this x64 OS or x86? What is the version of your SQL?

Thanks,

Mostafa Mokhtari

HEWLETT-PACKARD COMPANY

High Availability Team

(719) 592-6700 ext. 65209

Monday-Friday 8-4pm PST

Blog Home