A known issue exists in Channel Box 1.x whereby a user can save a scene using an Alpha/Numeric value.  However, this version of software does not support recall of these scenes.  Once a scene is saved in a non-numeric fashion Channel Box views the database as corrupt and will not populate the playout screen with any scenes. We are rectifying this issue in Channel Box 2.0, however until all our clients are upgraded to that software you will need to rename the scene so that Channel Box can function normally.  The solution lies in removing the ‘incorrect’ record from the database and replacing it with a proper, numeric only ID.

Type the following into the Windows Command Line utility (Start>Run>cmd) or edit and run the attached DatabaseRepair.bat file:

osql -U sa -H local -d Akron -P -Q "UPDATE UserDefinedID_GenericElement SET UserDefinedID = '<GoodID>' WHERE UserDefinedID = '<BadID>'"

Replace <BadID> with the problematic ID name and replace <GoodID> with the desired scene ID

For example, to change an incorrect ID named 'DVE12000' to a numeric only ID of '12000', use the following script:

osql -U sa -H local -d Akron -P -Q "UPDATE UserDefinedID_GenericElement SET UserDefinedID = '12000' WHERE UserDefinedID = 'DVE12000'"

Successful completion of the command will give you a response of (1 row affected).