I am have some difficulties in the Match Designer. When I fill up the Test Environment needed values, and click on Update I receive "Match Designer configuration update process failed".
Full Log:
Code: Select all
##I IIS-DSEE-TFCN-00001 11:19:50(000) <main_program>
IBM InfoSphere DataStage Enterprise Edition 8.7.0.6366
Copyright (c) 2001, 2005-2011 IBM Corporation. All rights reserved
##I IIS-DSEE-TFCN-00006 11:19:50(001) <main_program> conductor uname: -s=AIX; -r=1; -v=6; -n=moiqs; -m=00F6CB904C00
##I IIS-DSEE-TOSH-00002 11:19:50(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 11:19:50(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 11:19:50(004) <main_program> orchstats: loaded
##I IIS-DSEE-TDOD-00080 11:19:51(002) <QS_FreqProps_ODBC> Process meta data not available in database
##I IIS-DSEE-TDOD-00080 11:19:51(004) <QS_FreqFile_ODBC> Process meta data not available in database
##I IIS-DSEE-TFSC-00001 11:19:51(006) <main_program> APT configuration file: /moiqsfs/IBM/InformationServer/Server/Configurations/default.apt
##W IIS-DSEE-TFOR-00073 11:19:51(007) <Match_Freq> When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
##W IIS-DSEE-TFOR-00073 11:19:51(008) <Match_Freq> When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
##I IIS-DSEE-TDOD-00007 11:19:51(010) <main_program> [IBM(DataDirect OEM)][ODBC 20101 driver][20101]ORA-00942: table or view does not exist
##I IIS-DSEE-TDOD-00081 11:19:51(011) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 11:19:51(012) <main_program> Driver doesn't support the datatype. DataType Code = 4
##I IIS-DSEE-TDOD-00081 11:19:51(013) <main_program> Driver doesn't support the datatype. DataType Code = 6
##I IIS-DSEE-TDOD-00081 11:19:51(014) <main_program> Driver doesn't support the datatype. DataType Code = -9
##E IIS-DSEE-TDOD-00083 11:19:51(015) <main_program> Could not get mapping for one or more datatypes. Cannot create table:SPEC_1_FREQ_PROPS_DATA
##E IIS-DSEE-TDOD-00062 11:19:51(016) <QS_FreqProps_ODBC> Table create failed: {0}
##I IIS-DSEE-TCOS-00026 11:19:51(017) <main_program> Startup time, 0:00; production run time, 0:00.
1. Frequency Data: On source, I made sure there is NO null values.
2. Sample Data: 5 columns; Decimals and VarChars
3. Then the Match
Oracle target DB charset is set to what the data going to be processed, and for the National Charset it is UTF-8
I'm quite confused here, as I am out of clues!!
Can anybody help me please?
Thanks!!