Web Sever Unable to export XML in SageTV v9

[nyplayer]

I cannot export an XML of my recordings from the webserver ... I did this daily as part of my backup. I was able to do this prior to upgrading the Jars. If I go to recordings on my web page click on the XML export I get an error.

[Monedeath]

Originally Posted by nyplayer

I cannot export an XML of my recordings from the webserver ... I did this daily as part of my backup. I was able to do this prior to upgrading the Jars. If I go to recordings on my web page click on the XML export I get an error.

In all reality, this is a plugin issue, as the webserver isn't part of the "core" for SageTV. That being said, details regarding the error is going to be needed in order for anyone to be able to assist.

[nyplayer]

Originally Posted by Monedeath

In all reality, this is a plugin issue, as the webserver isn't part of the "core" for SageTV. That being said, details regarding the error is going to be needed in order for anyone to be able to assist.

The error is not much the web page is no longer found.

The webpage at http://127.0.01:8080/sage/Recordings?xml=yes might be temporarily down or it may have moved permanently to a new web address.

It works fine my my SageTV7.

Edit a little more. Favorite manager also kicks out an error.

11. java.lang.ClassCastException: sage.Person cannot be cast to java.lang.String at net.sf.sageplugins.sageutils.SageApi.StringApi(SageApi.java:112) at net.sf.sageplugins.webserver.Favorite.getPerson(Favorite.java:392) at net.sf.sageplugins.webserver.Favorite.printFavoriteTableCell(Favorite.java:770) at net.sf.sageplugins.webserver.FavoritesServlet.doServletGet(FavoritesServlet.java:89) at net.sf.sageplugins.webserver.SageServlet.doGet(SageServlet.java:102) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.handler.rewrite.RewriteHandler.handle(RewriteHandler.java:230) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:864) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)
New by: [Title] [Actor] [Category] [Keyword]

[Opus4]

Other than the SchedulesDirect EPG plugin that was required to be updated for v9, and is essentially a requirement for new users, I'm still asking that topics for plugin issues go in one of the customizations forums, so the topic was moved. The plugin developer can decide whether there is an issue to fix in the plugin due to core changes.

Andy

[Monedeath]

I'm the last person you want to see trying to diagnose that error log. Checking the path you specified(not having used the xml export capability in a looong time), I was able to successfully create xml files for both the
http://serverip:8080/sage/Recordings?xml=yes
and
http://serverip:8080/sage/Favorites?xml=yes
URL's.

I am running the 9.0.1.3 SageTV Jar on Windows 7Pro 32bit. (commit 8d4f872)

So whatever is happening, it is either an earlier build of Sage 9.x doing it by some strange means, or something else on your server is causing it, as I cannot reproduce the error. Did you just upgrade to Java 8 by any chance?

[nyplayer]

Originally Posted by Monedeath

I'm the last person you want to see trying to diagnose that error log. Checking the path you specified(not having used the xml export capability in a looong time), I was able to successfully create xml files for both the
http://serverip:8080/sage/Recordings?xml=yes
and
http://serverip:8080/sage/Favorites?xml=yes
URL's.

I am running the 9.0.1.3 SageTV Jar on Windows 7Pro 32bit. (commit 8d4f872)

So whatever is happening, it is either an earlier build of Sage 9.x doing it by some strange means, or something else on your server is causing it, as I cannot reproduce the error. Did you just upgrade to Java 8 by any chance?

Nope did not do anything just discovered this because I noticed the recordings xml was not being created on my nightly backups. ... Where can I find the latest Sage 9 Jar?


I am in the process of recreating the DB so I can back off Sage 9 would hate to do that but the webserver is a must as I plan to be going away. especially the favorite manager. PS you probably cannot recreate the favorites error because I have all kinds of keyword favorites etc...

[Monedeath]

Originally Posted by nyplayer

Nope did not do anything just discovered this because I noticed the recordings xml was not being created on my nightly backups. ... Where can I find the latest Sage 9 Jar?

Looks like Stuckless is still snoozing on uploading a new build.
Uploaded mine to dropbox, pm'd you a link to it.

