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