Jump to content

Playback Reporting - Missing Playback Chart after Update

redaktorn

By redaktorn
in Plugins

 Share

Recommended Posts

redaktorn

redaktorn 23

Posted
Posted (edited)

Hi,

 

I just updated to server version 4.1.1.0

Running EMBY Server on a Linux Mint 18.3 system.

 

After updated I noticed that the graphical chart disappered in plugin "Playback Reporting" under "Playback".

Marked in yellow in attachment.

I also attach the chart as it use to look before it disappear.

 

There used to be a nice chart showing playtime with all users that has been active last 4 weeks.

 

I am rather sure this problem is not because of my system.

I check this plugin every evening to see what is going on and it has always worked just fine.

The chart disappered just after I updated to latest EMBY Server this evening.

(Which I did just 20 minutes ago)

 

Hope it gets working again, because I really appreciate that plugin.

 

P.S: The problem is also visable under "Breakdown" where "Breakdown user" does not show anything.

Seems that the plugin can not reach the user information in system?

post-163695-0-65812900-1556672209_thumb.jpg

post-163695-0-10736100-1556672219_thumb.jpg

Edited by redaktorn
Happy2Play

Happy2Play 9780

Posted
Posted

Probably need to post a server log.  What is the plugin version number?  Everything appears to be functioning on my Windows 4.1.1.0, plugin v1.3.1.0.

Luke Emby Team

Luke 42077

Posted
Posted

What version of the plugin do you have?

redaktorn

redaktorn 23

Posted
  • Author
Posted

Hi Friends,
 
Thanks for reply.

The problem has nothing to do with browser.
I have tried several different computers running Linux and Windows 10.
Using Firefox, Chrome and Edge browsers.
 
My plugin has version 1.3.1.0 (I believe it is the latest)
 
Attaching a log (with cleaned up IP)

embyserver.txt

Happy2Play

Happy2Play 9780

Posted
Posted

It has to be something specific to your setup or everyone would have this issue.

 

But there appears to be a specific error though.

2019-05-03 00:25:24.752 Info HttpServer: HTTP Response 200 to 192.168.110.1. Time: 3ms. http://xxxxx.xxxxx.xx:8096/emby/user_usage_stats/DeviceName/BreakdownReport?days=28&end_date=2019-05-03&stamp=1556835925423
2019-05-03 00:25:24.753 Error HttpServer: Error processing request
	*** Error Report ***
	Version: 4.1.1.0
	Command line: /opt/emby-server/system/EmbyServer.dll -programdata /var/lib/emby -ffdetect /opt/emby-server/bin/ffdetect -ffmpeg /opt/emby-server/bin/ffmpeg -ffprobe /opt/emby-server/bin/ffprobe -restartexitcode 3 -updatepackage emby-server-deb_{version}_amd64.deb
	Operating system: Unix 4.15.0.48
	64-Bit OS: True
	64-Bit Process: True
	User Interactive: True
	Runtime: file:///opt/emby-server/system/System.Private.CoreLib.dll
	Processor count: 4
	Program data path: /var/lib/emby
	Application directory: /opt/emby-server/system
	System.FormatException: System.FormatException: Unrecognized Guid format.
	   at System.Guid.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument, String failureArgumentName, Exception innerException)
	   at System.Guid.TryParseGuid(ReadOnlySpan`1 guidString, GuidStyles flags, GuidResult& result)
	   at System.Guid..ctor(String g)
	   at playback_reporting.Api.UserActivityAPI.Get(GetBreakdownReport request)
	   at Emby.Server.Implementations.Services.ServiceExecGeneral.Execute(Type serviceType, IRequest request, Object instance, Object requestDto, String requestName)
	   at Emby.Server.Implementations.Services.ServiceController.Execute(HttpListenerHost appHost, Object requestDto, IRequest req)
	   at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, ILogger logger, String operationName, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IRequest httpReq, String urlString, String host, String localPath, CancellationToken cancellationToken)
	Source: System.Private.CoreLib
	TargetSite: Void SetFailure(ParseFailureKind, System.String, System.Object, System.String, System.Exception)
	
2019-05-03 00:25:24.753 Info HttpServer: HTTP Response 500 to 192.168.110.1. Time: 12ms. http://xxxxx.xxxxx.xx:8096/emby/user_usage_stats/UserId/BreakdownReport?days=28&end_date=2019-05-03&stamp=1556835925420
redaktorn

redaktorn 23

Posted
  • Author
Posted

 

It has to be something specific to your setup or everyone would have this issue.

 

But there appears to be a specific error though.

2019-05-03 00:25:24.752 Info HttpServer: HTTP Response 200 to 192.168.110.1. Time: 3ms. http://xxxxx.xxxxx.xx:8096/emby/user_usage_stats/DeviceName/BreakdownReport?days=28&end_date=2019-05-03&stamp=1556835925423
2019-05-03 00:25:24.753 Error HttpServer: Error processing request
	*** Error Report ***
	Version: 4.1.1.0
	Command line: /opt/emby-server/system/EmbyServer.dll -programdata /var/lib/emby -ffdetect /opt/emby-server/bin/ffdetect -ffmpeg /opt/emby-server/bin/ffmpeg -ffprobe /opt/emby-server/bin/ffprobe -restartexitcode 3 -updatepackage emby-server-deb_{version}_amd64.deb
	Operating system: Unix 4.15.0.48
	64-Bit OS: True
	64-Bit Process: True
	User Interactive: True
	Runtime: file:///opt/emby-server/system/System.Private.CoreLib.dll
	Processor count: 4
	Program data path: /var/lib/emby
	Application directory: /opt/emby-server/system
	System.FormatException: System.FormatException: Unrecognized Guid format.
	   at System.Guid.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument, String failureArgumentName, Exception innerException)
	   at System.Guid.TryParseGuid(ReadOnlySpan`1 guidString, GuidStyles flags, GuidResult& result)
	   at System.Guid..ctor(String g)
	   at playback_reporting.Api.UserActivityAPI.Get(GetBreakdownReport request)
	   at Emby.Server.Implementations.Services.ServiceExecGeneral.Execute(Type serviceType, IRequest request, Object instance, Object requestDto, String requestName)
	   at Emby.Server.Implementations.Services.ServiceController.Execute(HttpListenerHost appHost, Object requestDto, IRequest req)
	   at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, ILogger logger, String operationName, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IRequest httpReq, String urlString, String host, String localPath, CancellationToken cancellationToken)
	Source: System.Private.CoreLib
	TargetSite: Void SetFailure(ParseFailureKind, System.String, System.Object, System.String, System.Exception)
	
