Match Designer - Test pass error

centennium · Post by **centennium** » Wed Dec 05, 2007 12:53 pm

Hi, I try to create a match specification. When testing the pass the error below (OSHErrorLog.txt) is generated. Does anyone have an idea how to fix this? Thanks.
============
##I IIS-DSEE-TFCN-00001 19:35:42(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 19:35:42(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 19:35:42(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 19:35:42(003) <main_program> orchstats: loaded
##I IIS-QSEE-PMSP-00002 19:35:43(002) <HarmNameAndAddress> Match cutoff for pass [1] will be set to 1.0 as there are no MATCH variables

##I IIS-QSEE-POP*-00001 19:35:43(003) <HarmNameAndAddress> Creating sub-operator: <QSmatStats -workDir C:/IBM/InformationServer/Server/Projects/WINNCRM/QSScratch/HarmNameAndAddress -f HarmNameAndAddress.MAT -trace all -lvl 1>

##I IIS-QSEE-POP*-00001 19:35:43(004) <HarmNameAndAddress> Creating sub-operator: <copy>

##I IIS-QSEE-POP*-00001 19:35:43(005) <HarmNameAndAddress> Creating sub-operator: <copy>

##I IIS-QSEE-POP*-00001 19:35:43(006) <HarmNameAndAddress> Creating sub-operator: <QSmat -n 1 -workDir C:/IBM/InformationServer/Server/Projects/WINNCRM/QSScratch/HarmNameAndAddress -f HarmNameAndAddress.MAT -trace all -lvl 1>

##I IIS-QSEE-POP*-00001 19:35:43(007) <HarmNameAndAddress> Creating sub-operator: <tsort -flagKey -stable -key MatchPrimaryWord1NYSIIS_USNAME -ci -collation_sequence nl_NL -strength secondary>

##I IIS-QSEE-POP*-00001 19:35:43(008) <HarmNameAndAddress> Creating sub-operator: <tsort -key qsMatchDataIDA -key qsMatchPassNumber -collation_sequence nl_NL -strength secondary>

##I IIS-QSEE-POP*-00001 19:35:43(009) <HarmNameAndAddress> Creating sub-operator: <copy>

##I IIS-QSEE-POP*-00001 19:35:43(010) <HarmNameAndAddress> Creating sub-operator: <innerjoin -key qsMatchDataID>

##I IIS-QSEE-POP*-00001 19:35:43(011) <HarmNameAndAddress> Creating sub-operator: <tsort -key qsMatchDataID -collation_sequence nl_NL -strength secondary>

##I IIS-QSEE-POP*-00001 19:35:43(012) <HarmNameAndAddress> Creating sub-operator: <QSmat_join -U -workDir C:/IBM/InformationServer/Server/Projects/WINNCRM/QSScratch/HarmNameAndAddress -f HarmNameAndAddress.MAT -trace all -lvl 1>

##I IIS-QSEE-POP*-00001 19:35:43(013) <HarmNameAndAddress> Creating sub-operator: <copy>

##W IIS-DSEE-TLCL-00007 19:35:43(014) <main_program> No collation sequence found for nl_NL, using default locale root
##I IIS-DSEE-TDOD-00080 19:35:43(016) <ODBC_Enterprise_0> Process meta data not available in database
##W IIS-DSEE-TDOD-00007 19:35:43(017) <main_program> [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]DB2ADMIN.PASS_3_RESULTS_DATA IS AN UNDEFINED NAME.
##I IIS-DSEE-TDOD-00081 19:35:43(018) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(019) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(020) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(021) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(022) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(023) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(024) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(025) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(026) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(027) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(028) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(029) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(030) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(031) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(032) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(033) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(034) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(035) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(036) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(037) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(038) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(039) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(040) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(041) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(042) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(043) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(044) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(045) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(046) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(047) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:43(048) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(000) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(001) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(002) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(003) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(004) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(005) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(006) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(007) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(008) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(009) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(010) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(011) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(012) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(013) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(014) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(015) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(016) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(017) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(018) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(019) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(020) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(021) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(022) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(023) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(024) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(025) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(026) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(027) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(028) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(029) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(030) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(031) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(032) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(033) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(034) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(035) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(036) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(037) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 19:35:44(038) <main_program> Driver doesn't support the datatype. DataType Code = -9
##E IIS-DSEE-TDOD-00083 19:35:44(039) <main_program> ?? (PASS_3_RESULTS_DATA)
##E IIS-DSEE-TDOD-00062 19:35:44(041) <ODBC_Enterprise_0> Table create failed: {0}
##I IIS-DSEE-TDOD-00080 19:35:44(042) <ODBC_Enterprise_1> Process meta data not available in database
##W IIS-DSEE-TDOD-00007 19:35:44(043) <main_program> [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]DB2ADMIN.PASS_3_STATS IS AN UNDEFINED NAME.
##E IIS-DSEE-TFSR-00019 19:35:45(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFOR-00073 19:35:45(002) <APT_CopyOperator(1) in HarmNameAndAddress> When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
##W IIS-DSEE-TFIP-00095 19:35:45(003) <APT_CopyOperator(3) in HarmNameAndAddress> When checking operator: The modify operator drops field "qsMatchMasterFlag" which is not present in output interface.
##W IIS-DSEE-TFIP-00072 19:35:45(004) <APT_CopyOperator(3) in HarmNameAndAddress> 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 19:35:45(005) <APT_CopyOperator(3) in HarmNameAndAddress> 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 19:35:45(006) <QSM_MatStatsOp in HarmNameAndAddress> 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 19:35:45(007) <main_program> Creation of a step finished with status = FAILED.

dstage2006 · Post by **dstage2006** » Wed Jan 09, 2008 2:47 pm

Check the Table created by the Match designer in db2 database and data type for clomuns in the table pass_3_result_data.

http://www.ibm.com/developerworks/forum ... D=14032779

http://www-1.ibm.com/support/docview.ws ... 9427&aid=1

hope these links will help

ray.wurlod · Post by **ray.wurlod** » Wed Jan 09, 2008 3:54 pm

Also check ODBC.H in the include folder for DataStage Engine. This decodes the data type codes; for example -9 represents SQL.WVARCHAR (which one assumes to be "wide VarChar", or NVarChar: different vendors use different terminology). Negative numbers in this list represent unsupported data types. Try changing the data type to simple VarChar.