Match Designer - Test All Pass error
Posted: Tue Apr 29, 2008 7:31 pm
Hi , When i am trying to create a Match specifications while running "Test All Passes" following OSHErrorLog is generated. can any one please suggest solution in this.
##I IIS-DSEE-TFCN-00001 21:13:23(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 21:13:23(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 21:13:23(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 21:13:23(003) <main_program> orchstats: loaded
##I IIS-QSEE-POP*-00001 21:13:23(008) <sample_usprep_match> Creating sub-operator: <QSmatStats -workDir /bi/IBM/InformationServer/Server/Projects/bi_synergy/QSScratch/sample_usprep_match -f sample_usprep_match.MAT -trace all -lvl 1>
##I IIS-QSEE-POP*-00001 21:13:23(009) <sample_usprep_match> Creating sub-operator: <copy>
##I IIS-QSEE-POP*-00001 21:13:23(010) <sample_usprep_match> Creating sub-operator: <copy>
##I IIS-QSEE-POP*-00001 21:13:23(011) <sample_usprep_match> Creating sub-operator: <QSmat -n 1 -workDir /bi/IBM/InformationServer/Server/Projects/bi_synergy/QSScratch/sample_usprep_match -f sample_usprep_match.MAT -trace all -lvl 1>
##I IIS-QSEE-POP*-00001 21:13:23(012) <sample_usprep_match> Creating sub-operator: <tsort -flagKey -stable -key state -ci -key MatchPrimaryName_CopyOfUSNAME -ci -key Customer -ci -collation_sequence en -strength secondary>
##I IIS-QSEE-POP*-00001 21:13:23(013) <sample_usprep_match> Creating sub-operator: <tsort -key qsMatchDataIDA -key qsMatchPassNumber -collation_sequence en -strength secondary>
##I IIS-QSEE-POP*-00001 21:13:23(014) <sample_usprep_match> Creating sub-operator: <copy>
##I IIS-QSEE-POP*-00001 21:13:23(015) <sample_usprep_match> Creating sub-operator: <innerjoin -key qsMatchDataID>
##I IIS-QSEE-POP*-00001 21:13:23(016) <sample_usprep_match> Creating sub-operator: <tsort -key qsMatchDataID -collation_sequence en -strength secondary>
##I IIS-QSEE-POP*-00001 21:13:23(017) <sample_usprep_match> Creating sub-operator: <QSmat_join -U -workDir /bi/IBM/InformationServer/Server/Projects/bi_synergy/QSScratch/sample_usprep_match -f sample_usprep_match.MAT -trace all -lvl 1>
##I IIS-QSEE-POP*-00001 21:13:23(018) <sample_usprep_match> Creating sub-operator: <copy>
##I IIS-DSEE-TDOD-00080 21:13:23(020) <ODBC_Enterprise_0> Process meta data not available in database
##W IIS-DSEE-TDOD-00007 21:13:23(021) <main_program> [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]IAUSER.PASS_5_RESULTS_DATA IS AN UNDEFINED NAME.
##E IIS-DSEE-TDOD-00007 21:13:23(022) <main_program> [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]RECORD LENGTH OF TABLE EXCEEDS PAGE SIZE LIMIT. 32677
##E IIS-DSEE-TDOD-00062 21:13:23(024) <ODBC_Enterprise_0> Table create failed: {0}
##I IIS-DSEE-TDOD-00080 21:13:24(000) <ODBC_Enterprise_1> Process meta data not available in database
##E IIS-DSEE-TFSR-00019 21:13:24(002) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFOR-00073 21:13:24(003) <APT_CopyOperator(1) in sample_usprep_match> When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
##W IIS-DSEE-TFIP-00095 21:13:24(004) <APT_CopyOperator(3) in sample_usprep_match> When checking operator: The modify operator drops field "qsMatchMasterFlag" which is not present in output interface.
##W IIS-DSEE-TFIP-00072 21:13:24(005) <APT_CopyOperator(3) in sample_usprep_match> 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 21:13:24(006) <APT_CopyOperator(3) in sample_usprep_match> 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 21:13:24(007) <QSM_MatStatsOp in sample_usprep_match> 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.
##E IIS-DSEE-TCOS-00029 21:13:24(008) <main_program> Creation of a step finished with status = FAILED.
##I IIS-DSEE-TFCN-00001 21:13:23(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 21:13:23(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 21:13:23(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 21:13:23(003) <main_program> orchstats: loaded
##I IIS-QSEE-POP*-00001 21:13:23(008) <sample_usprep_match> Creating sub-operator: <QSmatStats -workDir /bi/IBM/InformationServer/Server/Projects/bi_synergy/QSScratch/sample_usprep_match -f sample_usprep_match.MAT -trace all -lvl 1>
##I IIS-QSEE-POP*-00001 21:13:23(009) <sample_usprep_match> Creating sub-operator: <copy>
##I IIS-QSEE-POP*-00001 21:13:23(010) <sample_usprep_match> Creating sub-operator: <copy>
##I IIS-QSEE-POP*-00001 21:13:23(011) <sample_usprep_match> Creating sub-operator: <QSmat -n 1 -workDir /bi/IBM/InformationServer/Server/Projects/bi_synergy/QSScratch/sample_usprep_match -f sample_usprep_match.MAT -trace all -lvl 1>
##I IIS-QSEE-POP*-00001 21:13:23(012) <sample_usprep_match> Creating sub-operator: <tsort -flagKey -stable -key state -ci -key MatchPrimaryName_CopyOfUSNAME -ci -key Customer -ci -collation_sequence en -strength secondary>
##I IIS-QSEE-POP*-00001 21:13:23(013) <sample_usprep_match> Creating sub-operator: <tsort -key qsMatchDataIDA -key qsMatchPassNumber -collation_sequence en -strength secondary>
##I IIS-QSEE-POP*-00001 21:13:23(014) <sample_usprep_match> Creating sub-operator: <copy>
##I IIS-QSEE-POP*-00001 21:13:23(015) <sample_usprep_match> Creating sub-operator: <innerjoin -key qsMatchDataID>
##I IIS-QSEE-POP*-00001 21:13:23(016) <sample_usprep_match> Creating sub-operator: <tsort -key qsMatchDataID -collation_sequence en -strength secondary>
##I IIS-QSEE-POP*-00001 21:13:23(017) <sample_usprep_match> Creating sub-operator: <QSmat_join -U -workDir /bi/IBM/InformationServer/Server/Projects/bi_synergy/QSScratch/sample_usprep_match -f sample_usprep_match.MAT -trace all -lvl 1>
##I IIS-QSEE-POP*-00001 21:13:23(018) <sample_usprep_match> Creating sub-operator: <copy>
##I IIS-DSEE-TDOD-00080 21:13:23(020) <ODBC_Enterprise_0> Process meta data not available in database
##W IIS-DSEE-TDOD-00007 21:13:23(021) <main_program> [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]IAUSER.PASS_5_RESULTS_DATA IS AN UNDEFINED NAME.
##E IIS-DSEE-TDOD-00007 21:13:23(022) <main_program> [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]RECORD LENGTH OF TABLE EXCEEDS PAGE SIZE LIMIT. 32677
##E IIS-DSEE-TDOD-00062 21:13:23(024) <ODBC_Enterprise_0> Table create failed: {0}
##I IIS-DSEE-TDOD-00080 21:13:24(000) <ODBC_Enterprise_1> Process meta data not available in database
##E IIS-DSEE-TFSR-00019 21:13:24(002) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFOR-00073 21:13:24(003) <APT_CopyOperator(1) in sample_usprep_match> When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
##W IIS-DSEE-TFIP-00095 21:13:24(004) <APT_CopyOperator(3) in sample_usprep_match> When checking operator: The modify operator drops field "qsMatchMasterFlag" which is not present in output interface.
##W IIS-DSEE-TFIP-00072 21:13:24(005) <APT_CopyOperator(3) in sample_usprep_match> 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 21:13:24(006) <APT_CopyOperator(3) in sample_usprep_match> 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 21:13:24(007) <QSM_MatStatsOp in sample_usprep_match> 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.
##E IIS-DSEE-TCOS-00029 21:13:24(008) <main_program> Creation of a step finished with status = FAILED.