MicroStrategy Report is taking too much time to execute

Troubleshooting steps
1. Check the report SQL generated in different environments (PROD, UAT and DEV). Match the SQL generated. Technically they *must* match. If they are NOT matching, you need to correct your attribute definition and/or parent-child relationship. FYI, Tedatada is not so forgiving for mismatched column types in database and as declared in attribute form definition.
2. Check the Load on database server. It may be offline, too much loaded with requests.
3. Job priority in the Server can 32432432a report in queue for long/infinite. Check MicroStrategy System Monitor under Project Source Administration.
4. Verify that you SQL is being run against the correct database. Check the Project DB Instance.
5. Your schema object definition is up to date. Try updating Schema.
6. Non MicroStrategy cause: Some Web Server load balancer can made to time out a query/request if not resolved under a stupulated time. Check Load Balance team.


Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Warning: count(): Parameter must be an array or an object that implements Countable in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 399