Posts

Configure a Netezza connection using ODBC on UNIX

Image
Install the Netezza ODBC driver, and Netezza client libraries. Note If you are running a PowerCenter 32-bit Integration Service, make sure the Netezza 32-bit ODBC driver and client are installed and accessible. If you are running a PowerCenter 64-bit Integration Service, make sure the Netezza 64-bit ODBC driver and client are installed and accessible. Set the following environment variables: NZ_ODBC_INI_PATH Set NZ_ODBC_INI_PATH to $INFA_HOME/ODBCn.n/ Add $INFA_HOME/ODBCn.n/lib:{NetezzaInstallationDir}/lib64 to the shared library environment variable. Solaris LD_LIBRARY_PATH Linux LD_LIBRARY_PATH AIX LIBPATH HP-UX SHLIB_PATH For instance, use the following syntax for Solaris: LD_LIBRARY_PATH Add $INFA_HOME/ODBCn.n/lib:{your Netezza path}/lib64 to the library path ODBCINI Set ODBCINI to ${NZ_ODBC_INI_PATH}/odbc.ini Set the ODBCINI environment variable so that it points to the location of the odbc.ini file. Note If this variable is not set it will look for .odbc.ini in the us...

E4) Cannot connect to admin server at host and post 5498 - ​ Cognos TM1 client not able to connect to TM1 admin server .

Image
​​ Cognos TM1 client not able to connect to TM1 admin server . You must refresh your SSL Certificate or your TM1 System. http://www-01.ibm.com/support/docview.wss?uid=swg21991793 http://www-01.ibm.com/support/docview.wss?uid=swg21991787 http://www-01.ibm.com/support/docview.wss?uid=swg21991790 http://www-01.ibm.com/support/docview.wss?uid=swg21990588 http://www-01.ibm.com/support/docview.wss?uid=swg21990869

How to uninstall the Cognos Content Database

Technote (troubleshooting) Problem(Abstract) If you configured your IBM Cognos environment to use the Cognos Content Database, otherwise known as Derby, as your Content Store and you would like to uninstall it and use a supported database application for you Content Store. Resolving the problem 1) - On the computer where you installed Cognos Content Database, go to the  cognosroot_location \bin directory, and type the following command: On Windows, type derby.bat uninstall This command removes the Cognos Content Database service. On UNIX, type derby.sh stop This command stops the Cognos Content Database service. 2) - In the  cognosroot_location  directory, delete the derby10.* directory. 3) - In the  cognosroot_location \bin directory, delete the following files: On Windows, derby.bat On UNIX, derby.sh and derbyenv.sh 4) - On Windows, in the  cognosroot_location \logs directory, delete the derby.service file. 5) - In the  cognosroot_location  directory, open the cmplst.txt file in a te...

Ambari Name Node Startup Fails when safe mode is on.

I'm having a weird issue trying to restart my hadoop cluster in Ambari after a reboot of all nodes. Despite not making any configuration changes the name node service fails to start with the error below. > Fail: Execution of 'su -s /bin/bash - hdfs -c 'export > PATH=$PATH:/usr/hdp/current/hadoop-client/bin ; hdfs --config > /etc/hadoop/conf dfsadmin -safemode get' | grep 'Safe mode is OFF'' > returned 1. I have looked around and found someone pointing to a non UTF-8 encoding issue but have not had any luck resolving this. Can someone tell me what this error means or how to debug it? Solution The name node service was failing to start because safe mode was on. After reading up on safe mode I realized that is turned on when read only mode is necessary for the name node. I'm not sure what caused it to stay in safe mode but running this command below resolved my issue. sudo -u hdfs hdfs dfsadmin -safemode leave

WAS Federated repositories - Not able to login when any one of the repositories is down

Scenario: In IBM IIS, when the user registry is configured as Federated repositories , we cannot login to WebSphere and any of the IIS components when any one of the repositories is down. Cause: If one or more configured repository is down, we cannot log in (even as admin) or stop WebSphere Application Server, regardless of the repository in which your particular ID is stored. Virtual member manager (VMM) always checks whether all repositories are up before authenticating. Resolution: To disable this feature, we must set allowOperationIfReposDown to true in wimconfig.xml file . Note: After updating wimconfig.xml, the services must be restarted for the changes to take effect. Reference Links: http://www.ibm.com/support/ knowledgecenter/SSAW57_8.5.5/ com.ibm.websphere.wim.doc/ UnableToAuthenticateWhenReposi toryIsDown.html https://developer.ibm.com/ answers/questions/242364/why- do-errors-cwwim2009e-and- secj0281e-occur-in-sy.html ​​

IGC - Not showing the steward and IGC rest explorer url not working

SystemOut.log says. Caused by: java.io.IOException: Permission denied at java.io.File.createTempFile(File.java:2013) at com.ibm.is.vr.client.impl.FileObjectStore.createTempFile (FileObjectStore.java:72) at com.ibm.is.vr.client.impl.FileObjectStore.ensureFilesOpen (FileObjectStore.java:58)  Solution: The exception is arising from a problem writing to vr.temp.location with the user WAS is running under. We have seen this before when WAS is running as non-root. Is your websphere process running as non-root? You can check by doing a ps as follows: ps -ef|grep AppServer on the services tier machine. Check the permissions on the temporary directory /tmp/*vrdata cd /tmp ls -ltr|grep vrdata If needed, the instructions on setting the location of vr.temp.location are here: http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.mdwb.doc/topics/t_defining_search_directory.html The user the WAS is running under should have write per...

TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS

​​ problem:               Message 1053 not found; No message file for product=network, facility=TNSTNS-12541:         Message 12541 not found; No message file for product=network, facility=TNS             TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS           TNS-00511: Message 511 not found; No message file for product=network, facility=TNS          Linux Error: 111: Connection refused  solution:                set below variable on OS  level :     #export ORACLE_SID=<oracle db name>     #export ORACLE_HOME=<oracle_home> <take oracle home location from /etc/oratab file>     #export PATH=/usr/sbin:$PATH      #export PATH=$ORACLE_HOME/bin:$PATH                then run the command which giving the error after execution.