DataDirect, Error: UpdateProgramViewTable no dd_state!

[davidbrodbeck]

For the last three or four days I've been having trouble retrieving new data. Here's a log snippet from mythfilldatabase:

2007-11-07 11:35:31.820 Checking day @ offset 10, date: Sat Nov 17 2007
2007-11-07 11:35:32.801 Data Refresh needed because offset day 10 has less than 4 programs per channel for the 6PM - midnight time window for channels that normally have data. We want at least 956 programs, but only found 100
2007-11-07 11:35:32.801 Refreshing data for Sat Nov 17 2007
2007-11-07 11:35:32.801 This DataDirect listings source is shared by 2 MythTV lineups
2007-11-07 11:35:32.802 We should keep data around after this one
2007-11-07 11:35:32.804 Retrieving datadirect data.
2007-11-07 11:35:32.804 Grabbing data for Wed Nov 7 2007 offset 10
2007-11-07 11:35:32.804 From Sat Nov 17 08:00:00 2007 to Sun Nov 18 08:00:00 2007 (UTC)
2007-11-07 11:35:32.805 Grabbing listing data
--11:35:32-- http://webservices.schedulesdirect.tmsd ... tvdService
=> `-'
2007-11-07 11:35:32.883 DataDirect: Saving listings to DD cache
Resolving webservices.schedulesdirect.tmsdatadirect.com... 206.18.98.175
Connecting to webservices.schedulesdirect.tmsdatadirect.com|206.18.98.175|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Reusing existing connection to webservices.schedulesdirect.tmsdatadirect.com:80.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]

[ <=> ] 341,407 53.53K/s

11:35:39 (53.44 KB/s) - `-' saved [341407]

2007-11-07 11:35:40.495 DataDirect: Your subscription expires on 06/19/2008 10:54:27 PM
2007-11-07 11:36:14.591 Grab complete. Actual data from Sat Nov 17 08:00:00 2007 to Sun Nov 18 08:00:00 2007 (UTC)
2007-11-07 11:36:14.593 Main temp tables populated.
2007-11-07 11:36:14.594 DataDirect, Error: UpdateProgramViewTable no dd_state!
2007-11-07 11:36:14.594 Did not find any new program data.

[fireyice01]

I noticed I don't have much over a week of listings either. So I ran a mythfilldatabase and it's reporting the same.

2007-11-07 22:50:25.970 Checking day @ offset 7, date: Wed Nov 14 2007
2007-11-07 22:50:26.114 Data Refresh needed because offset day 7 has less than 4 programs per channel for the 6PM - midnight time window for channels that normally have data. We want at least 1364 programs, but only found 1096
2007-11-07 22:50:26.114 Refreshing data for Wed Nov 14 2007
2007-11-07 22:50:26.115 Retrieving datadirect data.
2007-11-07 22:50:26.115 Grabbing data for Wed Nov 7 2007 offset 7
2007-11-07 22:50:26.115 From Wed Nov 14 08:00:00 2007 to Thu Nov 15 08:00:00 2007 (UTC)
2007-11-07 22:50:26.115 Grabbing listing data
2007-11-07 22:51:33.127 DataDirect: Your subscription expires on 06/21/2008 10:19:51 PM
2007-11-07 22:51:42.175 Grab complete. Actual data from Wed Nov 14 08:00:00 2007 to Thu Nov 15 08:00:00 2007 (UTC)
2007-11-07 22:51:42.176 Main temp tables populated.
2007-11-07 22:51:42.176 DataDirect, Error: UpdateProgramViewTable no dd_state!
2007-11-07 22:51:42.176 Did not find any new program data.
2007-11-07 22:51:42.192
2007-11-07 22:51:42.192 Checking day @ offset 8, date: Thu Nov 15 2007
2007-11-07 22:51:42.334 Data refresh needed because no data exists for day @ offset 8 from 6PM - midnight.
2007-11-07 22:51:42.334 Refreshing data for Thu Nov 15 2007
2007-11-07 22:51:42.334 Retrieving datadirect data.
2007-11-07 22:51:42.335 Grabbing data for Wed Nov 7 2007 offset 8
2007-11-07 22:51:42.335 From Thu Nov 15 08:00:00 2007 to Fri Nov 16 08:00:00 2007 (UTC)
2007-11-07 22:51:42.335 Grabbing listing data
2007-11-07 22:52:27.198 DataDirect: Your subscription expires on 06/21/2008 10:19:51 PM
2007-11-07 22:52:36.134 Grab complete. Actual data from Thu Nov 15 08:00:00 2007 to Fri Nov 16 08:00:00 2007 (UTC)
2007-11-07 22:52:36.135 Main temp tables populated.
2007-11-07 22:52:36.135 DataDirect, Error: UpdateProgramViewTable no dd_state!
2007-11-07 22:52:36.136 Did not find any new program data.
2007-11-07 22:52:36.136


