The proxy server received an invalid response from an upstream server.
I get the above error when I export from a cube I created with SQL source data import. Cube has 3 SQL sources instead of a union query from cwd_user. Included queries below. I could have used union, but was testing each individually and left it because it was easy to define measures for each in the cube that way.
Alternatively I get
The page you were looking for doesn’t exist.
You may have mistyped the address or the page may have moved.
SELECT u.user_name, u.display_name, u.active, m.parent_name group_name, attr.attribute_name,
attr.attribute_value as login_count, 1 as user_count
FROM cwd_user u
left join cwd_membership m on m.child_id = u.id
left join cwd_user_attributes attr on attr.user_id = u.id
where m.parent_name is null
and attr.attribute_name=‘invalidPasswordAttempts’
and u.active=0
SELECT u.user_name, u.display_name, u.active, m.parent_name group_name, attr.attribute_name,
attr.attribute_value as login_count, 1 as user_count
FROM cwd_user u
left join cwd_membership m on m.child_id = u.id
left join cwd_user_attributes attr on attr.user_id = u.id
where attr.attribute_value is null
SELECT u.user_name, u.display_name, u.active, m.parent_name group_name, attr.attribute_name,
attr.attribute_value as login_count, 1 as user_count
FROM cwd_user u
left join cwd_membership m on m.child_id = u.id
left join cwd_user_attributes attr on attr.user_id = u.id
WHERE m.membership_type = ‘GROUP_USER’
and attr.attribute_name = ‘login.count’