Reference Match Error

[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

[vairus]

Hi,

Did you check the both DATA and REFERENCE frequency file ?

Regards

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

[vasubabu]

Yes. I have checked both.

Rgds,
Vasu

[JRodriguez]

vasubabu,

Take a look at the Input Link Ordering, just make sure that each link is really pointing to what you want

[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.

[ray.wurlod]

That is not the same error. It is a completely different error. Hijacking unrelated threads does nothing productive.