DSXchange

Hi There,

Is there any way to configure the length of message sent from DB to DataStage ODBC conector?

We have some troubles to identify properly the error because the message is presented truncated at 200 characters.

Perhaps that the most significant part of message is not presented, like bellow.

APT_CombinedOperatorController,2: [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver][SQL Server]Violation of PRIMARY KEY constraint 'TD068IP'. Cannot insert duplicate key in object 'dbo.TD_068_SX_OCORRENCIA'. The duplicate key valu


See that the complete message is:
"Violation of PRIMARY KEY constraint 'TD068IP'. Cannot insert duplicate key in object 'dbo.TD_068_SX_OCORRENCIA'. The duplicate key value is (Feb 20 2015 8:19PM)."

That's going to be a support question, I would think.

Ouch, that hurts...

Have you tried routing the rejected records to a reject link? If they can be captured then you could easily view the key values.