Select Page
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 Screenshot:

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!
Happy Reading!!
Secured By miniOrange