Page 1 of 1
Reference Match Error
Posted: Sun Apr 05, 2009 10:59 pm
by vasubabu
Hi,
I developed Match Sepecification with one blocking field ( ID ) and one Matching field ( Name ).
I created Frequency files with that Match Spec. When i ran the Reference Match job, I am getting the below error
Reference_Match,0: Variable [_qsM_NAME_COMPANY] not found in [A] frequency file.
But when i viewed the frequency reference file output , i am able to see the values for [_qsM_NAME_COMPANY].
Pls help me to solve this error.
Regards,
Vasu
Re: Reference Match Error
Posted: Tue Apr 07, 2009 12:10 am
by vairus
Hi,
Did you check the both DATA and REFERENCE frequency file ?
Regards
vasubabu wrote:Hi,
I developed Match Sepecification with one blocking field ( ID ) and one Matching field ( Name ).
I created Frequency files with that Match Spec. When i ran the Reference Match job, I am getting the below error
Reference_Match,0: Variable [_qsM_NAME_COMPANY] not found in [A] frequency file.
But when i viewed the frequency reference file output , i am able to see the values for [_qsM_NAME_COMPANY].
Pls help me to solve this error.
Regards,
Vasu
Posted: Tue Apr 07, 2009 3:35 am
by vasubabu
Yes. I have checked both.
Rgds,
Vasu
Posted: Tue Apr 07, 2009 9:23 am
by JRodriguez
vasubabu,
Take a look at the Input Link Ordering, just make sure that each link is really pointing to what you want
Re: Reference Match Error
Posted: Mon May 04, 2009 11:55 am
by janreddy
Hi Vasu,
I am also getting the same error and see below the log. Did you find any resolution? I dont see that column in Frequncy file as I see only 4 columns: qsFreqValue, qsFreqCounts, qsFreqColumnID, and qsFreqHeaderFlag so I dont see the column: _qsC_StateAbbreviation_USAREA in frequency file.
Please throw me some light...
Thanks
Jan
##I IIS-DSEE-TUTL-00031 09:38:41(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I IIS-DSEE-TOSH-00002 09:38:41(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 09:38:41(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 09:38:42(000) <main_program> orchstats: loaded
##I IIS-DSEE-TDOD-00080 09:38:42(006) <MWI_Odbc_Write> Process meta data not available in database
##I IIS-DSEE-TFSC-00001 09:38:42(008) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt
##E IIS-QSEE-MATM-00004 09:38:43(000) <QS_Test_MWI_0,0> Variable [_qsC_StateAbbreviation_USAREA] not found in [A] frequency file
##E IIS-QSEE-POTO-00002 09:38:43(001) <QS_Test_MWI_0,0> Fatal error from object qsmExit, code 4
##E IIS-DSEE-TFOR-00089 09:38:43(003) <QS_Test_MWI_0,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00094 09:38:43(004) <QS_Test_MWI_0,0> Output 0 produced 201 records.
##E IIS-DSEE-TFPM-00040 09:38:43(005) <QS_Test_MWI_0,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
##E IIS-DSEE-TFSC-00011 09:38:49(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOS-00026 09:38:49(001) <main_program> Startup time, 0:06; production run time, 0:01.
Posted: Mon May 04, 2009 4:06 pm
by ray.wurlod
That is not the same error. It is a completely different error. Hijacking unrelated threads does nothing productive.