2019-05-03 00:25:24.753 Info HttpServer: HTTP Response 500 to 192.168.110.1. Time: 12ms. http://xxxxx.xxxxx.xx:8096/emby/user_usage_stats/UserId/BreakdownReport?days=28&end_date=2019-05-03&stamp=1556835925420

 

OK "Specific error" - any idea what that would be?

Do you think it might help if I uninstall the plugin and install again?

Any setting/configuration files I can/should delete before installing again?

redaktorn

redaktorn 23

Posted
  • Author
Posted (edited)

I think it is something weird in your collected data.

 

On the plugin page there is a Query Tab at the top, go to that tab and enter the following query and hit run

SELECT DISTINCT UserId
FROM PlaybackActivity

Then click the "Replace UserId with UserName" check box and run it again.

 

Post or PM to me both your results.

 

I runned the queries you asked for.

It seems to be normal reply on those.

(Files attached)

post-163695-0-48065400-1556850541_thumb.jpg

post-163695-0-91094100-1556850552_thumb.jpg

Edited by redaktorn
redaktorn

redaktorn 23

Posted
  • Author
Posted

Hmm that is super weird, I will keep looking

 

Seems I have a strange problem. Thanks for looking into it.

I will try to uninstall/install in the coming weekend. Maybe that can help.

ThePaladinTech

ThePaladinTech 22

Posted
Posted (edited)

I just installed this plugin on three servers - and they all look like redaktorn's :( - Further I have this error in my logs:

2019-05-02 22:53:55.447 Error PlaybackReporting - EventMonitorEntryPoint: Error loading PlaybackActivity database file.
	*** Error Report ***
	Version: 4.1.1.0
	Command line: C:\Users\Jeff\AppData\Roaming\Emby-Server\system\EmbyServer.dll -noautorunwebapp
	Operating system: Microsoft Windows NT 6.2.9200.0
	64-Bit OS: True
	64-Bit Process: True
	User Interactive: True
	Runtime: file:///C:/Users/Jeff/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll
	Processor count: 8
	Program data path: C:\Users\Jeff\AppData\Roaming\Emby-Server
	Application directory: C:\Users\Jeff\AppData\Roaming\Emby-Server\system
	SQLitePCL.pretty.SQLiteException: Error: no such table: PlaybackActivity
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
	   at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
	   at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql, Object[] values)
	   at playback_reporting.Data.ActivityRepository.InitializeInternal()
	   at playback_reporting.Data.ActivityRepository.Initialize()
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCL.sqlite3, Int32)
	
2019-05-02 22:53:55.447 Info App: Entry point completed: playback_reporting.EventMonitorEntryPoint. Duration: 0.0177848 seconds

If anything else is needed - or if this belongs in it's own topic let me know. I can get log files for all three servers.

Edited by ThePaladinTech
Happy2Play

Happy2Play 9780

Posted
Posted (edited)

I just installed this plugin on three servers - and they all look like redaktorn's :( - Further I have this error in my logs:

2019-05-02 22:53:55.447 Error PlaybackReporting - EventMonitorEntryPoint: Error loading PlaybackActivity database file.
	*** Error Report ***
	Version: 4.1.1.0
	Command line: C:\Users\Jeff\AppData\Roaming\Emby-Server\system\EmbyServer.dll -noautorunwebapp
	Operating system: Microsoft Windows NT 6.2.9200.0
	64-Bit OS: True
	64-Bit Process: True
	User Interactive: True
	Runtime: file:///C:/Users/Jeff/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll
	Processor count: 8
	Program data path: C:\Users\Jeff\AppData\Roaming\Emby-Server
	Application directory: C:\Users\Jeff\AppData\Roaming\Emby-Server\system
	SQLitePCL.pretty.SQLiteException: Error: no such table: PlaybackActivity
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
	   at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
	   at SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, String sql, Object[] values)
	   at playback_reporting.Data.ActivityRepository.InitializeInternal()
	   at playback_reporting.Data.ActivityRepository.Initialize()
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCL.sqlite3, Int32)
	
2019-05-02 22:53:55.447 Info App: Entry point completed: playback_reporting.EventMonitorEntryPoint. Duration: 0.0177848 seconds

If anything else is needed - or if this belongs in it's own topic let me know. I can get log files for all three servers.

 

Don't know if it is related to OP, but I just installed plugin on a portable install and got the same thing.  I am currently restarting the machine as there are pending OS updates to see if it makes a difference.

Edited by Happy2Play
redaktorn

redaktorn 23

Posted
  • Author
Posted

Hi TeamB,

 

You are really quick to respond - Thank you.

 

It seems that you solved the chart under "Playback reporting" - "Playback".

But it is still missing under "Playback reporting" - "Breakdown".

 

See pictures attached.

post-163695-0-95881100-1556866738_thumb.jpg

post-163695-0-79176100-1556866752_thumb.jpg

  • Like 1
redaktorn

redaktorn 23

Posted
  • Author
Posted

Ok based on your image from above it looks like I was correct the first time, I have no idea why my query did not show your user issue last time.

It looks like your user list has an extra entry that is null or empty, you can see this in the above image with the color block with no name next to it.

 

Can you try running this query in the Query tab

 

SELECT ROWID, *
FROM PlaybackActivity
WHERE UserId is null OR UserId = ''

post your results

 

Hi TeamB,

 

Thanks for all your help

 

Yes I have an empty user because I deleted one user yesterday that was not active in a year.

But deleting a user should not cause an error - or?

I can reset the database and start over if you tell me how to do.

 

I don't think that the deleted user caused the problem under "Breakdown".

That problem was there before i deleted that user.

Maybe you need to do the same kind of coding in that page as you did in "Playback"?

 

Attached the result of the query.

post-163695-0-12325700-1556873743_thumb.jpg

redaktorn

redaktorn 23

Posted
  • Author
Posted

Anybody else who can confirm (or not) that they have the same problem under "Breakdown"

(No chart under user breakdown - just empty)

 

See attachment

post-163695-0-04803300-1556874265_thumb.jpg

redaktorn

redaktorn 23

Posted
  • Author
Posted

 

boom there it is, entry 3965 is all sorts of %^&* up

 

Run this in the query TAB

DELETE FROM PlaybackActivity WHERE ROWID = 3965

 

Ok - query done.

See attchment

 

I think that line was added because that song was played by DLNA.

(I normally don't use DLNA but I probably have been testing some time)

redaktorn

redaktorn 23

Posted
  • Author
Posted

Problem solved

 

Seems it was that line that caused the problem under "Breakdown by User".

Now it works again  :)

 

TeamB - Thank you very much for your kind help.

 

Last question in this subject: Does this mean that I should avoid playing anything by DLNA? 

post-163695-0-59984800-1556874773_thumb.jpg

redaktorn

redaktorn 23

Posted
  • Author
Posted

That query should have deleted one entry and you should now be able to view all the charts

 

Yes I can see all charts now - Thank you.

Was it because that line was added when playing by DLNA?

(Or was it just a coincidence maybe?)

ThePaladinTech

ThePaladinTech 22

Posted
Posted

Looks like mine is working :) did you also update tvdb? Once both of those updated my user slack notifications started working again as well. Thank you

ThePaladinTech

ThePaladinTech 22

Posted
Posted

I Think we are really going to enjoy this plugin. Right now there's no data as i just installed it (when it was broke). But now i see the magic it does, I'll need to show my brother. Thank you again

redaktorn

redaktorn 23

Posted
  • Author
Posted

After looking at this, testing and bit and talking to the Emby devs you are safe to use DLNA players however they will not show up in the results as DLNA players current need a little work in Emby for this to be supported.

OK - good to know.

Thanks again for all kind help.

horstepipe

horstepipe 422

Posted
Posted (edited)

hey guys,

sorry to interrupt, but where is the main thread for the playback reporting plugin? Looks like it was being deleted...?

Edited by horstepipe

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...