[nyplayer]

Originally Posted by Monedeath

Looks like Stuckless is still snoozing on uploading a new build.
Uploaded mine to dropbox, pm'd you a link to it.

I believe the Favorite failure is being caused by this type of favorite.

By Actor and Keyword.

New By Actor/Team
Tom Hanks

Keyword
"MV\d+"

[Monedeath]

Added both as a favorite through the Web UI, have two more xml files to show for it(created another xml file after each addition). Mine just keeps chugging along without issue on this.

On second thought, which version of the Web UI are you running? The last changelog mine is showing is V2.30 21 Mar 2011 For SageTV 7.1

edit to add: Plugin Manager reports the Web Interface as 2.43

[nyplayer]

Originally Posted by Monedeath

Added both as a favorite through the Web UI, have two more xml files to show for it.

Maybe something went wrong with my DB conversion. I have to look further maybe I have to redo my favorites.

The funny this is that I recreated the DB in Sage V7 and everything works just fine. So it could be a hosed DB.

[nyplayer]

I was able to get past the errors by deleting my Favorites by Actor and re-adding them.

Thank for your help Monedeath.


Edit spoke to soon.

If I create a Favorite By Actor for ex. Tom Hanks.
I then bring up the Webserver go to Favorite manager scroll all the way down there is a Java error for that favorite.

Sun 10/11 12:57:13.052 [10765473@qtp-11413068-3@a444a1] ::WARN:  RecordingsServlet: Exception while processing servlet net.sf.sageplugins.webserver.RecordingsServlet
Sun 10/11 12:57:13.054 [10765473@qtp-11413068-3@a444a1] java.lang.ClassCastException: sage.Person cannot be cast to java.lang.String
Sun 10/11 12:57:13.057 [10765473@qtp-11413068-3@a444a1] ::WARN:  RecordingsServlet: Exception while processing servlet
Sun 10/11 12:57:13.059 [10765473@qtp-11413068-3@a444a1] java.io.IOException: Closed
Sun 10/11 12:57:13.061 [10765473@qtp-11413068-3@a444a1] ::WARN:  /sage/Recordings
Sun 10/11 12:57:13.206 [10765473@qtp-11413068-3@a444a1] ::WARN:  RecordingsServlet: Exception while processing servlet net.sf.sageplugins.webserver.RecordingsServlet
Sun 10/11 12:57:13.208 [10765473@qtp-11413068-3@a444a1] java.lang.ClassCastException: sage.Person cannot be cast to java.lang.String
Sun 10/11 12:57:13.211 [10765473@qtp-11413068-3@a444a1] ::WARN:  RecordingsServlet: Exception while processing servlet
Sun 10/11 12:57:13.213 [10765473@qtp-11413068-3@a444a1] java.io.IOException: Closed
Sun 10/11 12:57:13.215 [10765473@qtp-11413068-3@a444a1] ::WARN:  /sage/Recordings

Exception while processing servlet:
java.lang.ClassCastException: sage.Person cannot be cast to java.lang.String
java.lang.ClassCastException: sage.Person cannot be cast to java.lang.String
	at net.sf.sageplugins.sageutils.SageApi.StringApi(SageApi.java:112)
	at net.sf.sageplugins.webserver.Favorite.getPerson(Favorite.java:392)
	at net.sf.sageplugins.webserver.FavoriteDetailsServlet.doServletGet(FavoriteDetailsServlet.java:148)
	at net.sf.sageplugins.webserver.SageServlet.doGet(SageServlet.java:102)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
	at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
	at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.handler.rewrite.RewriteHandler.handle(RewriteHandler.java:230)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:326)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
	at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:864)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)

[skiingwiz]

Looking through the code, the webserver is calling the GetFavoritePerson API method, which in version 9 returns the type sage.Person (See here). Apparently in earlier versions, it returned a String (which the webserver relies on).

So the webserver will have to be updated to fix that.

[stuckless]

Originally Posted by Monedeath

Looks like Stuckless is still snoozing on uploading a new build.

Apparently this weekend is the Canadian Thanksgiving holiday... I been away visiting family all weekend.

