DTS Stage truncating SQL Reject message in RejectQ

mobashshar · Post by **mobashshar** » Wed Feb 08, 2012 10:41 am

Hi,
I am using DTS Stage to Insert/Delete in DB2. All the settings are correct in DTS such as Reject Failing Units = Yes and Prepend Rejects = Yes.
When the row is rejected because of SQL error in DB2 like -803, the the DTS is not writing the full message in RejectQ. Its truncating the SQL error message.

The message in RejectQ is like this: ERR_MSG: S Q L E x e c u t e r e p o r t e d : S Q L S T A T E = 2 3 5 0 5 : N a t i v e E r r o r C o d e = - 8 0 3 : M s g = [ I B M ] [ C L I D r i v e r ] [ D B 2 / A I X 6 4 ] S Q L 0 8 0 3 N O n e o r m o r e v a l u e s i n t h e I N S E R T s t a t e m e n t , U P D A T E s t a t e m e n t , o r f o r e i g n k e y u p d a t e c a u s e d b y a D E L E T E s t a t e m e n t a r e n o t v a l i d b e c a u s

Am I missing something? I also increased the RejectQ length but getting the same result. Is there any APT parameter I have to set to get the whole SQL Error message written in the Q?

Please advise.

mobashshar · Post by **mobashshar** » Wed Feb 08, 2012 9:53 pm

One thing I missed to mention.. DTS is writing message of length 615 only even after I increased the size of Q to 1 mb.

mobashshar · Post by **mobashshar** » Thu Feb 09, 2012 8:51 am

DS Realtime Gurus.....
Please help

chulett · Post by **chulett** » Thu Feb 09, 2012 9:09 am

No clue. Contact your official support provider.

SURA · Post by **SURA** » Thu Feb 09, 2012 4:31 pm

This table having index ?

DS User

mobashshar · Post by **mobashshar** » Mon Feb 13, 2012 10:36 pm

Hi Sura,
What do you mean? Please elaborate.
Thanks

SURA · Post by **SURA** » Mon Feb 13, 2012 10:40 pm

One of the cause is, when you insert a duplicate records in to a table where the table is having unique index.

It may not be the case for you, hence it is the reject link. Still i wish to know that.

Thanks

DS User

chulett · Post by **chulett** » Mon Feb 13, 2012 10:52 pm

I don't think they have an issue with the message itself, meaning they know why it was thrown. The question is why is the message strangely formatted with an extra space between each and every character? That doubles the length of the string needed and (apparently) cuts it off.

I'd still suggest you open a support case.

eostic · Post by **eostic** » Tue Feb 14, 2012 6:43 am

I would agree.....there's more than just truncation going on here.

mobashshar · Post by **mobashshar** » Tue Feb 14, 2012 8:07 am

Hi Ernie, Criag and Sura,
Thanks a lot for your replies. I am going to open a pmr today. It seems that I can view the whole message (formatted correctly) in DS Director Log but when DS Writes the RejectQ, its messing and missing the error log.
Thanks again.
Mobashshar

DSXchange

DTS Stage truncating SQL Reject message in RejectQ

DTS Stage truncating SQL Reject message in RejectQ

Re: DTS Stage truncating SQL Reject message in RejectQ