Serious TV SERVER start failure. (1 Viewer)

[SciDoctor]

The act of uninstalling a working TV server and installing a newer SVN (going from 14162 to 14192) has given rise to a MS system error and the failure of the TV Server to start.

'Error. 1058. The service cannot be started, either because it is dissabled or no enabled devices are associated with it'

Reverting to any of the past SVN's (previously working) gives rise to the above error .

I have run a repair on the .NET 2.0 installed, rebooted etc


There are no TV Service logs as it fails to start.

OS w2ksp4, MS SQL2005
Nebula pci DVB-t card
Radeon spec gpu
512Mb ddr ram

On starting TvSetup the password passes test and is saved fine, the dialog box conmes up to start the service and then the error occurs.

Starting the TVServer from within the OS Services management and the above error occurs.

Any hints on what may be amiss, which files the TVServer instal may have corrupted or how to purge the SQL databsase if this is the cause of the errors

 

[The_Stig]

Can not confirm any bug with latest TVE3. PLease try to delete your DB (TVLibrary) after unstinstalling TVE3.

 

[SciDoctor]

Deleting te databse files makes no difference.

Starting TVSetup creates new files but then errors as the TVservice tries to start.

This occurs for any SVN now that previously worked OK.

20/04/2007 18:57:10 ---- start setuptv ----
20/04/2007 18:57:10 ---- check connection with database ----
20/04/2007 18:57:14 ---- check if database needs to be updated/created ----
20/04/2007 18:57:15 ---- update/create database ----
20/04/2007 18:57:19 sql:use master IF EXISTS (SELECT name FROM sysdatabases WHERE name = N'TvLibrary') DROP DATABASE TvLibrary
20/04/2007 18:57:22 sql:CREATE DATABASE TvLibrary
20/04/2007 18:57:23 sql:use TvLibrary
20/04/2007 18:57:23 sql:--- create table ---
20/04/2007 18:57:23 sql:CREATE TABLE Version( idVersion int IDENTITY(1,1) NOT NULL, versionNumber int NOT NULL, CONSTRAINT PK_Versi PRIMARY KEY ( idVersion ASC ) )
20/04/2007 18:57:23 sql:CREATE TABLE Server( idServer int IDENTITY(1,1) NOT NULL, isMaster bit NOT NULL, hostName varchar(256) NOT NULL, CONSTRAINT PK_Server PRIMARY KEY ( idServer ASC ) )
20/04/2007 18:57:23 sql:CREATE TABLE Channel( idChannel int IDENTITY(1,1) NOT NULL, name varchar(200) NOT NULL, isRadio bit NOT NULL, isTv bit NOT NULL, timesWatched int NOT NULL, totalTimeWatched datetime NOT NULL, grabEpg bit NOT NULL, lastGrabTime datetime NOT NULL, sortOrder int NOT NULL, visibleInGuide bit NOT NULL, externalId varchar(200) NOT NULL, freetoair bit NOT NULL, CONSTRAINT PK_Channels PRIMARY KEY ( idChannel ASC ) )
20/04/2007 18:57:23 sql:CREATE TABLE ChannelGroup( idGroup int IDENTITY(1,1) NOT NULL, groupName varchar(200) NOT NULL, CONSTRAINT PK_ChannelGroup PRIMARY KEY ( idGroup ASC ) )
20/04/2007 18:57:23 sql:CREATE TABLE Setting( idSetting int IDENTITY(1,1) NOT NULL, tag varchar(200) NOT NULL, value varchar(4096) NOT NULL, CONSTRAINT PK_Setting PRIMARY KEY ( idSetting ASC ) )
20/04/2007 18:57:23 sql:CREATE TABLE Favorite( idFavorite int IDENTITY(1,1) NOT NULL, idProgram int NOT NULL, priority int NOT NULL, timesWatched int NOT NULL, CONSTRAINT PK_Favorites PRIMARY KEY ( idFavorite ASC ) )
20/04/2007 18:57:23 sql:CREATE TABLE CanceledSchedule( idCanceledSchedule int IDENTITY(1,1) NOT NULL, idSchedule int NOT NULL, cancelDateTime datetime NOT NULL, CONSTRAINT PK_CanceledSchedule PRIMARY KEY ( idCanceledSchedule ASC ) )
20/04/2007 18:57:23 sql:CREATE TABLE Card( idCard int IDENTITY(1,1) NOT NULL, devicePath varchar(2000) NOT NULL, name varchar(200) NOT NULL, priority int NOT NULL, grabEPG bit NOT NULL, lastEpgGrab datetime NOT NULL, recordingFolder varchar(256) NOT NULL, idServer int NOT NULL, enabled bit NOT NULL, camType int NOT NULL, timeshiftingFolder varchar(256) NOT NULL, recordingFormat int NOT NULL, decryptLimit int NOT NULL, CONSTRAINT PK_Cards PRIMARY KEY ( idCard ASC ) )
20/04/2007 18:57:23 sql:CREATE TABLE Recording( idRecording int IDENTITY(1,1) NOT NULL, idChannel int NOT NULL, startTime datetime NOT NULL, endTime datetime NOT NULL, title varchar(200) NOT NULL, description varchar(4000) NOT NULL, genre varchar(200) NOT NULL, fileName varchar(1024) NOT NULL, keepUntil int NOT NULL, keepUntilDate datetime NOT NULL, timesWatched int NOT NULL, idServer int NOT NULL, stopTime int NOT NULL, CONSTRAINT PK_Recordings PRIMARY KEY ( idRecording ASC ) )
20/04/2007 18:57:24 sql:CREATE TABLE ChannelMap( idChannelMap int IDENTITY(1,1) NOT NULL, idChannel int NOT NULL, idCard int NOT NULL, CONSTRAINT PK_ChannelMap PRIMARY KEY ( idChannelMap ASC ) )
20/04/2007 18:57:24 sql:CREATE TABLE TuningDetail( idTuning int IDENTITY(1,1) NOT NULL, idChannel int NOT NULL, name varchar(200) NOT NULL, provider varchar(200) NOT NULL, channelType int NOT NULL, channelNumber int NOT NULL, frequency int NOT NULL, countryId int NOT NULL, isRadio bit NOT NULL, isTv bit NOT NULL, networkId int NOT NULL, transportId int NOT NULL, serviceId int NOT NULL, pmtPid int NOT NULL, freeToAir bit NOT NULL, modulation int NOT NULL, polarisation int NOT NULL, symbolrate int NOT NULL, diseqc int NOT NULL, switchingFrequency int NOT NULL, bandwidth int NOT NULL, majorChannel int NOT NULL, minorChannel int NOT NULL, pcrPid int NOT NULL, videoSource int NOT NULL, tuningSource int NOT NULL, videoPid int NOT NULL, audioPid int NOT NULL, band int NOT NULL, satIndex int NOT NULL, innerFecRate int NOT NULL, CONSTRAINT PK_TuningDetail PRIMARY KEY ( idTuning ASC ) )
20/04/2007 18:57:24 sql:CREATE TABLE GroupMap( idMap int IDENTITY(1,1) NOT NULL, idGroup int NOT NULL, idChannel int NOT NULL, SortOrder int NOT NULL, CONSTRAINT PK_GroupMap PRIMARY KEY ( idMap ASC ) )
20/04/2007 18:57:24 sql:CREATE TABLE Program( idProgram int IDENTITY(1,1) NOT NULL, idChannel int NOT NULL, startTime datetime NOT NULL, endTime datetime NOT NULL, title varchar(2000) NOT NULL, description varchar(4000) NOT NULL, seriesNum varchar(200) NOT NULL, episodeNum varchar(200) NOT NULL, genre varchar(200) NOT NULL, originalAirDate datetime NOT NULL, classification varchar(200) NOT NULL, starRating int NOT NULL, notify bit NOT NULL, CONSTRAINT PK_Programs PRIMARY KEY ( idProgram ASC ) )
20/04/2007 18:57:24 sql:CREATE TABLE Schedule( id_Schedule int IDENTITY(1,1) NOT NULL, idChannel int NOT NULL, scheduleType int NOT NULL, programName varchar(256) NOT NULL, startTime datetime NOT NULL, endTime datetime NOT NULL, maxAirings int NOT NULL, priority int NOT NULL, directory varchar(1024) NOT NULL, quality int NOT NULL, keepMethod int NOT NULL, keepDate datetime NOT NULL, preRecordInterval int NOT NULL, postRecordInterval int NOT NULL, canceled datetime NOT NULL, recommendedCard int NOT NULL, CONSTRAINT PK_Schedule PRIMARY KEY ( id_Schedule ASC ) ) CREATE TABLE TvMovieMapping( idMapping int IDENTITY(1,1) NOT NULL, idChannel int NOT NULL, stationName varchar(200) NOT NULL, timeSharingStart varchar(200) NOT NULL, timeSharingEnd varchar(200) NOT NULL, CONSTRAINT PK_TvMovieMapping PRIMARY KEY ( idMapping ASC ) )
20/04/2007 18:57:24 sql:CREATE TABLE History( idHistory int IDENTITY(1,1) NOT NULL, idChannel int NOT NULL, startTime datetime NOT NULL, endTime datetime NOT NULL, title varchar(1000) NOT NULL, description varchar(1000) NOT NULL, genre varchar(1000) NOT NULL, recorded bit NOT NULL, watched int NOT NULL, CONSTRAINT PK_History PRIMARY KEY ( idHistory ASC ) )
20/04/2007 18:57:24 sql:ALTER TABLE History WITH CHECK ADD CONSTRAINT FK_History_Channel FOREIGN KEY(idChannel) REFERENCES Channel (idChannel)
20/04/2007 18:57:24 sql:ALTER TABLE Favorite WITH CHECK ADD CONSTRAINT FK_Favorites_Programs FOREIGN KEY(idProgram) REFERENCES Program (idProgram)
20/04/2007 18:57:24 sql:ALTER TABLE Favorite CHECK CONSTRAINT FK_Favorites_Programs
20/04/2007 18:57:24 sql:ALTER TABLE CanceledSchedule WITH CHECK ADD CONSTRAINT FK_CanceledSchedule_Schedule FOREIGN KEY(idSchedule) REFERENCES Schedule (id_Schedule)
20/04/2007 18:57:24 sql:ALTER TABLE CanceledSchedule CHECK CONSTRAINT FK_CanceledSchedule_Schedule
20/04/2007 18:57:24 sql:ALTER TABLE Card WITH CHECK ADD CONSTRAINT FK_Card_Server FOREIGN KEY(idServer) REFERENCES Server (idServer)
20/04/2007 18:57:24 sql:ALTER TABLE Card CHECK CONSTRAINT FK_Card_Server
20/04/2007 18:57:24 sql:ALTER TABLE Recording WITH CHECK ADD CONSTRAINT FK_Recording_Server FOREIGN KEY(idServer) REFERENCES Server (idServer)
20/04/2007 18:57:24 sql:ALTER TABLE Recording CHECK CONSTRAINT FK_Recording_Server
20/04/2007 18:57:24 sql:ALTER TABLE Recording WITH CHECK ADD CONSTRAINT FK_Recordings_Channels FOREIGN KEY(idChannel) REFERENCES Channel (idChannel)
20/04/2007 18:57:24 sql:ALTER TABLE Recording CHECK CONSTRAINT FK_Recordings_Channels
20/04/2007 18:57:24 sql:ALTER TABLE ChannelMap WITH CHECK ADD CONSTRAINT FK_ChannelMap_Cards FOREIGN KEY(idCard) REFERENCES Card (idCard)
20/04/2007 18:57:24 sql:ALTER TABLE ChannelMap CHECK CONSTRAINT FK_ChannelMap_Cards
20/04/2007 18:57:24 sql:ALTER TABLE ChannelMap WITH CHECK ADD CONSTRAINT FK_ChannelMap_Channels FOREIGN KEY(idChannel) REFERENCES Channel (idChannel)
20/04/2007 18:57:24 sql:ALTER TABLE ChannelMap CHECK CONSTRAINT FK_ChannelMap_Channels
20/04/2007 18:57:24 sql:ALTER TABLE TuningDetail WITH CHECK ADD CONSTRAINT FK_TuningDetail_Channel FOREIGN KEY(idChannel) REFERENCES Channel (idChannel)
20/04/2007 18:57:24 sql:ALTER TABLE TuningDetail CHECK CONSTRAINT FK_TuningDetail_Channel
20/04/2007 18:57:24 sql:ALTER TABLE GroupMap WITH CHECK ADD CONSTRAINT FK_GroupMap_Channel FOREIGN KEY(idChannel) REFERENCES Channel (idChannel)
20/04/2007 18:57:24 sql:ALTER TABLE GroupMap CHECK CONSTRAINT FK_GroupMap_Channel
20/04/2007 18:57:24 sql:ALTER TABLE GroupMap WITH CHECK ADD CONSTRAINT FK_GroupMap_ChannelGroup FOREIGN KEY(idGroup) REFERENCES ChannelGroup (idGroup)
20/04/2007 18:57:24 sql:ALTER TABLE GroupMap CHECK CONSTRAINT FK_GroupMap_ChannelGroup
20/04/2007 18:57:24 sql:ALTER TABLE Program WITH CHECK ADD CONSTRAINT FK_Programs_Channels FOREIGN KEY(idChannel) REFERENCES Channel (idChannel)
20/04/2007 18:57:24 sql:ALTER TABLE Program CHECK CONSTRAINT FK_Programs_Channels
20/04/2007 18:57:24 sql:ALTER TABLE Schedule WITH CHECK ADD CONSTRAINT FK_Schedule_Channel FOREIGN KEY(idChannel) REFERENCES Channel (idChannel)
20/04/2007 18:57:24 sql:ALTER TABLE Schedule CHECK CONSTRAINT FK_Schedule_Channel
20/04/2007 18:57:24 sql:ALTER TABLE TvMovieMapping WITH CHECK ADD CONSTRAINT FK_TvMovieMapping_Channel FOREIGN KEY(idChannel) REFERENCES Channel (idChannel)
20/04/2007 18:57:24 sql:ALTER TABLE TvMovieMapping CHECK CONSTRAINT FK_TvMovieMapping_Channel
20/04/2007 18:57:24 sql:---- create indexes -----
20/04/2007 18:57:24 sql:CREATE STATISTICS _dta_stat_645577338_4_3 ON Program(endTime, startTime)
20/04/2007 18:57:24 sql:CREATE STATISTICS _dta_stat_645577338_2_3 ON Program(idChannel, startTime)
20/04/2007 18:57:24 sql:CREATE INDEX _dta_index_Program_7_645577338__K3_1_2_4_5_6_7_8 ON Program ( startTime ASC ) INCLUDE ( idProgram, idChannel, endTime, title, description, genre, notify)
20/04/2007 18:57:24 sql:CREATE STATISTICS _dta_stat_565577053_9 ON Channel(sortOrder)
20/04/2007 18:57:24 sql:CREATE INDEX _dta_index_Channel_7_565577053__K4_K9_1_2_3_5_6_7_8_10 ON Channel ( isTv ASC, sortOrder ASC ) INCLUDE ( idChannel, name, isRadio, timesWatched, totalTimeWatched, grabEpg, lastGrabTime, visibleInGuide)
20/04/2007 18:57:24 sql:CREATE INDEX _dta_index_Program_7_645577338__K2_1_3_4_5_6_7_8 ON Program ( idChannel ASC ) INCLUDE ( idProgram, startTime, endTime, title, description, genre, notify)
20/04/2007 18:57:24 sql:CREATE STATISTICS _dta_stat_645577338_4_2_3 ON Program(endTime, idChannel, startTime)
20/04/2007 18:57:24 sql:CREATE INDEX _dta_index_Program_7_645577338__K2_K3_K4_1_5_6_7_8 ON Program ( idChannel ASC, startTime ASC, endTime ASC ) INCLUDE ( idProgram, title, description, genre, notify)
20/04/2007 18:57:24 sql:CREATE INDEX _dta_index_TuningDetail_7_709577566__K2_1_3_4_5_6_7_8_9_10_11_12_13_14_15_16_17_18_19_20_21_22_23_24_25_26 ON TuningDetail ( idChannel ASC ) INCLUDE ( idTuning, name, provider, channelType, channelNumber, frequency, countryId, isRadio, isTv, networkId, transportId, serviceId, pmtPid, freeToAir, modulation, polarisation, symbolrate, diseqc, switchingFrequency, bandwidth, majorChannel, minorChannel, pcrPid, videoSource, tuningSource)
20/04/2007 18:57:24 sql:--- version 12 ----
20/04/2007 18:57:24 sql:CREATE TABLE Conflict( idConflict int IDENTITY(1,1) NOT NULL, idSchedule int NOT NULL, idConflictingSchedule int NOT NULL, idChannel int NOT NULL, conflictDate datetime NOT NULL, idCard int NULL, CONSTRAINT PK_Conflict PRIMARY KEY ( idConflict ASC ) )
20/04/2007 18:57:24 sql:ALTER TABLE Conflict WITH CHECK ADD CONSTRAINT FK_Conflict_Channel FOREIGN KEY(idChannel) REFERENCES Channel (idChannel)
20/04/2007 18:57:24 sql:ALTER TABLE Conflict CHECK CONSTRAINT FK_Conflict_Channel
20/04/2007 18:57:24 sql:ALTER TABLE Conflict WITH CHECK ADD CONSTRAINT FK_Conflict_Schedule FOREIGN KEY(idSchedule) REFERENCES Schedule (id_Schedule)
20/04/2007 18:57:24 sql:ALTER TABLE Conflict CHECK CONSTRAINT FK_Conflict_Schedule
20/04/2007 18:57:24 sql:ALTER TABLE Conflict WITH CHECK ADD CONSTRAINT FK_Conflict_Schedule1 FOREIGN KEY(idConflictingSchedule) REFERENCES Schedule (id_Schedule)
20/04/2007 18:57:24 sql:ALTER TABLE Conflict CHECK CONSTRAINT FK_Conflict_Schedule1
20/04/2007 18:57:24 sql:--- version 12 ----
20/04/2007 18:57:24 sql:--- version 15 ----
20/04/2007 18:57:24 sql:---- update version -----
20/04/2007 18:57:24 sql:CREATE TABLE Satellite( idSatellite int IDENTITY(1,1) NOT NULL, satelliteName varchar(200) NOT NULL, transponderFileName varchar(200) NOT NULL, CONSTRAINT PK_Satellite PRIMARY KEY CLUSTERED ( idSatellite ASC ) )
20/04/2007 18:57:24 sql:CREATE TABLE DisEqcMotor( idDiSEqCMotor int IDENTITY(1,1) NOT NULL, idCard int NOT NULL, idSatellite int NOT NULL, position int NOT NULL, CONSTRAINT PK_DisEqcMotor PRIMARY KEY CLUSTERED ( idDiSEqCMotor ASC ) )
20/04/2007 18:57:24 sql:ALTER TABLE DisEqcMotor WITH CHECK ADD CONSTRAINT FK_DisEqcMotor_Satellite FOREIGN KEY(idSatellite) REFERENCES Satellite (idSatellite)
20/04/2007 18:57:24 sql:ALTER TABLE DisEqcMotor CHECK CONSTRAINT FK_DisEqcMotor_Satellite
20/04/2007 18:57:24 sql:ALTER TABLE DisEqcMotor WITH CHECK ADD CONSTRAINT FK_DisEqcMotor_Card FOREIGN KEY(idCard) REFERENCES Card (idCard)
20/04/2007 18:57:24 sql:ALTER TABLE DisEqcMotor CHECK CONSTRAINT FK_DisEqcMotor_Card
20/04/2007 18:57:24 sql:--- version 15 ----
20/04/2007 18:57:24 sql:--- version 20 ----
20/04/2007 18:57:24 sql:CREATE TABLE CardGroup ( idCardGroup int IDENTITY (1, 1) NOT NULL , name varchar (255) NOT NULL )
20/04/2007 18:57:24 sql:CREATE TABLE CardGroupMap ( idMapping int IDENTITY (1, 1) NOT NULL , idCard int NOT NULL , idCardGroup int NOT NULL )
20/04/2007 18:57:24 sql:CREATE TABLE ChannelLinkageMap ( idMapping int IDENTITY(1,1) NOT NULL, idPortalChannel int NOT NULL, idLinkedChannel int NOT NULL, CONSTRAINT PK_ChannelLinkageMap PRIMARY KEY CLUSTERED ( idMapping ASC ) )
20/04/2007 18:57:24 sql:ALTER TABLE CardGroup WITH NOCHECK ADD CONSTRAINT PK_CardGroup PRIMARY KEY CLUSTERED ( idCardGroup )
20/04/2007 18:57:24 sql:ALTER TABLE CardGroupMap WITH NOCHECK ADD CONSTRAINT PK_CardGroupMap PRIMARY KEY CLUSTERED ( idMapping )
20/04/2007 18:57:24 sql:ALTER TABLE CardGroupMap ADD CONSTRAINT FK_CardGroupMap_Card FOREIGN KEY ( idCard ) REFERENCES Card ( idCard ), CONSTRAINT FK_CardGroupMap_CardGroup FOREIGN KEY ( idCardGroup ) REFERENCES CardGroup ( idCardGroup )
20/04/2007 18:57:24 sql:--- version 23 ----
20/04/2007 18:57:24 sql:ALTER TABLE ChannelGroup ADD sortOrder int NOT NULL DEFAULT 0
20/04/2007 18:57:24 sql:CREATE NONCLUSTERED INDEX IDX_SortOrder ON ChannelGroup ( sortOrder ASC ) INCLUDE ( idGroup, groupName)
20/04/2007 18:57:24 sql:delete from version
20/04/2007 18:57:24 sql:insert into version(versionNumber) values(26)
20/04/2007 18:57:24 ---- check if tvservice is running ----
20/04/2007 18:57:29 ---- tvservice is not running ----
20/04/2007 18:57:33 ---- start tvservice----



As you can see from the above log there are no errors, The MS error report states 'system invalidoperationexception'

 

[SciDoctor]

Well I have found what seems to be the problem and I am testing to see if the below changes correct this.

It would seem that there is an error in the TV SERVICE setup of the service during instal and that the specific hardware profile logon is disabled.

Correcting this in the TVService properties and setting to enable has the TV Service now starting without the errors.

A dev needs to check the code for the SVN's to see were this may be happening.