Recording Lost

[sub]

Thanks sub for your reply. I changed my postprocessing.bat to set the correct Greek codepage (Windows-1253):
by adding the command:

chcp 1253>NUL

But Is this really the problem?

I don't know

I see from the logs you reference the OID passed to the .bat file was 989:

[color=#696969]`oid`=989

However in my database it only exist OID=991 and 992 if you take a look at the screenshots I uploaded. 
This is why the update failed most likely...

any ideas why the wrong OID was passed to the .bat file?

That definitely seemed to be the OID.

2020-03-10 03:00:00.242 [DEBUG][9] Stopping recording (989 on 23). Past end time of recording. 102

[aderlopas]

Thait is interesting, 

Today same recording started. I see now the 991 OID is being recorded as well as another small recording I added only once for testing (OID 993)...as per the schreenshot I upload.

That makes me think that ODI 989 was somehow deleted from the database as it is no longer there....

So it was not that my database update failed, the entry was somehow deleted...

Could it be due to the fact that recording starts one day and it finishes another (next day)?

[mvallevand]

Recordings get deleted from the table when they aren't found. That would include issues when there is a mismatch between unicode, utc and code page character sets.

Martin

[aderlopas]

Recordings get deleted from the table when they aren't found.  That would include issues when there is a mismatch between unicode,  utc and code page character sets.

Martin

thanks Martin, now we are getting closer I believe...

so if Database is UTF-8 (is it?), which encoding should I properly set via chcp command in postprocessing.bat?

chcp 1253  (which is Greek Codepage) or 
chcp 65001 (which is UTF-8 codepage)

[aderlopas]

OK, in the meantime I tried chcp 65001 (UTF-8) and it updated the database as "BLOB" and the recording was removed from the list.
Will try now chcp 1253 (Greek) instead...

[mvallevand]

During testing I'd change config.xml to not remove missing files.

Martin

[aderlopas]

During testing I'd change config.xml to not remove missing files.

Martin

thanks for the suggestion Martin, which option in config.xml would that be?

[sub]

<AutoRemoveMissingRecordings>

[aderlopas]

<AutoRemoveMissingRecordings>

Many thanks Sub

[aderlopas]

Recordings get deleted from the table when they aren't found.  That would include issues when there is a mismatch between unicode,  utc and code page character sets.

Martin

Hi,

coming back to this it seems that sqllite3.exe cannot handle UTF-8.
And from what I have checkd npvr.db3 is built using Macintosh UTF-8.
As such, there is no way that from command line using the sqllite3.exe utility to make a proper update using Greek characters.

Instead, if we could run a powershell post processing script, then I would be able to setup the connection library to make automatic conversion between 1253 codepage and UTF-8 so that Greek texts is updated correctly inside the database.

Would it be possible to call a postprocessing powershell script instead?