#5 MyTelly ver 1.4 Unable to import XML: null for lineup day / "in use by another process"
Reported by jlguy yesterday:
After configuring my SD Login and selecting all channels, I did an initial update for 13 days. The resultant Grid was only partially populated with channel information and the program quit with this message: "Unable to import XML: null". I exited the program and navigated to the Schedules Direct website in order to first Re-Add All Lineups and then restart My Telly. However, a new message stated that Re-add is no longer supported.
————
I've determined that I can download 1-4 days without error. The null error appears for 5+ day downloads.
————
This morning, I downloaded 4 days and was surprised to see the null error again. There was no error for 1-3 days. After re-confirming the error at 4 days, I navigated to and opened debug.bat in Command Prompt. I used the command C:\Users\Dell\Desktop\MyTelly>mytelly_sysout.txt to obtain the following:
"Parsing config file.
Grabber set to:ZapWebService
Parsing favorites file.
Parsing Hiddens file.
Parsing schedule file.
Connecting to: jdbc:hsqldb:mytelly
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT KEY,channel,start,title,subtitle FROM Programs
sql stmt:SELECT displayname FROM Channels
Writing favorites file: favorites.xml
No results in favorites
Writing Hiddens file: Hiddens.xml"
————
Current status:
Yes that is what I wanted. And again you should not (need to) edit the MyTelly_debug.bat file you are running for this testing/diagnostics.
But that is not what a complete mytelly_sysout.txt should look like for a My Telly session where Update schedules what requested. IOW the MyTelly_debug.bat created mytelly_sysout.txt will only be useful for diagnostics if it is from a MyTelly session with the problem.
So please recreate mytelly_sysout.txt as above & either post here to email to my sourceforge email.
I bet we are seeing an error in the Schedules Direct feed for your Day #4 data (will be for Day #3 tomorrow, etc). My Telly is not (very) tolerant of bad data in the schedule feed and never was. Better data feed fault diagnostics & tolerance is something it looks like will need to be added.
Hi Chris,
After deleting my two SD lineups, I added them back and reloaded My Telly with a one day update on the Windows 7 Dell I have been using . The "Unable to import XML: null" error returned again. At that point, I navigated to debug.bat in File Explorer and opened the file. This generated a sysout.txt which opened to the same text submitted in my earlier post three days ago.
I switched to a second Windows 8 Dell, unzipped a fresh copy of V1.4, and loaded it with a one day update. Although another partially-completed grid and null error were generated, a more informative sysout.txt report was also produced:
"Parsing config file.
Grabber set to:ZapWebService
java.io.FileNotFoundException: C:\Users\Random EW\Desktop\My Telly\favorites.xml (The system cannot find the file specified)
java.io.FileNotFoundException: C:\Users\Random EW\Desktop\My Telly\Hiddens.xml (The system cannot find the file specified)
java.io.FileNotFoundException: C:\Users\Random EW\Desktop\My Telly\schedule.xml (The system cannot find the file specified)
Connecting to: jdbc:hsqldb:mytelly
java.sql.SQLException: The database is already in use by another process
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Trace.getError(Trace.java:144)
at org.hsqldb.Trace.error(Trace.java:192)
at org.hsqldb.Log.open(Log.java:208)
at org.hsqldb.Database.<init>(Database.java:96)
at org.hsqldb.jdbcConnection.openStandalone(jdbcConnection.java:926)
at org.hsqldb.jdbcConnection.<init>(jdbcConnection.java:682)
at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:116)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.ttalbott.mytelly.SQLData.connect(SQLData.java:94)
at org.ttalbott.mytelly.SQLData.<init>(SQLData.java:68)
at org.ttalbott.mytelly.SQLData.getInstance(SQLData.java:73)
at org.ttalbott.mytelly.SQLChannelData.<init>(SQLChannelData.java:50)
at org.ttalbott.mytelly.MyTellyMainFrame.updatePrograms(MyTellyMainFrame.java:2464)
at org.ttalbott.mytelly.MyTellyMainFrame.initApp(MyTellyMainFrame.java:2387)
at org.ttalbott.mytelly.MyTellyMainFrame.<init>(MyTellyMainFrame.java:144)
at org.ttalbott.mytelly.MyTellyMainFrame.main(MyTellyMainFrame.java:2330)
Connecting to: jdbc:hsqldb:mytelly
java.sql.SQLException: The database is already in use by another process
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Trace.getError(Trace.java:144)
at org.hsqldb.Trace.error(Trace.java:192)
at org.hsqldb.Log.open(Log.java:208)
at org.hsqldb.Database.<init>(Database.java:96)
at org.hsqldb.jdbcConnection.openStandalone(jdbcConnection.java:926)
at org.hsqldb.jdbcConnection.<init>(jdbcConnection.java:682)
at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:116)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.ttalbott.mytelly.SQLData.connect(SQLData.java:94)
at org.ttalbott.mytelly.SQLData.<init>(SQLData.java:68)
at org.ttalbott.mytelly.SQLData.getInstance(SQLData.java:73)
at org.ttalbott.mytelly.SQLProgramData.<init>(SQLProgramData.java:86)
at org.ttalbott.mytelly.MyTellyMainFrame.updatePrograms(MyTellyMainFrame.java:2474)
at org.ttalbott.mytelly.MyTellyMainFrame.initApp(MyTellyMainFrame.java:2387)
at org.ttalbott.mytelly.MyTellyMainFrame.<init>(MyTellyMainFrame.java:144)
at org.ttalbott.mytelly.MyTellyMainFrame.main(MyTellyMainFrame.java:2330)
No cell data set in TVGrid
Writing favorites file: favorites.xml
No results in favorites
Writing Hiddens file: Hiddens.xml"</init></init></init></init></init></init></init></init></init></init>
I have Java 7 Update 71, Java 8 Update 25, and Java 8 Update 25 (64-bit) on the Dell Windows 8. Windows 8 Update 25 is on the Dell Windows 7.
I hope this is more helpful in resolving my problem.
Regards,
Joel
P.S. I didn't notice the sysout.txt file before. Is this a new addition?
Shortly after posting the above I re-loaded My Telly on the Windows 7 machine. The sysout.txt results associated with this null error now mirrors that obtained with Windows 8, as follows:
Parsing config file.
Grabber set to:ZapWebService
Parsing favorites file.
Parsing Hiddens file.
Parsing schedule file.
Connecting to: jdbc:hsqldb:mytelly
java.sql.SQLException: The database is already in use by another process
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Trace.getError(Trace.java:144)
at org.hsqldb.Trace.error(Trace.java:192)
at org.hsqldb.Log.open(Log.java:208)
at org.hsqldb.Database.<init>(Database.java:96)
at org.hsqldb.jdbcConnection.openStandalone(jdbcConnection.java:926)
at org.hsqldb.jdbcConnection.<init>(jdbcConnection.java:682)
at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:116)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.ttalbott.mytelly.SQLData.connect(SQLData.java:94)
at org.ttalbott.mytelly.SQLData.<init>(SQLData.java:68)
at org.ttalbott.mytelly.SQLData.getInstance(SQLData.java:73)
at org.ttalbott.mytelly.SQLChannelData.<init>(SQLChannelData.java:50)
at org.ttalbott.mytelly.MyTellyMainFrame.updatePrograms(MyTellyMainFrame.java:2464)
at org.ttalbott.mytelly.MyTellyMainFrame.initApp(MyTellyMainFrame.java:2387)
at org.ttalbott.mytelly.MyTellyMainFrame.<init>(MyTellyMainFrame.java:144)
at org.ttalbott.mytelly.MyTellyMainFrame.main(MyTellyMainFrame.java:2330)
Connecting to: jdbc:hsqldb:mytelly
java.sql.SQLException: The database is already in use by another process
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Trace.getError(Trace.java:144)
at org.hsqldb.Trace.error(Trace.java:192)
at org.hsqldb.Log.open(Log.java:208)
at org.hsqldb.Database.<init>(Database.java:96)
at org.hsqldb.jdbcConnection.openStandalone(jdbcConnection.java:926)
at org.hsqldb.jdbcConnection.<init>(jdbcConnection.java:682)
at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:116)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.ttalbott.mytelly.SQLData.connect(SQLData.java:94)
at org.ttalbott.mytelly.SQLData.<init>(SQLData.java:68)
at org.ttalbott.mytelly.SQLData.getInstance(SQLData.java:73)
at org.ttalbott.mytelly.SQLProgramData.<init>(SQLProgramData.java:86)
at org.ttalbott.mytelly.MyTellyMainFrame.updatePrograms(MyTellyMainFrame.java:2474)
at org.ttalbott.mytelly.MyTellyMainFrame.initApp(MyTellyMainFrame.java:2387)
at org.ttalbott.mytelly.MyTellyMainFrame.<init>(MyTellyMainFrame.java:144)
at org.ttalbott.mytelly.MyTellyMainFrame.main(MyTellyMainFrame.java:2330)
No cell data set in TVGrid
No cell data set in TVGrid
Writing favorites file: favorites.xml
No results in favorites
Writing Hiddens file: Hiddens.xml
No cell data set in TVGrid
No cell data set in TVGrid</init></init></init></init></init></init></init></init></init></init>
"java.sql.SQLException: The database is already in use by another process"
I don't know if this bears upon the issue, but I also use SD for the WiRNS application which updates my Replaytv boxes each day. The WiRNS service is only active between 3:45-6:00 a.m. Also the xdtv.jar file on both computer is 62/63K.
Regards,
Joel
Hi Joel,
It's possible what you are seeing now is a different problem than your prior one (where I thought it was a specific day of "bad" data for My Telly).
Think those latest debug msgs indicate either 1) you have 2 MyTellys running on the box at the same time, or 2) mytelly's database file(s) are locked. Here's what I suggest:
1) reboot the box. Make sure you've no MyTelly apps running (e.g. task manager),
2) in your mytelly directory delete these files: mytelly.data, mytelly.backup and *.lck (meaning any file there that has the 'lck' file extension - if it exists let me know & any errors when you try to delete these).
3) even if you're already an administrator, you may still have to right-click and 'run as administrator'. Please use File Explorer and right-click the mytelly bat file & choose 'run as administrator'
4) once MyTelly is up please re-try updating for, say, 3 days of data.
Post what happens. If it fails again sorry to ask for this but please post a new mytelly_debug bat mytelly_sysout.txt file here.
Sorry for the difficulties. Think something uniquely fishy is going on for you because we've had 50 or so downloads of MyTelly 1.4 and so far this is the first problem report.
Last edit: Chris Forster 2014-11-11
Hi Chris,
Each time over the past week that I've loaded MyTelley for a 1+ day update has resulted in null error and a partially-completed grid. Today, I've been getting a fully-completed grid, i.e., no null error, between 1-3 days update only. Updates for 4+ days have continued to return the null error. When a command window was executed for sysout.txt immediately upon closing the null error and error-free grids, the following message was displayed:
"My Telley failed to initialize: java.io.FileNotFoundException: mytelly_sysout.txt (The process cannot access the file because it is being used by another process)"
After sysout.txt was obtained for each type of grid, the computer was re-booted and mytelly.data and mytelly.backup were deleted. MyTelly was reloaded, with the same results as above depending upon the number of days downloaded. The same sysout.txt message as above was also observed.
I don't seem to be able to produce a sysout.txt similar to your example. Am I missing an important step or doing something incorrectly?
Regards,
Joel
Hi Joel,
I'm going to reply to your PM with responses to other queries/ideas you proposed in your PM. But wanted to say I plan/hope to post a new MyTelly 1.4 release that only adds more debugging info & (hopefully) some data feed fault tolerance.
I suspect we are looking at two problems here related to the two types of errors we are seeing:
1) "The database is already in use by another process" / "mytelly_sysout.txt (The process cannot access the file because it is being used by another process)" - These errors should related to what they say - Some other process (a duplicate MyTelly session or separate thread in the single MyTelly session) has a lock on the element mentioned. In these cases the mytelly database files or the debug output file.
2) "java.lang.NullPointerException at org.ttalbott.mytelly.XTVDtoSQL.beginImport(XTVDtoSQL.java:NNN)" (see also a later post to this ticket WRT Mike's report) - Pretty these are due to bad/illegal/missing-required data in the schedule data feed. Again, current & past MyTelly does not have much in the way of fault tolerance - the import tends to fail at the first sign of (serious?) data trouble.
Regards,
Chris
Last edit: Chris Forster 2014-11-16
Tacking in Mike's post from another thread topic... This is the expected output (mytelly_sysout.txt) for #2 type (data) errors from my last post:
Has there been any solution found for this issue? I get the dreaded null error when trying to download more than 1 day. See below.
---- MyTelly boot / init code log portion ------
Parsing config file.
Grabber set to:ZapWebService
Parsing favorites file.
Parsing Hiddens file.
Parsing schedule file.
Connecting to: jdbc:hsqldb:mytelly
------------ log portion for day of "good" data --------
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT KEY,channel,start,title,subtitle FROM Programs
sql stmt:SELECT displayname FROM Channels
hier2
http://dd.schedulesdirect.org/schedulesdirect/tvlistings/xtvdService
f hier
x Envelope
x Body
x downloadResponse
x xtvdResponse
x messages
x message
sta xtvd
STATION Lifetime
STATION Syfy
STATION USA Network
STATION FX
STATION BBC America
STATION WRCBDT (WRCB-DT)
STATION WDEFDT (WDEF-DT)
STATION WTVCDT (WTVC-DT)
STATION WTVCDT2 (WTVC-DT2)
STATION WTCIDT (WTCI-DT)
STATION WTCIDT2 (WTCI-DT2)
STATION WDSIDT (WDSI-DT)
STATION WFLIDT (WFLI-DT)
STATION WFLIDT2 (WFLI-DT 2)
STATION WRCBDT2 (WRCB-DT2)
STATION WDEFDT2 (WDEF-DT2)
STATION WDSIDT2 (WDSI-DT2)
STATION WNGHDT (WNGH-DT)
STATION WNGHDT3 (WNGH-DT3)
STATION WNGHDT2 (WNGH-DT2)
STATION WYHBCD (WYHB-CD)
STATION WOOTLD (WOOT-LD)
STATION WOOTLD2 (WOOT-LD2)
STATION WOOTLD3 (WOOT-LD3)
STATION WOOTLD4 (WOOT-LD4)
parseProgram
Connecting to: jdbc:hsqldb:mytelly
DateCheckFirstRuns - Maybe not a repeat Vanderbilt MDs, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat Astroblast, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat Game Changers With Kevin Frazier, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat PBS NewsHour Weekend, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat The Brady Barr Experience, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat Reluctantly Healthy, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat Open House, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat TMZ, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat PBS NewsHour Weekend, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat Global 3000, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
------------ log portion for next day that contains "bad" data ? --------
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT KEY,channel,start,title,subtitle FROM Programs
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT displayname FROM Channels
hier2
http://dd.schedulesdirect.org/schedulesdirect/tvlistings/xtvdService
f hier
x Envelope
x Body
x downloadResponse
x xtvdResponse
x messages
x message
sta xtvd
STATION Lifetime
STATION Syfy
STATION USA Network
STATION FX
STATION BBC America
STATION WRCBDT (WRCB-DT)
STATION WDEFDT (WDEF-DT)
STATION WTVCDT (WTVC-DT)
STATION WTVCDT2 (WTVC-DT2)
STATION WTCIDT (WTCI-DT)
STATION WTCIDT2 (WTCI-DT2)
STATION WDSIDT (WDSI-DT)
STATION WFLIDT (WFLI-DT)
STATION WFLIDT2 (WFLI-DT 2)
STATION WRCBDT2 (WRCB-DT2)
STATION WDEFDT2 (WDEF-DT2)
STATION WDSIDT2 (WDSI-DT2)
STATION WNGHDT (WNGH-DT)
STATION WNGHDT3 (WNGH-DT3)
STATION WNGHDT2 (WNGH-DT2)
STATION WYHBCD (WYHB-CD)
STATION WOOTLD (WOOT-LD)
STATION WOOTLD2 (WOOT-LD2)
STATION WOOTLD3 (WOOT-LD3)
STATION WOOTLD4 (WOOT-LD4)
parseProgram
Connecting to: jdbc:hsqldb:mytelly
DateCheckFirstRuns - Maybe not a repeat David Jeremiah, currentAirDate:2014-11-16:, getOriginalAirDate:2014-11-16
DateCheckFirstRuns - Maybe not a repeat Vanderbilt MDs, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat David Jeremiah, currentAirDate:2014-11-16:, getOriginalAirDate:2014-11-16
DateCheckFirstRuns - Maybe not a repeat Astroblast, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat Meet the Press, currentAirDate:2014-11-16:, getOriginalAirDate:2014-11-16
DateCheckFirstRuns - Maybe not a repeat Spartan Race, currentAirDate:2014-11-16:, getOriginalAirDate:2014-11-16
DateCheckFirstRuns - Maybe not a repeat Game Changers With Kevin Frazier, currentAirDate:2014-11-15:, getOriginalAirDate:2014-11-15
DateCheckFirstRuns - Maybe not a repeat Face the Nation, currentAirDate:2014-11-16:, getOriginalAirDate:2014-11-16
java.lang.NullPointerException
at org.ttalbott.mytelly.XTVDtoSQL.beginImport(XTVDtoSQL.java:225)
at org.ttalbott.mytelly.ZapWebServiceUpdateThread.run(ZapWebServiceUpdateThread.java:173)
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT KEY,channel,start,title,subtitle FROM Programs
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT displayname FROM Channels
Writing favorites file: favorites.xml
Writing Hiddens file: Hiddens.xml
Again I'm trying to put out a 1.4 patch with better diag / some data fault tolerance today or tomorrow.
Chris
Hi Chris,
Well, I stumbled my way to producing the expected mytelly_sysout.txt report, as follows:
"Parsing config file.
Grabber set to:ZapWebService
Parsing favorites file.
Parsing Hiddens file.
Parsing schedule file.
Connecting to: jdbc:hsqldb:mytelly
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT KEY,channel,start,title,subtitle FROM Programs
sql stmt:SELECT displayname FROM Channels
hier2
http://dd.schedulesdirect.org/schedulesdirect/tvlistings/xtvdService
f hier
x Envelope
x Body
x downloadResponse
x xtvdResponse
x messages
x message
sta xtvd
STATION CNBC
STATION Cable News Network
STATION HLN
STATION Comedy Central (Pacific)
STATION Encore
STATION HBO
STATION HBO2
STATION HBO2 (Pacific)
STATION HBO Signature
STATION HBO (Pacific)
STATION HSN
STATION KVCW
STATION KLAS
STATION KLVX
STATION KTNV
STATION KSNV
STATION KVVU
STATION Lifetime (Pacific)
STATION MTV - Music Television (Pacific)
STATION Nickelodeon (Pacific)
STATION INSP
STATION QVC
STATION Showtime (Pacific)
STATION The Weather Channel
STATION USA Network (Pacific)
STATION ABC Family (Pacific)
STATION The Discovery Channel (Pacific)
STATION CineMAX (Pacific)
STATION The Movie Channel (Pacific)
STATION Disney Channel (Pacific)
STATION UNLV University of Nevada
STATION Starz (Pacific)
STATION Turner Classic Movies
STATION FX (Pacific)
STATION Outdoor Channel
STATION Centric
STATION FXM
STATION MoviePlex
STATION Discovery Fit and Health
STATION MSNBC
STATION Fox News Channel
STATION VH1 (Pacific)
STATION SundanceTV (Pacific)
STATION SHO 2 (Pacific)
STATION Flix (Pacific)
STATION HBO Signature (Pacific)
STATION Showtime Showcase (Pacific)
STATION HBO Family
STATION Investigation Discovery
STATION Science
STATION Destination America
STATION HBO Family (Pacific)
STATION MoreMAX (Pacific)
STATION FYI
STATION WGN America
STATION Starz in Black (Pacific)
STATION Encore Action (Pacific)
STATION Encore (Pacific)
STATION Encore Classic (Pacific)
STATION Encore Suspense (Pacific)
STATION Starz Edge (Pacific)
STATION Encore Black (Pacific)
STATION Encore Family (Pacific)
STATION Encore Westerns (Pacific)
STATION E! Entertainment Television (Pacific)
STATION The Movie Channel Extra (Pacific)
STATION Showtime Extreme (Pacific)
STATION nuvoTV
STATION American Heroes Channel
STATION BBC America
STATION Las Vegas 8NEWS
STATION HBO Comedy (Pacific)
STATION HBO Zone (Pacific)
STATION ActionMAX (Pacific)
STATION ThrillerMAX (Pacific)
STATION Lifetime Movie Network
STATION Turner Network TV (Pacific)
STATION Do-It-Yourself Network
STATION Disney XD Pacific
STATION H2
STATION Spike TV (Pacific)
STATION The Learning Channel (Pacific)
STATION Starz Kids (Pacific)
STATION Starz Cinema (Pacific)
STATION Hallmark Channel (Pacific)
STATION Showtime Beyond (Pacific)
STATION Metro 48 Cable Channel 48 Las Vegas
STATION WeatherScan Local Network
STATION ION Television Satellite Feed (Pacific)
STATION Oxygen (Pacific)
STATION A&E Network (Pacific)
STATION History (Pacific)
STATION Cox Las Vegas Government Access Ch.
STATION BET (Pacific)
STATION Syfy (Pacific)
STATION truTV (Pacific)
STATION National Geographic Channel
STATION Showtime Next (Pacific)
STATION Showtime Women (Pacific)
STATION Showtime Familyzone (Pacific)
STATION 5 StarMAX
STATION MovieMax
STATION OuterMAX
STATION TV Land (Pacific)
STATION Country Music Television (Pacific)
STATION Cooking Channel
STATION Bravo (Pacific)
STATION AMC (Pacific)
STATION Video On Demand
STATION Food Network (Pacific)
STATION Home & Garden Television (Pacific)
STATION Universal HD
STATION Starz Comedy (Pacific)
STATION Esquire (Pacific)
STATION TV ONE
STATION KLAS-DT2 7
STATION L LAS VEGAS NV 04 (CCTV4)
STATION L LAS VEGAS NV 71/111 Vegas PBS
STATION Cox Las Vegas Community Channel 96
STATION KLVXDT2 (KLVX-DT2)
STATION TV Guide Network (Pacific)
STATION LOGO (Pacific)
STATION KSNVDT2 (KSNV-DT2)
STATION IndiePlex
STATION RetroPlex
STATION The Travel Channel (Pacific)
STATION Animal Planet (Pacific)
STATION WE tv (Pacific)
STATION Chiller
STATION Fox Business
STATION QVC HD
STATION KLVX MHZ Worldview Cable Feed
STATION Cox Las Vegas TBS
STATION KSNVDT3 (KSNV-DT3)
STATION IFCl (Pacific)
STATION Epix (Pacific)
STATION KVMYDT2 (KVMY-DT2)
STATION Hallmark Movies & Mysteries (Pacific)
STATION National Geographic Wild
STATION KVCW-DT2
STATION Cox Digital Cable News & Info
STATION Oprah Winfrey Network (Pacific)
STATION KVCWDT3 (KVCW-DT3)
STATION FXX (Pacific)
STATION MoviePlex HD
STATION El Rey Network
STATION KVMYDT3 (KVMY-DT3)
STATION Cox KVCWDT2
parseProgram
Connecting to: jdbc:hsqldb:mytelly
DateCheckFirstRuns - Maybe not a repeat Mad Money, currentAirDate:2014-11-17:, getOriginalAirDate:2014-11-17
DateCheckFirstRuns - Maybe not a repeat Mad Money, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat The Gospel Truth With Andrew Wommack, currentAirDate:2014-11-17:, getOriginalAirDate:2014-11-17
DateCheckFirstRuns - Maybe not a repeat The Gospel Truth With Andrew Wommack, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat Hot Bench, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat Daniel Tiger's Neighborhood, currentAirDate:2014-11-17:, getOriginalAirDate:2014-11-17
DateCheckFirstRuns - Maybe not a repeat Martha Speaks, currentAirDate:2014-11-17:, getOriginalAirDate:2014-11-17
DateCheckFirstRuns - Maybe not a repeat Martha Speaks, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat Good Morning America, currentAirDate:2014-11-17:, getOriginalAirDate:2014-11-17
DateCheckFirstRuns - Maybe not a repeat Good Morning America, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat Today, currentAirDate:2014-11-17:, getOriginalAirDate:2014-11-17
DateCheckFirstRuns - Maybe not a repeat Today, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat The Better Show, currentAirDate:2014-11-17:, getOriginalAirDate:2014-11-17
DateCheckFirstRuns - Maybe not a repeat The Better Show, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat The Balancing Act, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat PAW Patrol, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat Steel by Design Jewelry, currentAirDate:2014-11-17:, getOriginalAirDate:2014-11-17
DateCheckFirstRuns - Maybe not a repeat Mornings Made Easy, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat Q Check, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
DateCheckFirstRuns - Maybe not a repeat Great Gifts, currentAirDate:2014-11-18:, getOriginalAirDate:2014-11-18
java.lang.NullPointerException
at org.ttalbott.mytelly.XTVDtoSQL.beginImport(XTVDtoSQL.java:225)
at org.ttalbott.mytelly.ZapWebServiceUpdateThread.run(ZapWebServiceUpdateThread.java:173)
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT KEY,channel,start,title,subtitle FROM Programs
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT displayname FROM Channels
Writing favorites file: favorites.xml
No results in favorites
Writing Hiddens file: Hiddens.xml"
Regards,
Joel
Joel & Mike & any others getting Import .. null .. errors, I've good news regarding My Telly & schedule data feed errors that was causing the entire Import to fail...
Today I will post a new version of MyTelly that has the data diagnostics & fault tolerance I talked about (& a little new enhancement to searching). It's been tested & now "survives" update/import data errors that used to take down the whole update/import.
It now:
- logs, counts & ignores program data errors in non-critical fields,
- logs, counts & bypasses program entries with "critical" program data errors
On a test run I was able to perform on a problem lineup, ver 1.4 would fail at first data error. New ver 1.5 is able to pull/import the problem lineup all the way to its max days (13) and counted / logged 4 data errors across the pull.
Plan to post it up sometime today / tonight.
My Telly 1.5 is uploaded & should fix the Import null update problems related to non-critical schedule data feed errors. Announcements has more info.
Hi Chris,
After several days of successful updating, I bombed out today with the following message:
"** Importing XML (Java ver 1.8.0_25, My Telly ver Ver 1.5) ...
2014-11-20T18:52:28Z Finished parsing XTVD document
2014-11-20T18:52:28Z Finished reading response from server
** Import XML (under OS Windows 7) complete, msgs:
CRITICAL: Likely no import
total import errors:1
** Finished importing XML."
The corresponding sysout.txt file is presented below. It looks like there should be more sysout text available, but this is all that I could see. Is this just an odd occurrence for today or an event requiring corrective action?
MyTelly ver Ver 1.5, OS Windows 7, Java ver 1.8.0_25, Parsing config file.
Grabber set to:ZapWebService
Parsing favorites file.
Parsing Hiddens file.
Parsing schedule file.
Connecting to: jdbc:hsqldb:mytelly
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT KEY,channel,start,title,subtitle FROM Programs
sql stmt:SELECT displayname FROM Channels
hier2
http://dd.schedulesdirect.org/schedulesdirect/tvlistings/xtvdService
f hier
x Envelope
x Body
x downloadResponse
x xtvdResponse
x messages
x message
sta xtvd
STATION CNBC
STATION Cable News Network
STATION HLN
STATION Comedy Central (Pacific)
STATION Encore
STATION HBO
STATION HBO2
STATION HBO2 (Pacific)
STATION HBO Signature
STATION HBO (Pacific)
STATION HSN
STATION KVCW
STATION KLAS
STATION KLVX
STATION KTNV
STATION KSNV
STATION KVVU
STATION Lifetime (Pacific)
STATION MTV - Music Television (Pacific)
STATION Nickelodeon (Pacific)
STATION INSP
STATION QVC
STATION Showtime (Pacific)
STATION The Weather Channel
STATION USA Network (Pacific)
STATION ABC Family (Pacific)
STATION The Discovery Channel (Pacific)
STATION CineMAX (Pacific)
STATION The Movie Channel (Pacific)
STATION Disney Channel (Pacific)
STATION UNLV University of Nevada
STATION Starz (Pacific)
STATION Turner Classic Movies
STATION FX (Pacific)
STATION Outdoor Channel
STATION Centric
STATION FXM
STATION MoviePlex
STATION Discovery Fit and Health
STATION MSNBC
STATION Fox News Channel
STATION VH1 (Pacific)
STATION SundanceTV (Pacific)
STATION SHO 2 (Pacific)
STATION Flix (Pacific)
STATION HBO Signature (Pacific)
STATION Showtime Showcase (Pacific)
STATION HBO Family
STATION Investigation Discovery
STATION Science
STATION Destination America
STATION HBO Family (Pacific)
STATION MoreMAX (Pacific)
STATION FYI
STATION WGN America
STATION Starz in Black (Pacific)
STATION Encore Action (Pacific)
STATION Encore (Pacific)
STATION Encore Classic (Pacific)
STATION Encore Suspense (Pacific)
STATION Starz Edge (Pacific)
STATION Encore Black (Pacific)
STATION Encore Family (Pacific)
STATION Encore Westerns (Pacific)
STATION E! Entertainment Television (Pacific)
STATION The Movie Channel Extra (Pacific)
STATION Showtime Extreme (Pacific)
STATION nuvoTV
STATION American Heroes Channel
STATION BBC America
STATION Las Vegas 8NEWS
STATION HBO Comedy (Pacific)
STATION HBO Zone (Pacific)
STATION ActionMAX (Pacific)
STATION ThrillerMAX (Pacific)
STATION Lifetime Movie Network
STATION Turner Network TV (Pacific)
STATION Do-It-Yourself Network
STATION Disney XD Pacific
STATION H2
STATION Spike TV (Pacific)
STATION The Learning Channel (Pacific)
STATION Starz Kids (Pacific)
STATION Starz Cinema (Pacific)
STATION Hallmark Channel (Pacific)
STATION Showtime Beyond (Pacific)
STATION Metro 48 Cable Channel 48 Las Vegas
STATION WeatherScan Local Network
STATION ION Television Satellite Feed (Pacific)
STATION Oxygen (Pacific)
STATION A&E Network (Pacific)
STATION History (Pacific)
STATION Cox Las Vegas Government Access Ch.
STATION BET (Pacific)
STATION Syfy (Pacific)
STATION truTV (Pacific)
STATION National Geographic Channel
STATION Showtime Next (Pacific)
STATION Showtime Women (Pacific)
STATION Showtime Familyzone (Pacific)
STATION 5 StarMAX
STATION MovieMax
STATION OuterMAX
STATION TV Land (Pacific)
STATION Country Music Television (Pacific)
STATION Cooking Channel
STATION Bravo (Pacific)
STATION AMC (Pacific)
STATION Video On Demand
STATION Food Network (Pacific)
STATION Home & Garden Television (Pacific)
STATION Universal HD
STATION Starz Comedy (Pacific)
STATION Esquire (Pacific)
STATION TV ONE
STATION KLAS-DT2 7
STATION L LAS VEGAS NV 04 (CCTV4)
STATION L LAS VEGAS NV 71/111 Vegas PBS
STATION Cox Las Vegas Community Channel 96
STATION KLVXDT2 (KLVX-DT2)
STATION TV Guide Network (Pacific)
STATION LOGO (Pacific)
STATION KSNVDT2 (KSNV-DT2)
STATION IndiePlex
STATION RetroPlex
STATION The Travel Channel (Pacific)
STATION Animal Planet (Pacific)
STATION WE tv (Pacific)
STATION Chiller
STATION Fox Business
STATION KLVX MHZ Worldview Cable Feed
STATION Cox Las Vegas TBS
STATION KSNVDT3 (KSNV-DT3)
STATION IFCl (Pacific)
STATION Epix (Pacific)
STATION KVMYDT2 (KVMY-DT2)
STATION Hallmark Movies & Mysteries (Pacific)
STATION National Geographic Wild
STATION KVCW-DT2
STATION Cox Digital Cable News & Info
STATION Oprah Winfrey Network (Pacific)
STATION KVCWDT3 (KVCW-DT3)
STATION FXX (Pacific)
STATION El Rey Network
STATION KVMYDT3 (KVMY-DT3)
parseProgram
Connecting to: jdbc:hsqldb:mytelly
DateCheckFirstRuns - Maybe not a repeat Mad Money, currentAirDate:2014-11-20:, getOriginalAirDate:2014-11-20
DateCheckFirstRuns - Maybe not a repeat Mad Money, currentAirDate:2014-11-21:, getOriginalAirDate:2014-11-21
DateCheckFirstRuns - Maybe not a repeat English Premier League Soccer, currentAirDate:2014-11-23:, getOriginalAirDate:2014-11-23
DateCheckFirstRuns - Maybe not a repeat Mad Money, currentAirDate:2014-11-24:, getOriginalAirDate:2014-11-24
DateCheckFirstRuns - Maybe not a repeat Mad Money, currentAirDate:2014-11-25:, getOriginalAirDate:2014-11-25
DateCheckFirstRuns - Maybe not a repeat Mad Money, currentAirDate:2014-11-26:, getOriginalAirDate:2014-11-26
DateCheckFirstRuns - Maybe not a repeat Asia Business Leaders Awards, currentAirDate:2014-11-27:, getOriginalAirDate:2014-11-27
DateCheckFirstRuns - Maybe not a repeat Reliable Sources, currentAirDate:2014-11-23:, getOriginalAirDate:2014-11-23
DateCheckFirstRuns - Maybe not a repeat State of the Union With Candy Crowley, currentAirDate:2014-11-23:, getOriginalAirDate:2014-11-23
XTVDtoSQL::beginImport importErrorCount:0, threw ee:java.lang.NullPointerException
Accumulated errors: CRITICAL: Likely no import
java.lang.NullPointerException
at org.ttalbott.mytelly.XTVDtoSQL.beginImport(XTVDtoSQL.java:169)
at org.ttalbott.mytelly.ZapWebServiceUpdateThread.run(ZapWebServiceUpdateThread.java:130)
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT KEY,channel,start,title,subtitle FROM Programs
sql stmt:SELECT FLAGS FROM Flags WHERE Table = 'Programs'
sql stmt:SELECT displayname FROM Channels
Thanks for your consideration,
Joel
Hi Joel,
You, or should I say your lineup(s), have quite the knack for presenting illegal/empty/bad data in the schedule data feed.
This last one of yours exposed an omitted data test in the MyTelly ver 1.5, an additional test for a completely empty/null program entry. What should happen in this case, and will in new MyTelly ver 1.5.1, is that the specific program be bypassed & the balance of the import occur (a "MEDium" error thrown, not the CRITICAL one you were getting).
There is now a patch for My Telly ver 1.5 (bringing it to ver 1.5.1) that adds the missing test. Please bop over to the 1.5 files section, download the mytelly_1_5_1_patch_to_1_5.zip file & unzip it into your MyTelly 1.5 directories (overwriting the JAR & Readme.txt files there). This should "fix" your latest data feed problem.
Note: Again the Import dialog msg should now read MEDium for this sort of error, omit the program & continue with the Import.
Regards,
Chris
Hi Chris,
My lineups are pleased to be of such service (LOL)! Your patch is most welcome. I installed into the My Telly folder and obtained a complete 13-day grid.
Again, thanks for all you've done to keep this program working.
Joel