on 09-09-2014 4:34 PM
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:
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi, Nico,
Yes that's sounds such familiar to my case .
I can suggest you to reinstall SAP IQ in such order:
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
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}"
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
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
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
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
Hello
the Document - SAP First Guidance – SAP NLS Solution with SAP IQ explains how to setup the SAP IQ Cockpit sucessfully
Best Regards Roland
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, Saroj,
Thank you for your feedback.
I have a couple of questions:
Thank you in advance.
Best regards,
Donatas Budrys
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, Gi-Sung Jang,
Thank you for your feedback. I will investigate your suggestions for sure.
A couple of questions:
Thank you.
Best regards,
Donatas
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
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
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.