Match Designer - Unduplicate - Table Create Failed

[iHijazi]

Hi,

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.

Steps I've done to create this Spec:
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!!

[iHijazi]

Hi,

I finally found the solution. This line was my main clue:
"Could not get mapping for one or more datatypes. Cannot create table:SPEC_1_FREQ_PROPS_DATA"

I change ODBC driver and used "IBM Oracle Wire Protocol" instead of "IBM Oracle".

The update worked like a charm. Hope this will help someone out there.

Cheers.

[ray.wurlod]

Thank you for posting the solution. I was thinking along the same lines while reading the original problem (did not "do" DSXchange over the weekend).