Database Error

[matthrolf]

I am getting the following error in the recording service log and I cannot view my recordings, and it says I have none scheduled on the initial screen.

5/10/2006 7:07:57 PM.546 VERBOSE [47] getDatabaseConnection() creating new connection
5/10/2006 7:07:57 PM.593 VERBOSE [47] getValue() loading new key/value into cache: /settings/CheckForRenamedRecordings
5/10/2006 7:07:57 PM.593 VERBOSE [47] getValue: /settings/CheckForRenamedRecordings : true
5/10/2006 7:07:57 PM.609 ERROR [47] Caught unexpected exception: Specified cast is not valid.
5/10/2006 7:07:57 PM.671 ERROR [47] at System.Data.OleDb.DBBindings.get_ValueInt32()
at System.Data.OleDb.OleDbDataReader.GetInt32(Int32 ordinal)
at xd426863f4d052758.x396614b3dae3b1da.x0af9be4f94e00bbd(OleDbDataReader x1771d75e5d3bb5a9)
at xd426863f4d052758.x396614b3dae3b1da.x005239145b965dc1()
at GBPVR.RecordingService.RecordingManager.WorkerThread()
5/10/2006 7:07:57 PM.875 VERBOSE [47] RecordingFactory.loadSchedule()
5/10/2006 7:07:57 PM.875 VERBOSE [47] getValue cached value: /settings/AutoRemoveMissingRecordings : true
5/10/2006 7:07:57 PM.890 VERBOSE [47] getDatabaseConnection() creating new connection
5/10/2006 7:07:57 PM.968 VERBOSE [47] getValue cached value: /settings/CheckForRenamedRecordings : true
5/10/2006 7:07:57 PM.968 ERROR [47] Caught unexpected exception: Specified cast is not valid.
5/10/2006 7:07:57 PM.968 ERROR [47] at System.Data.OleDb.DBBindings.get_ValueInt32()
at System.Data.OleDb.OleDbDataReader.GetInt32(Int32 ordinal)
at xd426863f4d052758.x396614b3dae3b1da.x0af9be4f94e00bbd(OleDbDataReader x1771d75e5d3bb5a9)
at xd426863f4d052758.x396614b3dae3b1da.x005239145b965dc1()
at GBPVR.RecordingService.RecordingManager.WorkerThread()

[matthrolf]

I figured it out... had a null in the recording_group field on some records (got that when I recreated my database after it purged the records when I moved the files to a new volume and forgot to stop the service in the interim.)

Thanks,

Matt

[matthrolf]

5/10/2006 9:25:59 PM.609 VERBOSE [2] controller.OnClick()
5/10/2006 9:25:59 PM.656 VERBOSE [2] loadRecordings():1
5/10/2006 9:25:59 PM.656 VERBOSE [2] RecordingFactory.loadSchedule()
5/10/2006 9:25:59 PM.656 VERBOSE [2] getValue cached value: /settings/AutoRemoveMissingRecordings : false
5/10/2006 9:26:00 PM.375 ERROR [2] Error: msg=0x202 (WM_LBUTTONUP) hwnd=0x20206 wparam=0x0 lparam=0x890077 result=0x0 : System.InvalidCastException: Specified cast is not valid.
at System.Data.OleDb.DBBindings.get_ValueString()
at System.Data.OleDb.OleDbDataReader.GetString(Int32 ordinal)
at xd426863f4d052758.x396614b3dae3b1da.xf91efda6b7a5b9da()
at xae10db17d26ba033.x3222298a0181dd43.x2e7888c24499ad1b(Boolean xdf600583127b6822)
at xae10db17d26ba033.x3222298a0181dd43.render(Boolean& xbae0ec4fbb835d1e)
at xae10db17d26ba033.x86396f56243de9fb.render(Boolean& xbae0ec4fbb835d1e)
at xae10db17d26ba033.xbb1566157f5f8b1f.xf1b04f0b61b2ba29(Object xdf2e3583f942db7b, EventArgs xc4f45905cb1fc7ba)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
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.WndProc(Message& m)
at xae10db17d26ba033.xbb1566157f5f8b1f.WndProc(Message& x5f8f2c40c000ab2c)
5/10/2006 9:26:01 PM.984 VERBOSE [2] controller.OnMouseDown()
5/10/2006 9:26:02 PM.046 VERBOSE [2] controller.OnClick()
5/10/2006 9:26:18 PM.921 VERBOSE [2] HideMouse ref=-1
5/10/2006 9:26:44 PM.921 VERBOSE [2] MDB updated, forcing refresh of next recording panel
5/10/2006 9:26:44 PM.921 VERBOSE [2] Loading recording list for next recording panel
5/10/2006 9:26:44 PM.921 VERBOSE [2] RecordingFactory.loadSchedule()
5/10/2006 9:26:44 PM.921 VERBOSE [2] getValue cached value: /settings/AutoRemoveMissingRecordings : false
5/10/2006 9:26:44 PM.953 VERBOSE [2] getDatabaseConnection() creating new connection
5/10/2006 9:28:01 PM.312 VERBOSE [2] flushDatabaseConnections()
5/10/2006 9:28:01 PM.359 VERBOSE [2] Activating screen saver
5/10/2006 9:28:01 PM.359 VERBOSE [2] flushDatabaseConnections()


I solved the problem with the recording service and showing pending recordings in the main screen.

Now I still get a message when going to recordings that Specified cast is not valid. I searched for nulls in the PROGAMME and RECORDING_SCHEDULE tables and cannot find any. When I use the web manage all comes up fine. Any ideas?

Thanks,

Matt

[matthrolf]

Please just delete this thread!!!

There were more records in the programme table that did not come accross correctly... My eyes just were tired and I saw it after stepping away from it for a while.

Thanks for humoring me,

Matt