Skip to Content

SAP IQ Server is missing in SAP Cockpit login window

Hello,

Our SAP IQ 16.0 SP08 Single Server is missing in SAP Cockpit 4 login window System field.

We have installed SAP IQ 16.0, then updated it to SP08 and by doing that we have installed a new SAP Cockpit 4 server. Cockpit service is starting successfully, we can successfully open Cockpit web portal and see the Cockpit login window. But no SAP IQ server is displayed in the System field so far. Then we have executed Cockpit Monitor script, restarted database and then restarted Cockpit. But our SAP IQ database is still missing in the Cockpit login window.

So:

  1. SAP IQ Server 16.0 SP08 is installed and operating.
  2. SAP Cockpit is installed and running.
  3. SAP IQ database is running.
  4. Cockpit Monitor scripts are applied to the database.
  5. SAP SCC was not installed and is not running.

And still no IQ database in the Cockpit login window.

Any step missing, something not implemented or applied?

Any ideas why SAP IQ database is missing in the Cockpit login window?

Thank you in advance.

Best regards,

Donatas

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Sep 15, 2014 at 08:53 AM

    Hello, All,

    After a thorough testing and analysis I have finally found out the solution. All I had to do was to install both SAP IQ Cockpit and SAP Control Center. So after reinstalling SAP IQ 16.0 SP08 version now I can see my IQ database in the Login window.

    Best regards,

    Donatas Budrys

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2016 at 03:08 PM

    I ran into the very same problem today, after a (inplace) RESTORE to a different database name (and dbfile location).

    Running SAP IQ/16.0.0.809/150514/P/sp08.32/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit.

    Restarting IQCOCKPIT presented the old dbname only in the dropdown login window, but that dbname did no longer exist. No way to connect to the new db.

    This solution worked for me:

    After removing the sqlanywhere database subfolder <db> in <COCKPIT-4/services/repository> a new <db> folder (including all relevant db files) will be created with next restart of IQCOCKPIT. Connecting to IQCOCKPIT from your browser for the first time will offer you (unfortunately) an empty dropdown list only. However, if you shutdown cockpit and restart again, it will offer you the new database in the list. In one situation I had to Refresh within the browser to make this happen.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2014 at 12:35 AM

    Hi

    First of all, you need to check the hosts file on your client system.

    hosts file has to include some information such as "host/ipaddress" and so forth..

    In my case, I found out that the issue is related to OS System.

    If I installed IQ16 SP08 on window 2008 R2 (English version) or added a package of english language.

    And then I changed display language from korean to english.

    I succeeded to log in to cockpit console.


    And the cockpit related log files are helpful to investigate the root causes.


    thanks

    Gi-Sung Jang

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I have reviewed and corrected HOSTS file. Also set Windows OS locales to English - nothing helped.

      Also I've done a brief analysis of Cockpit log files - it didn't show any incorrect behavior or critical errors. Log file stated that all services including Cockpit Agent are started and running. By the way I have another SAP IQ machine where Cockpit is running correctly - but can't find any differences between those two machines that could show me why Cockpit is working incorrectly.

      Any more ideas?

      Thank you.

      Donatas

  • Oct 22, 2014 at 11:50 AM

    Hello,


    I had the same issue after following the guide "SAP First Guidance - SAP- NLS Solution with Sybase IQ".

    In my case this was caused by a parameter from the database configuration file ".cfg".

    I have deleted the below lines from my ".cfg" file and afterwards the database was visible in IQ Cockpit.

    "#### Prevent UDP connection support

    -sb 0"

    Kind regards,
    Theo

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 06, 2014 at 02:10 PM

    Hi Donatas,

    Irrespectively what order I had installed IQ 16 :
    1. Only 16-8.1 since it is full package - Cockpit list empty

    2. added SP2, SP3 - Cockpit list empty

    3. IQ 16.0 without SCC, than IQ 16-8.1 - Cockpit list empty

    4. added SP2, SP3 - Cockpit list empty

    5. same as 3. 4. but skipped SP2 - Cockpit list empty

    IQ runs fine, SCC works as well, even Central for 15.2 can access IQ 16.08.3

    I have run out of ideas what else could be done.

    BTW, the servers are on SLE 11 SP3 for SAP

    BR

    Ferenc

    Add comment
    10|10000 characters needed characters exceeded

    • Hello, Saroj,

      Thank you for your feedback.

      I have a couple of questions:

      1. Can you please take a look and provide your opinion regarding SAP DS and IQ compatibility problems described in this post - http://scn.sap.com/thread/3619164?
      2. When the new minor version of SAP IQ i.e. SAP IQ 16.1 or ne SP will be released (is planned to be released)?

      Thank you in advance.

      Best regards,

      Donatas Budrys