It does this for all the rest of the days up to offset 13. I don't know when this started happening, but presume sometime around 4 or 5 days ago, since I have data up until 11pm on the 14th.

zip: 95633
lineup: directv sacramento

[davidbrodbeck]

I guess it's not specific to my lineup, then -- I'm using ComcastDigital, zip 98032.

[underdeep]

I'm also having this problem with MythDora 4.0 using Shaw Cablesystems in Winnipeg, postal code R3Y 1W2. Mythweb shows me a whole lot of NO DATA today. I first noticed it on Sunday, then Monday morning they were back and now today they're gone again.
I'm using the mythfilldb.sh script from the g-ding.tv site from when the switch was first made.
It appears there have been updates to scripts, but atrpms.net is down so I can't download updates to sdxmltvsetup.sh or use yum to upgrade.

[bcaccavale]

I'm also having this problem with MythDora 4.0 using Shaw Cablesystems in Winnipeg, postal code R3Y 1W2. Mythweb shows me a whole lot of NO DATA today. I first noticed it on Sunday, then Monday morning they were back and now today they're gone again.
I'm using the mythfilldb.sh script from the g-ding.tv site from when the switch was first made.
It appears there have been updates to scripts, but atrpms.net is down so I can't download updates to sdxmltvsetup.sh or use yum to upgrade.

I'm also running Mythdora 4.0 and had the same problem running the mythfilldb.sh script. I followed Robert's suggestion (thank you!!) from viewtopic.php?f=6&t=295 to confirm that I was receiving the correct data download. I then updated my box using option 2 of the "Schedules Direct update" from http://g-ding.tv/?q=node/2191. I updated using "mythfilldatabase --do-channels-update --refresh-all" and all is well. I no longer use the mythfilldb.sh script - just use mythfilldatabase. It's been working great for the last 3 days. Hope this helps.

Ben

[davidbrodbeck]

Well, today's grab went through without any errors, and I now have 14 days of data. Hopefully it was a temporary problem and it's resolved itself.

[fireyice01]

yep, mine worked today too.

[Darth_Sebulba04]

I've been having this problem for the last 4 days. Is it something that just works itself out or is there something that needs to be done?

At first I thought it had something to do with resetting my password, but after seeing this, I'm starting to wonder.

[Darth_Sebulba04]

After closer examination, I believe it is because of my password change (this happened 5 times last night).
All of a sudden, I'm unauthorized. My password to login to the website is the same as the one configured in mythtv.

Any suggestions?

2007-11-15 00:02:33.966 Grabbing data for Thu Nov 15 2007 offset 9
2007-11-15 00:02:33.967 From Sat Nov 24 05:00:00 2007 to Sun Nov 25 05:00:00 2007 (UTC)
2007-11-15 00:02:33.967 Grabbing listing data
--00:02:34-- http://webservices.schedulesdirect.tmsd ... tvdService
=> `-'
Resolving webservices.schedulesdirect.tmsdatadirect.com... 206.18.98.175
Connecting to webservices.schedulesdirect.tmsdatadirect.com|206.18.98.175|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Reusing existing connection to webservices.schedulesdirect.tmsdatadirect.com:80.
HTTP request sent, awaiting response... 401 Unauthorized
Authorization failed.
2007-11-15 00:02:34.478 Grab complete. Actual data from to (UTC)
2007-11-15 00:02:34.479 Main temp tables populated.
2007-11-15 00:02:34.479 Updating myth channels.
2007-11-15 00:02:34.482 New DB connection, total: 3
2007-11-15 00:02:34.482 Connected to database 'mythconverg' at host: localhost
2007-11-15 00:02:34.500 Updating icons for sourceid: 1
2007-11-15 00:02:34.500 Channels updated.
2007-11-15 00:02:34.500 DataDirect, Error: UpdateProgramViewTable no dd_state!

[Darth_Sebulba04]

Problem solved by changing my password back to itself.