Match specification Run Error

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
vijaydasari
Participant
Posts: 29
Joined: Sun Jul 22, 2007 3:25 pm

Match specification Run Error

Post by vijaydasari »

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 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.
Vijaya K Dasari
Top
vijaydasari
Participant
Posts: 29
Joined: Sun Jul 22, 2007 3:25 pm

Re: Match specification Run Error

Post by vijaydasari »

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.
Vijaya K Dasari
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Review just the errors (marked with ##E). Your answer is there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

Re: Match specification Run Error

Post by vinodn »

I got the below error , when combining two sources of customers ,

two customer data sets I made to one using funnel size . i renamed column name in both the links but forgot to change the legths.

i chaged the lengths to have same in both the links then this issue resolved.
Top
Post Reply

Return to “IBM QualityStage”