DTS Stage truncating SQL Reject message in RejectQ
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.
DTS Stage truncating SQL Reject message in RejectQ
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.
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.
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.
Re: DTS Stage truncating SQL Reject message in RejectQ
This table having index ?
DS User
DS User
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.
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.
I'd still suggest you open a support case.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I would agree.....there's more than just truncation going on here.
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.