Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
palaniappan
Participant
Posts: 41 Joined: Wed Mar 05, 2003 1:28 am
Post
by palaniappan » Wed Aug 27, 2008 7:03 am
Hi,
When I try to connect to a project through any client, I get the below message.
Run-time error '457':
This key is already associated with an element of this collection
This is specfic to a project. All other projects on the server work fine. Pls suggest.
Thanks.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Aug 27, 2008 7:15 am
Reindex the project. Search the forums for reindex and/or DS.TOOLS for any of the many conversations we've already had on this topic.
-craig
"You can never have too many knives" -- Logan Nine Fingers
palaniappan
Participant
Posts: 41 Joined: Wed Mar 05, 2003 1:28 am
Post
by palaniappan » Wed Aug 27, 2008 7:44 am
I thought about it but I am not able to connect through Administrator as well. Can I re-index without using Administrator?
Thanks.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Aug 27, 2008 7:49 am
Sure, do this directly from the command line of your O/S.
-craig
"You can never have too many knives" -- Logan Nine Fingers
palaniappan
Participant
Posts: 41 Joined: Wed Mar 05, 2003 1:28 am
Post
by palaniappan » Wed Aug 27, 2008 7:58 am
Thanks; But in these line of commands, i do not see anything project specific. How do I ensure that I re-index only this project? Should I 'LOG TO' to the project and execute the same command that we execute through administrator to re-index?
attu
Participant
Posts: 225 Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas
Post
by attu » Wed Aug 27, 2008 8:15 am
yes, you need to logto the project which is giving you error messages and then go to DataStage Tools Menu ( DS-TOOLS)
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Aug 27, 2008 8:20 am
Right, LOGTO the project in question. And then execute the command directly or go thru the DS.TOOLS menu.
-craig
"You can never have too many knives" -- Logan Nine Fingers
palaniappan
Participant
Posts: 41 Joined: Wed Mar 05, 2003 1:28 am
Post
by palaniappan » Wed Aug 27, 2008 8:58 am
Re-indexing did not help, the issue persists...
-------------------------------------
I did this...
cd $DSHOME
. ./dsenv
./bin/dssh
>LOGTO <Project>
>DS.REINDEX ALL
-------------------------------------
palaniappan
Participant
Posts: 41 Joined: Wed Mar 05, 2003 1:28 am
Post
by palaniappan » Thu Aug 28, 2008 7:57 am
The issue was due to duplicates in DSParams. I have deleted them and now we are able to connect.
Thanks
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Aug 28, 2008 8:11 am
Interesting... a people issue, I assume.
-craig
"You can never have too many knives" -- Logan Nine Fingers