Baffling Exception Error

[chrismadog]

Hi everyone,
I have a baffling exception error on one of the servers.
I've looked at the tables and cannot find 'bs1770' anywhere.

23 Mar 2023 19:10:19
Column 'bs1770' does not belong to table Table.   at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at rdjInterface.Tracks.LoadTrackInfo(Int32 trackID, Boolean OnlyEnabled, Boolean RefreshInfo)
   at rdjInterface.Playlist.LoadPlaylist(Int32 playlistID, Boolean OnlyEnabled)
   at }t=iW(w}K!\\8Z:I@HX=@4_~w$.‍‭‬‭‬‭​‌‌‌‍‫‮‌​‍‎‏‫‫​‮‮(Object , EventArgs )
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Windows.Forms.Form.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.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)


Any ideas or suggestions ?

Regards
Chris M

[Kiwi]

Are you upgrading to a new version of RadioDJ? This may help you. It's the same issue answered by Marius...

https://www.radiodj.ro/community/index.php?topic=16374.0

Also to upgrade to 2.0.3.9 you have to update the database. Here are a couple of videos that may help if you are updating...

https://www.youtube.com/watch?v=200X8jYktHo&t=5s

and

https://www.youtube.com/watch?v=oAFXuBM1q8c&t=376s

Hope this is of use to you and solves your issues.

[chrismadog]

Also to upgrade to 2.0.3.9 you have to update the database. Here are a couple of videos that may help if you are updating...

https://www.youtube.com/watch?v=200X8jYktHo&t=5s

and

https://www.youtube.com/watch?v=oAFXuBM1q8c&t=376s

Hope this is of use to you and solves your issues.

Hi Kiwi,

Well, the tables are not utf8_general_ci but something else - utf8mb3_bin.
And, trying to change them won't work as that value isn't one of the options.
So now, I am stuck with nowhere to go. !!

Any suggestions welcome.

ChrisM

But interestingly, all copies of the events_catagories table were wit to a swedish option. Every one.

[Kiwi]

Not sure I can help but here is a link to previous forum information from Marius concerning "utf8"....

https://www.radiodj.ro/community/index.php?topic=15858.msg87457#msg87457

What is your setup and version of RadioDJ?

There appears to be a concensus on the forum that MariaDB works best with RadioDJ. Depending on your Windows version you may have to find a suitable MariaDB version. e.g. Windows 10 with MariaDB 10.6

Maybe a fresh install of MariaDB? or RadioDJ? or both?

Remember to do a Database Backup...

Hope you get things resolved.

[Marius]

Basically you have an incomplete database Did you updated and missed updating your database?

Please run this query on your database and it should fix that error:

Code Select Expand

ALTER TABLE `songs` ADD COLUMN `bs1770` DOUBLE(11,2) NOT NULL DEFAULT '0.00' AFTER `loudness`;

[chrismadog]

Basically you have an incomplete database Did you updated and missed updating your database?

Hi Marius,
I updated the database and left you a suggestion when it happened so fast that there wasn't any indication anything happened. I suggested some way to indicate something had in fact happened.
But I did update, or at least I tried to - more than once.

Please run this query on your database and it should fix that error:

Code Select Expand

ALTER TABLE `songs` ADD COLUMN `bs1770` DOUBLE(11,2) NOT NULL DEFAULT '0.00' AFTER `loudness`;

Did that and it inserted the column in the 'songs' table. Yay!

I am running Win10 with a new install of MariaDB.
I am trying to run v2.0.3.9 but cannot get past v2.0.1.5 without "Cannot find table Table" or "Cannot find Table 0" errors.

I can say with certainty that have "Applications can have exclusive use" in the audio settings, definitely leads to problems. Can this be unset in the installation script ?

Thanks for the fantastic program Marius and we are looking forward to the commercial program.

Kind regards,
Chris M

[chrismadog]

Hi folks,

Well, there were a couple of issues and resoilving them fixed everything. Yep. Everything - almost. LOL

The version of MariaDB was one issue - I was using v11.0.1 - that just simply doesn't work well.
I removed that and installed MariaDB v10.5 and it works. Yay !
Thanks Derek - that was the breakthrough. Awesome !

Then I remembered reading about the update file - about changing the version on the second line. So, I did that and changed it to the appropriate database entry and Yay ! Another win - it updated !

So it is working on two of the three servers - yes, I have a plan B and a plan C !
The third server still just stops and it is the primary server so I am running on the second one currently.

I've flushed all rotations, gone through all events, checked everything. It just randomly stops. Baffling !
It might go for a day, then it may stop three or four times in one day.
Clicking on 'Play' starts it up again.
AutoDJ and Automatic is on, tons of tracks available.

Any suggestions ?

Regards,
Chris M

[Kiwi]

Have you tried a "Repair Database" in the Database Setup Utility? C:\RadioDJv2\Database Setup.exe\Database Utils

