Seth
I am having trouble with some quirks in Visual Studios SSDT (SQL Server Data Tool)
with SSDT I am creating a local copy of my databases schema into a visual studio project but some of my stored procedures reference linked servers and users that are at the server level.
I actually resolved this by just deleting the users folder it imports as well as adding a dummy reference to my local schemas sys.servers table for the linked servers. I also added an IgnoreUnresolvedReferences tag to my .csproj file and this all seemed to make it work swimmingly
8 replies
Trouble Streaming Video Files [Error:416 Range Not Satisfiable] (ASP.NET/Angular)
this has been resolved. I was returning File and then later was returning a FileStreamResult and these must have trouble handling partial ranges. Since there was absolutely no changes from my endpoint to my middleware I just took out the FileStreamResult and instead wrote to the response body/headers directly and returned a new EmptyResult().
Im shocked it worked. I am led to believe File or FileStreamResult screws up when handling partial ranges.... I am too inexperienced with partial downloading and streaming to have any other insight lol
8 replies
Trouble Streaming Video Files [Error:416 Range Not Satisfiable] (ASP.NET/Angular)
It got deeper, so I started hitting the request with postman with hard coded byte request ranges. I could successfully get the video as long as my requested bytes was 0. I could set the end byte request to anything within the file size and I get it.
However, when I set the start byte to 1 I DO get a 206 partial content success, but I cannot stream the video. The video player seems to just be stuck.
Heres where it gets weird, if I make the start byte HALF of the total file size I get a 416 error response.
So my findings so far are:
1. I can partially download just fine if the byte start is 0
2. Despite the controller logic working fine, when the start byte is larger than HALF the video file size, it returns a 416 error and changes the content-range with a wrong byte size (
example: Content-Range=bytes */135152)
Could this have to do with .mp4 metadata or something?8 replies
Trouble Streaming Video Files [Error:416 Range Not Satisfiable] (ASP.NET/Angular)
@network problem Hey sorry for the late reply, I mustve had this server muted. I ended up making a middleware that logs the request and verified somewhere in my pipeline the response changes to 416 and the header content range changes to the
Content-Range=bytes */135152.
Its interesting because when I go line by line in the controller it works perfectly, grabs the perfect amount of content/bytes, sets the content range to the right values and so on... This is a simpler API and doesnt have any custom middleware I put on so I am wondering why is it getting screwed up before sending back to the client?8 replies