Run-time error '457'

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

palaniappan · 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 · Post by **chulett** » Wed Aug 27, 2008 7:49 am

Sure, do this directly from the command line of your O/S.

Code: Select all

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

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

palaniappan · 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 · 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 · Post by **chulett** » Thu Aug 28, 2008 8:11 am

Interesting... a people issue, I assume.

palaniappan · Post by **palaniappan** » Thu Aug 28, 2008 8:20 am

Yes it was