Author: Robert Reid

DataStage Designer, Admin or Manager clients: runtime error 457 – Reindex Datastage

  [ad#ad-post] Run-time error 457 logging into project in IBM InfoSphere DataStage from http://www-01.ibm.com/support/docview.wss?uid=swg21446213 Users cannot login to a particular project using DataStage clients (Designer, Director, or Manager) and encounter the error: “Run-time error ‘457’: This key is already associated with an element...

IBM InfoSphere Information Server DataStage 11.5 ODBC Connection Configuration for Microsoft SQL

[ad#ad-post] First, make sure to the latest ODBC drivers are installed from IBM Fix Central Note: The .odbc.ini file template defaults to an old driver. Make sure to use the latest driver. As of the time I updated this document, the...

SSH Key not working – Server refused our key

[ad#ad-post] I found this solution on https://adamwright.wordpress.com/2013/04/15/how-to-fix-server-refused-our-key-error-in-centos-6/ I received this error with Putty: “Server refused our key” SecureCRT gave me this error: “unable to authenticate using keys from the location “<ssh-agent>”. The error was: cannot find object or property.” [ad#ad-post] This appears to...

Notepad++ Silent Install Script

Similarly to the 7-zip silent install script, I also use the following script on my servers during their original build and patching: pushd "\\epmfileserver\share\utilities" npp.6.6.9.Installer.exe /S popd I’m not sure if any of you have ever used pushd and popd, but...

7-zip Silent Install Script

I’m just sharing a little script I use to install 7zip in silent mode. pushd "\\epmfileserver.mydomain.com\share\utilities" 7z920-x64.msi /q INSTALLDIR="C:\Program Files\7-Zip" popd I’m not sure if any of you have ever used pushd and popd, but they are pretty handy. The pushd...

EPM installTool and configTool – Record Response File for Silent Installation

I use the following to record an installation response file details to use as a future silent install and config task. This will create a unique file name each time, to avoid overwriting the previous: ./installTool.sh -record EPM_11_1_2_4_Install_$(hostname -s)_$(echo $RANDOM)_RunAs_$(whoami).rsp The...