Error in a simple job

[jaysheel]

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

[chulett]

Was your source table altered in any way?

[jaysheel]

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

[ray.wurlod]

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?

[jaysheel]

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

[chulett]

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.

[jaysheel]

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