Page 1 of 1

Run-time error '457'

Posted: Wed Aug 27, 2008 7:03 am
by palaniappan
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.

Posted: Wed Aug 27, 2008 7:15 am
by chulett
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.

Posted: Wed Aug 27, 2008 7:44 am
by palaniappan
I thought about it but I am not able to connect through Administrator as well. Can I re-index without using Administrator?

Thanks.

Posted: Wed Aug 27, 2008 7:49 am
by chulett
Sure, do this directly from the command line of your O/S.

Code: Select all

cd $DSHOME
. ./dsenv
./bin/dssh

Posted: Wed Aug 27, 2008 7:58 am
by palaniappan
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?

Posted: Wed Aug 27, 2008 8:15 am
by attu
yes, you need to logto the project which is giving you error messages and then go to DataStage Tools Menu ( DS-TOOLS)

Posted: Wed Aug 27, 2008 8:20 am
by chulett
Right, LOGTO the project in question. And then execute the command directly or go thru the DS.TOOLS menu.

Posted: Wed Aug 27, 2008 8:58 am
by palaniappan
Re-indexing did not help, the issue persists...

-------------------------------------
I did this...

cd $DSHOME
. ./dsenv
./bin/dssh

>LOGTO <Project>
>DS.REINDEX ALL
-------------------------------------

Posted: Thu Aug 28, 2008 7:57 am
by palaniappan
The issue was due to duplicates in DSParams. I have deleted them and now we are able to connect.

Thanks

Posted: Thu Aug 28, 2008 8:11 am
by chulett
Interesting... a people issue, I assume.

Posted: Thu Aug 28, 2008 8:20 am
by palaniappan
Yes it was