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
Reference Match Error
Re: Reference Match Error
Hi,
Did you check the both DATA and REFERENCE frequency file ?
Regards
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
vairamuthu
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Re: Reference Match Error
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: