cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Max Rej count =100 in Transformation file,but Package getting failed instead of Warning

0 Likes
460

Hello All,

Can any one say me that ,why my package is getting failed even when max rej=100 count is in the transformation file

Status of package.

Expected Status of Package

Thanks

Kishore

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Likes

below are the details of package log

/CPMB/MODIFY completed in 0 seconds /CPMB/BW_IOBJ_MASTER_SOURCE completed in 4 seconds /CPMB/BW_IOBJ_TEXT_SOURCE completed in 6 seconds /CPMB/MERGE_IOBJ_MD_DATA completed in 2 seconds /CPMB/IOBJ_SOURCE_MD_CONVERT completed in 33 seconds /CPMB/SPLIT_IOBJ_MD_TXT_DATA completed in 1 seconds /CPMB/BPC_MASTER_DATA_TARGET completed in 57 seconds /CPMB/BPC_TXT_DATA_TARGET completed in 4 seconds [Selection] -------------------------------------------------------------- INFOOBJECT = ABC SELECTION = <?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Attribute" /><Selection Type="Hierarchy" ImportText="1" /><Selection Type="Language" TextType="2"><Language>E</Language></Selection><Selection Type="AttributeList"><Attribute>ABC</Attribute><Attribute>WER</Attribute><Attribute>ABC</Attribute><Attribute>ASD</Attribute><Attribute>DFG</Attribute><Attribute>LKJ</Attribute><Attribute>UJN</Attribute><Attribute>IKJ</Attribute><Attribute>NJU</Attribute><Attribute>IUH</Attribute><Attribute>ERT</Attribute></Selection><KeyDate>20171005</KeyDate><Relation><Value Right="Hierarchy" Left="Attribute">1</Value></Relation></Selections> WRITEMODE = Yes FORMAT = Yes TRANSFORMATION = \ROOT\WEBFOLDERS\GPI_PLAN\AMER_SUM\DATAMANAGER\TRANSFORMATIONFILES\MASTER DATA\ZMD_ATTR_DIE.XLS DIMNAME = DIE CLEAR_ALL = No FILTERMD = 2 [Message] --------------------------------------------------------------

Task name MASTER DATA SOURCE:

Record count: 32600 Task name TEXT SOURCE: Record count: 29867 Task name CONVERT: No 1 Round:

Skip count: 112

Reject count: 0

Record count: 32600

Skip count: 112

Accept count: 32488 Task name MASTER DATA TARGET: Submit count: 32488 Task name TXT DATA TARGET: /CPMB/M2D24JG : Data record 26366 ('HOL 15 041') : Duplicate data record /CPMB/M2D24JG : Data record 32024 ('HOL 15 041') : Duplicate data record /CPMB/M2D24JG : Data record 26366 ('HOL 15 041') : Duplicate data record /CPMB/M2D24JG : Data record 32024 ('HOL 15 041') : Duplicate data record Submit count: 0 model: AMER_SUM. Package status: ERROR

for this log ,am having the status as failed .

In transformation file ,Max rej count =100 is maintained.(to give warning /reject records till 100 invalid record) instead package getting failed

former_member186338
Active Contributor
0 Likes

Please post your info in the readable form! Look on the results of your post...

Package details also not provided!