DSXchange

Hi,

I have a simple job which loads a table data from Oracle to Netezza DB.

Job is like this.

Oracle Stage -> Transformer -> Netezza Stage.

It was working fine few weeks ago.

But suddenly its not working now and getting aborted with the following error message.

Added field has duplicate identifier()


I know this happens because of RCP enabling. But I didnt understand the duplicate column name part.
Still I cross checked it and i didnt find any repeating column names in both the DB stages.

Anyone who have come across this kind of error ?
Any guidance will be highly aprreciated.


Thanks,
Jaysheel

Was your source table altered in any way?

No Craig. And I have made sure that I have reimported the latest metadata to prevent accidental metadata mismatch.
But still I am getting this error.
Is this a bug in Datastage ?

Thanks,

Jaysheel

jaysheel wrote:It was working fine few weeks ago.

But suddenly its not working now and getting aborted with the following error message.

Added field has duplicate identifier()

OK, what has changed?

Ray, I am not a premium member. If you could post it in generic area then it would be good for me.

All Ray asked was "OK, what has changed?" Obviously something has and unfortunately you are the one that's going to need to chase down the culprit.

Thanks Craig.

The issue is with the datamodels. The modelling team is reviewing the source and target datamodels. Will keep posted on any updates.

Thanks