The error 'Report execution failed due to time out after 180 seconds. Please try again or increase the timeout using CLI' can be due to a CUIC property 'report-query-timeout'. This timeout can be increased via below steps:
Steps to set CUIC report-query-timeout properties:
1. Login to CUIC CLI
2. Run below command
admin: set cuic properties report-query-timeout 240 // In this command 240 is the timeout value to be set. cuic.query.timeout has been updated // After running the above command successfully, you would see this line.
Note: This command requires a restart of Intelligence Center Reporting Service. Ensure that this command is executed on all nodes in the cluster.
Once service restart is done and you run the CUIC report, you should see the error 'Report execution failed due to time out after XXX seconds. Please try again or increase the timeout using CLI' only after XXX seconds where XXX is the new timeout set. In our above command, it is 240.
In my case, I was able to get this sorted out and hope you too would be.