Match designer Error when updating

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
seanc217
Premium Member
Premium Member
Posts: 188
Joined: Thu Sep 15, 2005 9:22 am

Match designer Error when updating

Post by seanc217 »

I am trying to update a match specification to an Oracle 10G Database.
When I hit update I get the following in the osh logs...

##E IIS-DSEE-TDOD-00083 16:09:41(004) <main_program> ?? (SPEC_1_FREQ_DATA)
##E IIS-DSEE-TDOD-00062 16:09:41(009) <QS_Freq_ODBC> Table create failed: {0}
##E IIS-DSEE-TDOD-00083 16:09:41(016) <main_program> ?? (SPEC_1_FREQ_REF)
##E IIS-DSEE-TDOD-00062 16:09:41(021) <QS_Freq_ODBC> Table create failed: {0}
##E IIS-DSEE-TFIP-00034 16:09:41(023) <APT_RealFileExportOperator in QS_Freq_DS_FlatFile(0)> Error when checking operator: Could not find input field "qsFreqCounts".
##E IIS-DSEE-TFIP-00034 16:09:41(026) <APT_RealFileExportOperator in QS_Freq_DS_FlatFile(0)> Error when checking operator: Could not find input field "qsFreqValue".
##E IIS-DSEE-TFIP-00034 16:09:41(027) <APT_RealFileExportOperator in QS_Freq_DS_FlatFile(1)> Error when checking operator: Could not find input field "qsFreqCounts".
##E IIS-DSEE-TFIP-00034 16:09:41(028) <APT_RealFileExportOperator in QS_Freq_DS_FlatFile(1)> Error when checking operator: Could not find input field "qsFreqValue".
##E IIS-DSEE-TFSR-00019 16:09:41(029) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 16:09:41(038) <main_program> Creation of a step finished with status = FAILED.


Here's the detail log:

##I IIS-DSEE-TFCN-00001 16:09:40(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4668
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved



##I IIS-DSEE-TOSH-00002 16:09:40(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 16:09:40(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 16:09:40(003) <main_program> orchstats: loaded
##I IIS-DSEE-TDOD-00080 16:09:41(000) <QS_Freq_ODBC> Process meta data not available in database
##I IIS-DSEE-TDOD-00007 16:09:41(001) <main_program> [IBM(DataDirect OEM)][ODBC 20101 driver][Oracle]ORA-00942: table or view does not exist
##I IIS-DSEE-TDOD-00081 16:09:41(002) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 16:09:41(003) <main_program> Driver doesn't support the datatype. DataType Code = -9
##E IIS-DSEE-TDOD-00083 16:09:41(004) <main_program> ?? (SPEC_1_FREQ_DATA)
##W IIS-DSEE-TDOD-00016 16:09:41(006) <QS_Freq_ODBC> string field qsInvColumnName will be truncated to 32 to override.
##W IIS-DSEE-TDOD-00016 16:09:41(007) <QS_Freq_ODBC> string field qsInvPattern will be truncated to 32 to override.
##W IIS-DSEE-TDOD-00016 16:09:41(008) <QS_Freq_ODBC> string field qsInvSample will be truncated to 32 to override.
##E IIS-DSEE-TDOD-00062 16:09:41(009) <QS_Freq_ODBC> Table create failed: {0}
##I IIS-DSEE-TDOD-00080 16:09:41(012) <QS_Freq_ODBC> Process meta data not available in database
##I IIS-DSEE-TDOD-00007 16:09:41(013) <main_program> [IBM(DataDirect OEM)][ODBC 20101 driver][Oracle]ORA-00942: table or view does not exist
##I IIS-DSEE-TDOD-00081 16:09:41(014) <main_program> Driver doesn't support the datatype. DataType Code = -9
##I IIS-DSEE-TDOD-00081 16:09:41(015) <main_program> Driver doesn't support the datatype. DataType Code = -9
##E IIS-DSEE-TDOD-00083 16:09:41(016) <main_program> ?? (SPEC_1_FREQ_REF)
##W IIS-DSEE-TDOD-00016 16:09:41(018) <QS_Freq_ODBC> string field qsInvColumnName will be truncated to 32 to override.
##W IIS-DSEE-TDOD-00016 16:09:41(019) <QS_Freq_ODBC> string field qsInvPattern will be truncated to 32 to override.
##W IIS-DSEE-TDOD-00016 16:09:41(020) <QS_Freq_ODBC> string field qsInvSample will be truncated to 32 to override.
##E IIS-DSEE-TDOD-00062 16:09:41(021) <QS_Freq_ODBC> Table create failed: {0}
##E IIS-DSEE-TFIP-00034 16:09:41(023) <APT_RealFileExportOperator in QS_Freq_DS_FlatFile(0)> Error when checking operator: Could not find input field "qsFreqCounts".
##W IIS-DSEE-TFIP-00093 16:09:41(024) <Copy_Op> When checking operator: On output data set 1: The modify operator has a binding for the non-existent output field "qsFreqCounts".
##W IIS-DSEE-TFIP-00093 16:09:41(025) <Copy_Op> When checking operator: On output data set 1: The modify operator has a binding for the non-existent output field "qsFreqValue".
##E IIS-DSEE-TFIP-00034 16:09:41(026) <APT_RealFileExportOperator in QS_Freq_DS_FlatFile(0)> Error when checking operator: Could not find input field "qsFreqValue".
##E IIS-DSEE-TFIP-00034 16:09:41(027) <APT_RealFileExportOperator in QS_Freq_DS_FlatFile(1)> Error when checking operator: Could not find input field "qsFreqCounts".
##E IIS-DSEE-TFIP-00034 16:09:41(028) <APT_RealFileExportOperator in QS_Freq_DS_FlatFile(1)> Error when checking operator: Could not find input field "qsFreqValue".
##E IIS-DSEE-TFSR-00019 16:09:41(029) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFIP-00093 16:09:41(030) <Copy_Op> When checking operator: On output data set 1: The modify operator has a binding for the non-existent output field "qsFreqColumnID".
##W IIS-DSEE-TFIP-00093 16:09:41(031) <Copy_Op> When checking operator: On output data set 1: The modify operator has a binding for the non-existent output field "qsFreqHeaderFlag".
##W IIS-DSEE-TFIP-00093 16:09:41(032) <Copy_Op> When checking operator: On output data set 1: The modify operator has a binding for the non-existent output field "qsFreqCounts".
##W IIS-DSEE-TFIP-00093 16:09:41(033) <Copy_Op> When checking operator: On output data set 1: The modify operator has a binding for the non-existent output field "qsFreqValue".
##W IIS-DSEE-TFIP-00093 16:09:41(034) <Copy_Op> When checking operator: On output data set 1: The modify operator has a binding for the non-existent output field "qsFreqColumnID".
##W IIS-DSEE-TFIP-00093 16:09:41(035) <Copy_Op> When checking operator: On output data set 1: The modify operator has a binding for the non-existent output field "qsFreqHeaderFlag".
##W IIS-DSEE-TFOR-00073 16:09:41(036) <APT_RealFileExportOperator in QS_Freq_DS_FlatFile(0)> Error when checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
##W IIS-DSEE-TFOR-00073 16:09:41(037) <APT_RealFileExportOperator in QS_Freq_DS_FlatFile(1)> Error when checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
##E IIS-DSEE-TCOS-00029 16:09:41(038) <main_program> Creation of a step finished with status = FAILED.
Top
seanc217
Premium Member
Premium Member
Posts: 188
Joined: Thu Sep 15, 2005 9:22 am

Post by seanc217 »

Errors were ocurring due to the output of Match Frequency stage not making it into the DataSet. Sorry, kind of new to QualityStage!

Otherwise the update to Oracle ran fine.
Top
dsinfo
Participant
Posts: 14
Joined: Sun Oct 04, 2009 7:24 pm

Could not find input field qsFreqValue

Post by dsinfo »

I am new to QS and having same issue: Could not find input field "qsFreqValue".

Please let me how to resolve this.
Thanks in advance.
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 »

Welcome aboard. Resolve it the same way - make sure that the output from the Match Frequency stage (which includes these qf... columns) makes it in to the Data Set.
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
william.eller@ed.gov
Participant
Posts: 19
Joined: Fri Aug 03, 2012 11:06 am

Just joined - Going through tutorial - same error

Post by william.eller@ed.gov »

How would one go about ensuring the output made it to the data set stage (as the posted solution suggests)?
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 »

On the Stage Properties tab you will find the ability to perform Mapping.
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
william.eller@ed.gov
Participant
Posts: 19
Joined: Fri Aug 03, 2012 11:06 am

Thanks Ray !!

Post by william.eller@ed.gov »

I figured it out - On the Stage proerties > Link Ordering Tab, the Link Labels and Link Names were inverted (cross matched). Have any insight as to what these fields do (The extent of my experience is the tutorial)

Thanks !! :D
Top
Post Reply

Return to “IBM QualityStage”