700+ videos have failed encoding

[msb]

An example is "rxpWIr5q" the SMS url is http://downloads.sms.cam.ac.uk:8074/2sYshTw1RVKkKxIdpMU8VwqgLRsdFaya/sms-archive02//638155/670674.mp4

.. needs further investigation

[abrahammartin]

The JWPlaftorm API now supports //video/error and //video/error/message that will tell us which videos have failed in combination with //video/status

webapp=# SELECT (data -> 'error' ->> 'message') message, COUNT(*) count FROM smsjwplatform_cachedresource WHERE (data ->> 'status') = 'failed' GROUP BY message;
                    message                     | count 
------------------------------------------------+-------
 Maximum transcode attempts exceeded            |   249
 Media file contains no recognized media stream |    14
 Original not found                             |     5
 System failure in conversion creation          |     1
(4 rows)

Not sure what "Maximum transcode attempts exceeded" means versus "Media file contains no recognized media stream" but it at least means we can identify those we should try uploading again

[abrahammartin]

Another way to tell if a video has failed uploading is to order videos by length in the JWPlatform dashboard. They should show as N/A.