All Forums Tools
Naveen_K 22 posts Joined 08/09
26 May 2016
Error limit in TPT's STREAM

Hi All,
 
I want to capture rows skipped due to Errors from STREAM operator. I see that this is not captured in STREAM in the way it is done for LOAD. I just get the following message.
STREAM_OPERATOR: Rows Inserted: 285

STREAM_OPERATOR: entering Cleanup Phase

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 2, Total Rows Received = 286, Total Rows Sent = 0

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 2, Total Rows Received = 0, Total Rows Sent = 286

 

However in Load operator, I get following message clearly indicating the rows that erred out.
 
LOAD_OPERATOR: Total Rows in Error Table 1:   0

LOAD_OPERATOR: Total Rows in Error Table 2:   0

LOAD_OPERATOR: Total Duplicate Rows:          0

 

 

Could you please let me know if there is such an option in STREAM operator? I'm using TTU 14.10.00.10.

feinholz 1234 posts Joined 05/08
27 May 2016

Starting in 15.00, the Stream operator will output the same stats for the error table to the console output, similar to what is done for the Load and Update operators.
 
The information is always available in the Stream operator private log.
 

--SteveF

You must sign in to leave a comment.