DSXchange

vijaydasari wrote:Hi ,

I created and Match specification and trying to run using Test All Passes option , getting below error message ...

Please help me , how to resolve this issues

i have blocking columsn mentioned

first name , last name , city , state , zip
and country .

i didn't specify any match commands / cut off values.



##I IIS-DSEE-TFCN-00001 11:01:08(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.5.0.5946
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TUTL-00031 11:01:08(001) <main_program> The open files limit is 8192; raising to 8200.
##I IIS-DSEE-TFCN-00006 11:01:08(002) <main_program> conductor uname: -s=SunOS; -r=5.10; -v=Generic_127111-03; -n=livdsadspcg01; -m=sun4us
##I IIS-DSEE-TOSH-00002 11:01:09(000) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 11:01:09(001) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 11:01:09(002) <main_program> orchstats: loaded
##I IIS-DSEE-TDOD-00080 11:01:10(000) <ODBC_Enterprise_0> Process meta data not available in database
##I IIS-DSEE-TDOD-00080 11:01:23(002) <ODBC_Enterprise_1> Process meta data not available in database
##I IIS-DSEE-TDOD-00080 11:01:23(004) <MWI_Odbc_Write> Process meta data not available in database
##I IIS-DSEE-TFSC-00001 11:01:24(001) <main_program> APT configuration file: /app/IBM/InformationServer/Server/Configurations/default.apt
##W IIS-DSEE-TFIP-00095 11:01:24(002) <APT_CopyOperator(2) in SamMS> When checking operator: The modify operator drops field "qsMatchMasterFlag" which is not present in output interface.
##W IIS-DSEE-TFIP-00072 11:01:24(003) <APT_CopyOperator(2) in SamMS> When checking operator: When binding output schema variable "outRec": When binding output interface field "qsMatchSetID" to field "qsMatchSetID": Implicit conversion from source type "uint64" to result type "int64": Possible range limitation.
##W IIS-DSEE-TFIP-00072 11:01:24(004) <APT_CopyOperator(2) in SamMS> When checking operator: When binding output schema variable "outRec": When binding output interface field "qsMatchDataID" to field "qsMatchDataID": Implicit conversion from source type "uint64" to result type "int64": Possible range limitation.
##W IIS-DSEE-TFIP-00072 11:01:24(005) <QSM_MatStatsOp in SamMS> When checking operator: When binding output interface field "qsMatchStatValue" to field "qsMatchStatValue": Implicit conversion from source type "uint64" to result type "int64": Possible range limitation.
##I IIS-QSEE-PMSO-00001 11:01:28(001) <QSM_MatStatsOp in SamMS,0> Match statistics for UNDUPLICATE specification SamMS follow:

##I IIS-QSEE-PMSO-00001 11:01:28(002) <QSM_MatStatsOp in SamMS,0> UNDUPLICATE type: Dependent

##I IIS-QSEE-PMSO-00001 11:01:28(003) <QSM_MatStatsOp in SamMS,0> ------------------------------ Match Pass 1 ------------------------

##I IIS-QSEE-PMSO-00001 11:01:28(004) <QSM_MatStatsOp in SamMS,0> Number of data input records read = 3

##I IIS-QSEE-PMSO-00001 11:01:28(005) <QSM_MatStatsOp in SamMS,0> Number of input blocks processed = 1

##I IIS-QSEE-PMSO-00001 11:01:28(006) <QSM_MatStatsOp in SamMS,0> Number of blocks that overflowed = 0

##I IIS-QSEE-PMSO-00001 11:01:28(007) <QSM_MatStatsOp in SamMS,0> Maximum block size (overflow blocks included) = 3

##I IIS-QSEE-PMSO-00001 11:01:28(008) <QSM_MatStatsOp in SamMS,0> Average block size (overflow blocks not included) = 3

##I IIS-QSEE-PMSO-00001 11:01:28(009) <QSM_MatStatsOp in SamMS,0> Number of master records found = 1

##I IIS-QSEE-PMSO-00001 11:01:28(010) <QSM_MatStatsOp in SamMS,0> Number of duplicate records found = 2

##I IIS-QSEE-PMSO-00001 11:01:28(011) <QSM_MatStatsOp in SamMS,0> Number of exact duplicate records found = 2

##I IIS-QSEE-PMSO-00001 11:01:28(012) <QSM_MatStatsOp in SamMS,0> Number of clerical duplicate records found = 0

##I IIS-QSEE-PMSO-00001 11:01:28(013) <QSM_MatStatsOp in SamMS,0> Number of residual data records (including those with null block columns) = 1

##I IIS-QSEE-PMSO-00001 11:01:28(014) <QSM_MatStatsOp in SamMS,0> Total number of comparisons performed = 2

##E IIS-DSEE-TFOR-00001 11:01:36(003) <ODBC_Enterprise_0,0> Failure during execution of operator logic.
##I IIS-DSEE-TFOR-00163 11:01:36(004) <ODBC_Enterprise_0,0> Input 0 consumed 1 records.
##F IIS-DSEE-TFDA-00002 11:01:36(005) <APT_CombinedOperatorController(0),0> Fatal Error: Invalid Julian day
##E IIS-DSEE-TFPM-00192 11:01:36(000) <node_node1> Player 12 terminated unexpectedly.
##E IIS-DSEE-TFPM-00338 11:01:36(000) <main_program> APT_PMsectionLeader(1, node1), player 12 - Unexpected exit status 1.
##E IIS-DSEE-TFIO-00032 11:01:36(000) <buffer(0),0> Error in writeBlock - could not write 16
##E IIS-DSEE-TFSC-00011 11:01:41(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOS-00026 11:01:41(001) <main_program> Startup time, 0:24; production run time, 0:08.