messages getting truncated when writing into MQ

s_porkalai · Post by **s_porkalai** » Thu Jun 19, 2008 6:12 am

Hi All,

I have two jobs as below running in sequencer.

1. teradataenterperise->transformer->odbc-teradata

2. teradataenterperise->MQ->column export->MQ

When the messages are entering into MQ it is getting truncated.

we first add the APT_PADCHAR='0X20' in the second job.

now only some records which undergone transaction in first job got truncated.

next we add the APT_PAD_CHAR='0x20' parameter to first job also.

Now the length of data getting truncated is reduced, nuy the whole data didn't entered MQ now also.

I try to write the same data in to sequential file, there it is writting fine.

the truncation happen only when writting into MQ

ArndW · Post by **ArndW** » Thu Jun 19, 2008 6:22 am

Most likely your the width of the MQ Queue you are writing to is too small.

s_porkalai · Post by **s_porkalai** » Sun Jun 22, 2008 10:42 pm

But the truncation happen only in some data which got transformed in first job. remaining data is entering the queue as whole

ArndW · Post by **ArndW** » Sun Jun 22, 2008 11:23 pm

That means that your "some data" is different from the rest. Does it contain 0x00 characters?