NextEnd v5 trial release

[mvallevand]

I am pretty sure it failing to load the 64 bit e_sqlite3.dll if you put it with nextend I expect it will work. I can't figure out the difference between our setups.

Martin

Martin

[BrettB]

I am pretty sure it failing to load the 64 bit e_sqlite3.dll if you put it with nextend I expect it will work. I can't figure out the difference between our setups.

I've got the following e_sqlite3.dll files in my C:\Program Files\NPVRv5 directory tree:
[ATTACHMENT NOT FOUND]

I copied the one from the root of the tree to the NextEnd folder, but still got the same error:

Code:

2019-09-02 13:48:18.942    [ERROR][1]    Unexpected error in EPGEvent.LoadByOID(): System.InvalidOperationException: Must add values for the following parameters: ,
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at NUtility.EPGEvent.GetListingsForTimePeriod(DateTime startTime, DateTime endTime)

For completeness, I'm uploading another full set of logs.

[mvallevand]

Can I get a copy of your database?

Martin

[BrettB]

Can I get a copy of your database?

Just sent you a link to download a copy.

[mvallevand]

Getting further...

It's installed and my startup script now runs it OK. But then NextEnd.exe gets an error

Code:

2019-09-02 12:00:41.977    [ERROR][1]    Unexpected error in EPGEvent.LoadByOID(): System.InvalidOperationException: Must add values for the following parameters: ,
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at NUtility.EPGEvent.GetListingsForTimePeriod(DateTime startTime, DateTime endTime)

The good news is I get this error with your database. The bad news is I've been wasting your time I get this error with my database too but the error is handled in NUtility so I didn't see it going to the console. It might be NUtility,

sub if you read this thread does NUtility.GetListingsForTimePeriod() have the sqlite parameters setup right for you in v5? GetListingsForTimePeriodForChannel() seems to be working as a comparison. The logged EPGEvent.LoadByOID() message is misleading.

Martin

[sub]

The good news is I get this error with your database. The bad news is I've been wasting your time I get this error with my database too but the error is handled in NUtility so I didn't see it going to the console. It might be NUtility,

sub if you read this thread does NUtility.GetListingsForTimePeriod() have the sqlite parameters setup right for you in v5? GetListingsForTimePeriodForChannel() seems to be working as a comparison. The logged EPGEvent.LoadByOID() message is misleading.

Martin

Sorry - been busy with day job stuff the last few days.

I've fixed NUtility.GetListingsForTimePeriod() for the next build. I haven't been using this call, and it was broken with a slight difference in .NET Core relating to DB stuff.

[mvallevand]

Thanks sub for the fix in the current beta. It is an important call for NextEnd since for jit monitoring I just care if a sporting event is in the hour preceding the start time. Otherwise I would need to load all the channels and check each separately.

Brett and other having issues with jit monitoring you can continue using your existing NextEnd setup. Tommorow's Sunday NFL week 1 is a good time to test the monitor function.

Martin

[BrettB]

Brett and other having issues with jit monitoring you can continue using your existing NextEnd setup. Tommorow's Sunday NFL week 1 is a good time to test the monitor function.

So far so good. No more error:

Code:

[...startup]
2019-09-07 16:19:51.405    [DEBUG][1]    NextEnd, Version=3.0.7177.32862, Culture=neutral, PublicKeyToken=null
2019-09-07 16:19:51.497    [INFO][1]    Using remote RecordingService
2019-09-07 16:19:51.498    [DEBUG][1]    Command Line --monitor --jit
2019-09-07 16:19:51.507    [DEBUG][1]    Sunday check
2019-09-07 16:19:51.521    [DEBUG][1]    Nothing to do until Sunday it is Saturday
2019-09-07 16:19:51.523    [DEBUG][1]    Late night check
2019-09-07 16:19:51.536    [DEBUG][1]    Checking for recordings from 2019-09-07 21:35:00 to 2019-09-08 00:35:00
2019-09-07 16:19:51.536    [DEBUG][1]    Checking for sports to monitor
2019-09-07 16:19:51.559    [DEBUG][1]    Database: C:\Users\Public\NPVR-data\npvr.db3
2019-09-07 16:19:52.079    [DEBUG][1]    Found College Football
2019-09-07 16:19:52.087    [DEBUG][1]    Long sleep time 5:25:07
2019-09-07 16:19:52.090    [DEBUG][1]    Requesting wake up for 'nextend-reload' [] at 9/7/2019 9:44 PM

[CDinger]

Martin,

Sorry, I am having trouble understanding the directions. I did step A as quoted below on Ubuntu 18.04. I skipped step 2 as it seemed to only apply to Windows installations.

For running Nextend shouldn't it be in ParallelProcessing.sh? Previously it was in ParallelProcessing.bat

For /opt/dotnet/dotnet /var/opt/nextpvr/Plugins/NextEnd/NextEnd.dll options ...... does options refer to command line option like --oid $3 --postgame 15?

my ParallellProcessing.sh file contains the following line
/opt/dotnet/dotnet /var/opt/nextpvr/Plugins/NextEnd/NextEnd.dll --oid %3 --postgame 15

Thanks for all your help,

Craig

Installation instructions

A. If you install the Windows Netcore 2.2 runtime on Window 64 or use any other platfrom

1. Unzip attached zip file into a folder Plugins/NextEnd in the v5 user data folder. Case is important outside windows. I kept the v4 upper case, but that will likely change.

2. If you aren't running in C:\Program Files\NPVR edit NextEnd.runtimeconfiguration and change the D:\\v5\\programs to your binary folder keeping the trailing blanks

3. On linux it might be tougher you also need to run this

Code:

sed -e 's/\"\/\"/\"\/opt\/nextpvr\/system\/\"/g' NextEnd.deps.json

Note that only the dep installer is supported at this time.



Running

For PostProcessing

Windows 64

Drive:\NextEnd Install folder\NextEnd.exe options

Linux

/opt/dotnet/dotnet /var/opt/nextpvr/Plugins/NextEnd/NextEnd.dll options


Martin

[mvallevand]

Yes use .sh instead of .bat in Linux and use $ instead of % for variables. The case of the file name is important too. Finally make sure you chmod +x the script
Martin