I am trying to Match frequency the data from standardize result data set.
The basic step i take is create a standardize job and save the table definition , in another job i will load this table definition and use the Match frequency stage to generate Frequency data set.
when I tryied to Reference match these stan and Freq files with another reference data sets ( ref_stan and ref_Freq) I got the error "_qsM_FirstName_MCKNAME" Not found"
I came back to search in the match frequency generated file , I did not find this field. While I could do properly a 3 days back.( I could see this field)
I tried many times designing the same stuff from begining with care. But still no luck.
Can any one know why this error comes up ?
This topic has been locked.
5 replies Latest Post - 2009-05-04T14:04:34Z by SystemAdmin
Pinned topic _qsM_FirstName_MCKNAME" Not found
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-05-04T14:04:34Z at 2009-05-04T14:04:34Z by SystemAdmin
Re: _qsM_FirstName_MCKNAME" Not found2008-07-24T13:22:38Z in response to SystemAdminAfter testing with other name field , the frequency stage is providing the _qsM_FirstName_MCKNAME , but not for the one which am looking for , Can any one help , how to modify my required field so that the Match Frequency stage will generate the _qsM_FirstName_MCKNAME ?
Thanks much in advance.
Re: _qsM_FirstName_MCKNAME" Not found2008-09-05T06:23:24Z in response to SystemAdminHi,
Even I have come across the same problem. The error displays - "Match_Contact_INT,0: Variable _qsC_ADDRESS not found in [A] frequency file".
If you could get a solution for your problem, do post it.
Re: _qsM_FirstName_MCKNAME" Not found2008-11-05T22:29:35Z in response to SystemAdminThis is typically a user error. There are three possible reasons for this error. The possible causes and solutions are
1. The link for the frequency file and the dataset are mixed. Check the link ordering in the match stage (see screen shot below).
2. It might be using an old snapshot of the match spec that is out of alignment. If you're not using fixpack 1a, remove the match spec, re-provision the match spec, re-add the match spec to the job, recompile the job, then run.
3. It really isn't there. There was an undocumented feature that prevented the Match Frequency stage from recognizing any changes to incoming columns. You would see that a column is going in, but it would not be in the output. The fix then was to delete the Match Frequency stage from the canvas and then add it back in.
Re: _qsM_FirstName_MCKNAME" Not found2008-12-11T20:44:14Z in response to SystemAdminSory for the late reply probably may be useful for future users, before the Frequency stage I have added a Trasformer stage to handle the nulls , I am sure that is one of the following way , can be with if IsNull() then '' else value the other way if len(stripwhitespace(value)) < 1 then '' else value. I could solve with this way.
Re: _qsM_FirstName_MCKNAME" Not found2009-05-04T14:04:34Z in response to SystemAdminHi Raj,
I am also getting the same or similar issue in the maptch process. could you please on this. see the below error:
By the way do you work for McKesson?
##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.