May help....

[Derek]

So it is working on two of the three servers - yes, I have a plan B and a plan C !
The third server still just stops and it is the primary server so I am running on the second one currently.
Any suggestions ?

Hi Chris, servers as such are not my area unfortunately but just to throw a couple of thoughts out there, just in case they help... is the problem one accessing the files from an internal drive or an external one?
Sometimes accessing external drives can cause a problem with latency or connection etc.

Also, if the problem server is the main one, if the others are all accessing that one, perhaps it's causing a slight delay resulting in play stopping? Anything in the error logs for that one?

Finally, how about having a plan D which is to scrap plan C, meaning that plan A & B are working fine? 
Sorry, couldn't resist that one! Seriously though, I hope that someone can help you better with this one.

[chrismadog]

Have you tried a "Repair Database" in the Database Setup Utility? C:\RadioDJv2\Database Setup.exe\Database Utils

May help....

Hi Kiwi,
Yep. Done that and no problems found.
Thanks for trying though.

Happy Easter !

Chris M

[chrismadog]

Hi Chris, servers as such are not my area unfortunately but just to throw a couple of thoughts out there, just in case they help... is the problem one accessing the files from an internal drive or an external one?
Sometimes accessing external drives can cause a problem with latency or connection etc.

All drives are internal, one SSD boot drive and one big drive for tracks.
I avoid accessing external drives except through batch files called by RadioDJ - the batch files have "IF EXIST ..." statements in them to eliminate connection problems. And no, the two events don't co-incide with them.

Also, if the problem server is the main one, if the others are all accessing that one, perhaps it's causing a slight delay resulting in play stopping? Anything in the error logs for that one?

Each server is standalone so if one fails, I can switch over to another one without repercussions.

Finally, how about having a plan D which is to scrap plan C, meaning that plan A & B are working fine? 
Sorry, couldn't resist that one! Seriously though, I hope that someone can help you better with this one.

LOL. The main server is a HP DL320 G6 with 24GB RAM and a xenon 2.13GHz CPU.
Running Windows 10. Oodles of HDD space (with a 500GB SSD Boot drive). All SMART statuses are healthy.

Thanks for your help Derek.

Update on this - I turned off Events and ran it just with music on rotation and it stopped at 4:16 this arvo. It had a stack of tracks to play (about 40) in the playlist and just stopped.
At TOTH (Top Of The Hour) the next News event has a Play! command and with events turned back on, it started up again, played the News and promptly stopped again at News end.
Clicking on Play and away it went again. Until next time

Cheers and have an excellent Easter.

Chris M



No speed demon but reliability is unquestioned.

[Kiwi]

Maybe this post may help... couple of issues that seemed to resolve a similar issue to yours...

https://www.radiodj.ro/community/index.php?topic=14216.0

Also have you checked the Windows Log files for error messages?

May also pay to check your disabled tracks and tracks not found in Tracks Manager.

A couple of thoughts...

[chrismadog]

Maybe this post may help... couple of issues that seemed to resolve a similar issue to yours...

https://www.radiodj.ro/community/index.php?topic=14216.0

Also have you checked the Windows Log files for error messages?

May also pay to check your disabled tracks and tracks not found in Tracks Manager.

A couple of thoughts...

Thanks,

I checked the database and ran Repair over it anyway. No problems found and no difference.

I am living in the Windows Events Logs and nothing comes up when the problem occurs.

That is probably the worst of it - no clues.
It either stops with plenty of tracks in the playlist or, it stops and the rotation isn't loading and I cannot get =any= rotation to work.
Either way, no playout.

Chris M

[Kiwi]

Maybe it is a Rotation issue. I know there were documented forum issues about this after the latests updates. This video may provide insight...

https://www.youtube.com/watch?v=VbBY-kiYPJA

[Dr_Anthony]

Hi,

just upgrade to RDJ to 2.0.4.3 and SQL DB to 2.0.3.8. SQL server runs, see the songs in RDJ search plugin but if click on any song, will get this error (and songs will not play).

5 Oct 2023 10:58:04
Column bs1770 does not belong in the Table. v System.Data.DataRow.GetDataColumn(String columnName)
   v System.Data.DataRow.get_Item(String columnName)
   v rdjInterface.Tracks.LoadTrackInfo(Int32 trackID, Boolean OnlyEnabled, Boolean RefreshInfo)
   v rdjInterface.TrackPlayer.LoadInfo(Int32 trackID, Boolean OnlyEnabled, Boolean RefreshInfo)
   v Plugin_Search.SearchControl.TlStripEditCue_Click(Object sender, EventArgs e)
   v System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   v System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
   v System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   v System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   v System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   v System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   v System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   v System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
   v System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   v System.Windows.Forms.Control.WndProc(Message& m)
   v System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   v System.Windows.Forms.ToolStrip.WndProc(Message& m)
   v System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
   v System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   v System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   v System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)