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 this collection”.

  • The permissions on the DSParams file for the project. This file is in the Projects directory under $DSHOME/Projects/<project name>
    the protections should allow rwx for the dstage group
  • DSParams file has duplicate entries or DSParams file has EnvVarValues without EnvVarDefs.
  • An incorrect index in the project

Correct the permissions, remove the Duplicate entries or add the missing EnvVarDefs for the EnvVarValues. You can also copy the correct DSParams file from the working project.

If the above does not resolve the problem, reindex the project:

  1. Stop all jobs and close sessions
  2. Backup the project with the error
  3. Open up a terminal
cd /IBM/InformationServer/Server/DSEngine
. ./dsenv
bin/uvsh
LOGTO project_name
DS.TOOLS
choose menu 2
QUIT

Please follow and like us:

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.