Length of ODBC Message

cassi_bsb · Post by **cassi_bsb** » Fri May 15, 2015 6:59 am

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

chulett · Post by **chulett** » Fri May 15, 2015 7:26 am

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

qt_ky · Post by **qt_ky** » Fri May 15, 2015 8:00 am

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.