SAP IQ Server is missing in SAP Cockpit login window

[Donatas]

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

[Donatas · Accepted solution]

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

[Gisung · Accepted solution]

Hi,

Good news!!

Regards,

Gi-sung Jang

[Former Member · Accepted solution]

Hi Donatas,

I have the same problem. I installed SAP IQ 16.0 and upgraded to SP8 (and also SP8 patch 3). After the installation of IQ16.0 SCC was already installed and after upgrading to SP8 I had both SCC 3.3 and Cockpit 4.

When I open the SCC URL I can access all monitoring and configuration tasks of IQ but when I open the cockpit URL I don't see any server. I also tried to change the browser language and added the server to my host file on my client. but no luck.

You mention that you installed SCC but that is already working, so do you have any other option for me?

Kind Regards,

Nico van der Linden

[Donatas · Accepted solution]

Hi, Nico,

Yes that's sounds such familiar to my case .

I can suggest you to reinstall SAP IQ in such order:

1. Install SAP IQ 16.0 SP00 without SCC.
2. Upgrade SAP IQ 16.0 SP00 with SP08. During this upgrade select both SCC 3.3 and IQ Cockpit options.
3. Start IQ demo database and connect to it via Interactive SQL.
4. Restart IQ Cockpit.
5. After some 5 minutes try to launch IQ Cockpit.

This procedure worked for me in 3 different installations.

By the way - when I have installed SP08 Patches 1, 2 and 3 my IQ Cockpit got corrupted - IQ Cockpit Explore tab got empty.

Good luck .

Regards,

Donatas Budrys

[Former Member · Accepted solution]

Hi donatas,

thanks for your answer. I tried it once more according to your approach although I did upgrade tot SPS08.1. Now I do see a selection where I can choose from "myserver" or "iq16_utility" in either option I cannot however logon with either sccadmin or uafadmin. It simply gives "Login failed."

Any idea what might go wrong here? I have no issues with logging on with the same accounts to scc though.

Kind Regards.

Nico van der Linden

Edit:

I am new to sybase IQ and try to install it for the usage of NLS based on a document provided on sdn. I start the utility_db with the command:

start_iq -n iq16_utility -gp 4096 -x "tcpip{PORT=2638}"

and then I create an database with the isql tool which I start with:

dbisql -c "uid=dba;pwd=sql;eng=myserver;dbn=utility_db"

So now I see that "myserver" and "iq16_utility" are coming from here. However, in the isql utility I created a database with the command "

CREATE DATABASE 'SAPIQDB.db'" (and of course some more parameters). After that I created "SAPIQDB.cfg" and started the database successfully through:

export IQTMP16=/usr/sap/NLS/SAPIQ/sapdata/tmp

start_iq @SAPIQDB.cfg SAPIQDB.db

On SCC I can successfully see this database and according to the documentation I found I should see "sapiqdb" in the system drop down list on the COCKPIT but that is still missing.

Do you have any idea if I am missing a step here or what might go wrong? e.g. where does the cockpit get its list of servers from? The document I used to install Sybase can be found here by the way:

Message was edited by: N. van der Linden

[Donatas · Accepted solution]

Hello, Nico,

Just use the database usename and password when connecting to the IQ Cockpit. Not the sccadmin or uafadmin .

Have a nice day.

Best regards,

Donatas Budrys

[Former Member · Accepted solution]

Hi Donatas,

yes thanks for that, I had an old guide of the one I mentioned before and there they mentioned sccadmin but in the new version indeed the database user was mentioned.

But could you help me out with where the cockpit gets the information from which servers to show in the list? I am wondering why I see the "iq16_utility" and "myserver", shouldn't it show the database name I created? E.g. in SCC I had to manually add a server by hostname and database port number, so how does the cockpit do this?

Kind Regards,

Nico

[Donatas · Accepted solution]

Hi, Nico,

As I understand IQ Cockpit Agent constantly monitors active databases and shows them in the list. Once the database was used it is stored in the IQ Cockpit repository.

I can't comment more details as I don't know how it actually works internally. You could open a new SCN thread for that . It would be interesting to know more details about this process.

Thank you.

Best regards,

Donatas Budrys

[Former Member · Accepted solution]

Hi Donatas,

I have been investigating but that is indeed the way it works.

Finally I succeeded in showing my server into the list of available servers in the cockpit. We now have the NLS on IQ functionality working as well so thanks for your installation advice. I indeed think that this is the best approach, at least it worked for us 🙂

Kind Regards,

Nico van der Linden

[Donatas · Accepted solution]

Hi, Nico,

Thanks for your feedback. I am glad that now you can proceed further.

Have a nice day .

Best regards,

Donatas Budrys

[RolandKramer]

Hello

the Document - SAP First Guidance – SAP NLS Solution with SAP IQ explains how to setup the SAP IQ Cockpit sucessfully

Best Regards Roland

[former_member354103]

Dear All,

I have installed SAP sybase IQ 16.1 SP04 and facing same issue not showing any system in cockpit login window and also unable to login using interactive isql.

Follow this SAP Note :2534600 - How to rebuild SAP IQ Cockpit Repository

Rebuild Cockpit Repository but same issue (Cockpit missing database Server in Cockpit monitor and Explore tab)

Kindly share your experience.

[Former Member]

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.

[Former Member]

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

[saroj_bagai]

Issue have been fixed in SAP IQ 16 sp08.09.

[Donatas]

Thank you, Saroj, for your feedback and information.

Ferenc, could you test SAP IQ 16.0 SP08.09? It would be great to hear if this solves this issue in your environment also.

Looking forward your feedback.

Thank you.

Best regards,

Donatas Budrys

[Donatas]

Hello, Saroj,

I can't find SAP IQ 16.0 SP08 Patch 09 version in the SAP Support Downloads area. The latest patch is 4. Where did you find this patch and information about it?

Thank you.

Regards,

Donatas Budrys

[saroj_bagai]

Do you have incident open? and for which platform do you need this patch?

[Donatas]

Hello, Ferenc,

Would you connect with Saroj regarding SAP IQ 16.0 SP08 Patch 9 which should fix your issue.

Best regards,

Donatas Budrys

[Former Member]

Hi Saroj,

I  have encountered this issue - as i wrote - on SLE 11 SP3 for SAP.

If available, I try SAP IQ 16.0 SP08 Patch 09 to fix this problem, and let you know the result.

BR

Ferenc

[saroj_bagai]

if you want, you can also wait till end of this month, when SAP IQ 16 sp08.20 will be released for all platforms and will be posted on Service Market place

[Donatas]

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

[former_member558196]

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

[Donatas]

Hi, Theodor,

Thank you for your feedback and additional information for this case.

Best regards,

Donatas Budrys

[Gisung]

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

[Donatas]

Hello, Gi-Sung Jang,

Thank you for your feedback. I will investigate your suggestions for sure.

A couple of questions:

1. In my previous post I have provided the steps that were applied in order to configure Cockpit. Are those steps sufficient or anything else should be installed / configured additionally? Did I miss anything?
2. Is it required to install SAP SCC in order for Cockpit to work properly? Or is it enough to install just Cockpit server?

Thank you.

Best regards,

Donatas

[Gisung]

Hi,

As I know SAP SCC is not necessary to use SAP Cockpit.

And if you install IQ16 SP08, the Cockpit module is involved.(Bundle)

So You don't need to install individually.

After running cockpit.sh, you can find some information like below.

cockpit> help

Print help for one or more commands.

Usage:  help <cmd>

    help

    status

    info

    log

    shutdown

    list

thanks

Gi-Sung Jang

[Donatas]

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