IBM Support

Run-time error 457 logging into project in IBM InfoSphere DataStage

Troubleshooting


Problem

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

Symptom

Users cannot login to a particular project using DataStage clients and encounter the error

"Run-time error '457':
This key is already associated with an element of this collection".

Cause

This can be caused by:

  • 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

Environment


Diagnosing The Problem

Check the following:

  • The permissions on the DSParams file for the project are rwx for the dstage group
  • DSParams file for duplicate entries or missing EnvVarDefs

Resolving The Problem

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:

For Unix/Linux platforms:

  1. Make sure there are no jobs running and no client connections opened.
  2. Backup the project to reindex
  3. Open a shell on the DataStage Server and go in the DSEngine folder
  4. Source the dsenv file (command ". ./dsenv", # dot space dot slash dsenv)
  5. bin/uvsh
  6. LOGTO project_name
  7. DS.TOOLS
  8. choose menu 2
  9. QUIT

For all platforms:

  1. Make sure there are no jobs running and no client connections opened.
  2. Open DataStage Administrator
  3. Select the project and go to command line (press button command)
  4. type: DS.REINDEX ALL then press "execute"
  5. Unselect "pause output at end of page" and then press "next"
  6. Click "Respond" or "Next" button when enabled
  7. Click "Close" when it is enabled

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.1;8.0.1;7.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21446213

Page Feedback