[Fuzzy]

Originally Posted by nyplayer

I was able to get past the errors by deleting my Favorites by Actor and re-adding them.

Thank for your help Monedeath.


Edit spoke to soon.

If I create a Favorite By Actor for ex. Tom Hanks.
I then bring up the Webserver go to Favorite manager scroll all the way down there is a Java error for that favorite.

Sun 10/11 12:57:13.052 [10765473@qtp-11413068-3@a444a1] ::WARN:  RecordingsServlet: Exception while processing servlet net.sf.sageplugins.webserver.RecordingsServlet
Sun 10/11 12:57:13.054 [10765473@qtp-11413068-3@a444a1] java.lang.ClassCastException: sage.Person cannot be cast to java.lang.String
Sun 10/11 12:57:13.057 [10765473@qtp-11413068-3@a444a1] ::WARN:  RecordingsServlet: Exception while processing servlet
Sun 10/11 12:57:13.059 [10765473@qtp-11413068-3@a444a1] java.io.IOException: Closed
Sun 10/11 12:57:13.061 [10765473@qtp-11413068-3@a444a1] ::WARN:  /sage/Recordings
Sun 10/11 12:57:13.206 [10765473@qtp-11413068-3@a444a1] ::WARN:  RecordingsServlet: Exception while processing servlet net.sf.sageplugins.webserver.RecordingsServlet
Sun 10/11 12:57:13.208 [10765473@qtp-11413068-3@a444a1] java.lang.ClassCastException: sage.Person cannot be cast to java.lang.String
Sun 10/11 12:57:13.211 [10765473@qtp-11413068-3@a444a1] ::WARN:  RecordingsServlet: Exception while processing servlet
Sun 10/11 12:57:13.213 [10765473@qtp-11413068-3@a444a1] java.io.IOException: Closed
Sun 10/11 12:57:13.215 [10765473@qtp-11413068-3@a444a1] ::WARN:  /sage/Recordings

Exception while processing servlet:
java.lang.ClassCastException: sage.Person cannot be cast to java.lang.String
java.lang.ClassCastException: sage.Person cannot be cast to java.lang.String
	at net.sf.sageplugins.sageutils.SageApi.StringApi(SageApi.java:112)
	at net.sf.sageplugins.webserver.Favorite.getPerson(Favorite.java:392)
	at net.sf.sageplugins.webserver.FavoriteDetailsServlet.doServletGet(FavoriteDetailsServlet.java:148)
	at net.sf.sageplugins.webserver.SageServlet.doGet(SageServlet.java:102)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
	at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
	at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.handler.rewrite.RewriteHandler.handle(RewriteHandler.java:230)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:326)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
	at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:864)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)

Interestingly enough, sage.Person DOES have a .toString() method, that returns the person's name - I had thought java would attempt to autocast objects to Strings if needed using toString if it was defined.

[stuckless]

Originally Posted by Fuzzy

Interestingly enough, sage.Person DOES have a .toString() method, that returns the person's name - I had thought java would attempt to autocast objects to Strings if needed using toString if it was defined.

Java will never auto cast anything. It will use the toString() for an object if you attempt to concatenate an object with a string...

so,

String s = "" + someObject;

will call the toString() method on someObject.

but,

String s = (String)someObject;

will fail with a class cast exception if someObject is not a String. It will never try to call toString() on someObject to make it a String.

[Monedeath]

Originally Posted by skiingwiz

Looking through the code, the webserver is calling the GetFavoritePerson API method, which in version 9 returns the type sage.Person (See here). Apparently in earlier versions, it returned a String (which the webserver relies on).

So the webserver will have to be updated to fix that.

Weird thing is, when I was trying to reproduce the issue he was reporting, I did go over the entire page being generated by my webserver. Everything was there and properly formed/presented as I would expect it to be presented. I didn't get any error messages at all, and that was while running SageV9. Not able to follow-up on it now, however. Away from the server for awhile, and it is isolated from the internet, I have Plex for that these days.

[skiingwiz]

This is fixed in Web UI 3.0. Release announcement here