Data view runs but UDR gives Results cannot be retrieved

I created a Data View that has a sub join that does a count based off a condition.

Here is the condition:

COUNT(CASE WHEN upper(STATUS) = 'COMPLETE' and uuu_tab_id = 0 then 1 end) Value1

The data view comes back with all the information and no errors. When I create a UDR against this data view I get a response that says Results cannot be retrieved. Please contact System Administrator.

I also ran a get udr rest call and I have the following response.

{

 "data": [ ],

 "message": [ "Server Error, contact the system administrator." ],

 "status":500

}

Has anyone ever had this issue when running a DV in a UDR. This is the first time I have ever had this issue. I am wondering if it has to do with the Count Case statement.