Guru Of Geeks

Technote (troubleshooting) Problem(Abstract) Unable to open the "Edit assembly" page of the Hierarchical Stage properties. Getting error "The underlying connection was closed : Unable to establish a trust for the secure channel SSL / TLS" Cause The security defined on the client machine does not allow installation of certificate. Diagnosing the problem Use the direct URL link to access the Edit Assembly page : https://<hostname>:<portnumber>/ibm/iis/ds/xmlpack3/index.html# example : https://MyServerIIS.ibm.com:9443/ibm/iis/ds/xmlpack3/index.html# Resolving the problem You can manually install the certificate using the following procedure : 1) Extract the certificate from the WebSphere Application Server web console into a file : From a web browser, go to the WebSphere Application Server web console : https://<hostname>:9043/ibm/console On the left menu ...

Technote (troubleshooting) Problem(Abstract) IBM InfoSphere DataStage and QualityStage Operations Console sometimes displays the Disk Space information of a selected engine as 'Nothing monitored'. For example, Activity > Resources > Charts > Disk Space > MYSERVER (Engine) > (Nothing monitored) Cause The Operations Console retrieves a list of mounted file systems to be monitored from the DSODBConfig.cfg file on the engine tier. The possible causes for the issue: - Properties ResourceLocalFS and / or ResourceRemoteFS in the DSODBConfig.cfg are not set. - The file systems specified in these properties do not actually exist. - Properties ResourceLocalFS and / or ResourceRemoteFS have leading and trailing spaces in their names and values. For example, # The following specifies a locally mounted file system to be monitored. # This property can be repeated any number of times to specify multiple file systems.   ResourceLocalF...

​ Technote (troubleshooting) Problem(Abstract) DataStage clients cannot connect to the server after a reboot of the engine tier. Symptom DSEngine does not start automatically on RHEL7 even though ds.rc links have been set up under /etc/init.d and /etc/rc[2-5].d. Cause In Red Hat Enterprise Linux 7, systemd replaces upstart as the default init system. Environment RHEL 7 Resolving the problem The following steps work around the issue . Root access is necessary. For non-itag installs:--- Create a file "/usr/lib/systemd/system/ds.rc.service" with the following content. [Unit] Description=DataStage Engine Requires=basic.target [Service] Type=forking RemainAfterExit=yes ExecStart=/etc/init.d/ds.rc start ExecStop=/etc/init.d/ds.rc stop [Install] WantedBy=multi-use...

Technote (troubleshooting) Problem(Abstract) The following error occurs when editting an LDAP group definition, using Information Server web console , if the group name contains an ampersand '&' character : The ID you entered contains invalid characters, re-enter the ID with valid characters and try again. For a list of valid characters, click the help icon. Resolving the problem Prior to 11..3. Customers could edit the isfconfig.properties file to modify the list of valid characters. Starting with IIS 11.3 and above, the isfconfig.properties file is no longer used. The properties are now saved in the repository. 1- You can list the property by running: sh-4.1# /opt/IBM/InformationServer/ASBServer/bin/iisAdmin.sh -display -key com.ibm.iis.isf.security.directory.principalIdAllowedCharacters com.ibm.iis.isf.security.directory.principalIdAllowedCharacters=_-,\ =$.@ 2- You can set the new value by appending characters l...

Technote (troubleshooting) Problem(Abstract) On the RedHat Enterprise Linux 6.1 operating system, parallel jobs run with degradated performance. Symptom On RedHat Linux 6.1 system there is a 10 - 90% performance degradation depending on the hardware configuration and DataStage node configuration during parallel job runs. Increase in number of CPU cores and DataStage node counts used on the system leads to more performance degradation. Cause This is caused by Parallel jobs using transformer stages and use of the CurrentTimestampMS() function in the transformer stage on the Redhat Linux 6.1 system. Resolving the problem On the computer that has the Redhat Enterprise Linux 6.1 operating system installed, set the environment variable as follows: TZ=:/etc/localtime before running parallel jobs. The CPU time improves. ...

Technote (troubleshooting) Problem(Abstract) Unable to retrieve data from the metadata repository using a SQL view due to insufficient privileges on an Oracle database. This may manifest itself as an internal server error when clicking an action on the Information Analyzer Web UI. Cause On an Oracle environment the metadata repository user (default name: xmeta) doesn't have the permission to access the objects under the Information Governance Dashboard(CMVIEWS, IGVIEWS, IAVIEWS, etc.,) schemas by default which causes exceptions such as the following when trying to query a SQL view: [Oracle]ORA-01031: insufficient privileges [Oracle]ORA-00942: table or view does not exist Missing privileges to access a SQL view can cause actions on the Information Analyzer Web UI such as 'Find data sets' to fail since these actions query the SQL views to retrieve values from the metadata repository based on the privileges of th...

Configure ODI 11g Local Agent: Today we are going create and configure Local Agent in ODI 11g. So open your odi studio and proceed as per below screenshot. Before doing any modification to the odiparams.bat file, take a backup of this. So that in case of any problem you can put this file again. We need to change the value for below pointed line in the screenshot. Just modify the bold values only but not others. Now open command prompt and go to ODI_HOME\oracledi\agent\bin. For encoding master repository password in windows use " encode your_master_repo_pwd ". For unix use " sh encode.sh your_master_repo_pwd " REM # Repository Connection Information REM # set ODI_MASTER_DRIVER=oracle.jdbc.OracleDriver set ODI_MASTER_URL= jdbc:oracle:thin:@localhost:1521:xe set ODI_MASTER_USER= ODI_MASTER1 set ODI_MASTER_ENCODED_PASS= bSyphW25OZr9ggsHRfvfy REM # REM # User credentials for agent startup program REM # set ODI_SUPERVISOR=SUPE...