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

  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 of...

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

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 latest...

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...

EPM Financial Reporting – Batch Export Folder Locations

EPM Financial Reporting – Batch Export Folder Locations Note: If you have never launched the FRConfig utility or get an error message, do the following step first. Set EPM_ORACLE_INSTANCE path Edit E:\Oracle\Middleware\EPMSystem11R1\products\financialreporting\bin\setInstance.cmd in notepad. Add your EPM_ORACLE_INSTANCE path after the equal...