Upgrade to 9.0 fails to start BIDBUILD server service

[mtucker]

Logged Monday, June 22, 2009

Problem:

Some users are having an issue with BidBuildServer not starting during/after upgrade to 9.0.

Cause:

Seems there is an issue where the status column of BidMaster's Jobs table has a null value for a job.

example log:
2009-06-22 14:13:09.312 []: Launching BID*BUILD Server 9.0 (User=SYSTEM)
2009-06-22 14:13:45.875 []: Upgrading job 'BidMaster' from 'Version 2008.2' to 'Version 2009.0'
2009-06-22 14:13:48.765 []: System.NullReferenceException: Object reference not set to an instance of an object.
   at HardDollar.JobServices.JobStatusFactory.UpgradeData(Job job, String originalVersionNumber, Boolean isInternalRelease, DataTable table)
   at HardDollar.JobServices.BusinessObjectFactory.InternalUpgradeData(Job job, String originalVersionNumber, DataTable table)
   at HardDollar.JobServices.BusinessObjectFactory.UpgradeData(Job job, DataSet ds, String originalVersionNumber)
   at HardDollar.JobServices.BusinessObjectManager.UpgradeData(Guid jobUid, Guid progressRecipientUid)
2009-06-22 14:13:48.781 []: UpgradeData transaction in Job 'BidMaster' has been rolled back.
2009-06-22 14:13:48.906 []: System.NullReferenceException: Object reference not set to an instance of an object.
   at HardDollar.JobServices.BusinessObjectManager.UpgradeData(Guid jobUid, Guid progressRecipientUid)
   at HardDollar.JobServices.UpgradeManager.ProcessRequest(IRequest request, IRequest& response, Object& result)
   at HardDollar.NetworkServices.Common.BaseRequestConsumer.ProcessRequestInternal(IRequest request)
2009-06-22 14:13:49.906 []: System.NullReferenceException: Object reference not set to an instance of an object.
   at HardDollar.JobServices.BusinessObjectRequestManager.RequestUpgradeJob(Job job)
   at HardDollar.JobServices.Job.Load(Boolean fireJobReadyGUI, Boolean checkIfAuthorized, Boolean loadStoredDataNotLiveJob)
   at HardDollar.JobServices.BidMaster.Initialize()
   at HardDollar.AppInitializationServices.ApplicationInitializer.Initialize(Form mainDialog)
   at HardDollar.NetworkServices.BidBuild.Server.Service.GUI.MainForm.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
2009-06-22 14:13:49.921 []: BID*BUILD Server forcefully terminated

Solution:

To fix have client send in the BidMaster and Hard Dollar will manually add "Bidding" to the status field. Then BidMaster will be sent back to the client.

Check:
USE BidMaster Select * from Jobs where status is NULL

Run:
USE BidMaster update jobs set Status = 'Bidding' where status is null