Recently was working on setting up Oracle 11.x environment on MicroStrategy & faced the below issue on opening the WH Catalog and also while creating the DSN through MicroStrategy Connectivity Wizard.
Issue Resolution Steps:
- Verify the Port Number – whether it is correctly mentioned while creating the ODBC DSN
- Verify whether you are able to connect to HOST Name from MSTR Servers
- Verify WH Catalog Read Settings are defined properly – try at least with default settings first
- Verify that there are no trial space in the end of HOST NAME – as this happens when we COPY + PASTE the details from email/some other sources – hence, this issue could occur due to that
Hope it helps everyone!